fx_franchise_order_product

4,933 rows · 33 columns · page 33 / 99

Invoice view 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 1614 2 192 12554 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.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-11 23:58:07
1602 1615 3 192 12554 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 2.5 828.34 2.5 828.34 0.0 0.0 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1603 1616 4 192 12554 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-11 23:58:07
1604 1617 5 192 12554 61 Radiation chip NULL 902221 20 325.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 6500.0 15984.0 9.0 1219.12 9.0 1219.12 0.0 0.0 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1605 1618 6 192 12554 31 Vegan Plant Protein Powder NULL 21061000 20 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 59980.0 20000.0 47984.0 2.5 1142.47 2.5 1142.47 0.0 0.0 2284.95 2284.95 47984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1606 1619 7 192 12554 49 Anti Dandruff Serum NULL 3304999 20 250.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 5000.0 15984.0 9.0 1219.12 9.0 1219.12 0.0 0.0 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1607 1620 8 192 12554 6 Asthma Care NULL 30049011 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-11 23:58:07
1608 1621 9 192 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 20 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 32000.0 9000.0 25600.0 2.5 609.52 2.5 609.52 0.0 0.0 1219.05 1219.05 25600.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1609 1622 10 192 12554 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-11 23:58:07
1610 1623 11 192 12554 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-11 23:58:07
1611 1624 12 192 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-11 23:58:07
1612 1625 13 192 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-11 23:58:07
1613 1626 14 192 12554 19 Fat loss Juice 500 ml NULL 30049011 10 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 14990.0 2500.0 14790.0 2.5 352.14 2.5 352.14 0.0 0.0 1408.57 704.29 14790.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1614 1627 15 192 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-11 23:58:07
1615 1628 16 192 12554 60 Foot patch NULL 30051090 20 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 39980.0 10000.0 31984.0 2.5 761.52 2.5 761.52 0.0 0.0 1523.05 1523.05 31984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1616 1629 17 192 12554 58 Green shield 250ml NULL 3105 20 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 50000.0 16000.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 1904.76 1904.76 40000.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1617 1630 18 192 12554 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.34 2.5 773.34 0.0 0.0 1546.67 1546.67 32480.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1618 1631 19 192 12554 2 Heart Care Capsules NULL 2936900 20 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 8500.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-11 23:58:07
1619 1632 20 192 12554 33 Herbal Soap 100gm NULL 30049011 2000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 200000.0 56000.0 160000.0 2.5 3809.53 2.5 3809.53 0.0 0.0 76.19 7619.05 160000.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1620 1633 21 192 12554 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-11 23:58:07
1621 1634 22 192 12554 24 Immunomax 24/7 Caps NULL 2009899 4 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1800.0 4796.8 2.5 114.21 2.5 114.21 0.0 0.0 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-11 23:58:07
1622 1635 23 192 12554 30 Iron Capsules NULL 30049011 40 250.0 899.0 0.0 0.0 719.2 684.95 34.25 35960.0 10000.0 28768.0 2.5 684.95 2.5 684.95 0.0 0.0 684.95 1369.9 28768.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1623 1636 24 192 12554 15 Kidney Stone Juice NULL 2009899 30 120.0 349.0 0.0 0.0 279.2 265.9 13.3 10470.0 3600.0 8376.0 2.5 199.43 2.5 199.43 0.0 0.0 265.9 398.86 8376.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1624 1637 25 192 12554 18 Lady Care Juice 500ml NULL 2009899 20 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 5000.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-11 23:58:07
1625 1638 26 192 12554 16 Liver Care 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-11 23:58:07
1626 1639 27 192 12554 25 Manicalcium Tablets NULL 2009899 20 95.0 399.0 0.0 0.0 319.2 304.0 15.2 7980.0 1900.0 6384.0 2.5 152.0 2.5 152.0 0.0 0.0 304.0 304.0 6384.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1627 1640 28 192 12554 12 Melatonin Drop NULL 2106909 20 190.0 749.0 0.0 0.0 599.2 570.67 28.53 14980.0 3800.0 11984.0 2.5 285.33 2.5 285.33 0.0 0.0 570.67 570.67 11984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1628 1641 29 192 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-11 23:58:07
1629 1642 30 192 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-11 23:58:07
1630 1643 31 192 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-11 23:58:07
1631 1644 32 192 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-11 23:58:07
1632 1645 33 192 12554 9 Omega 369 NULL 2936900 20 260.0 999.0 0.0 0.0 799.2 761.14 38.06 19980.0 5200.0 15984.0 2.5 380.57 2.5 380.57 0.0 0.0 761.14 761.14 15984.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1633 1646 34 192 12554 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-11 23:58:07
1634 1647 35 192 12554 72 Pain Relief Patch NULL 30051090 30 200.0 800.0 0.0 0.0 640.0 609.52 30.48 24000.0 6000.0 19200.0 2.5 457.14 2.5 457.14 0.0 0.0 609.52 914.29 19200.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1635 1648 36 192 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-11 23:58:07
1636 1649 37 192 12554 41 Premium Coco Body Lotion NULL 3304300 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-11 23:58:07
1637 1650 38 192 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-11 23:58:07
1638 1651 39 192 12554 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1639 1652 40 192 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-11 23:58:07
1640 1653 41 192 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-11 23:58:07
1641 1654 42 192 12554 57 Safe guard 250ml NULL 3105 20 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 50000.0 16000.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 1904.76 1904.76 40000.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1642 1655 43 192 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-11 23:58:07
1643 1656 44 192 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-11 23:58:07
1644 1657 45 192 12554 26 Spirulina Cap NULL 2009899 20 190.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 3800.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-11 23:58:07
1645 1658 46 192 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-11 23:58:07
1646 1659 47 192 12554 50 Sun Screen NULL 330499 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-11 23:58:07
1647 1660 48 192 12554 53 Terra care 2 kg NULL 3103100 20 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 30000.0 9000.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 1142.86 1142.86 24000.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1648 1661 49 192 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-11 23:58:07
1649 1662 50 192 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-11 23:58:07
1650 1663 51 192 12554 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-11 23:58:07