fx_franchise_order_product

4,737 rows · 33 columns · page 51 / 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
2501 2710 1 655 13536 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-09 17:17:35
2502 2711 2 655 13536 32 Neem Soap 100gm NULL 34011110 27 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1620.0 0.0 1296.0 2.5 30.86 2.5 30.86 0.0 0.0 1234.29 61.71 1296.0 INR 3 2.0 24.69 2026-01-09 17:17:35
2503 2712 3 655 13536 35 Sanitary Pad (15 pcs) NULL 9619001 13 0.0 380.0 0.0 0.0 304.0 304.0 0.0 4940.0 0.0 3952.0 0.0 0.0 0.0 0.0 0.0 0.0 3952.0 0.0 3952.0 INR 3 2.0 79.04 2026-01-09 17:17:35
2504 2713 4 655 13536 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 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-09 17:17:35
2505 2714 1 656 12554 36 Toilet Cleaner 500ml NULL 3924101 20 0.0 150.0 0.0 0.0 120.0 101.69 18.31 3000.0 0.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 2033.9 366.1 2400.0 INR 2 6.0 122.03 2026-01-09 17:18:26
2506 2715 1 657 12526 84 B AND B NULL 94041000 5 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 64995.0 0.0 52500.0 2.5 1250.0 2.5 1250.0 0.0 0.0 50000.0 2500.0 52500.0 INR 3 0.0 150.0 2026-01-09 17:39:29
2507 2716 1 658 13438 48 glow face wash NULL 3304999 6 0.0 380.0 0.0 0.0 304.0 257.63 46.37 2280.0 0.0 1824.0 0.0 0.0 0.0 0.0 18.0 278.24 1545.76 278.24 1824.0 INR 3 2.0 30.92 2026-01-09 18:45:20
2508 2717 2 658 13438 19 Fat loss Juice 500 ml NULL 30049011 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-09 18:45:20
2509 2718 3 658 13438 46 Root Vitality Hair Oil NULL 3305901 8 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2040.0 0.0 1632.0 0.0 0.0 0.0 0.0 5.0 77.71 1554.29 77.71 1632.0 INR 3 2.0 31.09 2026-01-09 18:45:20
2510 2719 4 658 13438 44 Vital Glow Face Scrub NULL 3304300 4 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 0.0 1040.0 0.0 0.0 0.0 0.0 18.0 158.64 881.36 158.64 1040.0 INR 3 2.0 17.63 2026-01-09 18:45:20
2511 2720 1 659 12554 12 P RADIANCE FACE SERUM NULL 33049990 20 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 25000.0 0.0 15000.0 2.5 357.14 2.5 357.14 0.0 0.0 14285.71 714.29 15000.0 INR 2 6.0 857.14 2026-01-09 19:24:22
2512 2721 1 660 12520 27 Multicharge Cap NULL 2009899 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-09 19:37:06
2513 2722 2 660 12520 31 Vegan Plant Protein Powder NULL 21061000 1 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 2999.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-01-09 19:37:06
2514 2723 3 660 12520 38 Dish Wash 500ml NULL 3924101 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-09 19:37:06
2515 2724 4 660 12520 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 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-09 19:37:06
2516 2725 5 660 12520 33 Herbal Soap 100gm NULL 30049011 20 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 0.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-01-09 19:37:06
2517 2726 6 660 12520 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-09 19:37:06
2518 2727 7 660 12520 28 Ortho Joint Shield NULL 2009899 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-09 19:37:06
2519 2728 8 660 12520 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-01-09 19:37:06
2520 2729 9 660 12520 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 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-09 19:37:06
2521 2730 1 661 13438 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-09 19:38:29
2522 2731 2 661 13438 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 0.0 0.0 0.0 0.0 5.0 29.14 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-09 19:38:29
2523 2732 3 661 13438 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 4 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 5696.0 0.0 3000.0 0.0 0.0 0.0 0.0 5.0 142.86 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-01-09 19:38:29
2524 2733 4 661 13438 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 0.0 0.0 0.0 0.0 5.0 95.19 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-09 19:38:29
2525 2734 5 661 13438 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-09 19:38:29
2526 2735 1 662 12516 84 B AND B NULL 94041000 5 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 64995.0 0.0 52500.0 2.5 1250.0 2.5 1250.0 0.0 0.0 50000.0 2500.0 52500.0 INR 1 0.0 400.0 2026-01-09 19:55:43
2527 2736 1 663 12517 84 B AND B NULL 94041000 3 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 38997.0 0.0 31500.0 0.0 0.0 0.0 0.0 5.0 1500.0 30000.0 1500.0 31500.0 INR 2 0.0 300.0 2026-01-09 19:58:10
2528 2737 1 664 12526 84 B AND B NULL 94041000 3 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 38997.0 0.0 31500.0 2.5 750.0 2.5 750.0 0.0 0.0 30000.0 1500.0 31500.0 INR 3 0.0 150.0 2026-01-09 20:05:14
2529 2738 1 665 12517 84 B AND B NULL 94041000 8 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 103992.0 0.0 84000.0 0.0 0.0 0.0 0.0 5.0 4000.0 80000.0 4000.0 84000.0 INR 2 0.0 300.0 2026-01-09 20:21:55
2530 2739 1 666 12516 84 B AND B NULL 94041000 15 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 194985.0 0.0 157500.0 2.5 3750.0 2.5 3750.0 0.0 0.0 150000.0 7500.0 157500.0 INR 1 0.0 400.0 2026-01-09 20:22:10
2531 2740 1 667 12532 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-09 21:44:20
2532 2741 2 667 12532 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-09 21:44:20
2533 2742 1 668 12517 20 Premium Berry Juice 1000ml NULL 2936900 3 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 10497.0 0.0 7800.0 0.0 0.0 0.0 0.0 5.0 371.43 7428.57 371.43 7800.0 INR 2 6.0 445.71 2026-01-09 21:49:36
2534 2743 1 669 12529 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-09 22:19:46
2535 2744 2 669 12529 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-09 22:19:46
2536 2745 3 669 12529 3 BP Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-09 22:19:46
2537 2746 4 669 12529 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-09 22:19:46
2538 2747 5 669 12529 38 Dish Wash 500ml NULL 3924101 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-01-09 22:19:46
2539 2748 6 669 12529 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-09 22:19:46
2540 2749 7 669 12529 37 Floor Cleaner 500ml NULL 3924101 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-01-09 22:19:46
2541 2750 8 669 12529 33 Herbal Soap 100gm NULL 30049011 3 0.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 0.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 228.57 11.43 240.0 INR 3 2.0 4.57 2026-01-09 22:19:46
2542 2751 9 669 12529 34 Herbo2o Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-01-09 22:19:46
2543 2752 10 669 12529 15 KIDNEY CARE JUICE NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-09 22:19:46
2544 2753 11 669 12529 16 Liver Care Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-09 22:19:46
2545 2754 12 669 12529 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-09 22:19:46
2546 2755 13 669 12529 7 Morning Fresh Churan NULL 30049011 4 0.0 199.0 0.0 0.0 159.0 151.43 7.57 796.0 0.0 636.0 2.5 15.14 2.5 15.14 0.0 0.0 605.71 30.29 636.0 INR 3 2.0 12.11 2026-01-09 22:19:46
2547 2756 14 669 12529 32 Neem Soap 100gm NULL 34011110 85 0.0 60.0 0.0 0.0 48.0 45.71 2.29 5100.0 0.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.72 194.29 4080.0 INR 3 2.0 77.71 2026-01-09 22:19:46
2548 2757 15 669 12529 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-09 22:19:46
2549 2758 16 669 12529 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-09 22:19:46
2550 2759 17 669 12529 5 Thyro Care NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-09 22:19:46