fx_franchise_order_product

4,737 rows · 33 columns · page 31 / 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
1501 1710 29 198 12554 17 Memory Booster 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-12 09:05:44
1502 1711 30 198 12554 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-11-12 09:05:44
1503 1712 31 198 12554 7 Morning Fresh Churan NULL 30049011 30 40.0 199.0 0.0 0.0 159.2 151.62 7.58 5970.0 1200.0 4776.0 2.5 113.72 2.5 113.72 0.0 0.0 151.62 227.43 4776.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1504 1713 32 198 12554 32 Neem Soap 100gm NULL 34011110 2000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 120000.0 20000.0 96000.0 2.5 2285.72 2.5 2285.72 0.0 0.0 45.71 4571.43 96000.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1505 1714 33 198 12554 9 Omega 369 NULL 2936900 10 260.0 999.0 0.0 0.0 799.2 761.14 38.06 9990.0 2600.0 7992.0 2.5 190.28 2.5 190.28 0.0 0.0 761.14 380.57 7992.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1506 1715 34 198 12554 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 09:05:44
1507 1716 35 198 12554 72 Pain Relief Patch NULL 30051090 20 200.0 800.0 0.0 0.0 640.0 609.52 30.48 16000.0 4000.0 12800.0 2.5 304.76 2.5 304.76 0.0 0.0 609.52 609.52 12800.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1508 1717 36 198 12554 8 Piles Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-12 09:05:44
1509 1718 37 198 12554 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-12 09:05:44
1510 1719 38 198 12554 14 Premium Aloe Vera VEG caps NULL 2936900 10 100.0 359.0 0.0 0.0 287.2 273.52 13.68 3590.0 1000.0 2872.0 2.5 68.38 2.5 68.38 0.0 0.0 273.52 136.76 2872.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1511 1720 39 198 12554 47 Premium Hair Care Shampoo NULL 3305109 15 150.0 699.0 0.0 0.0 559.2 532.57 26.63 10485.0 2250.0 8388.0 2.5 199.72 2.5 199.72 0.0 0.0 532.57 399.43 8388.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1512 1721 40 198 12554 13 Premium NONI VEG caps NULL 2936900 10 150.0 501.0 0.0 0.0 400.8 381.71 19.09 5010.0 1500.0 4008.0 2.5 95.43 2.5 95.43 0.0 0.0 381.71 190.86 4008.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1513 1722 41 198 12554 43 Quench Kiss Lip Balm NULL 3304300 8 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 280.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-12 09:05:44
1514 1723 42 198 12554 57 Safe guard 250ml NULL 3105 15 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 37500.0 12000.0 30000.0 2.5 714.28 2.5 714.28 0.0 0.0 1904.76 1428.57 30000.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1515 1724 43 198 12554 35 Sanitary Pad (15 pcs) NULL 9619001 8 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3040.0 320.0 2432.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 2432.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1516 1725 44 198 12554 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 09:05:44
1517 1726 45 198 12554 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-12 09:05:44
1518 1727 46 198 12554 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 09:05:44
1519 1728 47 198 12554 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 9.0 853.01 9.0 853.01 0.0 0.0 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1520 1729 48 198 12554 53 Terra care 2 kg NULL 3103100 15 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 22500.0 6750.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 1142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1521 1730 49 198 12554 5 Thyro Care NULL 2936900 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-12 09:05:44
1522 1731 50 198 12554 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 09:05:44
1523 1732 51 198 12554 44 Vital Glow Face Scrub NULL 3304300 15 71.0 325.0 0.0 0.0 260.0 220.34 39.66 4875.0 1065.0 3900.0 9.0 297.46 9.0 297.46 0.0 0.0 220.34 594.92 3900.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1524 1733 52 198 12554 54 Wonder grow 100ml NULL 3105 1 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 500.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1525 1734 1 199 12516 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 9.0 1044.84 9.0 1044.84 0.0 0.0 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-12 09:53:05
1526 1735 1 200 12516 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-11-12 09:59:48
1527 1736 1 201 12516 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-12 11:50:42
1528 1737 2 201 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 11:50:42
1529 1738 3 201 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 11:50:42
1530 1739 4 201 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 11:50:42
1531 1740 5 201 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 11:50:42
1532 1741 6 201 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 11:50:42
1533 1742 7 201 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 11:50:42
1534 1743 8 201 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 11:50:42
1535 1744 1 202 12554 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-12 12:13:12
1536 1745 2 202 12554 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:13:12
1537 1746 3 202 12554 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:13:12
1538 1747 4 202 12554 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:13:12
1539 1748 5 202 12554 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:13:12
1540 1749 6 202 12554 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:13:12
1541 1750 7 202 12554 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:13:12
1542 1751 1 203 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-12 12:22:06
1543 1752 2 203 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-12 12:22:06
1544 1753 3 203 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-12 12:22:06
1545 1754 4 203 12555 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:22:06
1546 1755 5 203 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-12 12:22:06
1547 1756 6 203 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-12 12:22:06
1548 1757 7 203 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 12:22:06
1549 1758 8 203 12555 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:22:06
1550 1759 1 204 12516 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-12 12:29:52