fx_franchise_order_product

4,737 rows · 33 columns · page 15 / 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
701 910 13 101 12527 8 Piles Care NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-08 02:21:46
702 911 14 101 12527 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-08 02:21:46
703 912 15 101 12527 35 Sanitary Pad (15 pcs) NULL 9619001 26 40.0 380.0 0.0 0.0 304.0 304.0 0.0 9880.0 1040.0 7904.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 7904.0 INR 0 0.0 0.0 2025-11-08 02:21:46
704 913 16 101 12527 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 2.5 190.4 2.5 190.4 0.0 0.0 1904.0 380.8 7996.8 INR 0 0.0 0.0 2025-11-08 02:21:46
705 914 17 101 12527 5 Thyro Care NULL 2936900 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-08 02:21:46
706 915 18 101 12527 36 Toilet Cleaner 500ml NULL 3924101 29 30.0 150.0 0.0 0.0 120.0 101.69 18.31 4350.0 870.0 3480.0 9.0 265.43 9.0 265.43 0.0 0.0 101.69 530.85 3480.0 INR 0 0.0 0.0 2025-11-08 02:21:46
707 916 1 102 12516 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 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
708 917 2 102 12516 20 Premium Berry Juice 1000ml NULL 2936900 8 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 27992.0 6000.0 27832.0 2.5 662.66 2.5 662.66 0.0 0.0 3313.33 1325.33 27832.0 INR 0 0.0 0.0 2025-11-08 13:26:29
709 918 3 102 12516 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 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
710 919 4 102 12516 31 Vegan Plant Protein Powder NULL 21061000 7 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 20993.0 7000.0 16794.4 2.5 399.87 2.5 399.87 0.0 0.0 2284.95 799.73 16794.4 INR 0 0.0 0.0 2025-11-08 13:26:29
711 920 5 102 12516 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 9.0 9151.93 9.0 9151.93 0.0 0.0 10168.81 18303.86 119992.0 INR 0 0.0 0.0 2025-11-08 13:26:29
712 921 6 102 12516 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 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-08 13:26:29
713 922 7 102 12516 6 Asthma Care NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
714 923 8 102 12516 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 9.0 134.24 9.0 134.24 0.0 0.0 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-08 13:26:29
715 924 9 102 12516 3 BP Care Capsules NULL 2936900 25 160.0 599.0 0.0 0.0 479.2 456.38 22.82 14975.0 4000.0 11980.0 2.5 285.24 2.5 285.24 0.0 0.0 456.38 570.48 11980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
716 925 10 102 12516 4 Diabetic Care Capsules NULL 2936900 25 250.0 899.0 0.0 0.0 719.2 684.95 34.25 22475.0 6250.0 17980.0 2.5 428.1 2.5 428.1 0.0 0.0 684.95 856.19 17980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
717 926 11 102 12516 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 9.0 2806.78 9.0 2806.78 0.0 0.0 155.93 5613.56 36800.0 INR 0 0.0 0.0 2025-11-08 13:26:29
718 927 12 102 12516 39 Fabric Wash 1000ml NULL 3924101 100 150.0 401.0 0.0 0.0 320.8 271.86 48.94 40100.0 15000.0 32080.0 9.0 2446.78 9.0 2446.78 0.0 0.0 271.86 4893.56 32080.0 INR 0 0.0 0.0 2025-11-08 13:26:29
719 928 13 102 12516 19 Fat loss Juice 500 ml NULL 30049011 5 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 7495.0 1250.0 7395.0 2.5 176.07 2.5 176.07 0.0 0.0 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-08 13:26:29
720 929 14 102 12516 37 Floor Cleaner 500ml NULL 3924101 200 80.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 16000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-08 13:26:29
721 930 15 102 12516 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 2.5 190.38 2.5 190.38 0.0 0.0 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
722 931 16 102 12516 2 Heart Care Capsules NULL 2936900 14 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 5950.0 16788.8 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-08 13:26:29
723 932 17 102 12516 33 Herbal Soap 100gm NULL 30049011 502 28.0 100.0 0.0 0.0 80.0 76.19 3.81 50200.0 14056.0 40160.0 2.5 956.19 2.5 956.19 0.0 0.0 76.19 1912.38 40160.0 INR 0 0.0 0.0 2025-11-08 13:26:29
724 933 18 102 12516 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 9.0 3642.71 9.0 3642.71 0.0 0.0 134.92 7285.42 47760.0 INR 0 0.0 0.0 2025-11-08 13:26:29
725 934 19 102 12516 24 Immunomax 24/7 Caps NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
726 935 20 102 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
727 936 21 102 12516 15 Kidney Stone Juice NULL 2009899 15 120.0 349.0 0.0 0.0 279.2 265.9 13.3 5235.0 1800.0 4188.0 2.5 99.72 2.5 99.72 0.0 0.0 265.9 199.43 4188.0 INR 0 0.0 0.0 2025-11-08 13:26:29
728 937 22 102 12516 18 Lady Care Juice 500ml NULL 2009899 5 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 1250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
729 938 23 102 12516 16 Liver Care Juice NULL 2009899 15 120.0 349.0 0.0 0.0 279.2 265.9 13.3 5235.0 1800.0 4188.0 2.5 99.72 2.5 99.72 0.0 0.0 265.9 199.43 4188.0 INR 0 0.0 0.0 2025-11-08 13:26:29
730 939 24 102 12516 25 Manicalcium Tablets NULL 2009899 5 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1995.0 475.0 1596.0 2.5 38.0 2.5 38.0 0.0 0.0 304.0 76.0 1596.0 INR 0 0.0 0.0 2025-11-08 13:26:29
731 940 25 102 12516 12 Melatonin Drop NULL 2106909 15 190.0 749.0 0.0 0.0 599.2 570.67 28.53 11235.0 2850.0 8988.0 2.5 214.0 2.5 214.0 0.0 0.0 570.67 428.0 8988.0 INR 0 0.0 0.0 2025-11-08 13:26:29
732 941 26 102 12516 17 Memory Booster Juice NULL 2009899 25 120.0 349.0 0.0 0.0 279.2 265.9 13.3 8725.0 3000.0 6980.0 2.5 166.19 2.5 166.19 0.0 0.0 265.9 332.38 6980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
733 942 27 102 12516 7 Morning Fresh Churan NULL 30049011 25 40.0 199.0 0.0 0.0 159.2 151.62 7.58 4975.0 1000.0 3980.0 2.5 94.76 2.5 94.76 0.0 0.0 151.62 189.52 3980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
734 943 28 102 12516 32 Neem Soap 100gm NULL 34011110 601 10.0 60.0 0.0 0.0 48.0 45.71 2.29 36060.0 6010.0 28848.0 2.5 686.86 2.5 686.86 0.0 0.0 45.71 1373.71 28848.0 INR 0 0.0 0.0 2025-11-08 13:26:29
735 944 29 102 12516 9 Omega 369 NULL 2936900 25 260.0 999.0 0.0 0.0 799.2 761.14 38.06 24975.0 6500.0 19980.0 2.5 475.71 2.5 475.71 0.0 0.0 761.14 951.43 19980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
736 945 30 102 12516 28 Ortho Joint Shield NULL 2009899 8 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 11992.0 3600.0 9593.6 2.5 228.42 2.5 228.42 0.0 0.0 1142.1 456.84 9593.6 INR 0 0.0 0.0 2025-11-08 13:26:29
737 946 31 102 12516 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 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-08 13:26:29
738 947 32 102 12516 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 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-08 13:26:29
739 948 33 102 12516 41 Premium Coco Body Lotion NULL 3304300 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-08 13:26:29
740 949 34 102 12516 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-08 13:26:29
741 950 35 102 12516 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 2.5 266.29 2.5 266.29 0.0 0.0 532.57 532.57 11184.0 INR 0 0.0 0.0 2025-11-08 13:26:29
742 951 36 102 12516 13 Premium NONI VEG caps NULL 2936900 5 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2505.0 750.0 2004.0 2.5 47.72 2.5 47.72 0.0 0.0 381.71 95.43 2004.0 INR 0 0.0 0.0 2025-11-08 13:26:29
743 952 37 102 12516 43 Quench Kiss Lip Balm NULL 3304300 5 35.0 199.0 0.0 0.0 159.2 134.92 24.28 995.0 175.0 796.0 9.0 60.71 9.0 60.71 0.0 0.0 134.92 121.42 796.0 INR 0 0.0 0.0 2025-11-08 13:26:29
744 953 38 102 12516 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 2.5 145.72 2.5 145.72 0.0 0.0 194.29 291.43 6120.0 INR 0 0.0 0.0 2025-11-08 13:26:29
745 954 39 102 12516 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-08 13:26:29
746 955 40 102 12516 29 Shilajith NULL 30049011 8 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 14400.0 2000.0 11520.0 2.5 274.29 2.5 274.29 0.0 0.0 1371.43 548.57 11520.0 INR 0 0.0 0.0 2025-11-08 13:26:29
747 956 41 102 12516 26 Spirulina Cap NULL 2009899 15 190.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 2850.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
748 957 42 102 12516 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 2.5 190.4 2.5 190.4 0.0 0.0 1904.0 380.8 7996.8 INR 0 0.0 0.0 2025-11-08 13:26:29
749 958 43 102 12516 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 9.0 853.01 9.0 853.01 0.0 0.0 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-08 13:26:29
750 959 44 102 12516 5 Thyro Care NULL 2936900 25 250.0 899.0 0.0 0.0 719.2 684.95 34.25 22475.0 6250.0 17980.0 2.5 428.1 2.5 428.1 0.0 0.0 684.95 856.19 17980.0 INR 0 0.0 0.0 2025-11-08 13:26:29