fx_franchise_order_product

4,737 rows · 33 columns · page 79 / 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
3901 4110 2 1000 12521 58 Green shield 250ml NULL 3105 1 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 0.0 1850.0 2.5 44.05 2.5 44.05 0.0 0.0 1761.9 88.1 1850.0 INR 3 2.0 35.24 2026-03-02 23:03:40
3902 4111 3 1000 12521 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-02 23:03:40
3903 4112 4 1000 12521 54 Wonder grow 100ml NULL 3105 1 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-02 23:03:40
3904 4113 1 1001 14079 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-03-03 12:47:39
3905 4114 1 1002 12532 20 Premium Berry Juice 1000ml NULL 2936900 3 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 10497.0 0.0 7800.0 2.5 185.71 2.5 185.71 0.0 0.0 7428.57 371.43 7800.0 INR 3 2.0 148.57 2026-03-03 17:03:13
3906 4115 2 1002 12532 82 ALKALINE CAPSULE NULL 3402000 3 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 7500.0 0.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 3 2.0 114.29 2026-03-03 17:03:13
3907 4116 3 1002 12532 38 Dish Wash 500ml NULL 34029099 10 0.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 0.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 1559.32 280.68 1840.0 INR 3 2.0 31.19 2026-03-03 17:03:13
3908 4117 4 1002 12532 39 Fabric Wash 1000ml NULL 34029099 10 0.0 401.0 0.0 0.0 321.0 272.03 48.97 4010.0 0.0 3210.0 9.0 244.83 9.0 244.83 0.0 0.0 2720.34 489.66 3210.0 INR 3 2.0 54.41 2026-03-03 17:03:13
3909 4118 5 1002 12532 19 Fat loss Juice 500 ml NULL 30049011 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-03 17:03:13
3910 4119 6 1002 12532 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-03-03 17:03:13
3911 4120 7 1002 12532 48 Glow bliss face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-03-03 17:03:13
3912 4121 8 1002 12532 33 HALDI CHANDAN SOAP 100gm NULL 30049011 200 0.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 0.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.1 761.9 16000.0 INR 3 2.0 304.76 2026-03-03 17:03:13
3913 4122 9 1002 12532 17 Memory Booster Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-03-03 17:03:13
3914 4123 10 1002 12532 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 13714.29 685.71 14400.0 INR 3 2.0 274.29 2026-03-03 17:03:13
3915 4124 11 1002 12532 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-03-03 17:03:13
3916 4125 12 1002 12532 94 PAVANA DROPS NULL 30041211 3 0.0 699.0 0.0 0.0 499.0 475.24 23.76 2097.0 0.0 1497.0 2.5 35.64 2.5 35.64 0.0 0.0 1425.71 71.29 1497.0 INR 3 2.0 28.51 2026-03-03 17:03:13
3917 4126 13 1002 12532 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-03-03 17:03:13
3918 4127 14 1002 12532 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-03-03 17:03:13
3919 4128 15 1002 12532 35 Sanitary Pad (15 pcs) NULL 9619001 5 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-03-03 17:03:13
3920 4129 16 1002 12532 36 Toilet Cleaner 500ml NULL 3924101 12 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1800.0 0.0 1440.0 9.0 109.83 9.0 109.83 0.0 0.0 1220.34 219.66 1440.0 INR 3 2.0 24.41 2026-03-03 17:03:13
3921 4130 17 1002 12532 34 Toothpaste NULL 33061090 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-03-03 17:03:13
3922 4131 1 1003 12545 11 BRINGRAJ & SHIKAKAI NULL 33051090 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-03-04 11:20:53
3923 4132 2 1003 12545 27 Multicharge Cap NULL 2009899 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-03-04 11:20:53
3924 4133 3 1003 12545 3 BP 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-03-04 11:20:53
3925 4134 4 1003 12545 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-03-04 11:20:53
3926 4135 5 1003 12545 39 Fabric Wash 1000ml NULL 34029099 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-03-04 11:20:53
3927 4136 6 1003 12545 37 Floor Cleaner 500ml NULL 3924101 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-03-04 11:20:53
3928 4137 7 1003 12545 24 Immunomax 24/7 Caps NULL 2009899 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-03-04 11:20:53
3929 4138 8 1003 12545 30 Iron Capsules NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-03-04 11:20:53
3930 4139 9 1003 12545 25 Manicalcium Tablets NULL 2009899 2 0.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 0.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 607.62 30.38 638.0 INR 3 2.0 12.15 2026-03-04 11:20:53
3931 4140 10 1003 12545 32 Neem Soap 100gm NULL 34011110 7 0.0 60.0 0.0 0.0 48.0 45.71 2.29 420.0 0.0 336.0 2.5 8.0 2.5 8.0 0.0 0.0 320.0 16.0 336.0 INR 3 2.0 6.4 2026-03-04 11:20:53
3932 4141 11 1003 12545 9 Omega 369 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-03-04 11:20:53
3933 4142 12 1003 12545 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-03-04 11:20:53
3934 4143 13 1003 12545 46 Root Vitality Hair Oil NULL 3305901 4 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1020.0 0.0 816.0 2.5 19.43 2.5 19.43 0.0 0.0 777.14 38.86 816.0 INR 3 2.0 15.54 2026-03-04 11:20:53
3935 4144 1 1004 12526 31 Vegan Plant Protein Powder NULL 21061000 2 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 5998.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-03-04 23:18:18
3936 4145 2 1004 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-03-04 23:18:18
3937 4146 3 1004 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-04 23:18:18
3938 4147 4 1004 12526 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-03-04 23:18:18
3939 4148 5 1004 12526 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-04 23:18:18
3940 4149 6 1004 12526 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-03-04 23:18:18
3941 4150 7 1004 12526 34 Toothpaste NULL 33061090 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-03-04 23:18:18
3942 4151 1 1005 12527 4 Diabetic Care Capsules NULL 2936900 5 0.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-03-05 15:46:24
3943 4152 2 1005 12527 19 Fat loss Juice 500 ml NULL 30049011 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-03-05 15:46:24
3944 4153 3 1005 12527 28 Ortho Joint Shield NULL 2009899 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-03-05 15:46:24
3945 4154 1 1006 12532 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 7 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 130900.0 0.0 74900.0 2.5 1783.33 2.5 1783.33 0.0 0.0 71333.33 3566.67 74900.0 INR 3 2.0 1426.67 2026-03-06 15:49:54
3946 4155 1 1007 14902 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-03-06 21:24:47
3947 4156 2 1007 14902 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-03-06 21:24:47
3948 4157 3 1007 14902 32 Neem Soap 100gm NULL 34011110 25 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1500.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-06 21:24:47
3949 4158 4 1007 14902 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.0 5750.0 2.5 136.9 2.5 136.9 0.0 0.0 5476.19 273.81 5750.0 INR 3 2.0 109.52 2026-03-06 21:24:47
3950 4159 1 1008 12521 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-06 21:57:30