fx_franchise_order_product

4,737 rows · 33 columns · page 37 / 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
1801 2010 3 290 12555 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 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:17:15
1802 2011 4 290 12555 10 Vitamin D3 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:17:15
1803 2012 1 291 12554 48 glow face wash NULL 3304999 100 100.0 380.0 0.0 0.0 304.0 257.63 46.37 38000.0 10000.0 30400.0 9.0 2318.64 9.0 2318.64 0.0 0.0 257.63 4637.29 30400.0 INR 0 0.0 0.0 2025-11-28 13:18:20
1804 2013 2 291 12554 34 Herbo2o Toothpaste NULL 33061090 200 45.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 9000.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-28 13:18:20
1805 2014 3 291 12554 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 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:18:20
1806 2015 4 291 12554 10 Vitamin D3 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:18:20
1807 2016 1 292 12516 48 glow face wash NULL 3304999 100 100.0 380.0 0.0 0.0 304.0 257.63 46.37 38000.0 10000.0 30400.0 9.0 2318.64 9.0 2318.64 0.0 0.0 257.63 4637.29 30400.0 INR 0 0.0 0.0 2025-11-28 13:19:22
1808 2017 2 292 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-28 13:19:22
1809 2018 3 292 12516 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 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:19:22
1810 2019 4 292 12516 10 Vitamin D3 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:19:22
1811 2020 1 293 12555 38 Dish Wash 500ml NULL 3924101 100 85.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 8500.0 18400.0 9.0 1403.39 9.0 1403.39 0.0 0.0 155.93 2806.78 18400.0 INR 0 0.0 0.0 2025-11-28 14:33:54
1812 2021 2 293 12555 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-28 14:33:54
1813 2022 3 293 12555 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:33:54
1814 2023 4 293 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-28 14:33:54
1815 2024 1 294 12554 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:37:16
1816 2025 2 294 12554 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-28 14:37:16
1817 2026 1 295 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:38:07
1818 2027 2 295 12516 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-28 14:38:07
1819 2028 1 296 12551 48 glow face wash NULL 3304999 3 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 300.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-28 15:12:10
1820 2029 1 297 12557 48 glow face wash NULL 3304999 1 100.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 100.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-28 16:29:49
1821 2030 1 298 12555 60 Foot patch NULL 30051090 10 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 19990.0 5000.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-29 15:18:16
1822 2031 1 299 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 32 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 51200.0 14400.0 40960.0 2.5 975.24 2.5 975.24 0.0 0.0 1219.05 1950.48 40960.0 INR 0 0.0 0.0 2025-11-29 17:33:41
1823 2032 1 300 12551 52 Bhoo sanjeevni 5 kg NULL 3103100 32 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 51200.0 14400.0 40960.0 2.5 975.24 2.5 975.24 0.0 0.0 1219.05 1950.48 40960.0 INR 0 0.0 0.0 2025-11-29 17:41:09
1824 2033 1 301 12551 48 glow face wash NULL 3304999 4 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 400.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-29 17:43:50
1825 2034 1 302 12551 48 glow face wash NULL 3304999 4 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 400.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-29 18:27:21
1826 2035 1 303 12551 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-29 18:42:52
1827 2036 1 304 12551 21 All Fuel Juice NULL 22029990 3 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 7497.0 1050.0 7437.0 2.5 177.07 2.5 177.07 0.0 0.0 2360.95 354.14 7437.0 INR 0 0.0 0.0 2025-11-29 18:49:03
1828 2037 1 305 12855 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 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-29 19:18:05
1829 2038 1 306 12855 34 Herbo2o Toothpaste NULL 33061090 22 45.0 199.0 0.0 0.0 159.2 134.92 24.28 4378.0 990.0 3502.4 9.0 267.13 9.0 267.13 0.0 0.0 134.92 534.26 3502.4 INR 0 0.0 0.0 2025-11-29 19:23:37
1830 2039 1 307 12551 33 Herbal Soap 100gm NULL 30049011 54 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5400.0 1512.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 76.19 205.71 4320.0 INR 0 0.0 0.0 2025-11-29 20:19:51
1831 2040 1 308 12855 33 Herbal Soap 100gm NULL 30049011 52 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5200.0 1456.0 4160.0 2.5 99.05 2.5 99.05 0.0 0.0 76.19 198.1 4160.0 INR 0 0.0 0.0 2025-11-29 20:30:26
1832 2041 1 309 12555 71 Bio magnetic water pad NULL 9404 4 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 18000.0 4000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 3428.57 685.71 14400.0 INR 0 0.0 0.0 2025-11-30 09:22:58
1833 2042 1 310 12554 71 Bio magnetic water pad NULL 9404 4 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 18000.0 4000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 3428.57 685.71 14400.0 INR 0 0.0 0.0 2025-11-30 09:24:10
1834 2043 1 311 12516 71 Bio magnetic water pad NULL 9404 4 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 18000.0 4000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 3428.57 685.71 14400.0 INR 0 0.0 0.0 2025-11-30 09:25:32
1835 2044 1 312 12555 37 Floor Cleaner 500ml NULL 3924101 100 80.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 8000.0 15920.0 9.0 1214.23 9.0 1214.23 0.0 0.0 134.92 2428.47 15920.0 INR 0 0.0 0.0 2025-11-30 15:48:04
1836 2045 2 312 12555 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-30 15:48:04
1837 2046 1 313 12555 74 EXPLORER BOX NULL NULL 6 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 161982.0 0.0 62994.0 2.5 1499.86 2.5 1499.86 0.0 0.0 9999.05 2999.71 62994.0 INR 0 0.0 0.0 2025-11-30 19:50:50
1838 2047 1 314 12555 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-30 23:19:31
1839 2048 1 315 12555 2 Heart Care Capsules NULL 2936900 4 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1700.0 4796.8 2.5 114.21 2.5 114.21 0.0 0.0 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-30 23:27:23
1840 2049 1 316 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-12-01 16:18:59
1841 2050 1 317 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-12-01 16:19:41
1842 2051 1 318 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-12-01 16:20:26
1843 2052 1 319 12855 53 Terra care 2 kg NULL 3103100 46 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 69000.0 20700.0 55200.0 2.5 1314.29 2.5 1314.29 0.0 0.0 1142.86 2628.57 55200.0 INR 0 0.0 0.0 2025-12-01 17:49:50
1844 2053 1 320 12855 1 Stem Cell Powder NULL 2936900 6 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 14994.0 4494.0 11995.2 2.5 285.6 2.5 285.6 0.0 0.0 1904.0 571.2 11995.2 INR 0 0.0 0.0 2025-12-01 18:03:10
1845 2054 1 321 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-12-03 17:17:31
1846 2055 1 322 12555 16 Liver Care 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-12-04 15:34:41
1847 2056 1 323 12554 16 Liver Care Juice NULL 2009899 30 120.0 349.0 0.0 0.0 279.2 265.9 13.3 10470.0 3600.0 8376.0 2.5 199.43 2.5 199.43 0.0 0.0 265.9 398.86 8376.0 INR 0 0.0 0.0 2025-12-04 15:36:04
1848 2057 1 324 12551 48 glow face wash NULL 3304999 5 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 500.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1849 2058 2 324 12551 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1850 2059 3 324 12551 34 Herbo2o Toothpaste NULL 33061090 6 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 270.0 955.2 9.0 72.86 9.0 72.86 0.0 0.0 134.92 145.71 955.2 INR 0 0.0 0.0 2025-12-05 14:21:29