fx_franchise_order_product

4,737 rows · 33 columns · page 25 / 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
1201 1410 41 179 12516 43 Quench Kiss Lip Balm NULL 3304300 1 35.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 35.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-11 20:02:12
1202 1411 42 179 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 20:02:12
1203 1412 43 179 12516 29 Shilajith NULL 30049011 30 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 54000.0 7500.0 43200.0 2.5 1028.57 2.5 1028.57 0.0 0.0 1371.43 2057.14 43200.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1204 1413 44 179 12516 26 Spirulina Cap NULL 2009899 50 190.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 9500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1205 1414 45 179 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 20:02:12
1206 1415 46 179 12516 50 Sun Screen NULL 330499 200 250.0 699.0 0.0 0.0 559.2 473.9 85.3 139800.0 50000.0 111840.0 9.0 8530.17 9.0 8530.17 0.0 0.0 473.9 17060.34 111840.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1207 1416 47 179 12516 59 T Shirt NULL 61099010 20 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 28000.0 0.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 20:02:12
1208 1417 48 179 12516 53 Terra care 2 kg NULL 3103100 50 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 75000.0 22500.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1209 1418 49 179 12516 5 Thyro Care NULL 2936900 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-11 20:02:12
1210 1419 50 179 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 20:02:12
1211 1420 51 179 12516 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 9.0 991.52 9.0 991.52 0.0 0.0 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1212 1421 52 179 12516 54 Wonder grow 100ml NULL 3105 50 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 70000.0 25000.0 56000.0 2.5 1333.34 2.5 1333.34 0.0 0.0 1066.67 2666.67 56000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1213 1422 1 180 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1214 1423 2 180 12516 27 Multicharge Cap NULL 2009899 30 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 13500.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1215 1424 3 180 12516 20 Premium Berry Juice 1000ml NULL 2936900 30 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 104970.0 22500.0 104370.0 2.5 2485.0 2.5 2485.0 0.0 0.0 3313.33 4970.0 104370.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1216 1425 4 180 12516 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.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 20:02:13
1217 1426 5 180 12516 61 Radiation chip NULL 902221 50 325.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 16250.0 39960.0 9.0 3047.8 9.0 3047.8 0.0 0.0 677.29 6095.59 39960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1218 1427 6 180 12516 31 Vegan Plant Protein Powder NULL 21061000 30 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 89970.0 30000.0 71976.0 2.5 1713.71 2.5 1713.71 0.0 0.0 2284.95 3427.43 71976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1219 1428 7 180 12516 49 Anti Dandruff Serum NULL 3304999 30 250.0 999.0 0.0 0.0 799.2 677.29 121.91 29970.0 7500.0 23976.0 9.0 1828.68 9.0 1828.68 0.0 0.0 677.29 3657.36 23976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1220 1429 8 180 12516 6 Asthma Care 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-11 20:02:13
1221 1430 9 180 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 50 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 80000.0 22500.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 1219.05 3047.62 64000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1222 1431 10 180 12516 3 BP Care Capsules NULL 2936900 40 160.0 599.0 0.0 0.0 479.2 456.38 22.82 23960.0 6400.0 19168.0 2.5 456.38 2.5 456.38 0.0 0.0 456.38 912.76 19168.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1223 1432 11 180 12516 4 Diabetic Care Capsules NULL 2936900 50 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 12500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1224 1433 12 180 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 20:02:13
1225 1434 13 180 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 20:02:13
1226 1435 14 180 12516 19 Fat loss Juice 500 ml NULL 30049011 70 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 104930.0 17500.0 103530.0 2.5 2465.0 2.5 2465.0 0.0 0.0 1408.57 4930.0 103530.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1227 1436 15 180 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 20:02:13
1228 1437 16 180 12516 60 Foot patch NULL 30051090 50 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 99950.0 25000.0 79960.0 2.5 1903.81 2.5 1903.81 0.0 0.0 1523.05 3807.62 79960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1229 1438 17 180 12516 58 Green shield 250ml NULL 3105 30 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 75000.0 24000.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1904.76 2857.14 60000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1230 1439 18 180 12516 55 Grow master 500ml NULL 3105 30 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 60900.0 25500.0 48720.0 2.5 1160.0 2.5 1160.0 0.0 0.0 1546.67 2320.0 48720.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1231 1440 19 180 12516 2 Heart Care Capsules NULL 2936900 30 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 12750.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1232 1441 20 180 12516 33 Herbal Soap 100gm NULL 30049011 1500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 150000.0 42000.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 76.19 5714.29 120000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1233 1442 21 180 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 20:02:13
1234 1443 22 180 12516 24 Immunomax 24/7 Caps NULL 2009899 50 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 22500.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1235 1444 23 180 12516 30 Iron Capsules NULL 30049011 50 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 12500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1236 1445 24 180 12516 15 Kidney Stone Juice NULL 2009899 100 120.0 349.0 0.0 0.0 279.2 265.9 13.3 34900.0 12000.0 27920.0 2.5 664.76 2.5 664.76 0.0 0.0 265.9 1329.52 27920.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1237 1446 25 180 12516 18 Lady Care Juice 500ml NULL 2009899 50 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 12500.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1238 1447 26 180 12516 16 Liver Care Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1239 1448 27 180 12516 25 Manicalcium Tablets NULL 2009899 50 95.0 399.0 0.0 0.0 319.2 304.0 15.2 19950.0 4750.0 15960.0 2.5 380.0 2.5 380.0 0.0 0.0 304.0 760.0 15960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1240 1449 28 180 12516 12 Melatonin Drop NULL 2106909 50 190.0 749.0 0.0 0.0 599.2 570.67 28.53 37450.0 9500.0 29960.0 2.5 713.34 2.5 713.34 0.0 0.0 570.67 1426.67 29960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1241 1450 29 180 12516 17 Memory Booster Juice NULL 2009899 100 120.0 349.0 0.0 0.0 279.2 265.9 13.3 34900.0 12000.0 27920.0 2.5 664.76 2.5 664.76 0.0 0.0 265.9 1329.52 27920.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1242 1451 30 180 12516 56 Micro magic 500ml NULL 3105 30 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 60900.0 25500.0 48720.0 9.0 3715.93 9.0 3715.93 0.0 0.0 1376.27 7431.86 48720.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1243 1452 31 180 12516 7 Morning Fresh Churan NULL 30049011 100 40.0 199.0 0.0 0.0 159.2 151.62 7.58 19900.0 4000.0 15920.0 2.5 379.05 2.5 379.05 0.0 0.0 151.62 758.1 15920.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1244 1453 32 180 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 20:02:13
1245 1454 33 180 12516 9 Omega 369 NULL 2936900 50 260.0 999.0 0.0 0.0 799.2 761.14 38.06 49950.0 13000.0 39960.0 2.5 951.43 2.5 951.43 0.0 0.0 761.14 1902.86 39960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1246 1455 34 180 12516 28 Ortho Joint Shield NULL 2009899 50 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 22500.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1247 1456 35 180 12516 72 Pain Relief Patch NULL 30051090 100 200.0 800.0 0.0 0.0 640.0 609.52 30.48 80000.0 20000.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 609.52 3047.62 64000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1248 1457 36 180 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 20:02:13
1249 1458 37 180 12516 41 Premium Coco Body Lotion NULL 3304300 150 250.0 699.0 0.0 0.0 559.2 473.9 85.3 104850.0 37500.0 83880.0 9.0 6397.62 9.0 6397.62 0.0 0.0 473.9 12795.25 83880.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1250 1459 38 180 12516 14 Premium Aloe Vera VEG caps NULL 2936900 100 100.0 359.0 0.0 0.0 287.2 273.52 13.68 35900.0 10000.0 28720.0 2.5 683.81 2.5 683.81 0.0 0.0 273.52 1367.62 28720.0 INR 0 0.0 0.0 2025-11-11 20:02:13