fx_franchise_order_product

4,737 rows · 33 columns · page 24 / 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
1151 1360 44 177 12554 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 18:31:23
1152 1361 45 177 12554 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 18:31:23
1153 1362 46 177 12554 1 Stem Cell Powder NULL 2936900 500 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 1249500.0 374500.0 999600.0 2.5 23800.0 2.5 23800.0 0.0 0.0 1904.0 47600.0 999600.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1154 1363 47 177 12554 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 18:31:23
1155 1364 48 177 12554 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 18:31:23
1156 1365 49 177 12554 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 18:31:23
1157 1366 50 177 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 18:31:23
1158 1367 51 177 12554 44 Vital Glow Face Scrub NULL 3304300 30 71.0 325.0 0.0 0.0 260.0 220.34 39.66 9750.0 2130.0 7800.0 9.0 594.91 9.0 594.91 0.0 0.0 220.34 1189.83 7800.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1159 1368 52 177 12554 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 18:31:23
1160 1369 1 178 12516 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-11 19:45:48
1161 1370 1 179 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:12
1162 1371 2 179 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:12
1163 1372 3 179 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:12
1164 1373 4 179 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:12
1165 1374 5 179 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:12
1166 1375 6 179 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:12
1167 1376 7 179 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:12
1168 1377 8 179 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:12
1169 1378 9 179 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:12
1170 1379 10 179 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:12
1171 1380 11 179 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:12
1172 1381 12 179 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:12
1173 1382 13 179 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:12
1174 1383 14 179 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:12
1175 1384 15 179 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:12
1176 1385 16 179 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:12
1177 1386 17 179 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:12
1178 1387 18 179 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:12
1179 1388 19 179 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:12
1180 1389 20 179 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:12
1181 1390 21 179 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:12
1182 1391 22 179 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:12
1183 1392 23 179 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:12
1184 1393 24 179 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:12
1185 1394 25 179 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:12
1186 1395 26 179 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:12
1187 1396 27 179 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:12
1188 1397 28 179 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:12
1189 1398 29 179 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:12
1190 1399 30 179 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:12
1191 1400 31 179 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:12
1192 1401 32 179 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:12
1193 1402 33 179 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:12
1194 1403 34 179 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:12
1195 1404 35 179 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:12
1196 1405 36 179 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:12
1197 1406 37 179 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:12
1198 1407 38 179 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:12
1199 1408 39 179 12516 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-11 20:02:12
1200 1409 40 179 12516 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-11 20:02:12