fx_franchise_order_product

4,737 rows · 33 columns · page 36 / 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
1751 1960 1 266 12516 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:07:37
1752 1961 1 267 12516 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 15:20:23
1753 1962 1 268 12555 44 Vital Glow Face Scrub NULL 3304300 20 71.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 1420.0 5200.0 9.0 396.61 9.0 396.61 0.0 0.0 220.34 793.22 5200.0 INR 0 0.0 0.0 2025-11-20 17:46:39
1754 1963 1 269 12555 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-20 22:15:12
1755 1964 2 269 12555 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 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-20 22:15:12
1756 1965 1 270 12517 48 glow face wash NULL 3304999 30 100.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 3000.0 9120.0 0.0 0.0 0.0 0.0 18.0 1391.19 257.63 1391.19 9120.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1757 1966 2 270 12517 27 Multicharge Cap NULL 2009899 10 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4500.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-20 23:13:55
1758 1967 3 270 12517 70 Premium Hand belt NULL 9404 5 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 49995.0 3000.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1759 1968 4 270 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-20 23:13:55
1760 1969 5 270 12517 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 0.0 0.0 0.0 0.0 5.0 304.76 1219.05 304.76 6400.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1761 1970 6 270 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-20 23:13:55
1762 1971 7 270 12517 7 Morning Fresh Churan NULL 30049011 50 40.0 199.0 0.0 0.0 159.2 151.62 7.58 9950.0 2000.0 7960.0 0.0 0.0 0.0 0.0 5.0 379.05 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1763 1972 8 270 12517 28 Ortho Joint Shield NULL 2009899 10 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4500.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-20 23:13:55
1764 1973 9 270 12517 41 Premium Coco Body Lotion NULL 3304300 10 250.0 699.0 0.0 0.0 559.2 473.9 85.3 6990.0 2500.0 5592.0 0.0 0.0 0.0 0.0 18.0 853.02 473.9 853.02 5592.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1765 1974 10 270 12517 47 Premium Hair Care Shampoo NULL 3305109 30 150.0 699.0 0.0 0.0 559.2 532.57 26.63 20970.0 4500.0 16776.0 0.0 0.0 0.0 0.0 5.0 798.86 532.57 798.86 16776.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1766 1975 11 270 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-20 23:13:55
1767 1976 12 270 12517 57 Safe guard 250ml NULL 3105 2 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 1600.0 4000.0 0.0 0.0 0.0 0.0 5.0 190.48 1904.76 190.48 4000.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1768 1977 13 270 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-20 23:13:55
1769 1978 14 270 12517 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 0.0 0.0 0.0 0.0 5.0 285.71 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1770 1979 15 270 12517 54 Wonder grow 100ml NULL 3105 5 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 7000.0 2500.0 5600.0 0.0 0.0 0.0 0.0 5.0 266.67 1066.67 266.67 5600.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1771 1980 1 271 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-21 07:28:54
1772 1981 1 272 12516 47 Premium Hair Care Shampoo NULL 3305109 40 150.0 699.0 0.0 0.0 559.2 532.57 26.63 27960.0 6000.0 22368.0 2.5 532.57 2.5 532.57 0.0 0.0 532.57 1065.14 22368.0 INR 0 0.0 0.0 2025-11-21 09:33:32
1773 1982 1 273 12516 28 Ortho Joint Shield NULL 2009899 20 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 9000.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-21 09:40:24
1774 1983 1 274 12517 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 0.0 0.0 0.0 0.0 5.0 2642.86 17619.05 2642.86 55500.0 INR 0 0.0 0.0 2025-11-21 10:36:53
1775 1984 2 274 12517 74 EXPLORER BOX NULL NULL 11 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 296967.0 0.0 115489.0 0.0 0.0 0.0 0.0 5.0 5499.48 9999.05 5499.48 115489.0 INR 0 0.0 0.0 2025-11-21 10:36:53
1776 1985 1 275 12555 41 Premium Coco Body Lotion NULL 3304300 30 250.0 699.0 0.0 0.0 559.2 473.9 85.3 20970.0 7500.0 16776.0 9.0 1279.53 9.0 1279.53 0.0 0.0 473.9 2559.05 16776.0 INR 0 0.0 0.0 2025-11-21 14:42:45
1777 1986 1 276 12554 41 Premium Coco Body Lotion NULL 3304300 50 250.0 699.0 0.0 0.0 559.2 473.9 85.3 34950.0 12500.0 27960.0 9.0 2132.54 9.0 2132.54 0.0 0.0 473.9 4265.08 27960.0 INR 0 0.0 0.0 2025-11-21 14:43:41
1778 1987 1 277 12516 41 Premium Coco Body Lotion NULL 3304300 50 250.0 699.0 0.0 0.0 559.2 473.9 85.3 34950.0 12500.0 27960.0 9.0 2132.54 9.0 2132.54 0.0 0.0 473.9 4265.08 27960.0 INR 0 0.0 0.0 2025-11-21 14:44:50
1779 1988 1 278 12555 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-22 13:10:28
1780 1989 1 279 12554 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-22 13:11:20
1781 1990 1 280 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-22 13:12:05
1782 1991 1 281 12516 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-11-22 13:16:09
1783 1992 1 282 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-23 14:13:16
1784 1993 2 282 12555 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 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-23 14:13:16
1785 1994 3 282 12555 28 Ortho Joint Shield 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-23 14:13:16
1786 1995 1 283 12555 18 Lady Care Juice 500ml NULL 2009899 10 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 2500.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-24 11:59:58
1787 1996 1 284 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-24 15:08:20
1788 1997 1 285 12555 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-24 18:08:41
1789 1998 1 286 12555 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-25 13:27:10
1790 1999 1 287 12554 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-27 14:00:14
1791 2000 2 287 12554 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:00:14
1792 2001 3 287 12554 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:00:14
1793 2002 1 288 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-27 14:01:30
1794 2003 2 288 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:01:30
1795 2004 3 288 12516 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:01:30
1796 2005 1 289 12555 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-27 14:02:51
1797 2006 2 289 12555 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:02:51
1798 2007 3 289 12555 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:02:51
1799 2008 1 290 12555 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:17:15
1800 2009 2 290 12555 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:17:15