fx_franchise_order_product

4,933 rows · 33 columns · page 58 / 99

Invoice view 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
2851 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
2852 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
2853 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
2854 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
2855 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
2856 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
2857 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
2858 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
2859 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
2860 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
2861 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
2862 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
2863 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
2864 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
2865 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
2866 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
2867 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
2868 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
2869 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
2870 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
2871 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
2872 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
2873 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
2874 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
2875 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
2876 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
2877 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
2878 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
2879 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
2880 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
2881 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
2882 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
2883 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
2884 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
2885 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
2886 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
2887 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
2888 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
2889 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
2890 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
2891 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
2892 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
2893 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
2894 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
2895 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
2896 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
2897 2910 2 707 12542 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 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-13 11:00:12
2898 2911 3 707 12542 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 0.0 0.0 0.0 0.0 5.0 13.29 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-13 11:00:12
2899 2912 4 707 12542 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 0.0 0.0 0.0 0.0 5.0 13.29 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-13 11:00:12
2900 2913 5 707 12542 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 0.0 0.0 0.0 0.0 5.0 228.57 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-13 11:00:12