fx_franchise_order_product

4,737 rows · 33 columns · page 59 / 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
2901 3110 5 756 13836 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-16 15:34:09
2902 3111 6 756 13836 32 Neem Soap 100gm NULL 34011110 120 0.0 60.0 0.0 0.0 48.0 45.71 2.29 7200.0 0.0 5760.0 2.5 137.14 2.5 137.14 0.0 0.0 5485.72 274.29 5760.0 INR 3 2.0 109.71 2026-01-16 15:34:09
2903 3112 7 756 13836 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 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-16 15:34:09
2904 3113 8 756 13836 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-16 15:34:09
2905 3114 9 756 13836 36 Toilet Cleaner 500ml NULL 3924101 6 0.0 150.0 0.0 0.0 120.0 101.69 18.31 900.0 0.0 720.0 9.0 54.92 9.0 54.92 0.0 0.0 610.17 109.83 720.0 INR 3 2.0 12.2 2026-01-16 15:34:09
2906 3115 1 757 12517 48 glow face wash NULL 3304999 20 0.0 380.0 0.0 0.0 304.0 257.63 46.37 7600.0 0.0 6080.0 0.0 0.0 0.0 0.0 18.0 927.46 5152.54 927.46 6080.0 INR 2 6.0 309.15 2026-01-16 15:53:49
2907 3116 1 758 12532 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-16 19:12:03
2908 3117 1 759 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-16 20:36:12
2909 3118 1 760 12552 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-16 20:46:34
2910 3119 2 760 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-16 20:46:34
2911 3120 3 760 12552 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-16 20:46:34
2912 3121 4 760 12552 33 Herbal Soap 100gm NULL 30049011 2 0.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 0.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 3 2.0 3.05 2026-01-16 20:46:34
2913 3122 5 760 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-16 20:46:34
2914 3123 6 760 12552 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-01-16 20:46:34
2915 3124 7 760 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-16 20:46:34
2916 3125 8 760 12552 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-16 20:46:34
2917 3126 9 760 12552 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-16 20:46:34
2918 3127 10 760 12552 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 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-16 20:46:34
2919 3128 11 760 12552 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-01-16 20:46:34
2920 3129 12 760 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-16 20:46:34
2921 3130 1 761 12533 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-16 20:47:38
2922 3131 2 761 12533 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 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-01-16 20:47:38
2923 3132 3 761 12533 34 Herbo2o Toothpaste NULL 33061090 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-16 20:47:38
2924 3133 4 761 12533 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 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-16 20:47:38
2925 3134 5 761 12533 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-01-16 20:47:38
2926 3135 1 762 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-16 20:57:23
2927 3136 1 763 13536 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-16 21:01:38
2928 3137 2 763 13536 61 Radiation chip NULL 902221 1 0.0 999.0 0.0 0.0 500.0 423.73 76.27 999.0 0.0 500.0 9.0 38.14 9.0 38.14 0.0 0.0 423.73 76.27 500.0 INR 3 2.0 8.47 2026-01-16 21:01:38
2929 3138 3 763 13536 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-16 21:01:38
2930 3139 4 763 13536 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 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-01-16 21:01:38
2931 3140 5 763 13536 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-16 21:01:38
2932 3141 6 763 13536 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-16 21:01:38
2933 3142 7 763 13536 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-16 21:01:38
2934 3143 8 763 13536 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-16 21:01:38
2935 3144 1 764 12554 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 2 0.0 300.0 2026-01-16 21:02:57
2936 3145 1 765 13438 61 Radiation chip NULL 902221 4 0.0 999.0 0.0 0.0 500.0 423.73 76.27 3996.0 0.0 2000.0 9.0 152.54 9.0 152.54 0.0 0.0 1694.92 305.08 2000.0 INR 3 2.0 33.9 2026-01-16 21:03:04
2937 3146 2 765 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-16 21:03:04
2938 3147 3 765 13438 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-16 21:03:04
2939 3148 4 765 13438 38 Dish Wash 500ml NULL 3924101 10 0.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 0.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 1559.32 280.68 1840.0 INR 3 2.0 31.19 2026-01-16 21:03:04
2940 3149 5 765 13438 16 Liver Care Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-16 21:03:04
2941 3150 6 765 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 21:03:04
2942 3151 7 765 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 21:03:04
2943 3152 1 766 12517 61 Radiation chip NULL 902221 6 0.0 999.0 0.0 0.0 500.0 423.73 76.27 5994.0 0.0 3000.0 0.0 0.0 0.0 0.0 18.0 457.63 2542.37 457.63 3000.0 INR 2 6.0 152.54 2026-01-16 21:05:25
2944 3153 1 767 13438 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-16 21:15:42
2945 3154 1 768 13438 34 Herbo2o Toothpaste NULL 33061090 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-01-16 21:18:50
2946 3155 1 769 12529 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-16 21:30:39
2947 3156 1 770 12529 32 Neem Soap 100gm NULL 34011110 21 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1260.0 0.0 1008.0 2.5 24.0 2.5 24.0 0.0 0.0 960.0 48.0 1008.0 INR 3 2.0 19.2 2026-01-16 21:32:28
2948 3157 1 771 12529 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-16 21:33:03
2949 3158 1 772 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-16 21:38:49
2950 3159 1 773 12517 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 2 0.0 300.0 2026-01-16 21:40:20