fx_franchise_order_product

4,737 rows · 33 columns · page 38 / 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
1851 2060 4 324 12551 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1852 2061 5 324 12551 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-12-05 14:21:29
1853 2062 6 324 12551 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-12-05 14:21:29
1854 2063 7 324 12551 43 Quench Kiss Lip Balm NULL 3304300 10 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 350.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-12-05 14:21:29
1855 2064 8 324 12551 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.43 408.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1856 2065 9 324 12551 35 Sanitary Pad (15 pcs) NULL 9619001 5 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 200.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1520.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1857 2066 10 324 12551 50 Sun Screen NULL 330499 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-12-05 14:21:29
1858 2067 11 324 12551 44 Vital Glow Face Scrub NULL 3304300 3 71.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 213.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 220.34 118.98 780.0 INR 0 0.0 0.0 2025-12-05 14:21:29
1859 2068 1 325 12516 48 glow face wash NULL 3304999 50 100.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 5000.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-12-05 14:23:35
1860 2069 2 325 12516 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-12-05 14:23:35
1861 2070 1 326 12554 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-12-05 14:30:49
1862 2071 1 327 12551 76 ELITE BOX NULL NULL 3 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 139482.0 0.0 54000.0 2.5 1285.71 2.5 1285.71 0.0 0.0 17142.86 2571.43 54000.0 INR 0 0.0 0.0 2025-12-05 14:34:50
1863 2072 1 328 12551 32 Neem Soap 100gm NULL 34011110 1 10.0 60.0 0.0 0.0 48.0 45.71 2.28 60.0 10.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.28 48.0 INR 0 0.0 0.0 2025-12-05 15:47:09
1864 2073 1 329 12555 81 PREMIUM GLOW FACE WASH NULL 3404 30 280.0 699.0 0.0 0.0 559.2 513.03 46.17 20970.0 8400.0 16776.0 4.5 692.59 4.5 692.59 0.0 0.0 513.03 1385.18 16776.0 INR 0 0.0 0.0 2025-12-05 17:28:50
1865 2074 1 330 12554 81 PREMIUM GLOW FACE WASH NULL 3404 30 280.0 699.0 0.0 0.0 559.2 513.03 46.17 20970.0 8400.0 16776.0 4.5 692.59 4.5 692.59 0.0 0.0 513.03 1385.18 16776.0 INR 0 0.0 0.0 2025-12-05 17:29:37
1866 2075 1 331 12516 81 PREMIUM GLOW FACE WASH NULL 3404 30 280.0 699.0 0.0 0.0 559.2 513.03 46.17 20970.0 8400.0 16776.0 4.5 692.59 4.5 692.59 0.0 0.0 513.03 1385.18 16776.0 INR 0 0.0 0.0 2025-12-05 17:30:15
1867 2076 1 332 12555 43 Quench Kiss Lip Balm NULL 3304300 20 35.0 199.0 0.0 0.0 159.2 134.92 24.29 3980.0 700.0 3184.0 9.0 242.85 9.0 242.85 0.0 0.0 134.92 485.7 3184.0 INR 0 0.0 0.0 2025-12-05 17:35:18
1868 2077 1 333 12554 43 Quench Kiss Lip Balm NULL 3304300 30 35.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1050.0 4776.0 9.0 364.27 9.0 364.27 0.0 0.0 134.92 728.54 4776.0 INR 0 0.0 0.0 2025-12-05 17:36:01
1869 2078 1 334 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-05 22:11:30
1870 2079 1 335 12555 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-05 23:04:31
1871 2080 1 336 12554 74 EXPLORER BOX NULL NULL 60 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1619820.0 0.0 629940.0 2.5 14998.57 2.5 14998.57 0.0 0.0 9999.05 29997.14 629940.0 INR 0 0.0 0.0 2025-12-05 23:05:26
1872 2081 1 337 12516 74 EXPLORER BOX NULL NULL 60 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1619820.0 0.0 629940.0 2.5 14998.57 2.5 14998.57 0.0 0.0 9999.05 29997.14 629940.0 INR 0 0.0 0.0 2025-12-05 23:06:47
1873 2082 1 338 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-06 13:46:32
1874 2083 1 339 12855 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-06 16:28:15
1875 2084 2 339 12855 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-06 16:28:15
1876 2085 3 339 12855 34 Herbo2o Toothpaste NULL 33061090 6 45.0 199.0 0.0 0.0 159.2 134.92 24.28 1194.0 270.0 955.2 9.0 72.85 9.0 72.85 0.0 0.0 134.92 145.7 955.2 INR 0 0.0 0.0 2025-12-06 16:28:15
1877 2086 4 339 12855 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-12-06 16:28:15
1878 2087 5 339 12855 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-12-06 16:28:15
1879 2088 6 339 12855 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.94 2.5 39.94 0.0 0.0 532.57 79.88 1677.6 INR 0 0.0 0.0 2025-12-06 16:28:15
1880 2089 7 339 12855 43 Quench Kiss Lip Balm NULL 3304300 10 35.0 199.0 0.0 0.0 159.2 134.92 24.28 1990.0 350.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.84 1592.0 INR 0 0.0 0.0 2025-12-06 16:28:15
1881 2090 8 339 12855 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.42 408.0 INR 0 0.0 0.0 2025-12-06 16:28:15
1882 2091 9 339 12855 35 Sanitary Pad (15 pcs) NULL 9619001 5 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 200.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1520.0 INR 0 0.0 0.0 2025-12-06 16:28:15
1883 2092 10 339 12855 50 Sun Screen NULL 330499 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-12-06 16:28:15
1884 2093 11 339 12855 44 Vital Glow Face Scrub NULL 3304300 3 71.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 213.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 220.34 118.98 780.0 INR 0 0.0 0.0 2025-12-06 16:28:15
1885 2094 1 340 12555 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 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.96 14384.0 INR 0 0.0 0.0 2025-12-07 22:35:52
1886 2095 1 341 12554 4 Diabetic Care Capsules NULL 2936900 30 250.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 7500.0 21576.0 2.5 513.71 2.5 513.71 0.0 0.0 684.95 1027.42 21576.0 INR 0 0.0 0.0 2025-12-07 22:36:33
1887 2096 1 342 12855 76 ELITE BOX NULL NULL 3 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 139482.0 0.0 54000.0 2.5 1285.71 2.5 1285.71 0.0 0.0 17142.86 2571.42 54000.0 INR 0 0.0 0.0 2025-12-08 13:51:53
1888 2097 1 343 12855 76 ELITE BOX NULL NULL 1 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 46494.0 0.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-12-08 14:00:52
1889 2098 1 344 12855 6 Asthma 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-12-08 14:19:43
1890 2099 2 344 12855 71 Bio magnetic water pad NULL 9404 2 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 9000.0 2000.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 3428.57 342.86 7200.0 INR 0 0.0 0.0 2025-12-08 14:19:43
1891 2100 1 345 12855 58 Green shield 250ml NULL 3105 11 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 27500.0 8800.0 22000.0 2.5 523.81 2.5 523.81 0.0 0.0 1904.76 1047.62 22000.0 INR 0 0.0 0.0 2025-12-08 14:34:32
1892 2101 2 345 12855 55 Grow master 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 40600.0 17000.0 32480.0 2.5 773.33 2.5 773.33 0.0 0.0 1546.67 1546.66 32480.0 INR 0 0.0 0.0 2025-12-08 14:34:32
1893 2102 3 345 12855 56 Micro magic 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 40600.0 17000.0 32480.0 9.0 2477.29 9.0 2477.29 0.0 0.0 1376.27 4954.58 32480.0 INR 0 0.0 0.0 2025-12-08 14:34:32
1894 2103 4 345 12855 57 Safe guard 250ml NULL 3105 21 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 52500.0 16800.0 42000.0 2.5 1000.0 2.5 1000.0 0.0 0.0 1904.76 2000.0 42000.0 INR 0 0.0 0.0 2025-12-08 14:34:32
1895 2104 5 345 12855 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.33 2.5 1333.33 0.0 0.0 1066.67 2666.66 56000.0 INR 0 0.0 0.0 2025-12-08 14:34:32
1896 2105 1 346 12855 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.96 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.96 18500.0 INR 0 0.0 0.0 2025-12-08 16:37:48
1897 2106 1 347 12551 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.96 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.96 18500.0 INR 0 0.0 0.0 2025-12-08 16:41:42
1898 2107 1 348 12551 35 Sanitary Pad (15 pcs) NULL 9619001 4 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 160.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1216.0 INR 0 0.0 0.0 2025-12-10 19:06:32
1899 2108 1 349 12855 35 Sanitary Pad (15 pcs) NULL 9619001 4 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 160.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1216.0 INR 0 0.0 0.0 2025-12-10 19:13:43
1900 2109 1 350 12555 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-12-11 11:37:50