fx_franchise_order_product

4,737 rows · 33 columns · page 86 / 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
4251 4462 2 1112 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-04-24 22:11:22
4252 4463 3 1112 12526 48 Glow it multi fruit face wash NULL 3304999 5 160.0 450.0 0.0 0.0 320.0 271.19 48.81 2250.0 800.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1355.93 244.07 1600.0 INR 3 2.0 27.12 2026-04-24 22:11:22
4253 4464 4 1112 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 25 35.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 875.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-24 22:11:22
4254 4465 5 1112 12526 53 Terra care 2 kg NULL 3103100 2 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 1150.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-04-24 22:11:22
4255 4466 1 1113 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 2 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 1250.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-04-27 08:50:05
4256 4467 2 1113 12545 53 Terra care 2 kg NULL 3103100 2 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 1150.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-04-27 08:50:05
4257 4468 1 1114 12532 27 Multicharge Cap NULL 2009899 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-04-27 19:51:57
4258 4469 2 1114 12532 52 Bhoo sanjeevni 5 kg NULL 3103100 4 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 6400.0 2500.0 5000.0 2.5 119.05 2.5 119.05 0.0 0.0 4761.9 238.1 5000.0 INR 3 2.0 95.24 2026-04-27 19:51:57
4259 4470 3 1114 12532 4 Diabetic Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-04-27 19:51:57
4260 4471 4 1114 12532 2 Heart Care Capsules NULL 2936900 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.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-04-27 19:51:57
4261 4472 5 1114 12532 53 Terra care 2 kg NULL 3103100 3 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 1725.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-04-27 19:51:57
4262 4473 1 1115 12539 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-04-28 15:41:58
4263 4474 1 1116 12545 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 1 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 23999.0 9250.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 3 2.0 352.38 2026-04-28 15:48:13
4264 4475 1 1117 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-04-28 15:49:15
4265 4476 2 1117 12545 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-04-28 15:49:15
4266 4477 3 1117 12545 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.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-04-28 15:49:15
4267 4478 1 1118 12516 46 Root Vitality Hair Oil NULL 3305901 101 102.0 255.0 0.0 0.0 204.0 194.29 9.71 25755.0 10302.0 20604.0 2.5 490.57 2.5 490.57 0.0 0.0 19622.86 981.14 20604.0 INR 1 8.0 1569.83 2026-04-28 16:01:08
4268 4479 1 1119 12516 46 Root Vitality Hair Oil NULL 3305901 100 102.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 10200.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 19428.57 971.43 20400.0 INR 1 8.0 1554.29 2026-04-28 16:04:14
4269 4480 1 1120 12517 46 Root Vitality Hair Oil NULL 3305901 100 102.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 10200.0 20400.0 0.0 0.0 0.0 0.0 5.0 971.43 19428.57 971.43 20400.0 INR 2 6.0 1165.71 2026-04-28 16:07:51
4270 4481 1 1121 12539 20 Premium Berry Juice 1000ml NULL 2936900 2 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 6998.0 1600.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 3047.62 152.38 3200.0 INR 3 2.0 60.95 2026-04-28 16:11:34
4271 4482 2 1121 12539 46 Root Vitality Hair Oil NULL 3305901 1 102.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 102.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-28 16:11:34
4272 4483 1 1122 12539 2 Heart Care Capsules NULL 2936900 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-04-28 17:29:13
4273 4484 2 1122 12539 46 Root Vitality Hair Oil NULL 3305901 5 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 510.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-04-28 17:29:13
4274 4485 1 1123 12526 11 BHRINGRAJ & SHIKAKAI NULL 33051090 2 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 750.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-04-28 20:45:38
4275 4486 2 1123 12526 20 Premium Berry Juice 1000ml NULL 2936900 2 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 6998.0 1600.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 3047.62 152.38 3200.0 INR 3 2.0 60.95 2026-04-28 20:45:38
4276 4487 3 1123 12526 31 Vegan Plant Protein Powder NULL 21061000 2 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 5998.0 1400.0 2800.0 2.5 66.67 2.5 66.67 0.0 0.0 2666.67 133.33 2800.0 INR 3 2.0 53.33 2026-04-28 20:45:38
4277 4488 4 1123 12526 82 ALKALINE CAPSULE NULL 3402000 2 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 5000.0 1600.0 3300.0 2.5 78.57 2.5 78.57 0.0 0.0 3142.86 157.14 3300.0 INR 3 2.0 62.86 2026-04-28 20:45:38
4278 4489 5 1123 12526 79 ALKALINE JAR NULL 8421 2 3300.0 14499.0 0.0 0.0 6000.0 5084.75 915.25 28998.0 6600.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 10169.49 1830.51 12000.0 INR 3 2.0 203.39 2026-04-28 20:45:38
4279 4490 6 1123 12526 49 Anti Dandruff Serum NULL 3304999 2 399.0 999.0 0.0 0.0 799.0 677.12 121.88 1998.0 798.0 1598.0 9.0 121.88 9.0 121.88 0.0 0.0 1354.24 243.76 1598.0 INR 3 2.0 27.08 2026-04-28 20:45:38
4280 4491 7 1123 12526 38 Dish Wash 500ml NULL 34029099 2 65.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 130.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-04-28 20:45:38
4281 4492 8 1123 12526 48 Glow it multi fruit face wash NULL 3304999 2 160.0 450.0 0.0 0.0 320.0 271.19 48.81 900.0 320.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 542.37 97.63 640.0 INR 3 2.0 10.85 2026-04-28 20:45:38
4282 4493 9 1123 12526 17 Memory Booster Juice NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 3 2.0 5.71 2026-04-28 20:45:38
4283 4494 10 1123 12526 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 400.0 380.95 19.05 1600.0 400.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-04-28 20:45:38
4284 4495 11 1123 12526 41 Premium Coco Body Lotion NULL 3304300 5 279.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 1395.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-04-28 20:45:38
4285 4496 12 1123 12526 47 Premium Hair Care Shampoo NULL 3305109 2 279.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 558.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-04-28 20:45:38
4286 4497 13 1123 12526 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 375.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-04-28 20:45:38
4287 4498 14 1123 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 3 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 4272.0 1125.0 2250.0 9.0 171.61 9.0 171.61 0.0 0.0 1906.78 343.22 2250.0 INR 3 2.0 38.14 2026-04-28 20:45:38
4288 4499 15 1123 12526 46 Root Vitality Hair Oil NULL 3305901 5 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 510.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-04-28 20:45:38
4289 4500 16 1123 12526 36 Toilet Cleaner 500ml NULL 3924101 5 42.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 210.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-04-28 20:45:38
4290 4501 1 1124 12523 61 Radiation chip NULL 902221 10 100.0 999.0 0.0 0.0 200.0 169.49 30.51 9990.0 1000.0 2000.0 9.0 152.54 9.0 152.54 0.0 0.0 1694.91 305.08 2000.0 INR 3 2.0 33.9 2026-04-29 15:31:48
4291 4502 2 1124 12523 4 Diabetic Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-04-29 15:31:48
4292 4503 3 1124 12523 39 Fabric Wash 1000ml NULL 34029099 10 112.0 401.0 0.0 0.0 321.0 272.03 48.97 4010.0 1120.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-04-29 15:31:48
4293 4504 4 1124 12523 48 Glow it multi fruit face wash NULL 3304999 10 160.0 450.0 0.0 0.0 320.0 271.19 48.81 4500.0 1600.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-04-29 15:31:48
4294 4505 5 1124 12523 55 Grow master 500ml NULL 3105 1 825.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 825.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-29 15:31:48
4295 4506 6 1124 12523 33 HALDI CHANDAN SOAP 100gm NULL 30049011 100 35.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 3500.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 7619.05 380.95 8000.0 INR 3 2.0 152.38 2026-04-29 15:31:48
4296 4507 7 1124 12523 25 Manicalcium Tablets NULL 2009899 1 159.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 159.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-04-29 15:31:48
4297 4508 8 1124 12523 9 Omega 369 NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-04-29 15:31:48
4298 4509 9 1124 12523 47 Premium Hair Care Shampoo NULL 3305109 1 279.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 279.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-04-29 15:31:48
4299 4510 10 1124 12523 46 Root Vitality Hair Oil NULL 3305901 10 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 1020.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-04-29 15:31:48
4300 4511 11 1124 12523 1 Stem Cell Powder NULL 2936900 2 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 4998.0 1000.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-29 15:31:48