fx_franchise_order_product

4,737 rows · 33 columns · page 16 / 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
751 960 45 102 12516 36 Toilet Cleaner 500ml NULL 3924101 200 30.0 150.0 0.0 0.0 120.0 101.69 18.31 30000.0 6000.0 24000.0 9.0 1830.51 9.0 1830.51 0.0 0.0 101.69 3661.02 24000.0 INR 0 0.0 0.0 2025-11-08 13:26:29
752 961 46 102 12516 44 Vital Glow Face Scrub NULL 3304300 5 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 355.0 1300.0 9.0 99.16 9.0 99.16 0.0 0.0 220.34 198.31 1300.0 INR 0 0.0 0.0 2025-11-08 13:26:29
753 962 47 102 12516 11 Vitamin B12 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-08 13:26:29
754 963 48 102 12516 10 Vitamin D3 Drop NULL 2106909 9 190.0 749.0 0.0 0.0 599.2 570.67 28.53 6741.0 1710.0 5392.8 2.5 128.4 2.5 128.4 0.0 0.0 570.67 256.8 5392.8 INR 0 0.0 0.0 2025-11-08 13:26:29
755 964 1 103 12526 73 ENTRY BOX NULL NULL 3 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 11995.2 0.0 11995.2 2.5 285.6 2.5 285.6 0.0 0.0 3808.0 571.2 11995.2 INR 0 0.0 0.0 2025-11-08 16:25:14
756 965 1 104 12548 52 Bhoo sanjeevni 5 kg NULL 3103100 5 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 8000.0 2250.0 6400.0 2.5 152.38 2.5 152.38 0.0 0.0 1219.05 304.76 6400.0 INR 0 0.0 0.0 2025-11-08 16:46:05
757 966 2 104 12548 33 Herbal Soap 100gm NULL 30049011 50 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1400.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 76.19 190.48 4000.0 INR 0 0.0 0.0 2025-11-08 16:46:05
758 967 3 104 12548 53 Terra care 2 kg NULL 3103100 5 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 7500.0 2250.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-08 16:46:05
759 968 1 105 12532 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 09:46:23
760 969 1 106 12517 20 Premium Berry Juice 1000ml NULL 2936900 3 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 10497.0 2250.0 10437.0 0.0 0.0 0.0 0.0 5.0 497.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-09 12:02:35
761 970 2 106 12517 61 Radiation chip NULL 902221 5 325.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1625.0 3996.0 0.0 0.0 0.0 0.0 18.0 609.56 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-09 12:02:35
762 971 3 106 12517 31 Vegan Plant Protein Powder NULL 21061000 3 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 8997.0 3000.0 7197.6 0.0 0.0 0.0 0.0 5.0 342.74 2284.95 342.74 7197.6 INR 0 0.0 0.0 2025-11-09 12:02:35
763 972 4 106 12517 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.0 7992.0 0.0 0.0 0.0 0.0 18.0 1219.12 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
764 973 5 106 12517 6 Asthma Care NULL 30049011 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
765 974 6 106 12517 40 Bamboo Brush NULL 96032100 20 25.0 110.0 0.0 0.0 88.0 74.58 13.42 2200.0 500.0 1760.0 0.0 0.0 0.0 0.0 18.0 268.47 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-09 12:02:35
766 975 7 106 12517 3 BP Care Capsules NULL 2936900 20 160.0 599.0 0.0 0.0 479.2 456.38 22.82 11980.0 3200.0 9584.0 0.0 0.0 0.0 0.0 5.0 456.38 456.38 456.38 9584.0 INR 0 0.0 0.0 2025-11-09 12:02:35
767 976 8 106 12517 4 Diabetic Care Capsules NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
768 977 9 106 12517 60 Foot patch NULL 30051090 5 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 9995.0 2500.0 7996.0 0.0 0.0 0.0 0.0 5.0 380.76 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-09 12:02:35
769 978 10 106 12517 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
770 979 11 106 12517 33 Herbal Soap 100gm NULL 30049011 500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 50000.0 14000.0 40000.0 0.0 0.0 0.0 0.0 5.0 1904.76 76.19 1904.76 40000.0 INR 0 0.0 0.0 2025-11-09 12:02:35
771 980 12 106 12517 34 Herbo2o Toothpaste NULL 33061090 300 45.0 199.0 0.0 0.0 159.2 134.92 24.28 59700.0 13500.0 47760.0 0.0 0.0 0.0 0.0 18.0 7285.42 134.92 7285.42 47760.0 INR 0 0.0 0.0 2025-11-09 12:02:35
772 981 13 106 12517 30 Iron Capsules NULL 30049011 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
773 982 14 106 12517 15 Kidney Stone Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 0.0 0.0 0.0 0.0 5.0 132.95 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-09 12:02:35
774 983 15 106 12517 16 Liver Care Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 0.0 0.0 0.0 0.0 5.0 132.95 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-09 12:02:35
775 984 16 106 12517 12 Melatonin Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 0.0 0.0 0.0 0.0 5.0 285.33 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
776 985 17 106 12517 17 Memory Booster Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 0.0 0.0 0.0 0.0 5.0 265.9 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-09 12:02:35
777 986 18 106 12517 7 Morning Fresh Churan NULL 30049011 20 40.0 199.0 0.0 0.0 159.2 151.62 7.58 3980.0 800.0 3184.0 0.0 0.0 0.0 0.0 5.0 151.62 151.62 151.62 3184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
778 987 19 106 12517 32 Neem Soap 100gm NULL 34011110 600 10.0 60.0 0.0 0.0 48.0 45.71 2.29 36000.0 6000.0 28800.0 0.0 0.0 0.0 0.0 5.0 1371.43 45.71 1371.43 28800.0 INR 0 0.0 0.0 2025-11-09 12:02:35
779 988 20 106 12517 9 Omega 369 NULL 2936900 20 260.0 999.0 0.0 0.0 799.2 761.14 38.06 19980.0 5200.0 15984.0 0.0 0.0 0.0 0.0 5.0 761.14 761.14 761.14 15984.0 INR 0 0.0 0.0 2025-11-09 12:02:35
780 989 21 106 12517 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 0.0 0.0 0.0 0.0 5.0 171.31 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-09 12:02:35
781 990 22 106 12517 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 0.0 0.0 0.0 0.0 5.0 152.38 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-09 12:02:35
782 991 23 106 12517 8 Piles Care NULL 30049011 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
783 992 24 106 12517 47 Premium Hair Care Shampoo NULL 3305109 20 150.0 699.0 0.0 0.0 559.2 532.57 26.63 13980.0 3000.0 11184.0 0.0 0.0 0.0 0.0 5.0 532.57 532.57 532.57 11184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
784 993 25 106 12517 46 Root Vitality Hair Oil NULL 3305901 30 54.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 1620.0 6120.0 0.0 0.0 0.0 0.0 5.0 291.43 194.29 291.43 6120.0 INR 0 0.0 0.0 2025-11-09 12:02:35
785 994 26 106 12517 35 Sanitary Pad (15 pcs) NULL 9619001 200 40.0 380.0 0.0 0.0 304.0 304.0 0.0 76000.0 8000.0 60800.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 60800.0 INR 0 0.0 0.0 2025-11-09 12:02:35
786 995 27 106 12517 29 Shilajith NULL 30049011 3 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 750.0 4320.0 0.0 0.0 0.0 0.0 5.0 205.71 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-09 12:02:35
787 996 28 106 12517 26 Spirulina Cap NULL 2009899 10 190.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 1900.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
788 997 29 106 12517 1 Stem Cell Powder NULL 2936900 4 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 9996.0 2996.0 7996.8 0.0 0.0 0.0 0.0 5.0 380.8 1904.0 380.8 7996.8 INR 0 0.0 0.0 2025-11-09 12:02:35
789 998 30 106 12517 50 Sun Screen NULL 330499 20 250.0 699.0 0.0 0.0 559.2 473.9 85.3 13980.0 5000.0 11184.0 0.0 0.0 0.0 0.0 18.0 1706.03 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
790 999 31 106 12517 5 Thyro Care NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
791 1000 32 106 12517 44 Vital Glow Face Scrub NULL 3304300 5 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 355.0 1300.0 0.0 0.0 0.0 0.0 18.0 198.31 220.34 198.31 1300.0 INR 0 0.0 0.0 2025-11-09 12:02:35
792 1001 33 106 12517 10 Vitamin D3 Drop NULL 2106909 9 190.0 749.0 0.0 0.0 599.2 570.67 28.53 6741.0 1710.0 5392.8 0.0 0.0 0.0 0.0 5.0 256.8 570.67 256.8 5392.8 INR 0 0.0 0.0 2025-11-09 12:02:35
793 1002 1 107 12517 27 Multicharge Cap NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 0.0 0.0 0.0 0.0 5.0 285.52 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
794 1003 2 107 12517 20 Premium Berry Juice 1000ml NULL 2936900 5 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 17495.0 3750.0 17395.0 0.0 0.0 0.0 0.0 5.0 828.33 3313.33 828.33 17395.0 INR 0 0.0 0.0 2025-11-09 12:31:27
795 1004 3 107 12517 31 Vegan Plant Protein Powder NULL 21061000 4 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 11996.0 4000.0 9596.8 0.0 0.0 0.0 0.0 5.0 456.99 2284.95 456.99 9596.8 INR 0 0.0 0.0 2025-11-09 12:31:27
796 1005 4 107 12517 79 ALKALINE JUG NULL 8421 10 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 149990.0 35000.0 119992.0 0.0 0.0 0.0 0.0 18.0 18303.86 10168.81 18303.86 119992.0 INR 0 0.0 0.0 2025-11-09 12:31:27
797 1006 5 107 12517 6 Asthma Care NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
798 1007 6 107 12517 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 0.0 0.0 0.0 0.0 5.0 114.1 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
799 1008 7 107 12517 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
800 1009 8 107 12517 38 Dish Wash 500ml NULL 3924101 200 85.0 230.0 0.0 0.0 184.0 155.93 28.07 46000.0 17000.0 36800.0 0.0 0.0 0.0 0.0 18.0 5613.56 155.93 5613.56 36800.0 INR 0 0.0 0.0 2025-11-09 12:31:27