fx_franchise_order_product

4,737 rows · 33 columns · page 55 / 95

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
2701 2910 2 707 12542 34 Herbo2o Toothpaste NULL 33061090 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 0.0 0.0 0.0 0.0 18.0 242.54 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-13 11:00:12
2702 2911 3 707 12542 16 Liver Care Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 0.0 0.0 0.0 0.0 5.0 13.29 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-13 11:00:12
2703 2912 4 707 12542 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 0.0 0.0 0.0 0.0 5.0 13.29 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-13 11:00:12
2704 2913 5 707 12542 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 0.0 0.0 0.0 0.0 5.0 228.57 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-13 11:00:12
2705 2914 6 707 12542 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 11:00:12
2706 2915 7 707 12542 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 0.0 0.0 0.0 0.0 5.0 19.43 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-13 11:00:12
2707 2916 1 708 12552 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-13 12:19:22
2708 2917 1 709 12517 19 Fat loss Juice 500 ml NULL 30049011 5 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 7495.0 0.0 6000.0 0.0 0.0 0.0 0.0 5.0 285.71 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-01-13 12:20:20
2709 2918 1 710 12526 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-13 12:27:54
2710 2919 2 710 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 2500.0 0.0 2000.0 1.5 29.13 1.5 29.13 0.0 0.0 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-13 12:27:54
2711 2920 3 710 12526 38 Dish Wash 500ml NULL 3924101 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-13 12:27:54
2712 2921 4 710 12526 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-13 12:27:54
2713 2922 5 710 12526 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-13 12:27:54
2714 2923 6 710 12526 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 4.5 23.08 4.5 23.08 0.0 0.0 512.84 46.16 559.0 INR 3 2.0 10.26 2026-01-13 12:27:54
2715 2924 7 710 12526 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-13 12:27:54
2716 2925 8 710 12526 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-13 12:27:54
2717 2926 9 710 12526 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-13 12:27:54
2718 2927 1 711 12518 48 glow face wash NULL 3304999 3 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 0.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 772.88 139.12 912.0 INR 3 2.0 15.46 2026-01-13 12:54:45
2719 2928 2 711 12518 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-13 12:54:45
2720 2929 3 711 12518 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-13 12:54:45
2721 2930 4 711 12518 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-13 12:54:45
2722 2931 5 711 12518 81 PREMIUM GLOW FACE WASH NULL 3404 3 0.0 699.0 0.0 0.0 559.0 512.84 46.16 2097.0 0.0 1677.0 4.5 69.23 4.5 69.23 0.0 0.0 1538.53 138.47 1677.0 INR 3 2.0 30.77 2026-01-13 12:54:45
2723 2932 6 711 12518 43 Quench Kiss Lip Balm NULL 3304300 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-13 12:54:45
2724 2933 7 711 12518 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 3 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 3750.0 0.0 2250.0 2.5 53.57 2.5 53.57 0.0 0.0 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-13 12:54:45
2725 2934 8 711 12518 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 3 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 4272.0 0.0 2250.0 2.5 53.57 2.5 53.57 0.0 0.0 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-13 12:54:45
2726 2935 1 712 13836 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-13 15:00:21
2727 2936 2 712 13836 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-01-13 15:00:21
2728 2937 3 712 13836 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-01-13 15:00:21
2729 2938 4 712 13836 36 Toilet Cleaner 500ml NULL 3924101 1 0.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 0.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.3 120.0 INR 3 2.0 2.03 2026-01-13 15:00:21
2730 2939 1 713 13536 48 glow face wash NULL 3304999 6 0.0 380.0 0.0 0.0 304.0 257.63 46.37 2280.0 0.0 1824.0 9.0 139.12 9.0 139.12 0.0 0.0 1545.76 278.24 1824.0 INR 3 2.0 30.92 2026-01-13 16:05:23
2731 2940 2 713 13536 61 Radiation chip NULL 902221 1 0.0 999.0 0.0 0.0 500.0 423.73 76.27 999.0 0.0 500.0 9.0 38.14 9.0 38.14 0.0 0.0 423.73 76.27 500.0 INR 3 2.0 8.47 2026-01-13 16:05:23
2732 2941 3 713 13536 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-13 16:05:23
2733 2942 4 713 13536 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-13 16:05:23
2734 2943 5 713 13536 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-13 16:05:23
2735 2944 6 713 13536 37 Floor Cleaner 500ml NULL 3924101 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-13 16:05:23
2736 2945 7 713 13536 33 Herbal Soap 100gm NULL 30049011 3 0.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 0.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 228.57 11.43 240.0 INR 3 2.0 4.57 2026-01-13 16:05:23
2737 2946 8 713 13536 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 16:05:23
2738 2947 9 713 13536 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-01-13 16:05:23
2739 2948 10 713 13536 41 Premium Coco Body Lotion NULL 3304300 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-13 16:05:23
2740 2949 11 713 13536 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-13 16:05:23
2741 2950 12 713 13536 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-13 16:05:23
2742 2951 13 713 13536 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-13 16:05:23
2743 2952 14 713 13536 35 Sanitary Pad (15 pcs) NULL 9619001 4 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 0.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 1216.0 0.0 1216.0 INR 3 2.0 24.32 2026-01-13 16:05:23
2744 2953 15 713 13536 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-13 16:05:23
2745 2954 1 714 13536 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 16:39:50
2746 2955 1 715 12534 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-01-13 18:40:46
2747 2956 2 715 12534 6 Asthma Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-13 18:40:46
2748 2957 3 715 12534 3 BP Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-13 18:40:46
2749 2958 4 715 12534 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-13 18:40:46
2750 2959 5 715 12534 38 Dish Wash 500ml NULL 3924101 8 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1840.0 0.0 1472.0 9.0 112.27 9.0 112.27 0.0 0.0 1247.46 224.54 1472.0 INR 3 2.0 24.95 2026-01-13 18:40:46