fx_franchise_order_product

4,737 rows · 33 columns · page 30 / 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
1451 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
1452 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
1453 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
1454 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
1455 1664 52 192 12554 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:58:07
1456 1665 1 193 12552 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 00:14:12
1457 1666 2 193 12552 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-12 00:14:12
1458 1667 3 193 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-12 00:14:12
1459 1668 1 194 12554 80 BOOSTER KIT NULL NULL 50 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 1099910.0 0.0 684950.0 9.0 52241.95 9.0 52241.95 0.0 0.0 11609.32 104483.9 684950.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1460 1669 2 194 12554 76 ELITE BOX NULL NULL 10 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 464940.0 0.0 180000.0 2.5 4285.72 2.5 4285.72 0.0 0.0 17142.86 8571.43 180000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1461 1670 3 194 12554 77 ELITE COMFORT NULL NULL 50 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 2699700.0 0.0 925000.0 2.5 22023.81 2.5 22023.81 0.0 0.0 17619.05 44047.62 925000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1462 1671 4 194 12554 73 ENTRY BOX NULL NULL 50 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 199920.0 0.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 3808.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1463 1672 5 194 12554 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1464 1673 6 194 12554 75 WELLNESS EXPLORER NULL NULL 50 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 1114730.0 0.0 530000.0 2.5 12619.05 2.5 12619.05 0.0 0.0 10095.24 25238.1 530000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1465 1674 1 195 12555 80 BOOSTER KIT NULL NULL 50 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 1099910.0 0.0 684950.0 9.0 52241.95 9.0 52241.95 0.0 0.0 11609.32 104483.9 684950.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1466 1675 2 195 12555 76 ELITE BOX NULL NULL 10 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 464940.0 0.0 180000.0 2.5 4285.72 2.5 4285.72 0.0 0.0 17142.86 8571.43 180000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1467 1676 3 195 12555 77 ELITE COMFORT NULL NULL 50 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 2699700.0 0.0 925000.0 2.5 22023.81 2.5 22023.81 0.0 0.0 17619.05 44047.62 925000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1468 1677 4 195 12555 73 ENTRY BOX NULL NULL 50 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 199920.0 0.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 3808.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1469 1678 5 195 12555 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1470 1679 6 195 12555 75 WELLNESS EXPLORER NULL NULL 30 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 668838.0 0.0 318000.0 2.5 7571.43 2.5 7571.43 0.0 0.0 10095.24 15142.86 318000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1471 1680 1 196 12516 58 Green shield 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 08:29:53
1472 1681 1 197 12516 58 Green shield 250ml NULL 3105 10 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 25000.0 8000.0 20000.0 2.5 476.19 2.5 476.19 0.0 0.0 1904.76 952.38 20000.0 INR 0 0.0 0.0 2025-11-12 08:45:26
1473 1682 1 198 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-12 09:05:44
1474 1683 2 198 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-12 09:05:44
1475 1684 3 198 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-12 09:05:44
1476 1685 4 198 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-12 09:05:44
1477 1686 5 198 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-12 09:05:44
1478 1687 6 198 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-12 09:05:44
1479 1688 7 198 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-12 09:05:44
1480 1689 8 198 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-12 09:05:44
1481 1690 9 198 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-12 09:05:44
1482 1691 10 198 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-12 09:05:44
1483 1692 11 198 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-12 09:05:44
1484 1693 12 198 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 09:05:44
1485 1694 13 198 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 09:05:44
1486 1695 14 198 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-12 09:05:44
1487 1696 15 198 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 09:05:44
1488 1697 16 198 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-12 09:05:44
1489 1698 17 198 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-12 09:05:44
1490 1699 18 198 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-12 09:05:44
1491 1700 19 198 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-12 09:05:44
1492 1701 20 198 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-12 09:05:44
1493 1702 21 198 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-12 09:05:44
1494 1703 22 198 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-12 09:05:44
1495 1704 23 198 12554 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 09:05:44
1496 1705 24 198 12554 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-12 09:05:44
1497 1706 25 198 12554 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 09:05:44
1498 1707 26 198 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-12 09:05:44
1499 1708 27 198 12554 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1500 1709 28 198 12554 12 Melatonin 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 09:05:44