fx_franchise_order_product

4,737 rows · 33 columns · page 46 / 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
2251 2460 1 583 12554 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 2 6.0 2.74 2026-01-03 22:03:29
2252 2461 1 584 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 2 6.0 71.43 2026-01-03 22:04:12
2253 2462 1 585 12518 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-03 22:21:25
2254 2463 2 585 12518 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.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-01-03 22:21:25
2255 2464 3 585 12518 38 Dish Wash 500ml NULL 3924101 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-03 22:21:25
2256 2465 4 585 12518 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.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-01-03 22:21:25
2257 2466 5 585 12518 34 Herbo2o Toothpaste NULL 33061090 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.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-01-03 22:21:25
2258 2467 6 585 12518 16 Liver Care Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-03 22:21:25
2259 2468 7 585 12518 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-03 22:21:25
2260 2469 8 585 12518 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-03 22:21:25
2261 2470 9 585 12518 47 Premium Hair Care Shampoo NULL 3305109 5 0.0 699.0 0.0 0.0 559.0 532.38 26.62 3495.0 0.0 2795.0 2.5 66.55 2.5 66.55 0.0 0.0 2661.91 133.1 2795.0 INR 3 2.0 53.24 2026-01-03 22:21:25
2262 2471 10 585 12518 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.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-01-03 22:21:25
2263 2472 11 585 12518 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.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-01-03 22:21:25
2264 2473 12 585 12518 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.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-01-03 22:21:25
2265 2474 1 586 12545 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.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-01-04 11:08:14
2266 2475 2 586 12545 34 Herbo2o Toothpaste NULL 33061090 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.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-01-04 11:08:14
2267 2476 3 586 12545 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-04 11:08:14
2268 2477 4 586 12545 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 0.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-04 11:08:14
2269 2478 1 587 12517 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 0.0 0.0 0.0 0.0 9.0 46.16 512.84 46.16 559.0 INR 2 6.0 30.77 2026-01-04 21:40:06
2270 2479 1 588 12549 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.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-01-04 21:45:26
2271 2480 2 588 12549 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.63 9.0 60.63 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-04 21:45:26
2272 2481 3 588 12549 34 Herbo2o Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-01-04 21:45:26
2273 2482 4 588 12549 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-04 21:45:26
2274 2483 5 588 12549 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 4.5 23.08 4.5 23.08 0.0 0.0 512.84 46.16 559.0 INR 3 2.0 10.26 2026-01-04 21:45:26
2275 2484 6 588 12549 26 Spirulina Cap NULL 2009899 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.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-01-04 21:45:26
2276 2485 1 589 12549 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.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-01-05 14:09:40
2277 2486 2 589 12549 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.63 9.0 60.63 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-05 14:09:40
2278 2487 3 589 12549 34 Herbo2o Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-01-05 14:09:40
2279 2488 4 589 12549 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-05 14:09:40
2280 2489 5 589 12549 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.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-01-05 14:09:40
2281 2490 6 589 12549 26 Spirulina Cap NULL 2009899 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.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-01-05 14:09:40
2282 2491 1 590 12685 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-05 20:06:58
2283 2492 2 590 12685 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.91 2.5 61.91 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-05 20:06:58
2284 2493 3 590 12685 31 Vegan Plant Protein Powder NULL 21061000 1 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 2999.0 0.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-01-05 20:06:58
2285 2494 4 590 12685 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.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-01-05 20:06:58
2286 2495 5 590 12685 19 Fat loss Juice 500 ml NULL 30049011 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.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-01-05 20:06:58
2287 2496 6 590 12685 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.12 9.0 12.12 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-05 20:06:58
2288 2497 7 590 12685 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.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-01-05 20:06:58
2289 2498 8 590 12685 34 Herbo2o Toothpaste NULL 33061090 7 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1393.0 0.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-01-05 20:06:58
2290 2499 9 590 12685 15 KIDNEY CARE JUICE NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-05 20:06:58
2291 2500 10 590 12685 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.15 2.5 1.15 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-05 20:06:58
2292 2501 11 590 12685 9 Omega 369 NULL 2936900 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-01-05 20:06:58
2293 2502 12 590 12685 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-01-05 20:06:58
2294 2503 13 590 12685 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.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-01-05 20:06:58
2295 2504 14 590 12685 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.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-01-05 20:06:58
2296 2505 15 590 12685 26 Spirulina Cap NULL 2009899 4 0.0 899.0 0.0 0.0 719.0 684.76 34.24 3596.0 0.0 2876.0 2.5 68.47 2.5 68.47 0.0 0.0 2739.05 136.95 2876.0 INR 3 2.0 54.78 2026-01-05 20:06:58
2297 2506 16 590 12685 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.3 9.0 18.3 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-05 20:06:58
2298 2507 1 591 12548 27 Multicharge Cap NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.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-01-05 20:53:19
2299 2508 2 591 12548 38 Dish Wash 500ml NULL 3924101 3 0.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 0.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-01-05 20:53:19
2300 2509 3 591 12548 39 Fabric Wash 1000ml NULL 3924101 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.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-01-05 20:53:19