fx_franchise_order_product

4,737 rows · 33 columns · page 35 / 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
1701 1910 38 240 12551 54 Wonder grow 100ml NULL 3105 50 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 70000.0 25000.0 56000.0 2.5 1333.34 2.5 1333.34 0.0 0.0 1066.67 2666.67 56000.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1702 1911 1 241 12551 77 ELITE COMFORT NULL NULL 3 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 161982.0 0.0 55500.0 2.5 1321.43 2.5 1321.43 0.0 0.0 17619.05 2642.86 55500.0 INR 0 0.0 0.0 2025-11-14 14:49:55
1703 1912 1 242 12516 21 All Fuel Juice NULL 22029990 10 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 24990.0 3500.0 24790.0 2.5 590.24 2.5 590.24 0.0 0.0 2360.95 1180.48 24790.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1704 1913 2 242 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-14 15:33:11
1705 1914 3 242 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 50 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 80000.0 22500.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 1219.05 3047.62 64000.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1706 1915 4 242 12516 19 Fat loss Juice 500 ml NULL 30049011 20 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 29980.0 5000.0 29580.0 2.5 704.28 2.5 704.28 0.0 0.0 1408.57 1408.57 29580.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1707 1916 5 242 12516 22 Fit Fuel Juice NULL 2009899 10 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 19990.0 2000.0 19790.0 2.5 471.19 2.5 471.19 0.0 0.0 1884.76 942.38 19790.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1708 1917 6 242 12516 24 Immunomax 24/7 Caps NULL 2009899 10 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4500.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1709 1918 7 242 12516 18 Lady Care Juice 500ml NULL 2009899 20 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 5000.0 23984.0 2.5 571.05 2.5 571.05 0.0 0.0 1142.1 1142.1 23984.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1710 1919 8 242 12516 35 Sanitary Pad (15 pcs) NULL 9619001 20 40.0 380.0 0.0 0.0 304.0 304.0 0.0 7600.0 800.0 6080.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 6080.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1711 1920 9 242 12516 23 Women Fuel Juice NULL 2202999 10 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 19990.0 2000.0 15992.0 2.5 380.76 2.5 380.76 0.0 0.0 1523.05 761.52 15992.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1712 1921 1 243 12516 10 Vitamin D3 Drop NULL 2106909 5 190.0 749.0 0.0 0.0 599.2 570.67 28.53 3745.0 950.0 2996.0 2.5 71.33 2.5 71.33 0.0 0.0 570.67 142.67 2996.0 INR 0 0.0 0.0 2025-11-14 15:37:49
1713 1922 1 244 12516 71 Bio magnetic water pad NULL 9404 10 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 45000.0 10000.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 3428.57 1714.29 36000.0 INR 0 0.0 0.0 2025-11-14 15:40:01
1714 1923 1 245 12855 77 ELITE COMFORT NULL NULL 3 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 161982.0 0.0 55500.0 2.5 1321.43 2.5 1321.43 0.0 0.0 17619.05 2642.86 55500.0 INR 0 0.0 0.0 2025-11-14 15:47:27
1715 1924 1 246 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 8 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 12800.0 3600.0 10240.0 2.5 243.81 2.5 243.81 0.0 0.0 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-14 17:24:56
1716 1925 1 247 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 8 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 12800.0 3600.0 10240.0 2.5 243.81 2.5 243.81 0.0 0.0 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-14 17:41:01
1717 1926 1 248 12555 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.0 28800.0 2.5 685.72 2.5 685.72 0.0 0.0 1371.43 1371.43 28800.0 INR 0 0.0 0.0 2025-11-17 12:26:01
1718 1927 1 249 12554 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.0 28800.0 2.5 685.72 2.5 685.72 0.0 0.0 1371.43 1371.43 28800.0 INR 0 0.0 0.0 2025-11-17 12:26:25
1719 1928 1 250 12551 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 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1720 1929 2 250 12551 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 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-18 13:38:15
1721 1930 3 250 12551 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1722 1931 4 250 12551 32 Neem Soap 100gm NULL 34011110 1110 10.0 60.0 0.0 0.0 48.0 45.71 2.29 66600.0 11100.0 53280.0 2.5 1268.57 2.5 1268.57 0.0 0.0 45.71 2537.14 53280.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1723 1932 5 250 12551 46 Root Vitality Hair Oil NULL 3305901 5 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 270.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 194.29 48.57 1020.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1724 1933 1 251 12552 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-18 16:12:53
1725 1934 2 251 12552 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-18 16:12:53
1726 1935 1 252 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-18 17:22:34
1727 1936 2 252 12517 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 0.0 0.0 0.0 0.0 5.0 499.95 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-18 17:22:34
1728 1937 1 253 12555 74 EXPLORER BOX NULL NULL 30 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 809910.0 0.0 314970.0 2.5 7499.28 2.5 7499.28 0.0 0.0 9999.05 14998.57 314970.0 INR 0 0.0 0.0 2025-11-18 22:39:28
1729 1938 1 254 12554 74 EXPLORER BOX NULL NULL 40 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1079880.0 0.0 419960.0 2.5 9999.05 2.5 9999.05 0.0 0.0 9999.05 19998.1 419960.0 INR 0 0.0 0.0 2025-11-18 22:41:31
1730 1939 1 255 12516 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-18 22:44:17
1731 1940 1 256 12555 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-19 14:27:00
1732 1941 1 257 12555 48 glow face wash NULL 3304999 10 100.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 1000.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-19 17:59:07
1733 1942 1 258 12555 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 2.5 132.95 2.5 132.95 0.0 0.0 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-19 18:07:08
1734 1943 2 258 12555 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-19 18:07:08
1735 1944 1 259 12554 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-19 18:08:15
1736 1945 1 260 12516 8 Piles Care NULL 30049011 40 250.0 899.0 0.0 0.0 719.2 684.95 34.25 35960.0 10000.0 28768.0 2.5 684.95 2.5 684.95 0.0 0.0 684.95 1369.9 28768.0 INR 0 0.0 0.0 2025-11-19 18:09:08
1737 1946 1 261 12552 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-19 21:38:07
1738 1947 1 262 12855 48 glow face wash NULL 3304999 11 100.0 380.0 0.0 0.0 304.0 257.63 46.37 4180.0 1100.0 3344.0 9.0 255.05 9.0 255.05 0.0 0.0 257.63 510.1 3344.0 INR 0 0.0 0.0 2025-11-20 12:35:41
1739 1948 2 262 12855 32 Neem Soap 100gm NULL 34011110 1104 10.0 60.0 0.0 0.0 48.0 45.71 2.29 66240.0 11040.0 52992.0 2.5 1261.71 2.5 1261.71 0.0 0.0 45.71 2523.43 52992.0 INR 0 0.0 0.0 2025-11-20 12:35:41
1740 1949 1 263 12855 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 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-20 13:59:55
1741 1950 2 263 12855 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 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-20 13:59:55
1742 1951 3 263 12855 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-20 13:59:55
1743 1952 1 264 12555 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 2.5 66.47 2.5 66.47 0.0 0.0 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1744 1953 2 264 12555 7 Morning Fresh Churan NULL 30049011 30 40.0 199.0 0.0 0.0 159.2 151.62 7.58 5970.0 1200.0 4776.0 2.5 113.72 2.5 113.72 0.0 0.0 151.62 227.43 4776.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1745 1954 3 264 12555 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 2.5 380.57 2.5 380.57 0.0 0.0 761.14 761.14 15984.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1746 1955 4 264 12555 72 Pain Relief Patch NULL 30051090 20 200.0 800.0 0.0 0.0 640.0 609.52 30.48 16000.0 4000.0 12800.0 2.5 304.76 2.5 304.76 0.0 0.0 609.52 609.52 12800.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1747 1956 5 264 12555 46 Root Vitality Hair Oil NULL 3305901 100 54.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 5400.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 194.29 971.43 20400.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1748 1957 6 264 12555 35 Sanitary Pad (15 pcs) NULL 9619001 40 40.0 380.0 0.0 0.0 304.0 304.0 0.0 15200.0 1600.0 12160.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 12160.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1749 1958 1 265 12554 46 Root Vitality Hair Oil NULL 3305901 100 54.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 5400.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 194.29 971.43 20400.0 INR 0 0.0 0.0 2025-11-20 14:04:39
1750 1959 2 265 12554 35 Sanitary Pad (15 pcs) NULL 9619001 40 40.0 380.0 0.0 0.0 304.0 304.0 0.0 15200.0 1600.0 12160.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 12160.0 INR 0 0.0 0.0 2025-11-20 14:04:39