fx_franchise_order_product

4,737 rows · 33 columns · page 54 / 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
2651 2860 1 701 12545 39 Fabric Wash 1000ml NULL 3924101 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-01-12 15:47:18
2652 2861 2 701 12545 34 Herbo2o Toothpaste NULL 33061090 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-12 15:47:18
2653 2862 3 701 12545 7 Morning Fresh Churan NULL 30049011 3 0.0 199.0 0.0 0.0 159.0 151.43 7.57 597.0 0.0 477.0 2.5 11.36 2.5 11.36 0.0 0.0 454.29 22.71 477.0 INR 3 2.0 9.09 2026-01-12 15:47:18
2654 2863 4 701 12545 32 Neem Soap 100gm NULL 34011110 33 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1980.0 0.0 1584.0 2.5 37.71 2.5 37.71 0.0 0.0 1508.57 75.43 1584.0 INR 3 2.0 30.17 2026-01-12 15:47:18
2655 2864 5 701 12545 43 Quench Kiss Lip Balm NULL 3304300 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-12 15:47:18
2656 2865 1 702 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-12 16:49:12
2657 2866 1 703 12532 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-12 17:02:39
2658 2867 2 703 12532 82 ALKALINE CAPSULE NULL 3402000 3 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 7500.0 0.0 6000.0 1.5 87.38 1.5 87.38 0.0 0.0 5825.24 174.76 6000.0 INR 3 2.0 116.5 2026-01-12 17:02:39
2659 2868 3 703 12532 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-01-12 17:02:39
2660 2869 4 703 12532 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 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-12 17:02:39
2661 2870 5 703 12532 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-12 17:02:39
2662 2871 6 703 12532 38 Dish Wash 500ml NULL 3924101 6 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1380.0 0.0 1104.0 9.0 84.2 9.0 84.2 0.0 0.0 935.59 168.41 1104.0 INR 3 2.0 18.71 2026-01-12 17:02:39
2663 2872 7 703 12532 58 Green shield 250ml NULL 3105 1 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 0.0 1850.0 2.5 44.05 2.5 44.05 0.0 0.0 1761.9 88.1 1850.0 INR 3 2.0 35.24 2026-01-12 17:02:39
2664 2873 8 703 12532 55 Grow master 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 0.0 0.0 2026-01-12 17:02:39
2665 2874 9 703 12532 2 Heart Care Capsules NULL 2936900 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-12 17:02:39
2666 2875 10 703 12532 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-12 17:02:39
2667 2876 11 703 12532 18 Lady Care Juice 500ml 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-12 17:02:39
2668 2877 12 703 12532 25 Manicalcium Tablets NULL 2009899 2 0.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 0.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 607.62 30.38 638.0 INR 3 2.0 12.15 2026-01-12 17:02:39
2669 2878 13 703 12532 56 Micro magic 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-01-12 17:02:39
2670 2879 14 703 12532 9 Omega 369 NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-01-12 17:02:39
2671 2880 15 703 12532 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 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-12 17:02:39
2672 2881 16 703 12532 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-12 17:02:39
2673 2882 17 703 12532 46 Root Vitality Hair Oil NULL 3305901 12 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 0.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-01-12 17:02:39
2674 2883 18 703 12532 57 Safe guard 250ml NULL 3105 1 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 0.0 1850.0 2.5 44.05 2.5 44.05 0.0 0.0 1761.9 88.1 1850.0 INR 3 2.0 35.24 2026-01-12 17:02:39
2675 2884 19 703 12532 26 Spirulina Cap NULL 2009899 5 0.0 899.0 0.0 0.0 719.0 684.76 34.24 4495.0 0.0 3595.0 2.5 85.6 2.5 85.6 0.0 0.0 3423.81 171.19 3595.0 INR 3 2.0 68.48 2026-01-12 17:02:39
2676 2885 20 703 12532 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 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-12 17:02:39
2677 2886 21 703 12532 53 Terra care 2 kg NULL 3103100 3 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 0.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-01-12 17:02:39
2678 2887 22 703 12532 5 Thyro Care 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-12 17:02:39
2679 2888 23 703 12532 54 Wonder grow 100ml NULL 3105 1 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.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-12 17:02:39
2680 2889 1 704 12517 4 Diabetic Care Capsules NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 6857.14 342.86 7200.0 INR 2 6.0 411.43 2026-01-12 17:34:41
2681 2890 2 704 12517 30 Iron Capsules NULL 30049011 10 0.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 0.0 7190.0 0.0 0.0 0.0 0.0 5.0 342.38 6847.62 342.38 7190.0 INR 2 6.0 410.86 2026-01-12 17:34:41
2682 2891 3 704 12517 26 Spirulina Cap NULL 2009899 10 0.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 0.0 7190.0 0.0 0.0 0.0 0.0 5.0 342.38 6847.62 342.38 7190.0 INR 2 6.0 410.86 2026-01-12 17:34:41
2683 2892 1 705 13836 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-12 23:07:20
2684 2893 2 705 13836 37 Floor Cleaner 500ml NULL 3924101 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-12 23:07:20
2685 2894 3 705 13836 34 Herbo2o Toothpaste NULL 33061090 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-12 23:07:20
2686 2895 4 705 13836 32 Neem Soap 100gm NULL 34011110 6 0.0 60.0 0.0 0.0 48.0 45.71 2.29 360.0 0.0 288.0 2.5 6.86 2.5 6.86 0.0 0.0 274.29 13.71 288.0 INR 3 2.0 5.49 2026-01-12 23:07:20
2687 2896 5 705 13836 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-12 23:07:20
2688 2897 1 706 12526 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 9.0 115.93 9.0 115.93 0.0 0.0 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-12 23:20:20
2689 2898 2 706 12526 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-12 23:20:20
2690 2899 3 706 12526 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-12 23:20:20
2691 2900 4 706 12526 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-12 23:20:20
2692 2901 5 706 12526 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-01-12 23:20:20
2693 2902 6 706 12526 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-01-12 23:20:20
2694 2903 7 706 12526 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-12 23:20:20
2695 2904 8 706 12526 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.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-12 23:20:20
2696 2905 9 706 12526 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-01-12 23:20:20
2697 2906 10 706 12526 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 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-12 23:20:20
2698 2907 11 706 12526 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 2 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 2848.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-12 23:20:20
2699 2908 12 706 12526 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 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-01-12 23:20:20
2700 2909 1 707 12542 48 glow face wash NULL 3304999 12 0.0 380.0 0.0 0.0 304.0 257.63 46.37 4560.0 0.0 3648.0 0.0 0.0 0.0 0.0 18.0 556.47 3091.53 556.47 3648.0 INR 3 2.0 61.83 2026-01-13 11:00:12