fx_franchise_order_product

4,737 rows · 33 columns · page 60 / 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
2951 3160 1 774 13438 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-16 21:45:16
2952 3161 1 775 13438 33 Herbal Soap 100gm NULL 30049011 20 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 0.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-01-16 21:46:46
2953 3162 1 776 12546 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-01-16 22:27:40
2954 3163 2 776 12546 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 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-16 22:27:40
2955 3164 3 776 12546 24 Immunomax 24/7 Caps NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-16 22:27:40
2956 3165 4 776 12546 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-16 22:27:40
2957 3166 5 776 12546 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-16 22:27:40
2958 3167 6 776 12546 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 22:27:40
2959 3168 7 776 12546 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-16 22:27:40
2960 3169 1 777 12546 32 Neem Soap 100gm NULL 34011110 84 0.0 60.0 0.0 0.0 48.0 45.71 2.29 5040.0 0.0 4032.0 2.5 96.0 2.5 96.0 0.0 0.0 3840.0 192.0 4032.0 INR 3 2.0 76.8 2026-01-16 22:42:08
2961 3170 1 778 12516 84 B AND B NULL 94041000 6 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 77994.0 0.0 63000.0 2.5 1500.0 2.5 1500.0 0.0 0.0 60000.0 3000.0 63000.0 INR 1 0.0 400.0 2026-01-16 23:00:58
2962 3171 1 779 12517 20 Premium Berry Juice 1000ml NULL 2936900 5 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 17495.0 0.0 13000.0 0.0 0.0 0.0 0.0 5.0 619.05 12380.95 619.05 13000.0 INR 2 6.0 742.86 2026-01-16 23:02:35
2963 3172 2 779 12517 84 B AND B NULL 94041000 4 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 51996.0 0.0 42000.0 0.0 0.0 0.0 0.0 5.0 2000.0 40000.0 2000.0 42000.0 INR 2 0.0 300.0 2026-01-16 23:02:35
2964 3173 1 780 13438 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 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-16 23:08:15
2965 3174 1 781 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 23:10:15
2966 3175 1 782 13536 33 Herbal Soap 100gm NULL 30049011 6 0.0 100.0 0.0 0.0 80.0 76.19 3.81 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 23:24:06
2967 3176 2 782 13536 32 Neem Soap 100gm NULL 34011110 7 0.0 60.0 0.0 0.0 48.0 45.71 2.29 420.0 0.0 336.0 2.5 8.0 2.5 8.0 0.0 0.0 320.0 16.0 336.0 INR 3 2.0 6.4 2026-01-16 23:24:06
2968 3177 3 782 13536 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 23:24:06
2969 3178 1 783 13536 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-16 23:26:14
2970 3179 1 784 13536 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-16 23:30:01
2971 3180 1 785 12516 20 Premium Berry Juice 1000ml NULL 2936900 50 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 174950.0 0.0 130000.0 2.5 3095.24 2.5 3095.24 0.0 0.0 123809.52 6190.48 130000.0 INR 1 8.0 9904.76 2026-01-19 12:28:56
2972 3181 1 786 12516 19 Fat loss Juice 500 ml NULL 30049011 30 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 44970.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 34285.71 1714.29 36000.0 INR 1 8.0 2742.86 2026-01-19 12:31:58
2973 3182 1 787 12517 27 Multicharge Cap NULL 2009899 15 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 22485.0 0.0 18000.0 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 2 6.0 1028.57 2026-01-19 12:38:48
2974 3183 2 787 12517 20 Premium Berry Juice 1000ml NULL 2936900 15 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 52485.0 0.0 39000.0 0.0 0.0 0.0 0.0 5.0 1857.14 37142.86 1857.14 39000.0 INR 2 6.0 2228.57 2026-01-19 12:38:48
2975 3184 3 787 12517 19 Fat loss Juice 500 ml NULL 30049011 15 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 22485.0 0.0 18000.0 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 2 6.0 1028.57 2026-01-19 12:38:48
2976 3185 4 787 12517 26 Spirulina Cap NULL 2009899 15 0.0 899.0 0.0 0.0 719.0 684.76 34.24 13485.0 0.0 10785.0 0.0 0.0 0.0 0.0 5.0 513.57 10271.43 513.57 10785.0 INR 2 6.0 616.29 2026-01-19 12:38:48
2977 3186 1 788 12516 44 Vital Glow Face Scrub NULL 3304300 20 0.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 0.0 5200.0 9.0 396.61 9.0 396.61 0.0 0.0 4406.78 793.22 5200.0 INR 1 8.0 352.54 2026-01-19 14:51:47
2978 3187 1 789 12517 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 0.0 0.0 0.0 0.0 18.0 594.92 3305.09 594.92 3900.0 INR 2 6.0 198.31 2026-01-19 14:54:13
2979 3188 1 790 12529 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-19 14:57:39
2980 3189 1 791 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-19 15:00:04
2981 3190 2 791 12529 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-19 15:00:04
2982 3191 1 792 12528 39 Fabric Wash 1000ml NULL 3924101 6 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2406.0 0.0 1926.0 9.0 146.9 9.0 146.9 0.0 0.0 1632.2 293.8 1926.0 INR 3 2.0 32.64 2026-01-19 15:15:09
2983 3192 2 792 12528 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-19 15:15:09
2984 3193 3 792 12528 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-19 15:15:09
2985 3194 4 792 12528 30 Iron Capsules NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-19 15:15:09
2986 3195 5 792 12528 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-19 15:15:09
2987 3196 6 792 12528 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-19 15:15:09
2988 3197 7 792 12528 9 Omega 369 NULL 2936900 4 0.0 999.0 0.0 0.0 720.0 685.71 34.29 3996.0 0.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-01-19 15:15:09
2989 3198 8 792 12528 81 PREMIUM GLOW FACE WASH NULL 3404 4 0.0 699.0 0.0 0.0 559.0 512.84 46.16 2796.0 0.0 2236.0 4.5 92.31 4.5 92.31 0.0 0.0 2051.38 184.62 2236.0 INR 3 2.0 41.03 2026-01-19 15:15:09
2990 3199 9 792 12528 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-19 15:15:09
2991 3200 10 792 12528 44 Vital Glow Face Scrub NULL 3304300 4 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 0.0 1040.0 9.0 79.32 9.0 79.32 0.0 0.0 881.36 158.64 1040.0 INR 3 2.0 17.63 2026-01-19 15:15:09
2992 3201 1 793 12543 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-19 19:13:18
2993 3202 2 793 12543 17 Memory Booster 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-19 19:13:18
2994 3203 1 794 12549 48 glow face wash NULL 3304999 3 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 0.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 772.88 139.12 912.0 INR 3 2.0 15.46 2026-01-19 19:58:07
2995 3204 2 794 12549 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-19 19:58:07
2996 3205 3 794 12549 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-19 19:58:07
2997 3206 4 794 12549 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 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-19 19:58:07
2998 3207 5 794 12549 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-19 19:58:07
2999 3208 6 794 12549 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-19 19:58:07
3000 3209 7 794 12549 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-19 19:58:07