fx_franchise_order_product

4,737 rows · 33 columns · page 48 / 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
2351 2560 1 609 12526 79 ALKALINE JUG NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 0.0 0.0 0.0 0.0 18.0 1510.17 8389.83 1510.17 9900.0 INR 3 0.0 150.0 2026-01-07 16:23:06
2352 2561 2 609 12526 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 0.0 0.0 0.0 0.0 5.0 500.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 16:23:06
2353 2562 1 610 12518 61 Radiation chip NULL 902221 2 0.0 999.0 0.0 0.0 500.0 423.73 76.27 1998.0 0.0 1000.0 0.0 0.0 0.0 0.0 18.0 152.54 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-07 16:39:49
2354 2563 2 610 12518 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 2500.0 0.0 2000.0 0.0 0.0 0.0 0.0 3.0 58.25 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-07 16:39:49
2355 2564 3 610 12518 3 BP Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 16:39:49
2356 2565 4 610 12518 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 16:39:49
2357 2566 5 610 12518 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 0.0 0.0 0.0 0.0 18.0 121.27 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-07 16:39:49
2358 2567 6 610 12518 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 0.0 0.0 0.0 0.0 5.0 37.86 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-07 16:39:49
2359 2568 7 610 12518 12 P RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 0.0 0.0 0.0 0.0 5.0 71.43 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-07 16:39:49
2360 2569 8 610 12518 41 Premium Coco Body Lotion NULL 3304300 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 18.0 255.81 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-07 16:39:49
2361 2570 9 610 12518 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 0.0 0.0 0.0 0.0 5.0 48.57 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-07 16:39:49
2362 2571 10 610 12518 26 Spirulina Cap NULL 2009899 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 0.0 0.0 0.0 0.0 5.0 68.48 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-07 16:39:49
2363 2572 11 610 12518 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 18.0 170.54 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-07 16:39:49
2364 2573 12 610 12518 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 0.0 0.0 0.0 0.0 18.0 91.53 508.47 91.53 600.0 INR 3 2.0 10.17 2026-01-07 16:39:49
2365 2574 13 610 12518 44 Vital Glow Face Scrub NULL 3304300 3 0.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 0.0 780.0 0.0 0.0 0.0 0.0 18.0 118.98 661.02 118.98 780.0 INR 3 2.0 13.22 2026-01-07 16:39:49
2366 2575 1 611 12555 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.0 5750.0 2.5 136.9 2.5 136.9 0.0 0.0 5476.19 273.81 5750.0 INR 3 2.0 109.52 2026-01-07 16:42:40
2367 2576 1 612 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 15 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 24000.0 0.0 18750.0 2.5 446.43 2.5 446.43 0.0 0.0 17857.14 892.86 18750.0 INR 2 6.0 1071.43 2026-01-07 16:44:29
2368 2577 2 612 12554 53 Terra care 2 kg NULL 3103100 15 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 22500.0 0.0 17250.0 2.5 410.71 2.5 410.71 0.0 0.0 16428.57 821.43 17250.0 INR 2 6.0 985.71 2026-01-07 16:44:29
2369 2578 1 613 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 10 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 16000.0 0.0 12500.0 2.5 297.62 2.5 297.62 0.0 0.0 11904.76 595.24 12500.0 INR 3 2.0 238.1 2026-01-07 16:45:06
2370 2579 1 614 12518 34 Herbo2o Toothpaste NULL 33061090 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 0.0 0.0 0.0 0.0 18.0 363.81 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-01-07 16:46:34
2371 2580 1 615 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-01-07 17:17:06
2372 2581 2 615 12555 53 Terra care 2 kg NULL 3103100 10 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 15000.0 0.0 11500.0 2.5 273.81 2.5 273.81 0.0 0.0 10952.38 547.62 11500.0 INR 3 2.0 219.05 2026-01-07 17:17:06
2373 2582 1 616 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 6 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 9600.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 2 6.0 428.57 2026-01-07 17:17:52
2374 2583 1 617 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-01-07 17:19:28
2375 2584 1 618 12554 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 2 0.0 300.0 2026-01-07 18:11:09
2376 2585 1 619 12555 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 18:11:43
2377 2586 2 619 12555 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-07 18:11:43
2378 2587 1 620 12546 48 glow face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 18.0 231.86 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-07 19:23:04
2379 2588 2 620 12546 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 0.0 0.0 0.0 0.0 5.0 123.81 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-07 19:23:04
2380 2589 3 620 12546 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 0.0 0.0 0.0 0.0 5.0 500.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 19:23:04
2381 2590 4 620 12546 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-07 19:23:04
2382 2591 5 620 12546 15 KIDNEY CARE JUICE NULL 2009899 5 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1745.0 0.0 1395.0 0.0 0.0 0.0 0.0 5.0 66.43 1328.57 66.43 1395.0 INR 3 2.0 26.57 2026-01-07 19:23:04
2383 2592 6 620 12546 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 3 2.0 90.86 2026-01-07 19:23:04
2384 2593 7 620 12546 47 Premium Hair Care Shampoo NULL 3305109 3 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 5.0 79.86 1597.14 79.86 1677.0 INR 3 2.0 31.94 2026-01-07 19:23:04
2385 2594 8 620 12546 46 Root Vitality Hair Oil NULL 3305901 4 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1020.0 0.0 816.0 0.0 0.0 0.0 0.0 5.0 38.86 777.14 38.86 816.0 INR 3 2.0 15.54 2026-01-07 19:23:04
2386 2595 9 620 12546 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 18.0 255.81 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-07 19:23:04
2387 2596 10 620 12546 36 Toilet Cleaner 500ml NULL 3924101 10 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 0.0 1200.0 0.0 0.0 0.0 0.0 18.0 183.05 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-07 19:23:04
2388 2597 1 621 12526 48 glow face wash NULL 3304999 4 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 0.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 1030.51 185.49 1216.0 INR 3 2.0 20.61 2026-01-07 20:18:12
2389 2598 2 621 12526 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 2.5 123.81 2.5 123.81 0.0 0.0 4952.38 247.62 5200.0 INR 3 2.0 99.05 2026-01-07 20:18:12
2390 2599 3 621 12526 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-07 20:18:12
2391 2600 4 621 12526 33 Herbal Soap 100gm NULL 30049011 5 0.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 0.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-01-07 20:18:12
2392 2601 5 621 12526 18 Lady Care Juice 500ml NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-07 20:18:12
2393 2602 6 621 12526 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-01-07 20:18:12
2394 2603 1 622 12539 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 21:17:25
2395 2604 1 623 12517 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 2285.71 114.29 2400.0 INR 2 6.0 137.14 2026-01-07 22:10:31
2396 2605 2 623 12517 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 10 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 14240.0 0.0 7500.0 0.0 0.0 0.0 0.0 5.0 357.14 7142.86 357.14 7500.0 INR 2 6.0 428.57 2026-01-07 22:10:31
2397 2606 1 624 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 9 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 12816.0 0.0 6750.0 2.5 160.71 2.5 160.71 0.0 0.0 6428.57 321.43 6750.0 INR 1 8.0 514.29 2026-01-07 22:11:16
2398 2607 1 625 13438 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-07 22:12:47
2399 2608 2 625 13438 81 PREMIUM GLOW FACE WASH NULL 3404 2 0.0 699.0 0.0 0.0 559.0 512.84 46.16 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 9.0 92.31 1025.69 92.31 1118.0 INR 3 2.0 20.51 2026-01-07 22:12:47
2400 2609 3 625 13438 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 3 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 4272.0 0.0 2250.0 0.0 0.0 0.0 0.0 5.0 107.14 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-07 22:12:47