fx_franchise_order_product

4,737 rows · 33 columns · page 27 / 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
1301 1510 1 189 12554 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-11 21:47:33
1302 1511 1 190 12516 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 22:11:56
1303 1512 2 190 12516 27 Multicharge Cap 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 22:11:56
1304 1513 3 190 12516 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 22:11:56
1305 1514 4 190 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-11 22:11:56
1306 1515 5 190 12516 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 22:11:56
1307 1516 6 190 12516 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 22:11:56
1308 1517 7 190 12516 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 22:11:56
1309 1518 8 190 12516 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 22:11:56
1310 1519 9 190 12516 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 22:11:56
1311 1520 10 190 12516 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 22:11:56
1312 1521 11 190 12516 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 22:11:56
1313 1522 12 190 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-11 22:11:56
1314 1523 13 190 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-11 22:11:56
1315 1524 14 190 12516 19 Fat loss Juice 500 ml NULL 30049011 20 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 29980.0 5000.0 29580.0 2.5 704.28 2.5 704.28 0.0 0.0 1408.57 1408.57 29580.0 INR 0 0.0 0.0 2025-11-11 22:11:56
1316 1525 15 190 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-11 22:11:56
1317 1526 16 190 12516 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 22:11:56
1318 1527 17 190 12516 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 22:11:56
1319 1528 18 190 12516 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 22:11:56
1320 1529 19 190 12516 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 22:11:56
1321 1530 20 190 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-11 22:11:56
1322 1531 21 190 12516 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 22:11:56
1323 1532 22 190 12516 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 22:11:56
1324 1533 23 190 12516 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 22:11:56
1325 1534 24 190 12516 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 22:11:56
1326 1535 25 190 12516 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 22:11:56
1327 1536 26 190 12516 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 22:11:56
1328 1537 27 190 12516 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 22:11:56
1329 1538 28 190 12516 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 22:11:56
1330 1539 29 190 12516 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 22:11:56
1331 1540 30 190 12516 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 22:11:56
1332 1541 31 190 12516 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 22:11:56
1333 1542 32 190 12516 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 22:11:56
1334 1543 33 190 12516 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 22:11:56
1335 1544 34 190 12516 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 22:11:56
1336 1545 35 190 12516 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 22:11:56
1337 1546 36 190 12516 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 22:11:56
1338 1547 37 190 12516 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 22:11:56
1339 1548 38 190 12516 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 22:11:56
1340 1549 39 190 12516 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 22:11:56
1341 1550 40 190 12516 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 22:11:56
1342 1551 41 190 12516 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 22:11:56
1343 1552 42 190 12516 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 22:11:56
1344 1553 43 190 12516 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 22:11:56
1345 1554 44 190 12516 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 22:11:56
1346 1555 45 190 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-11 22:11:56
1347 1556 46 190 12516 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 22:11:56
1348 1557 47 190 12516 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 22:11:56
1349 1558 48 190 12516 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 22:11:56
1350 1559 49 190 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 22:11:56