fx_franchise_order_product

4,737 rows · 33 columns · page 50 / 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
2451 2660 9 637 12552 9 Omega 369 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-08 22:47:06
2452 2661 10 637 12552 8 Piles Care NULL 30049011 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-08 22:47:06
2453 2662 11 637 12552 41 Premium Coco Body Lotion NULL 3304300 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-08 22:47:06
2454 2663 12 637 12552 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 4.5 46.16 4.5 46.16 0.0 0.0 1025.69 92.31 1118.0 INR 3 2.0 20.51 2026-01-08 22:47:06
2455 2664 13 637 12552 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-08 22:47:06
2456 2665 14 637 12552 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-08 22:47:06
2457 2666 1 638 12534 6 Asthma Care NULL 30049011 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 10:29:26
2458 2667 2 638 12534 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 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-09 10:29:26
2459 2668 3 638 12534 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 10:29:26
2460 2669 4 638 12534 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-01-09 10:29:26
2461 2670 5 638 12534 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 10:29:26
2462 2671 6 638 12534 33 Herbal Soap 100gm NULL 30049011 70 0.0 100.0 0.0 0.0 80.0 76.19 3.81 7000.0 0.0 5600.0 2.5 133.33 2.5 133.33 0.0 0.0 5333.34 266.67 5600.0 INR 3 2.0 106.67 2026-01-09 10:29:26
2463 2672 7 638 12534 34 Herbo2o Toothpaste NULL 33061090 27 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5373.0 0.0 4293.0 9.0 327.43 9.0 327.43 0.0 0.0 3638.14 654.86 4293.0 INR 3 2.0 72.76 2026-01-09 10:29:26
2464 2673 8 638 12534 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-09 10:29:26
2465 2674 9 638 12534 32 Neem Soap 100gm NULL 34011110 66 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3960.0 0.0 3168.0 2.5 75.43 2.5 75.43 0.0 0.0 3017.14 150.86 3168.0 INR 3 2.0 60.34 2026-01-09 10:29:26
2466 2675 10 638 12534 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-01-09 10:29:26
2467 2676 1 639 12517 60 Foot patch NULL 30051090 50 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 99950.0 0.0 79950.0 0.0 0.0 0.0 0.0 5.0 3807.14 76142.85 3807.14 79950.0 INR 2 6.0 4568.57 2026-01-09 12:50:03
2468 2677 2 639 12517 72 Pain Relief Patch NULL 30051090 50 0.0 800.0 0.0 0.0 600.0 571.43 28.57 40000.0 0.0 30000.0 0.0 0.0 0.0 0.0 5.0 1428.57 28571.43 1428.57 30000.0 INR 2 6.0 1714.29 2026-01-09 12:50:03
2469 2678 3 639 12517 43 Quench Kiss Lip Balm NULL 3304300 40 0.0 199.0 0.0 0.0 159.0 134.75 24.25 7960.0 0.0 6360.0 0.0 0.0 0.0 0.0 18.0 970.17 5389.83 970.17 6360.0 INR 2 6.0 323.39 2026-01-09 12:50:03
2470 2679 4 639 12517 46 Root Vitality Hair Oil NULL 3305901 150 0.0 255.0 0.0 0.0 204.0 194.29 9.71 38250.0 0.0 30600.0 0.0 0.0 0.0 0.0 5.0 1457.14 29142.85 1457.14 30600.0 INR 2 6.0 1748.57 2026-01-09 12:50:03
2471 2680 5 639 12517 1 Stem Cell Powder NULL 2936900 50 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 124950.0 0.0 99950.0 0.0 0.0 0.0 0.0 5.0 4759.52 95190.48 4759.52 99950.0 INR 2 6.0 5711.43 2026-01-09 12:50:03
2472 2681 6 639 12517 5 Thyro Care NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 0.0 0.0 0.0 0.0 5.0 1714.29 34285.71 1714.29 36000.0 INR 2 6.0 2057.14 2026-01-09 12:50:03
2473 2682 1 640 12516 43 Quench Kiss Lip Balm NULL 3304300 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 9.0 363.81 9.0 363.81 0.0 0.0 4042.37 727.63 4770.0 INR 1 8.0 323.39 2026-01-09 12:51:17
2474 2683 1 641 12516 46 Root Vitality Hair Oil NULL 3305901 150 0.0 255.0 0.0 0.0 204.0 194.29 9.71 38250.0 0.0 30600.0 2.5 728.57 2.5 728.57 0.0 0.0 29142.85 1457.14 30600.0 INR 1 8.0 2331.43 2026-01-09 12:53:46
2475 2684 1 642 12538 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 13:07:00
2476 2685 1 643 14079 33 Herbal Soap 100gm NULL 30049011 13 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1300.0 0.0 1040.0 2.5 24.76 2.5 24.76 0.0 0.0 990.48 49.52 1040.0 INR 3 2.0 19.81 2026-01-09 13:57:25
2477 2686 2 643 14079 30 Iron Capsules NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-01-09 13:57:25
2478 2687 3 643 14079 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-09 13:57:25
2479 2688 4 643 14079 26 Spirulina Cap NULL 2009899 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-01-09 13:57:25
2480 2689 5 643 14079 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 13:57:25
2481 2690 1 644 12555 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 9.0 76.27 9.0 76.27 0.0 0.0 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-09 15:42:18
2482 2691 1 645 12532 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 0.0 0.0 0.0 0.0 18.0 140.34 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-09 15:54:54
2483 2692 2 645 12532 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 0.0 0.0 0.0 0.0 18.0 242.54 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-09 15:54:54
2484 2693 3 645 12532 33 Herbal Soap 100gm NULL 30049011 200 0.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 0.0 16000.0 0.0 0.0 0.0 0.0 5.0 761.9 15238.1 761.9 16000.0 INR 3 2.0 304.76 2026-01-09 15:54:54
2485 2694 4 645 12532 34 Herbo2o Toothpaste NULL 33061090 24 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4776.0 0.0 3816.0 0.0 0.0 0.0 0.0 18.0 582.1 3233.9 582.1 3816.0 INR 3 2.0 64.68 2026-01-09 15:54:54
2486 2695 5 645 12532 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 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 15:54:54
2487 2696 6 645 12532 7 Morning Fresh Churan NULL 30049011 24 0.0 199.0 0.0 0.0 159.0 151.43 7.57 4776.0 0.0 3816.0 0.0 0.0 0.0 0.0 5.0 181.71 3634.29 181.71 3816.0 INR 3 2.0 72.69 2026-01-09 15:54:54
2488 2697 7 645 12532 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 0.0 0.0 0.0 0.0 5.0 685.71 13714.29 685.71 14400.0 INR 3 2.0 274.29 2026-01-09 15:54:54
2489 2698 8 645 12532 36 Toilet Cleaner 500ml NULL 3924101 24 0.0 150.0 0.0 0.0 120.0 101.69 18.31 3600.0 0.0 2880.0 0.0 0.0 0.0 0.0 18.0 439.32 2440.68 439.32 2880.0 INR 3 2.0 48.81 2026-01-09 15:54:54
2490 2699 1 646 12554 7 Morning Fresh Churan NULL 30049011 15 0.0 199.0 0.0 0.0 159.0 151.43 7.57 2985.0 0.0 2385.0 2.5 56.79 2.5 56.79 0.0 0.0 2271.43 113.57 2385.0 INR 2 6.0 136.29 2026-01-09 15:57:37
2491 2700 2 646 12554 72 Pain Relief Patch NULL 30051090 10 0.0 800.0 0.0 0.0 600.0 571.43 28.57 8000.0 0.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-01-09 15:57:37
2492 2701 1 647 12532 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 0.0 0.0 0.0 0.0 5.0 28.57 571.43 28.57 600.0 INR 3 2.0 11.43 2026-01-09 16:43:26
2493 2702 2 647 12532 47 Premium Hair Care Shampoo NULL 3305109 9 0.0 699.0 0.0 0.0 559.0 532.38 26.62 6291.0 0.0 5031.0 0.0 0.0 0.0 0.0 5.0 239.57 4791.43 239.57 5031.0 INR 3 2.0 95.83 2026-01-09 16:43:26
2494 2703 1 648 12532 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 9.0 755.08 9.0 755.08 0.0 0.0 8389.83 1510.17 9900.0 INR 3 0.0 150.0 2026-01-09 16:49:21
2495 2704 1 649 12554 61 Radiation chip NULL 902221 20 0.0 999.0 0.0 0.0 500.0 423.73 76.27 19980.0 0.0 10000.0 9.0 762.71 9.0 762.71 0.0 0.0 8474.58 1525.42 10000.0 INR 2 6.0 508.47 2026-01-09 17:05:58
2496 2705 1 650 12555 61 Radiation chip NULL 902221 10 0.0 999.0 0.0 0.0 500.0 423.73 76.27 9990.0 0.0 5000.0 9.0 381.36 9.0 381.36 0.0 0.0 4237.29 762.71 5000.0 INR 3 2.0 84.75 2026-01-09 17:06:41
2497 2706 1 651 12532 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 1.5 29.13 1.5 29.13 0.0 0.0 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-09 17:11:05
2498 2707 1 652 12554 84 B AND B NULL 94041000 10 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 129990.0 0.0 105000.0 2.5 2500.0 2.5 2500.0 0.0 0.0 100000.0 5000.0 105000.0 INR 2 0.0 300.0 2026-01-09 17:14:33
2499 2708 1 653 12516 84 B AND B NULL 94041000 10 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 129990.0 0.0 105000.0 2.5 2500.0 2.5 2500.0 0.0 0.0 100000.0 5000.0 105000.0 INR 1 0.0 400.0 2026-01-09 17:15:00
2500 2709 1 654 13536 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 17:15:51