fx_franchise_order_product

4,737 rows · 33 columns · page 29 / 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
1401 1610 49 191 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-11 23:32:11
1402 1611 50 191 12516 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:32:11
1403 1612 51 191 12516 54 Wonder grow 100ml NULL 3105 20 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 28000.0 10000.0 22400.0 2.5 533.34 2.5 533.34 0.0 0.0 1066.67 1066.67 22400.0 INR 0 0.0 0.0 2025-11-11 23:32:11
1404 1613 1 192 12554 48 glow face wash NULL 3304999 30 250.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 7500.0 9120.0 9.0 695.6 9.0 695.6 0.0 0.0 257.63 1391.19 9120.0 INR 0 0.0 0.0 2025-11-11 23:58:07
1405 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
1406 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
1407 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
1408 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
1409 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
1410 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
1411 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
1412 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
1413 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
1414 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
1415 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
1416 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
1417 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
1418 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
1419 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
1420 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
1421 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
1422 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
1423 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
1424 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
1425 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
1426 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
1427 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
1428 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
1429 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
1430 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
1431 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
1432 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
1433 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
1434 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
1435 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
1436 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
1437 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
1438 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
1439 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
1440 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
1441 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
1442 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
1443 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
1444 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
1445 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
1446 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
1447 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
1448 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
1449 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
1450 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