fx_franchise_order_product

4,737 rows · 33 columns · page 89 / 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
4401 4612 3 1175 14902 39 Fabric Wash 1000ml NULL 34029099 3 112.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 336.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-05-10 21:09:55
4402 4613 4 1175 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 35.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 1050.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-05-10 21:09:55
4403 4614 5 1175 14902 15 KIDNEY CARE 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-05-10 21:09:55
4404 4615 6 1175 14902 28 Ortho Joint Shield 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-05-10 21:09:55
4405 4616 7 1175 14902 46 Root Vitality Hair Oil NULL 3305901 6 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 612.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-05-10 21:09:55
4406 4617 8 1175 14902 35 Sanitary Pad (15 pcs) NULL 9619001 2 150.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 300.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-05-10 21:09:55
4407 4618 9 1175 14902 1 Stem Cell Powder NULL 2936900 4 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 9996.0 2000.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-05-10 21:09:55
4408 4619 1 1176 12545 79 ALKALINE JAR NULL 8421 1 3300.0 14499.0 0.0 0.0 6000.0 5084.75 915.25 14499.0 3300.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 5084.75 915.25 6000.0 INR 3 2.0 101.69 2026-05-10 22:24:18
4409 4620 2 1176 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 3 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-05-10 22:24:18
4410 4621 3 1176 12545 7 Morning Fresh Churan NULL 30049011 1 79.0 199.0 0.0 0.0 179.0 170.48 8.52 199.0 79.0 179.0 2.5 4.26 2.5 4.26 0.0 0.0 170.48 8.52 179.0 INR 3 2.0 3.41 2026-05-10 22:24:18
4411 4622 4 1176 12545 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-05-10 22:24:18
4412 4623 5 1176 12545 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-05-10 22:24:18
4413 4624 1 1177 12545 70 Premium Hand belt NULL 9404 1 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 2500.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-05-11 19:34:07
4414 4625 2 1177 12545 49 Anti Dandruff Serum NULL 3304999 1 399.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 399.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-05-11 19:34:07
4415 4626 3 1177 12545 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-05-11 19:34:07
4416 4627 4 1177 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 15 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 525.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-05-11 19:34:07
4417 4628 5 1177 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-05-11 19:34:07
4418 4629 6 1177 12545 94 PAVANA DROPS NULL 30041211 1 249.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 249.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-05-11 19:34:07
4419 4630 7 1177 12545 35 Sanitary Pad (15 pcs) NULL 9619001 1 150.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 150.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-05-11 19:34:07
4420 4631 1 1178 12539 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-05-11 20:09:59
4421 4632 2 1178 12539 15 KIDNEY CARE 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-05-11 20:09:59
4422 4633 3 1178 12539 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-05-11 20:09:59
4423 4634 4 1178 12539 46 Root Vitality Hair Oil NULL 3305901 13 102.0 255.0 0.0 0.0 204.0 194.29 9.71 3315.0 1326.0 2652.0 2.5 63.14 2.5 63.14 0.0 0.0 2525.71 126.29 2652.0 INR 3 2.0 50.51 2026-05-11 20:09:59
4424 4635 5 1178 12539 34 Toothpaste NULL 33061090 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.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-05-11 20:09:59
4425 4636 1 1179 12532 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-05-11 20:16:31
4426 4637 2 1179 12532 82 ALKALINE CAPSULE NULL 3402000 3 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 7500.0 2400.0 4950.0 2.5 117.86 2.5 117.86 0.0 0.0 4714.29 235.71 4950.0 INR 3 2.0 94.29 2026-05-11 20:16:31
4427 4638 3 1179 12532 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-05-11 20:16:31
4428 4639 4 1179 12532 3 BP Care Capsules NULL 2936900 3 360.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 1080.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-05-11 20:16:31
4429 4640 5 1179 12532 4 Diabetic Care Capsules NULL 2936900 3 360.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 1080.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-05-11 20:16:31
4430 4641 6 1179 12532 38 Dish Wash 500ml NULL 34029099 3 65.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 195.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-05-11 20:16:31
4431 4642 7 1179 12532 37 Floor Cleaner 500ml NULL 3924101 3 55.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 165.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-05-11 20:16:31
4432 4643 8 1179 12532 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-05-11 20:16:31
4433 4644 9 1179 12532 33 HALDI CHANDAN SOAP 100gm NULL 30049011 200 35.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 7000.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-05-11 20:16:31
4434 4645 10 1179 12532 15 KIDNEY CARE JUICE NULL 2009899 3 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1047.0 450.0 900.0 2.5 21.43 2.5 21.43 0.0 0.0 857.14 42.86 900.0 INR 3 2.0 17.14 2026-05-11 20:16:31
4435 4646 11 1179 12532 16 Liver Care Juice NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-05-11 20:16:31
4436 4647 12 1179 12532 28 Ortho Joint Shield 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-05-11 20:16:31
4437 4648 13 1179 12532 94 PAVANA DROPS NULL 30041211 6 249.0 699.0 0.0 0.0 499.0 475.24 23.76 4194.0 1494.0 2994.0 2.5 71.29 2.5 71.29 0.0 0.0 2851.43 142.57 2994.0 INR 3 2.0 57.03 2026-05-11 20:16:31
4438 4649 14 1179 12532 8 Piles Care NULL 30049011 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-05-11 20:16:31
4439 4650 15 1179 12532 41 Premium Coco Body Lotion NULL 3304300 3 279.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 837.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-05-11 20:16:31
4440 4651 16 1179 12532 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 750.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-05-11 20:16:31
4441 4652 17 1179 12532 46 Root Vitality Hair Oil NULL 3305901 6 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 612.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-05-11 20:16:31
4442 4653 18 1179 12532 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 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-05-11 20:16:31
4443 4654 19 1179 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-05-11 20:16:31
4444 4655 20 1179 12532 34 Toothpaste NULL 33061090 24 55.0 199.0 0.0 0.0 159.0 134.75 24.25 4776.0 1320.0 3816.0 9.0 291.05 9.0 291.05 0.0 0.0 3233.9 582.1 3816.0 INR 3 2.0 64.68 2026-05-11 20:16:31
4445 4656 21 1179 12532 54 Wonder grow 100ml NULL 3105 1 600.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.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-05-11 20:16:31
4446 4657 1 1180 12532 65 SINGLE WELLNESS NULL 94041000 3 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 38997.0 16050.0 32100.0 2.5 764.29 2.5 764.29 0.0 0.0 30571.43 1528.57 32100.0 INR 3 2.0 611.43 2026-05-11 20:20:36
4447 4658 1 1181 12517 46 Root Vitality Hair Oil NULL 3305901 14 102.0 255.0 0.0 0.0 204.0 194.29 9.71 3570.0 1428.0 2856.0 0.0 0.0 0.0 0.0 5.0 136.0 2720.0 136.0 2856.0 INR 2 6.0 163.2 2026-05-11 21:30:30
4448 4659 1 1182 12526 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-05-12 11:11:56
4449 4660 2 1182 12526 57 Safe guard 250ml NULL 3105 1 925.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 925.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-05-12 11:11:56
4450 4661 3 1182 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-05-12 11:11:56