fx_franchise_order_product

4,737 rows · 33 columns · page 33 / 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
1601 1810 1 220 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.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-11-12 17:31:01
1602 1811 2 220 12516 61 Radiation chip NULL 902221 109 325.0 999.0 0.0 0.0 799.2 677.29 121.91 108891.0 35425.0 87112.8 9.0 6644.19 9.0 6644.19 0.0 0.0 677.29 13288.39 87112.8 INR 0 0.0 0.0 2025-11-12 17:31:01
1603 1812 3 220 12516 31 Vegan Plant Protein Powder NULL 21061000 50 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 149950.0 50000.0 119960.0 2.5 2856.19 2.5 2856.19 0.0 0.0 2284.95 5712.38 119960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1604 1813 4 220 12516 49 Anti Dandruff Serum NULL 3304999 50 250.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 12500.0 39960.0 9.0 3047.8 9.0 3047.8 0.0 0.0 677.29 6095.59 39960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1605 1814 5 220 12516 3 BP Care Capsules NULL 2936900 100 160.0 599.0 0.0 0.0 479.2 456.38 22.82 59900.0 16000.0 47920.0 2.5 1140.95 2.5 1140.95 0.0 0.0 456.38 2281.9 47920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1606 1815 6 220 12516 4 Diabetic Care Capsules NULL 2936900 100 250.0 899.0 0.0 0.0 719.2 684.95 34.25 89900.0 25000.0 71920.0 2.5 1712.38 2.5 1712.38 0.0 0.0 684.95 3424.76 71920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1607 1816 7 220 12516 60 Foot patch NULL 30051090 100 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 199900.0 50000.0 159920.0 2.5 3807.62 2.5 3807.62 0.0 0.0 1523.05 7615.24 159920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1608 1817 8 220 12516 58 Green shield 250ml NULL 3105 100 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 250000.0 80000.0 200000.0 2.5 4761.9 2.5 4761.9 0.0 0.0 1904.76 9523.81 200000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1609 1818 9 220 12516 55 Grow master 500ml NULL 3105 100 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 203000.0 85000.0 162400.0 2.5 3866.66 2.5 3866.66 0.0 0.0 1546.67 7733.33 162400.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1610 1819 10 220 12516 2 Heart Care Capsules NULL 2936900 50 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 21250.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1611 1820 11 220 12516 30 Iron Capsules NULL 30049011 30 250.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 7500.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1612 1821 12 220 12516 15 Kidney Stone Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1613 1822 13 220 12516 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-12 17:31:01
1614 1823 14 220 12516 16 Liver Care Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1615 1824 15 220 12516 25 Manicalcium Tablets NULL 2009899 50 95.0 399.0 0.0 0.0 319.2 304.0 15.2 19950.0 4750.0 15960.0 2.5 380.0 2.5 380.0 0.0 0.0 304.0 760.0 15960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1616 1825 16 220 12516 12 Melatonin Drop NULL 2106909 50 190.0 749.0 0.0 0.0 599.2 570.67 28.53 37450.0 9500.0 29960.0 2.5 713.34 2.5 713.34 0.0 0.0 570.67 1426.67 29960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1617 1826 17 220 12516 17 Memory Booster Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1618 1827 18 220 12516 56 Micro magic 500ml NULL 3105 100 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 203000.0 85000.0 162400.0 9.0 12386.44 9.0 12386.44 0.0 0.0 1376.27 24772.88 162400.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1619 1828 19 220 12516 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-12 17:31:01
1620 1829 20 220 12516 72 Pain Relief Patch NULL 30051090 50 200.0 800.0 0.0 0.0 640.0 609.52 30.48 40000.0 10000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 609.52 1523.81 32000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1621 1830 21 220 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-12 17:31:01
1622 1831 22 220 12516 14 Premium Aloe Vera VEG caps NULL 2936900 30 100.0 359.0 0.0 0.0 287.2 273.52 13.68 10770.0 3000.0 8616.0 2.5 205.15 2.5 205.15 0.0 0.0 273.52 410.29 8616.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1623 1832 23 220 12516 43 Quench Kiss Lip Balm NULL 3304300 50 35.0 199.0 0.0 0.0 159.2 134.92 24.28 9950.0 1750.0 7960.0 9.0 607.12 9.0 607.12 0.0 0.0 134.92 1214.24 7960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1624 1833 24 220 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-12 17:31:01
1625 1834 25 220 12516 57 Safe guard 250ml NULL 3105 100 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 250000.0 80000.0 200000.0 2.5 4761.9 2.5 4761.9 0.0 0.0 1904.76 9523.81 200000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1626 1835 26 220 12516 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1627 1836 27 220 12516 29 Shilajith NULL 30049011 20 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 36000.0 5000.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-12 17:31:01
1628 1837 28 220 12516 26 Spirulina Cap NULL 2009899 100 190.0 899.0 0.0 0.0 719.2 684.95 34.25 89900.0 19000.0 71920.0 2.5 1712.38 2.5 1712.38 0.0 0.0 684.95 3424.76 71920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1629 1838 29 220 12516 50 Sun Screen NULL 330499 100 250.0 699.0 0.0 0.0 559.2 473.9 85.3 69900.0 25000.0 55920.0 9.0 4265.09 9.0 4265.09 0.0 0.0 473.9 8530.17 55920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1630 1839 30 220 12516 59 T Shirt NULL 61099010 5 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 7000.0 0.0 5600.0 2.5 133.34 2.5 133.34 0.0 0.0 1066.67 266.67 5600.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1631 1840 31 220 12516 53 Terra care 2 kg NULL 3103100 100 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 150000.0 45000.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.29 120000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1632 1841 32 220 12516 5 Thyro Care 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.95 14384.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1633 1842 33 220 12516 44 Vital Glow Face Scrub NULL 3304300 25 71.0 325.0 0.0 0.0 260.0 220.34 39.66 8125.0 1775.0 6500.0 9.0 495.76 9.0 495.76 0.0 0.0 220.34 991.53 6500.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1634 1843 34 220 12516 54 Wonder grow 100ml NULL 3105 100 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 140000.0 50000.0 112000.0 2.5 2666.66 2.5 2666.66 0.0 0.0 1066.67 5333.33 112000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1635 1844 1 221 12527 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-12 21:35:38
1636 1845 2 221 12527 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-12 21:35:38
1637 1846 1 222 12527 2 Heart Care Capsules NULL 2936900 1 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 425.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-12 21:48:10
1638 1847 2 222 12527 34 Herbo2o Toothpaste NULL 33061090 30 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1350.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-11-12 21:48:10
1639 1848 3 222 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-12 21:48:10
1640 1849 4 222 12527 35 Sanitary Pad (15 pcs) NULL 9619001 30 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11400.0 1200.0 9120.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 9120.0 INR 0 0.0 0.0 2025-11-12 21:48:10
1641 1850 1 223 12535 77 ELITE COMFORT NULL NULL 9 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 485946.0 0.0 166500.0 2.5 3964.28 2.5 3964.28 0.0 0.0 17619.05 7928.57 166500.0 INR 0 0.0 0.0 2025-11-13 12:24:53
1642 1851 2 223 12535 74 EXPLORER BOX NULL NULL 9 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 242973.0 0.0 94491.0 2.5 2249.78 2.5 2249.78 0.0 0.0 9999.05 4499.57 94491.0 INR 0 0.0 0.0 2025-11-13 12:24:53
1643 1852 1 224 12620 76 ELITE BOX NULL NULL 5 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 232470.0 0.0 90000.0 2.5 2142.86 2.5 2142.86 0.0 0.0 17142.86 4285.71 90000.0 INR 0 0.0 0.0 2025-11-13 12:48:06
1644 1853 2 224 12620 74 EXPLORER BOX NULL NULL 8 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 215976.0 0.0 83992.0 2.5 1999.81 2.5 1999.81 0.0 0.0 9999.05 3999.62 83992.0 INR 0 0.0 0.0 2025-11-13 12:48:06
1645 1854 1 225 12620 77 ELITE COMFORT NULL NULL 9 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 485946.0 0.0 166500.0 2.5 3964.28 2.5 3964.28 0.0 0.0 17619.05 7928.57 166500.0 INR 0 0.0 0.0 2025-11-13 12:53:34
1646 1855 2 225 12620 74 EXPLORER BOX NULL NULL 9 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 242973.0 0.0 94491.0 2.5 2249.78 2.5 2249.78 0.0 0.0 9999.05 4499.57 94491.0 INR 0 0.0 0.0 2025-11-13 12:53:34
1647 1856 1 226 12555 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 2.5 189.53 2.5 189.53 0.0 0.0 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-13 13:03:27
1648 1857 1 227 12555 15 Kidney Stone 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-13 13:19:26
1649 1858 2 227 12555 16 Liver Care 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-13 13:19:26
1650 1859 3 227 12555 43 Quench Kiss Lip Balm NULL 3304300 6 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 210.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-11-13 13:19:26