fx_franchise_order_product

4,933 rows · 33 columns · page 53 / 99

Invoice view 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
2601 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
2602 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
2603 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
2604 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
2605 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
2606 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
2607 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
2608 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
2609 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
2610 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
2611 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
2612 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
2613 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
2614 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
2615 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
2616 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
2617 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
2618 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
2619 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
2620 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
2621 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
2622 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
2623 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
2624 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
2625 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
2626 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
2627 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
2628 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
2629 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
2630 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
2631 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
2632 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
2633 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
2634 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
2635 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
2636 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
2637 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
2638 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
2639 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
2640 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
2641 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
2642 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
2643 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
2644 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
2645 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
2646 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
2647 2660 9 637 12552 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-08 22:47:06
2648 2661 10 637 12552 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-08 22:47:06
2649 2662 11 637 12552 41 Premium Coco Body Lotion NULL 3304300 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.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-01-08 22:47:06
2650 2663 12 637 12552 81 PREMIUM GLOW FACE WASH NULL 3404 2 0.0 699.0 0.0 0.0 559.0 512.84 46.16 1398.0 0.0 1118.0 4.5 46.16 4.5 46.16 0.0 0.0 1025.69 92.31 1118.0 INR 3 2.0 20.51 2026-01-08 22:47:06