fx_franchise_order_product

4,737 rows · 33 columns · page 13 / 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
601 810 7 88 12544 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 23:38:29
602 811 8 88 12544 7 Morning Fresh Churan NULL 30049011 15 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2985.0 600.0 2388.0 2.5 56.85 2.5 56.85 0.0 0.0 151.62 113.71 2388.0 INR 0 0.0 0.0 2025-11-07 23:38:29
603 812 9 88 12544 32 Neem Soap 100gm NULL 34011110 40 10.0 60.0 0.0 0.0 48.0 45.71 2.29 2400.0 400.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 45.71 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 23:38:29
604 813 10 88 12544 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 640.0 609.52 30.48 1600.0 400.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 609.52 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 23:38:29
605 814 11 88 12544 8 Piles Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 23:38:29
606 815 12 88 12544 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 23:38:29
607 816 13 88 12544 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-07 23:38:29
608 817 14 88 12544 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 23:38:29
609 818 15 88 12544 10 Vitamin D3 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 23:38:29
610 819 1 89 12557 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-07 23:42:17
611 820 2 89 12557 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 23:42:17
612 821 3 89 12557 4 Diabetic Care Capsules NULL 2936900 6 250.0 899.0 0.0 0.0 719.2 684.95 34.25 5394.0 1500.0 4315.2 2.5 102.75 2.5 102.75 0.0 0.0 684.95 205.49 4315.2 INR 0 0.0 0.0 2025-11-07 23:42:17
613 822 4 89 12557 33 Herbal Soap 100gm NULL 30049011 30 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 840.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 76.19 114.29 2400.0 INR 0 0.0 0.0 2025-11-07 23:42:17
614 823 5 89 12557 34 Herbo2o Toothpaste NULL 33061090 1 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 45.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 23:42:17
615 824 6 89 12557 17 Memory Booster Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-07 23:42:17
616 825 7 89 12557 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-07 23:42:17
617 826 8 89 12557 32 Neem Soap 100gm NULL 34011110 91 10.0 60.0 0.0 0.0 48.0 45.71 2.29 5460.0 910.0 4368.0 2.5 104.0 2.5 104.0 0.0 0.0 45.71 208.0 4368.0 INR 0 0.0 0.0 2025-11-07 23:42:17
618 827 9 89 12557 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-07 23:42:17
619 828 10 89 12557 46 Root Vitality Hair Oil NULL 3305901 10 54.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 540.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 194.29 97.14 2040.0 INR 0 0.0 0.0 2025-11-07 23:42:17
620 829 11 89 12557 29 Shilajith NULL 30049011 1 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 1800.0 250.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-07 23:42:17
621 830 1 90 12685 48 glow face wash NULL 3304999 3 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 750.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-07 23:47:34
622 831 2 90 12685 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 2.5 121.91 2.5 121.91 0.0 0.0 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 23:47:34
623 832 3 90 12685 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 23:47:34
624 833 4 90 12685 38 Dish Wash 500ml NULL 3924101 9 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2070.0 765.0 1656.0 9.0 126.31 9.0 126.31 0.0 0.0 155.93 252.61 1656.0 INR 0 0.0 0.0 2025-11-07 23:47:34
625 834 5 90 12685 39 Fabric Wash 1000ml NULL 3924101 9 150.0 401.0 0.0 0.0 320.8 271.86 48.94 3609.0 1350.0 2887.2 9.0 220.21 9.0 220.21 0.0 0.0 271.86 440.42 2887.2 INR 0 0.0 0.0 2025-11-07 23:47:34
626 835 6 90 12685 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-07 23:47:34
627 836 7 90 12685 33 Herbal Soap 100gm NULL 30049011 17 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1700.0 476.0 1360.0 2.5 32.38 2.5 32.38 0.0 0.0 76.19 64.76 1360.0 INR 0 0.0 0.0 2025-11-07 23:47:34
628 837 8 90 12685 34 Herbo2o Toothpaste NULL 33061090 10 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 450.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-07 23:47:34
629 838 9 90 12685 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-07 23:47:34
630 839 10 90 12685 32 Neem Soap 100gm NULL 34011110 104 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6240.0 1040.0 4992.0 2.5 118.86 2.5 118.86 0.0 0.0 45.71 237.71 4992.0 INR 0 0.0 0.0 2025-11-07 23:47:34
631 840 11 90 12685 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 2.5 19.03 2.5 19.03 0.0 0.0 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-07 23:47:34
632 841 12 90 12685 8 Piles Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 23:47:34
633 842 13 90 12685 41 Premium Coco Body Lotion NULL 3304300 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 9.0 85.3 9.0 85.3 0.0 0.0 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-11-07 23:47:34
634 843 14 90 12685 46 Root Vitality Hair Oil NULL 3305901 1 54.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 54.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 0 0.0 0.0 2025-11-07 23:47:34
635 844 15 90 12685 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 23:47:34
636 845 16 90 12685 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 23:47:34
637 846 17 90 12685 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 23:47:34
638 847 18 90 12685 53 Terra care 2 kg NULL 3103100 4 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 6000.0 1800.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 23:47:34
639 848 19 90 12685 36 Toilet Cleaner 500ml NULL 3924101 5 30.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 150.0 600.0 9.0 45.77 9.0 45.77 0.0 0.0 101.69 91.53 600.0 INR 0 0.0 0.0 2025-11-07 23:47:34
640 849 20 90 12685 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 23:47:34
641 850 1 91 12548 48 glow face wash NULL 3304999 3 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 750.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-07 23:54:32
642 851 2 91 12548 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 2.5 121.91 2.5 121.91 0.0 0.0 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 23:54:32
643 852 3 91 12548 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 23:54:32
644 853 4 91 12548 38 Dish Wash 500ml NULL 3924101 9 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2070.0 765.0 1656.0 9.0 126.31 9.0 126.31 0.0 0.0 155.93 252.61 1656.0 INR 0 0.0 0.0 2025-11-07 23:54:32
645 854 5 91 12548 39 Fabric Wash 1000ml NULL 3924101 9 150.0 401.0 0.0 0.0 320.8 271.86 48.94 3609.0 1350.0 2887.2 9.0 220.21 9.0 220.21 0.0 0.0 271.86 440.42 2887.2 INR 0 0.0 0.0 2025-11-07 23:54:32
646 855 6 91 12548 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-07 23:54:32
647 856 7 91 12548 33 Herbal Soap 100gm NULL 30049011 17 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1700.0 476.0 1360.0 2.5 32.38 2.5 32.38 0.0 0.0 76.19 64.76 1360.0 INR 0 0.0 0.0 2025-11-07 23:54:32
648 857 8 91 12548 34 Herbo2o Toothpaste NULL 33061090 10 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 450.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-07 23:54:32
649 858 9 91 12548 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-07 23:54:32
650 859 10 91 12548 32 Neem Soap 100gm NULL 34011110 104 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6240.0 1040.0 4992.0 2.5 118.86 2.5 118.86 0.0 0.0 45.71 237.71 4992.0 INR 0 0.0 0.0 2025-11-07 23:54:32