fx_franchise_order_product

4,737 rows · 33 columns · page 87 / 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
4301 4512 1 1125 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 5 35.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 175.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-04-29 15:44:54
4302 4513 2 1125 12545 30 Iron Capsules NULL 30049011 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-04-29 15:44:54
4303 4514 3 1125 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-04-29 15:44:54
4304 4515 4 1125 12545 43 Quench Kiss Lip Balm NULL 3304300 3 79.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 237.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-04-29 15:44:54
4305 4516 5 1125 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-04-29 15:44:54
4306 4517 6 1125 12545 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-04-29 15:44:54
4307 4518 7 1125 12545 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-29 15:44:54
4308 4519 8 1125 12545 34 Toothpaste NULL 33061090 15 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 825.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-04-29 15:44:54
4309 4520 1 1126 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 5 35.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 175.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-04-29 15:44:54
4310 4521 2 1126 12545 30 Iron Capsules NULL 30049011 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-04-29 15:44:54
4311 4522 3 1126 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-04-29 15:44:54
4312 4523 4 1126 12545 43 Quench Kiss Lip Balm NULL 3304300 3 79.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 237.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-04-29 15:44:54
4313 4524 5 1126 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-04-29 15:44:54
4314 4525 6 1126 12545 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-04-29 15:44:54
4315 4526 7 1126 12545 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-29 15:44:54
4316 4527 8 1126 12545 34 Toothpaste NULL 33061090 15 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 825.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-04-29 15:44:54
4317 4528 1 1127 12545 32 Neem Soap 100gm NULL 34011110 95 20.0 60.0 0.0 0.0 52.0 49.52 2.48 5700.0 1900.0 4940.0 2.5 117.62 2.5 117.62 0.0 0.0 4704.76 235.24 4940.0 INR 3 2.0 94.1 2026-04-29 16:23:26
4318 4529 1 1128 12526 27 Multicharge Cap NULL 2009899 3 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 1800.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-04-29 23:10:31
4319 4530 2 1128 12526 82 ALKALINE CAPSULE NULL 3402000 4 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 10000.0 3200.0 6600.0 2.5 157.14 2.5 157.14 0.0 0.0 6285.71 314.29 6600.0 INR 3 2.0 125.71 2026-04-29 23:10:31
4320 4531 3 1128 12526 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-29 23:10:31
4321 4532 4 1128 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-29 23:10:31
4322 4533 5 1128 12526 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-29 23:10:31
4323 4534 6 1128 12526 43 Quench Kiss Lip Balm NULL 3304300 5 79.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 395.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-04-29 23:10:31
4324 4535 7 1128 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-29 23:10:31
4325 4536 8 1128 12526 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-04-29 23:10:31
4326 4537 9 1128 12526 1 Stem Cell Powder NULL 2936900 3 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 7497.0 1500.0 3000.0 2.5 71.43 2.5 71.43 0.0 0.0 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-04-29 23:10:31
4327 4538 10 1128 12526 50 Sun Screen NULL 330499 2 279.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 558.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-04-29 23:10:31
4328 4539 1 1129 12545 82 ALKALINE CAPSULE NULL 3402000 1 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 2500.0 800.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-30 05:47:14
4329 4540 2 1129 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 5 35.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 175.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-04-30 05:47:14
4330 4541 3 1129 12545 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-30 05:47:14
4331 4542 4 1129 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-04-30 05:47:14
4332 4543 1 1130 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-04-30 09:06:55
4333 4544 2 1130 12545 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-04-30 09:06:55
4334 4545 1 1131 12552 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-30 09:29:27
4335 4546 2 1131 12552 2 Heart Care Capsules NULL 2936900 4 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 5996.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-04-30 09:29:27
4336 4547 3 1131 12552 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-04-30 09:29:27
4337 4548 1 1132 12545 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-30 09:52:30
4338 4549 2 1132 12545 48 Glow it multi fruit face wash NULL 3304999 3 160.0 450.0 0.0 0.0 320.0 271.19 48.81 1350.0 480.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 3 2.0 16.27 2026-04-30 09:52:30
4339 4550 1 1133 12545 8 Piles Care NULL 30049011 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-04-30 09:59:04
4340 4551 1 1134 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-04-30 10:17:31
4341 4552 1 1135 12545 3 BP 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-30 12:51:54
4342 4553 1 1136 12527 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-30 14:26:25
4343 4554 2 1136 12527 46 Root Vitality Hair Oil NULL 3305901 20 102.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 2040.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.71 194.29 4080.0 INR 3 2.0 77.71 2026-04-30 14:26:25
4344 4555 3 1136 12527 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-04-30 14:26:25
4345 4556 4 1136 12527 34 Toothpaste NULL 33061090 20 55.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 1100.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-04-30 14:26:25
4346 4557 1 1137 12545 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-30 16:42:02
4347 4558 2 1137 12545 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-30 16:42:02
4348 4559 3 1137 12545 36 Toilet Cleaner 500ml NULL 3924101 10 42.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 420.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-04-30 16:42:02
4349 4560 4 1137 12545 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-04-30 16:42:02
4350 4561 1 1138 12545 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-30 19:49:47