fx_franchise_order_product

4,737 rows · 33 columns · page 49 / 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
2401 2610 4 625 13438 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 0.0 0.0 0.0 0.0 18.0 170.54 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-07 22:12:47
2402 2611 1 626 12554 9 Omega 369 NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 6857.14 342.86 7200.0 INR 2 6.0 411.43 2026-01-07 22:41:59
2403 2612 1 627 13438 9 Omega 369 NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 22:44:38
2404 2613 1 628 13438 32 Neem Soap 100gm NULL 34011110 20 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 0.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-01-07 23:14:20
2405 2614 1 629 13438 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.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-08 13:02:01
2406 2615 1 630 12517 15 KIDNEY CARE JUICE NULL 2009899 30 0.0 349.0 0.0 0.0 279.0 265.71 13.29 10470.0 0.0 8370.0 0.0 0.0 0.0 0.0 5.0 398.57 7971.43 398.57 8370.0 INR 2 6.0 478.29 2026-01-08 14:03:13
2407 2616 1 631 12517 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 0.0 0.0 0.0 0.0 5.0 247.62 4952.38 247.62 5200.0 INR 2 6.0 297.14 2026-01-08 14:04:19
2408 2617 1 632 12521 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-08 17:29:46
2409 2618 2 632 12521 79 ALKALINE JUG NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 9.0 755.08 9.0 755.08 0.0 0.0 8389.83 1510.17 9900.0 INR 3 0.0 150.0 2026-01-08 17:29:46
2410 2619 3 632 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.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-01-08 17:29:46
2411 2620 4 632 12521 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-08 17:29:46
2412 2621 5 632 12521 39 Fabric Wash 1000ml NULL 3924101 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-08 17:29:46
2413 2622 6 632 12521 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.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-08 17:29:46
2414 2623 7 632 12521 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-08 17:29:46
2415 2624 8 632 12521 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-01-08 17:29:46
2416 2625 9 632 12521 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.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-08 17:29:46
2417 2626 10 632 12521 35 Sanitary Pad (15 pcs) NULL 9619001 10 0.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 0.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 3040.0 0.0 3040.0 INR 3 2.0 60.8 2026-01-08 17:29:46
2418 2627 11 632 12521 53 Terra care 2 kg NULL 3103100 3 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 0.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-01-08 17:29:46
2419 2628 12 632 12521 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-01-08 17:29:46
2420 2629 1 633 12523 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 2500.0 0.0 2000.0 1.5 29.13 1.5 29.13 0.0 0.0 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-08 19:11:01
2421 2630 1 634 12517 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 2 6.0 272.57 2026-01-08 20:41:47
2422 2631 2 634 12517 12 P RADIANCE FACE SERUM NULL 33049990 20 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 25000.0 0.0 15000.0 0.0 0.0 0.0 0.0 5.0 714.29 14285.71 714.29 15000.0 INR 2 6.0 857.14 2026-01-08 20:41:47
2423 2632 3 634 12517 81 PREMIUM GLOW FACE WASH NULL 3404 20 0.0 699.0 0.0 0.0 559.0 512.84 46.16 13980.0 0.0 11180.0 0.0 0.0 0.0 0.0 9.0 923.12 10256.88 923.12 11180.0 INR 2 6.0 615.41 2026-01-08 20:41:47
2424 2633 4 634 12517 47 Premium Hair Care Shampoo NULL 3305109 20 0.0 699.0 0.0 0.0 559.0 532.38 26.62 13980.0 0.0 11180.0 0.0 0.0 0.0 0.0 5.0 532.38 10647.62 532.38 11180.0 INR 2 6.0 638.86 2026-01-08 20:41:47
2425 2634 5 634 12517 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 20 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 25000.0 0.0 15000.0 0.0 0.0 0.0 0.0 5.0 714.29 14285.71 714.29 15000.0 INR 2 6.0 857.14 2026-01-08 20:41:47
2426 2635 6 634 12517 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 10 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 14240.0 0.0 7500.0 0.0 0.0 0.0 0.0 5.0 357.14 7142.86 357.14 7500.0 INR 2 6.0 428.57 2026-01-08 20:41:47
2427 2636 1 635 12516 12 P RADIANCE FACE SERUM NULL 33049990 30 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 37500.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 21428.57 1071.43 22500.0 INR 1 8.0 1714.29 2026-01-08 20:44:03
2428 2637 2 635 12516 81 PREMIUM GLOW FACE WASH NULL 3404 30 0.0 699.0 0.0 0.0 559.0 512.84 46.16 20970.0 0.0 16770.0 4.5 692.34 4.5 692.34 0.0 0.0 15385.32 1384.68 16770.0 INR 1 8.0 1230.83 2026-01-08 20:44:03
2429 2638 3 635 12516 47 Premium Hair Care Shampoo NULL 3305109 30 0.0 699.0 0.0 0.0 559.0 532.38 26.62 20970.0 0.0 16770.0 2.5 399.29 2.5 399.29 0.0 0.0 15971.43 798.57 16770.0 INR 1 8.0 1277.71 2026-01-08 20:44:03
2430 2639 4 635 12516 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 30 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 37500.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 21428.57 1071.43 22500.0 INR 1 8.0 1714.29 2026-01-08 20:44:03
2431 2640 5 635 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 30 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 42720.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 21428.57 1071.43 22500.0 INR 1 8.0 1714.29 2026-01-08 20:44:03
2432 2641 1 636 12545 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.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-08 22:07:51
2433 2642 2 636 12545 3 BP Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.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-01-08 22:07:51
2434 2643 3 636 12545 39 Fabric Wash 1000ml NULL 3924101 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-08 22:07:51
2435 2644 4 636 12545 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-08 22:07:51
2436 2645 5 636 12545 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-08 22:07:51
2437 2646 6 636 12545 12 P RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.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-01-08 22:07:51
2438 2647 7 636 12545 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-08 22:07:51
2439 2648 8 636 12545 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-01-08 22:07:51
2440 2649 9 636 12545 35 Sanitary Pad (15 pcs) NULL 9619001 3 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 0.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 912.0 0.0 912.0 INR 3 2.0 18.24 2026-01-08 22:07:51
2441 2650 10 636 12545 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-08 22:07:51
2442 2651 11 636 12545 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-08 22:07:51
2443 2652 1 637 12552 48 glow face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-08 22:47:06
2444 2653 2 637 12552 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 2500.0 0.0 2000.0 1.5 29.13 1.5 29.13 0.0 0.0 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-08 22:47:06
2445 2654 3 637 12552 38 Dish Wash 500ml NULL 3924101 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.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-01-08 22:47:06
2446 2655 4 637 12552 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-08 22:47:06
2447 2656 5 637 12552 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.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-08 22:47:06
2448 2657 6 637 12552 33 Herbal Soap 100gm NULL 30049011 2 0.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 0.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 3 2.0 3.05 2026-01-08 22:47:06
2449 2658 7 637 12552 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.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-01-08 22:47:06
2450 2659 8 637 12552 32 Neem Soap 100gm NULL 34011110 2 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120.0 0.0 96.0 2.5 2.29 2.5 2.29 0.0 0.0 91.43 4.57 96.0 INR 3 2.0 1.83 2026-01-08 22:47:06