fx_franchise_order_product

4,737 rows · 33 columns · page 91 / 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
4501 4712 4 1197 12526 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-20 21:02:32
4502 4713 5 1197 12526 25 Manicalcium Tablets NULL 2009899 4 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1596.0 636.0 1276.0 2.5 30.38 2.5 30.38 0.0 0.0 1215.24 60.76 1276.0 INR 3 2.0 24.3 2026-05-20 21:02:32
4503 4714 6 1197 12526 17 Memory Booster 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-20 21:02:32
4504 4715 7 1197 12526 7 Morning Fresh Churan NULL 30049011 3 79.0 199.0 0.0 0.0 179.0 170.48 8.52 597.0 237.0 537.0 2.5 12.79 2.5 12.79 0.0 0.0 511.43 25.57 537.0 INR 3 2.0 10.23 2026-05-20 21:02:32
4505 4716 8 1197 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-05-20 21:02:32
4506 4717 9 1197 12526 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.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-05-20 21:02:32
4507 4718 1 1198 12545 15 KIDNEY 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-21 05:48:12
4508 4719 2 1198 12545 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-21 05:48:12
4509 4720 1 1199 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-05-21 14:28:32
4510 4721 2 1199 12539 33 HALDI CHANDAN SOAP 100gm NULL 30049011 1 35.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 35.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-05-21 14:28:32
4511 4722 1 1200 14079 33 HALDI CHANDAN SOAP 100gm NULL 30049011 12 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1200.0 420.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-05-21 19:41:17
4512 4723 2 1200 14079 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-21 19:41:17
4513 4724 1 1201 12545 37 Floor Cleaner 500ml NULL 3924101 1 55.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 55.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-05-21 20:36:55
4514 4725 2 1201 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 350.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-05-21 20:36:55
4515 4726 3 1201 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-21 20:36:55
4516 4727 4 1201 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-21 20:36:55
4517 4728 5 1201 12545 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-21 20:36:55
4518 4729 1 1202 12517 48 Glow it multi fruit face wash NULL 3304999 20 160.0 450.0 0.0 0.0 320.0 271.19 48.81 9000.0 3200.0 6400.0 0.0 0.0 0.0 0.0 18.0 976.27 5423.73 976.27 6400.0 INR 2 6.0 325.42 2026-05-21 21:00:05
4519 4730 1 1203 12545 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-21 21:28:30
4520 4731 2 1203 12545 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.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-05-21 21:28:30
4521 4732 1 1204 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-05-22 14:06:55
4522 4733 1 1205 12554 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 2 6.0 1456.31 2026-05-22 17:41:45
4523 4734 1 1206 12555 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 3 2.0 485.44 2026-05-22 17:43:22
4524 4735 1 1207 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-05-23 16:18:38
4525 4736 2 1207 12539 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.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-05-23 16:18:38
4526 4737 1 1208 12545 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-05-23 16:38:13
4527 4738 1 1209 14902 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-24 13:03:29
4528 4739 2 1209 14902 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-05-24 13:03:29
4529 4740 3 1209 14902 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-05-24 13:03:29
4530 4741 4 1209 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.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-05-24 13:03:29
4531 4742 5 1209 14902 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-24 13:03:29
4532 4743 6 1209 14902 28 Ortho Joint Shield NULL 2009899 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-05-24 13:03:29
4533 4744 7 1209 14902 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.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-05-24 13:03:29
4534 4745 8 1209 14902 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-05-24 13:03:29
4535 4746 9 1209 14902 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-24 13:03:29
4536 4747 10 1209 14902 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-05-24 13:03:29
4537 4748 11 1209 14902 36 Toilet Cleaner 500ml NULL 3924101 2 42.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 84.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-05-24 13:03:29
4538 4749 1 1210 14902 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-24 23:19:14
4539 4750 2 1210 14902 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-05-24 23:19:14
4540 4751 3 1210 14902 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-05-24 23:19:14
4541 4752 4 1210 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.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-05-24 23:19:14
4542 4753 5 1210 14902 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-24 23:19:14
4543 4754 6 1210 14902 28 Ortho Joint Shield NULL 2009899 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-05-24 23:19:14
4544 4755 7 1210 14902 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.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-05-24 23:19:14
4545 4756 8 1210 14902 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-05-24 23:19:14
4546 4757 9 1210 14902 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-24 23:19:14
4547 4758 10 1210 14902 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-05-24 23:19:14
4548 4759 11 1210 14902 36 Toilet Cleaner 500ml NULL 3924101 2 42.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 84.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-05-24 23:19:14
4549 4760 1 1211 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-05-28 04:00:28
4550 4761 2 1211 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-28 04:00:28