fx_franchise_order_product

4,737 rows · 33 columns · page 92 / 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
4551 4762 3 1211 12539 39 Fabric Wash 1000ml NULL 34029099 1 112.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 112.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-05-28 04:00:28
4552 4763 1 1212 12526 34 Toothpaste NULL 33061090 6 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 330.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-05-28 20:44:51
4553 4764 1 1213 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-29 15:53:20
4554 4765 2 1213 12539 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-29 15:53:20
4555 4766 3 1213 12539 43 Quench Kiss Lip Balm NULL 3304300 1 79.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 79.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-29 15:53:20
4556 4767 4 1213 12539 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-29 15:53:20
4557 4768 1 1214 12539 25 Manicalcium Tablets NULL 2009899 3 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 477.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-05-29 16:14:49
4558 4769 1 1215 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-05-29 23:55:48
4559 4770 2 1215 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-05-29 23:55:48
4560 4771 3 1215 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-29 23:55:48
4561 4772 4 1215 12526 1 Stem Cell Powder NULL 2936900 1 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 2499.0 500.0 1000.0 2.5 23.81 2.5 23.81 0.0 0.0 952.38 47.62 1000.0 INR 3 2.0 19.05 2026-05-29 23:55:48
4562 4773 5 1215 12526 34 Toothpaste NULL 33061090 6 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 330.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-05-29 23:55:48
4563 4774 1 1216 12532 65 SINGLE WELLNESS NULL 94041000 1 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 12999.0 5350.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-05-30 12:44:21
4564 4775 1 1217 12532 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-05-30 13:37:20
4565 4776 2 1217 12532 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-30 13:37:20
4566 4777 3 1217 12532 25 Manicalcium Tablets NULL 2009899 2 159.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 318.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-05-30 13:37:20
4567 4778 4 1217 12532 26 Spirulina Cap NULL 2009899 2 359.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 718.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-05-30 13:37:20
4568 4779 1 1218 12526 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-05-30 21:41:09
4569 4780 2 1218 12526 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-30 21:41:09
4570 4781 3 1218 12526 34 Toothpaste NULL 33061090 12 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 660.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-05-30 21:41:09
4571 4782 1 1219 12545 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-05-31 08:49:43
4572 4783 2 1219 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 50 35.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1750.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-05-31 08:49:43
4573 4784 3 1219 12545 15 KIDNEY CARE JUICE NULL 2009899 4 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1396.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-31 08:49:43
4574 4785 4 1219 12545 25 Manicalcium Tablets NULL 2009899 3 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 477.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-05-31 08:49:43
4575 4786 5 1219 12545 26 Spirulina Cap NULL 2009899 3 359.0 899.0 0.0 0.0 719.0 684.76 34.24 2697.0 1077.0 2157.0 2.5 51.36 2.5 51.36 0.0 0.0 2054.29 102.71 2157.0 INR 3 2.0 41.09 2026-05-31 08:49:43
4576 4787 1 1220 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-05-31 12:39:10
4577 4788 2 1220 12539 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-31 12:39:10
4578 4789 3 1220 12539 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-31 12:39:10
4579 4790 1 1221 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-31 12:43:52
4580 4791 1 1222 12545 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-05-31 21:50:53
4581 4792 2 1222 12545 34 Toothpaste NULL 33061090 5 55.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 275.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-05-31 21:50:53
4582 4793 1 1223 12545 37 Floor Cleaner 500ml NULL 3924101 7 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1393.0 385.0 1113.0 9.0 84.89 9.0 84.89 0.0 0.0 943.22 169.78 1113.0 INR 3 2.0 18.86 2026-05-31 21:51:34
4583 4794 1 1224 12545 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-06-01 12:06:10
4584 4795 2 1224 12545 36 Toilet Cleaner 500ml NULL 3924101 1 42.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 42.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.3 120.0 INR 3 2.0 2.03 2026-06-01 12:06:10
4585 4796 1 1225 12555 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-06-02 17:07:58
4586 4797 1 1226 12516 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 10 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 239990.0 92500.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 176190.48 8809.52 185000.0 INR 1 8.0 14095.24 2026-06-03 14:55:50
4587 4798 1 1227 12554 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 10 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 239990.0 92500.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 176190.48 8809.52 185000.0 INR 2 6.0 10571.43 2026-06-03 17:02:13
4588 4799 1 1228 12554 20 Premium Berry Juice 1000ml NULL 2936900 10 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 34990.0 8000.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.09 761.9 16000.0 INR 2 6.0 914.29 2026-06-03 17:02:33
4589 4800 1 1229 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.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-06-03 17:04:09
4590 4801 2 1229 12555 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 5 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 119995.0 46250.0 92500.0 2.5 2202.38 2.5 2202.38 0.0 0.0 88095.24 4404.76 92500.0 INR 3 2.0 1761.9 2026-06-03 17:04:09
4591 4802 1 1230 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-06-03 21:34:29
4592 4803 2 1230 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-06-03 21:34:29
4593 4804 1 1231 12555 96 TRIM VEDA NULL 30049011 4 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 10000.0 3000.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-06-04 17:20:10
4594 4805 1 1232 12554 64 Bio magnetic bracelet NULL 9404 30 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 299970.0 37500.0 75000.0 1.5 1092.23 1.5 1092.23 0.0 0.0 72815.54 2184.47 75000.0 INR 2 6.0 4368.93 2026-06-05 18:57:52
4595 4806 1 1233 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-06-05 19:50:33
4596 4807 1 1234 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.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-06-06 12:11:14
4597 4808 1 1235 14902 27 Multicharge Cap 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-06-07 09:38:45
4598 4809 2 1235 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-06-07 09:38:45
4599 4810 3 1235 14902 38 Dish Wash 500ml NULL 34029099 10 65.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 650.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-06-07 09:38:45
4600 4811 4 1235 14902 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-06-07 09:38:45