fx_franchise_order_product

4,737 rows · 33 columns · page 57 / 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
2801 3010 1 725 12517 44 Vital Glow Face Scrub NULL 3304300 13 0.0 325.0 0.0 0.0 260.0 220.34 39.66 4225.0 0.0 3380.0 0.0 0.0 0.0 0.0 18.0 515.59 2864.41 515.59 3380.0 INR 2 6.0 171.86 2026-01-14 16:37:48
2802 3011 1 726 12521 7 Morning Fresh Churan NULL 30049011 1 0.0 199.0 0.0 0.0 159.0 151.43 7.57 199.0 0.0 159.0 2.5 3.79 2.5 3.79 0.0 0.0 151.43 7.57 159.0 INR 3 2.0 3.03 2026-01-14 16:41:06
2803 3012 2 726 12521 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-14 16:41:06
2804 3013 3 726 12521 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-14 16:41:06
2805 3014 1 727 14323 44 Vital Glow Face Scrub NULL 3304300 15 0.0 325.0 0.0 0.0 260.0 220.34 39.66 4875.0 0.0 3900.0 9.0 297.46 9.0 297.46 0.0 0.0 3305.09 594.92 3900.0 INR 3 2.0 66.1 2026-01-14 16:42:28
2806 3015 1 728 12516 44 Vital Glow Face Scrub NULL 3304300 10 0.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 0.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 2203.39 396.61 2600.0 INR 1 8.0 176.27 2026-01-14 17:13:08
2807 3016 1 729 12517 44 Vital Glow Face Scrub NULL 3304300 10 0.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 0.0 2600.0 0.0 0.0 0.0 0.0 18.0 396.61 2203.39 396.61 2600.0 INR 2 6.0 132.2 2026-01-14 17:14:36
2808 3017 1 730 14079 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-14 21:27:07
2809 3018 1 731 13438 32 Neem Soap 100gm NULL 34011110 25 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1500.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-15 09:56:02
2810 3019 1 732 13438 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-15 10:03:25
2811 3020 1 733 13438 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-15 10:05:10
2812 3021 1 734 13438 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-15 10:07:31
2813 3022 1 735 13438 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-15 10:08:44
2814 3023 1 736 13438 39 Fabric Wash 1000ml NULL 3924101 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-15 10:10:34
2815 3024 1 737 14032 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-15 13:01:40
2816 3025 2 737 14032 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-15 13:01:40
2817 3026 3 737 14032 37 Floor Cleaner 500ml NULL 3924101 7 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1393.0 0.0 1113.0 9.0 84.89 9.0 84.89 0.0 0.0 943.22 169.78 1113.0 INR 3 2.0 18.86 2026-01-15 13:01:40
2818 3027 4 737 14032 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-15 13:01:40
2819 3028 5 737 14032 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 4.5 23.08 4.5 23.08 0.0 0.0 512.84 46.16 559.0 INR 3 2.0 10.26 2026-01-15 13:01:40
2820 3029 6 737 14032 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-15 13:01:40
2821 3030 7 737 14032 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-15 13:01:40
2822 3031 1 738 14428 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-15 13:05:03
2823 3032 2 738 14428 33 Herbal Soap 100gm NULL 30049011 10 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 0.0 800.0 0.0 0.0 0.0 0.0 5.0 38.1 761.9 38.1 800.0 INR 3 2.0 15.24 2026-01-15 13:05:03
2824 3033 3 738 14428 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-15 13:05:03
2825 3034 4 738 14428 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 0.0 0.0 0.0 0.0 5.0 114.29 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-15 13:05:03
2826 3035 5 738 14428 32 Neem Soap 100gm NULL 34011110 20 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 0.0 960.0 0.0 0.0 0.0 0.0 5.0 45.71 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-15 13:05:03
2827 3036 6 738 14428 12 P RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 0.0 0.0 0.0 0.0 5.0 35.71 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-15 13:05:03
2828 3037 1 739 12517 18 Lady Care Juice 500ml NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 0.0 0.0 0.0 0.0 5.0 571.43 11428.57 571.43 12000.0 INR 2 6.0 685.71 2026-01-15 13:08:41
2829 3038 1 740 12552 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-15 14:11:52
2830 3039 2 740 12552 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-15 14:11:52
2831 3040 3 740 12552 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-15 14:11:52
2832 3041 4 740 12552 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-15 14:11:52
2833 3042 5 740 12552 7 Morning Fresh Churan NULL 30049011 1 0.0 199.0 0.0 0.0 159.0 151.43 7.57 199.0 0.0 159.0 2.5 3.79 2.5 3.79 0.0 0.0 151.43 7.57 159.0 INR 3 2.0 3.03 2026-01-15 14:11:52
2834 3043 6 740 12552 36 Toilet Cleaner 500ml NULL 3924101 1 0.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 0.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.3 120.0 INR 3 2.0 2.03 2026-01-15 14:11:52
2835 3044 1 741 13438 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-15 15:05:23
2836 3045 1 742 13438 37 Floor Cleaner 500ml NULL 3924101 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-15 15:06:01
2837 3046 1 743 12546 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-15 20:23:10
2838 3047 2 743 12546 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-15 20:23:10
2839 3048 1 744 12517 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 0.0 0.0 0.0 0.0 5.0 297.62 5952.38 297.62 6250.0 INR 2 6.0 357.14 2026-01-15 20:51:21
2840 3049 2 744 12517 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 0.0 0.0 0.0 0.0 5.0 273.81 5476.19 273.81 5750.0 INR 2 6.0 328.57 2026-01-15 20:51:21
2841 3050 1 745 12529 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-15 20:59:59
2842 3051 1 746 12543 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-15 22:30:14
2843 3052 2 746 12543 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-15 22:30:14
2844 3053 3 746 12543 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-15 22:30:14
2845 3054 4 746 12543 28 Ortho Joint Shield NULL 2009899 4 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 5996.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-15 22:30:14
2846 3055 5 746 12543 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-15 22:30:14
2847 3056 1 747 13438 32 Neem Soap 100gm NULL 34011110 30 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1800.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-16 11:22:56
2848 3057 1 748 13438 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-16 11:33:52
2849 3058 2 748 13438 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-16 11:33:52
2850 3059 1 749 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 9.0 139.12 9.0 139.12 0.0 0.0 1545.76 278.24 1824.0 INR 3 2.0 30.92 2026-01-16 12:14:48