fx_franchise_order_product

4,737 rows · 33 columns · page 26 / 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
1251 1460 39 180 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:13
1252 1461 40 180 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:13
1253 1462 41 180 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:13
1254 1463 42 180 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:13
1255 1464 43 180 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:13
1256 1465 44 180 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:13
1257 1466 45 180 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:13
1258 1467 46 180 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:13
1259 1468 47 180 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:13
1260 1469 48 180 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:13
1261 1470 49 180 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:13
1262 1471 50 180 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:13
1263 1472 51 180 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:13
1264 1473 52 180 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:13
1265 1474 1 181 12517 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 0.0 0.0 0.0 0.0 18.0 2089.68 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1266 1475 2 181 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1267 1476 3 181 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1268 1477 1 182 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 21:16:03
1269 1478 2 182 12516 27 Multicharge Cap 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 21:16:03
1270 1479 3 182 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 21:16:03
1271 1480 4 182 12516 70 Premium Hand belt NULL 9404 30 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 299970.0 18000.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 21:16:03
1272 1481 1 183 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 21:22:38
1273 1482 2 183 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 21:22:38
1274 1483 3 183 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 21:22:38
1275 1484 4 183 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1276 1485 5 183 12516 34 Herbo2o Toothpaste NULL 33061090 200 45.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 9000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1277 1486 6 183 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1278 1487 7 183 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 21:22:38
1279 1488 1 184 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 21:26:19
1280 1489 2 184 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 21:26:19
1281 1490 3 184 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 21:26:19
1282 1491 4 184 12554 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:26:19
1283 1492 5 184 12554 34 Herbo2o Toothpaste NULL 33061090 100 45.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 4500.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 21:26:19
1284 1493 6 184 12554 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:26:19
1285 1494 7 184 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 21:26:19
1286 1495 1 185 12555 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 21:28:36
1287 1496 2 185 12555 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 21:28:36
1288 1497 3 185 12555 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 21:28:36
1289 1498 4 185 12555 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:28:36
1290 1499 5 185 12555 34 Herbo2o Toothpaste NULL 33061090 100 45.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 4500.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 21:28:36
1291 1500 6 185 12555 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:28:36
1292 1501 7 185 12555 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 21:28:36
1293 1502 1 186 12526 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-11 21:28:53
1294 1503 2 186 12526 74 EXPLORER BOX NULL NULL 4 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 107988.0 0.0 41996.0 2.5 999.9 2.5 999.9 0.0 0.0 9999.05 1999.81 41996.0 INR 0 0.0 0.0 2025-11-11 21:28:53
1295 1504 1 187 12555 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:41:34
1296 1505 1 188 12516 80 BOOSTER KIT NULL NULL 10 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 219982.0 0.0 136990.0 9.0 10448.39 9.0 10448.39 0.0 0.0 11609.32 20896.78 136990.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1297 1506 2 188 12516 76 ELITE BOX NULL NULL 1 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 46494.0 0.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1298 1507 3 188 12516 77 ELITE COMFORT NULL NULL 10 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 539940.0 0.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 17619.05 8809.52 185000.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1299 1508 4 188 12516 73 ENTRY BOX NULL NULL 10 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 39984.0 0.0 39984.0 2.5 952.0 2.5 952.0 0.0 0.0 3808.0 1904.0 39984.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1300 1509 5 188 12516 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-11-11 21:43:20