fx_franchise_order_product

4,737 rows · 33 columns · page 83 / 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
4101 4310 8 1054 12545 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-27 19:10:08
4102 4311 9 1054 12545 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-27 19:10:08
4103 4312 10 1054 12545 34 Toothpaste NULL 33061090 13 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2587.0 0.0 2067.0 9.0 157.65 9.0 157.65 0.0 0.0 1751.7 315.31 2067.0 INR 3 2.0 35.03 2026-03-27 19:10:08
4104 4313 1 1055 12545 39 Fabric Wash 1000ml NULL 34029099 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-03-27 19:13:13
4105 4314 2 1055 12545 55 Grow master 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-03-27 19:13:13
4106 4315 3 1055 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 2 0.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 0.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 3 2.0 3.05 2026-03-27 19:13:13
4107 4316 4 1055 12545 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-03-27 19:13:13
4108 4317 5 1055 12545 9 Omega 369 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-03-27 19:13:13
4109 4318 6 1055 12545 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-03-27 19:13:13
4110 4319 7 1055 12545 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-03-27 19:13:13
4111 4320 1 1056 12545 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-03-27 21:29:24
4112 4321 2 1056 12545 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-03-27 21:29:24
4113 4322 3 1056 12545 34 Toothpaste NULL 33061090 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-27 21:29:24
4114 4323 1 1057 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-27 21:29:57
4115 4324 2 1057 12526 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.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-27 21:29:57
4116 4325 3 1057 12526 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-03-27 21:29:57
4117 4326 4 1057 12526 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-03-27 21:29:57
4118 4327 1 1058 12516 48 Glow it multi fruit face wash NULL 3304999 50 0.0 450.0 0.0 0.0 320.0 271.19 48.81 22500.0 0.0 16000.0 9.0 1220.34 9.0 1220.34 0.0 0.0 13559.32 2440.68 16000.0 INR 1 8.0 1084.75 2026-03-27 21:43:39
4119 4328 1 1059 12517 48 Glow it multi fruit face wash NULL 3304999 50 0.0 450.0 0.0 0.0 320.0 271.19 48.81 22500.0 0.0 16000.0 0.0 0.0 0.0 0.0 18.0 2440.68 13559.32 2440.68 16000.0 INR 2 6.0 813.56 2026-03-27 21:45:18
4120 4329 1 1060 12526 48 Glow it multi fruit face wash NULL 3304999 10 0.0 450.0 0.0 0.0 320.0 271.19 48.81 4500.0 0.0 3200.0 9.0 244.07 9.0 244.07 0.0 0.0 2711.86 488.14 3200.0 INR 3 2.0 54.24 2026-03-27 22:03:26
4121 4330 1 1061 12521 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-27 22:56:16
4122 4331 2 1061 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-27 22:56:16
4123 4332 1 1062 12521 32 Neem Soap 100gm NULL 34011110 65 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3900.0 0.0 3120.0 2.5 74.29 2.5 74.29 0.0 0.0 2971.43 148.57 3120.0 INR 3 2.0 59.43 2026-03-27 23:12:00
4124 4333 1 1063 12517 70 Premium Hand belt NULL 9404 25 0.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 62500.0 0.0 36000.0 0.0 0.0 0.0 0.0 5.0 1714.29 34285.71 1714.29 36000.0 INR 2 6.0 2057.14 2026-03-30 12:20:17
4125 4334 1 1064 12516 70 Premium Hand belt NULL 9404 20 0.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 50000.0 0.0 28800.0 2.5 685.71 2.5 685.71 0.0 0.0 27428.57 1371.43 28800.0 INR 1 8.0 2194.29 2026-03-30 12:20:39
4126 4335 1 1065 12548 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.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-30 18:51:16
4127 4336 2 1065 12548 2 Heart Care Capsules NULL 2936900 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-30 18:51:16
4128 4337 1 1066 12526 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.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-30 21:11:48
4129 4338 2 1066 12526 37 Floor Cleaner 500ml NULL 3924101 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-03-30 21:11:48
4130 4339 3 1066 12526 33 HALDI CHANDAN 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-03-30 21:11:48
4131 4340 4 1066 12526 30 Iron Capsules NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-03-30 21:11:48
4132 4341 5 1066 12526 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-03-30 21:11:48
4133 4342 6 1066 12526 32 Neem Soap 100gm NULL 34011110 35 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2100.0 0.0 1680.0 2.5 40.0 2.5 40.0 0.0 0.0 1600.0 80.0 1680.0 INR 3 2.0 32.0 2026-03-30 21:11:48
4134 4343 7 1066 12526 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.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-30 21:11:48
4135 4344 8 1066 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-03-30 21:11:48
4136 4345 9 1066 12526 46 Root Vitality Hair Oil NULL 3305901 6 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 0.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1165.71 58.29 1224.0 INR 3 2.0 23.31 2026-03-30 21:11:48
4137 4346 10 1066 12526 95 STRI VEDA NULL 30049011 1 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 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-30 21:11:48
4138 4347 11 1066 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-30 21:11:48
4139 4348 1 1067 12539 4 Diabetic Care Capsules NULL 2936900 6 0.0 999.0 0.0 0.0 720.0 685.71 34.29 5994.0 0.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 4114.29 205.71 4320.0 INR 3 2.0 82.29 2026-03-31 19:17:39
4140 4349 2 1067 12539 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-31 19:17:39
4141 4350 3 1067 12539 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-03-31 19:17:39
4142 4351 1 1068 14079 15 KIDNEY CARE 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-04-01 21:29:53
4143 4352 1 1069 12521 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-04-03 16:14:54
4144 4353 2 1069 12521 55 Grow master 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-04-03 16:14:54
4145 4354 3 1069 12521 32 Neem Soap 100gm NULL 34011110 6 0.0 60.0 0.0 0.0 48.0 45.71 2.29 360.0 0.0 288.0 2.5 6.86 2.5 6.86 0.0 0.0 274.29 13.71 288.0 INR 3 2.0 5.49 2026-04-03 16:14:54
4146 4355 4 1069 12521 81 PREMIUM GLOW FACE WASH NULL 3404 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-04-03 16:14:54
4147 4356 5 1069 12521 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 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-04-03 16:14:54
4148 4357 6 1069 12521 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-04-03 16:14:54
4149 4358 1 1070 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-04-03 20:56:09
4150 4359 2 1070 12526 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-04-03 20:56:09