fx_franchise_order_product

4,737 rows · 33 columns · page 32 / 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
1551 1760 2 204 12516 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-12 12:29:52
1552 1761 3 204 12516 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-12 12:29:52
1553 1762 4 204 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:29:52
1554 1763 5 204 12516 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-12 12:29:52
1555 1764 6 204 12516 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-12 12:29:52
1556 1765 7 204 12516 1 Stem Cell Powder NULL 2936900 100 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 249900.0 74900.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 1904.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 12:29:52
1557 1766 8 204 12516 36 Toilet Cleaner 500ml NULL 3924101 100 30.0 150.0 0.0 0.0 120.0 101.69 18.31 15000.0 3000.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 101.69 1830.51 12000.0 INR 0 0.0 0.0 2025-11-12 12:29:52
1558 1767 1 205 12554 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-12 12:37:16
1559 1768 1 206 12517 33 Herbal Soap 100gm NULL 30049011 1 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 28.0 80.0 0.0 0.0 0.0 0.0 5.0 3.81 76.19 3.81 80.0 INR 0 0.0 0.0 2025-11-12 12:37:41
1560 1769 1 207 12517 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 0.0 0.0 0.0 0.0 5.0 487.62 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1561 1770 2 207 12517 33 Herbal Soap 100gm NULL 30049011 1500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 150000.0 42000.0 120000.0 0.0 0.0 0.0 0.0 5.0 5714.29 76.19 5714.29 120000.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1562 1771 3 207 12517 34 Herbo2o Toothpaste NULL 33061090 1000 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199000.0 45000.0 159200.0 0.0 0.0 0.0 0.0 18.0 24284.75 134.92 24284.75 159200.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1563 1772 4 207 12517 32 Neem Soap 100gm NULL 34011110 3000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 180000.0 30000.0 144000.0 0.0 0.0 0.0 0.0 5.0 6857.14 45.71 6857.14 144000.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1564 1773 5 207 12517 53 Terra care 2 kg NULL 3103100 8 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 12000.0 3600.0 9600.0 0.0 0.0 0.0 0.0 5.0 457.14 1142.86 457.14 9600.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1565 1774 1 208 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:44:00
1566 1775 2 208 12516 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-12 12:44:00
1567 1776 1 209 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:45:38
1568 1777 2 209 12516 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-12 12:45:38
1569 1778 1 210 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:53:28
1570 1779 2 210 12516 34 Herbo2o Toothpaste NULL 33061090 500 45.0 199.0 0.0 0.0 159.2 134.92 24.28 99500.0 22500.0 79600.0 9.0 6071.19 9.0 6071.19 0.0 0.0 134.92 12142.37 79600.0 INR 0 0.0 0.0 2025-11-12 12:53:28
1571 1780 3 210 12516 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-12 12:53:28
1572 1781 1 211 12516 33 Herbal Soap 100gm NULL 30049011 3000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 300000.0 84000.0 240000.0 2.5 5714.28 2.5 5714.28 0.0 0.0 76.19 11428.57 240000.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1573 1782 2 211 12516 34 Herbo2o Toothpaste NULL 33061090 1000 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199000.0 45000.0 159200.0 9.0 12142.38 9.0 12142.38 0.0 0.0 134.92 24284.75 159200.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1574 1783 3 211 12516 32 Neem Soap 100gm NULL 34011110 5000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 300000.0 50000.0 240000.0 2.5 5714.28 2.5 5714.28 0.0 0.0 45.71 11428.57 240000.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1575 1784 1 212 12555 1 Stem Cell Powder NULL 2936900 100 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 249900.0 74900.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 1904.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 13:10:21
1576 1785 1 213 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.95 14384.0 INR 0 0.0 0.0 2025-11-12 13:22:45
1577 1786 1 214 12555 3 BP Care Capsules NULL 2936900 20 160.0 599.0 0.0 0.0 479.2 456.38 22.82 11980.0 3200.0 9584.0 2.5 228.19 2.5 228.19 0.0 0.0 456.38 456.38 9584.0 INR 0 0.0 0.0 2025-11-12 13:24:03
1578 1787 1 215 12517 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 0.0 0.0 0.0 0.0 5.0 190.4 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-12 14:02:23
1579 1788 2 215 12517 74 EXPLORER BOX NULL NULL 4 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 107988.0 0.0 41996.0 0.0 0.0 0.0 0.0 5.0 1999.81 9999.05 1999.81 41996.0 INR 0 0.0 0.0 2025-11-12 14:02:23
1580 1789 1 216 12517 48 glow face wash NULL 3304999 18 250.0 380.0 0.0 0.0 304.0 257.63 46.37 6840.0 4500.0 5472.0 0.0 0.0 0.0 0.0 18.0 834.71 257.63 834.71 5472.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1581 1790 2 216 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-12 14:23:23
1582 1791 3 216 12517 40 Bamboo Brush NULL 96032100 10 25.0 110.0 0.0 0.0 88.0 74.58 13.42 1100.0 250.0 880.0 0.0 0.0 0.0 0.0 18.0 134.24 74.58 134.24 880.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1583 1792 4 216 12517 7 Morning Fresh Churan NULL 30049011 34 40.0 199.0 0.0 0.0 159.2 151.62 7.58 6766.0 1360.0 5412.8 0.0 0.0 0.0 0.0 5.0 257.75 151.62 257.75 5412.8 INR 0 0.0 0.0 2025-11-12 14:23:23
1584 1793 5 216 12517 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 0.0 0.0 0.0 0.0 18.0 255.91 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-12 14:23:23
1585 1794 6 216 12517 42 Premium Glow Charm Fairness Cream NULL 33049990 8 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3192.0 640.0 2553.6 0.0 0.0 0.0 0.0 18.0 389.53 270.51 389.53 2553.6 INR 0 0.0 0.0 2025-11-12 14:23:23
1586 1795 7 216 12517 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 0.0 0.0 0.0 0.0 18.0 242.85 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1587 1796 8 216 12517 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 0.0 0.0 0.0 0.0 5.0 971.43 194.29 971.43 20400.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1588 1797 9 216 12517 11 Vitamin B12 Drop NULL 2106909 7 190.0 749.0 0.0 0.0 599.2 570.67 28.53 5243.0 1330.0 4194.4 0.0 0.0 0.0 0.0 5.0 199.73 570.67 199.73 4194.4 INR 0 0.0 0.0 2025-11-12 14:23:23
1589 1798 10 216 12517 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 0.0 0.0 0.0 0.0 5.0 160.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1590 1799 1 217 12516 48 glow face wash NULL 3304999 20 250.0 380.0 0.0 0.0 304.0 257.63 46.37 7600.0 5000.0 6080.0 9.0 463.73 9.0 463.73 0.0 0.0 257.63 927.46 6080.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1591 1800 2 217 12516 70 Premium Hand belt NULL 9404 10 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 99990.0 6000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 1371.43 685.71 14400.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1592 1801 3 217 12516 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-12 15:14:55
1593 1802 4 217 12516 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 9.0 426.51 9.0 426.51 0.0 0.0 473.9 853.02 5592.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1594 1803 5 217 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 20 80.0 399.0 0.0 0.0 319.2 270.51 48.69 7980.0 1600.0 6384.0 9.0 486.92 9.0 486.92 0.0 0.0 270.51 973.83 6384.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1595 1804 6 217 12516 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-11-12 15:14:55
1596 1805 7 217 12516 46 Root Vitality Hair Oil NULL 3305901 120 54.0 255.0 0.0 0.0 204.0 194.29 9.71 30600.0 6480.0 24480.0 2.5 582.86 2.5 582.86 0.0 0.0 194.29 1165.71 24480.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1597 1806 8 217 12516 11 Vitamin B12 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-12 15:14:55
1598 1807 9 217 12516 54 Wonder grow 100ml NULL 3105 10 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 14000.0 5000.0 11200.0 2.5 266.67 2.5 266.67 0.0 0.0 1066.67 533.33 11200.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1599 1808 1 218 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-12 15:20:18
1600 1809 1 219 12527 32 Neem Soap 100gm NULL 34011110 200 10.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 2000.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 45.71 457.14 9600.0 INR 0 0.0 0.0 2025-11-12 16:25:14