fx_franchise_order_product

4,737 rows · 33 columns · page 61 / 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
3001 3210 8 794 12549 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-19 19:58:07
3002 3211 9 794 12549 11 SOUNDARYA VEDA BRINGARAJ & SHIKAKAI NULL 33051090 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-19 19:58:07
3003 3212 10 794 12549 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-19 19:58:07
3004 3213 11 794 12549 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-19 19:58:07
3005 3214 12 794 12549 44 Vital Glow Face Scrub NULL 3304300 2 0.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 0.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 440.68 79.32 520.0 INR 3 2.0 8.81 2026-01-19 19:58:07
3006 3215 1 795 13536 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-20 13:18:44
3007 3216 1 796 12855 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 3 2.0 154.95 2026-01-20 13:38:02
3008 3217 1 797 12551 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 2 6.0 464.85 2026-01-20 13:56:00
3009 3218 2 797 12551 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 2 6.0 34.29 2026-01-20 13:56:00
3010 3219 3 797 12551 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 2 6.0 34.97 2026-01-20 13:56:00
3011 3220 1 798 12551 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 2 6.0 464.85 2026-01-20 14:20:30
3012 3221 2 798 12551 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 2 6.0 91.37 2026-01-20 14:20:30
3013 3222 3 798 12551 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 2 6.0 34.29 2026-01-20 14:20:30
3014 3223 4 798 12551 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 2 6.0 34.97 2026-01-20 14:20:30
3015 3224 1 799 12855 60 Foot patch NULL 30051090 2 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 3998.0 0.0 3198.0 2.5 76.14 2.5 76.14 0.0 0.0 3045.71 152.29 3198.0 INR 3 2.0 60.91 2026-01-20 17:05:17
3016 3225 2 799 12855 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-20 17:05:17
3017 3226 1 800 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-20 17:52:52
3018 3227 1 801 12517 82 ALKALINE CAPSULE NULL 3402000 10 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 25000.0 0.0 20000.0 0.0 0.0 0.0 0.0 3.0 582.52 19417.48 582.52 20000.0 INR 2 6.0 1165.05 2026-01-21 15:02:00
3019 3228 1 802 14079 38 Dish Wash 500ml NULL 34029099 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-21 22:59:50
3020 3229 2 802 14079 39 Fabric Wash 1000ml NULL 34029099 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-21 22:59:50
3021 3230 3 802 14079 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-21 22:59:50
3022 3231 4 802 14079 33 Herbal Soap 100gm NULL 30049011 16 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1600.0 0.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 1219.05 60.95 1280.0 INR 3 2.0 24.38 2026-01-21 22:59:50
3023 3232 5 802 14079 34 Herbo2o Toothpaste NULL 33061090 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-21 22:59:50
3024 3233 6 802 14079 32 Neem Soap 100gm NULL 34011110 16 0.0 60.0 0.0 0.0 48.0 45.71 2.29 960.0 0.0 768.0 2.5 18.29 2.5 18.29 0.0 0.0 731.43 36.57 768.0 INR 3 2.0 14.63 2026-01-21 22:59:50
3025 3234 7 802 14079 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-21 22:59:50
3026 3235 8 802 14079 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-21 22:59:50
3027 3236 1 803 12855 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 1 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 21999.0 0.0 14999.0 1.5 218.43 1.5 218.43 0.0 0.0 14562.14 436.86 14999.0 INR 3 0.0 150.0 2026-01-23 13:25:41
3028 3237 1 804 12541 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-23 16:20:15
3029 3238 2 804 12541 38 Dish Wash 500ml NULL 34029099 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-23 16:20:15
3030 3239 3 804 12541 39 Fabric Wash 1000ml NULL 34029099 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-23 16:20:15
3031 3240 4 804 12541 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-23 16:20:15
3032 3241 5 804 12541 33 Herbal Soap 100gm NULL 30049011 5 0.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 0.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-01-23 16:20:15
3033 3242 6 804 12541 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-23 16:20:15
3034 3243 7 804 12541 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 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-23 16:20:15
3035 3244 8 804 12541 32 Neem Soap 100gm NULL 34011110 40 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2400.0 0.0 1920.0 2.5 45.71 2.5 45.71 0.0 0.0 1828.57 91.43 1920.0 INR 3 2.0 36.57 2026-01-23 16:20:15
3036 3245 9 804 12541 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-23 16:20:15
3037 3246 10 804 12541 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-23 16:20:15
3038 3247 11 804 12541 43 Quench Kiss Lip Balm NULL 3304300 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-23 16:20:15
3039 3248 12 804 12541 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-23 16:20:15
3040 3249 13 804 12541 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-23 16:20:15
3041 3250 14 804 12541 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-23 16:20:15
3042 3251 1 805 12541 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-23 16:22:51
3043 3252 2 805 12541 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-23 16:22:51
3044 3253 3 805 12541 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-23 16:22:51
3045 3254 1 806 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-23 16:33:47
3046 3255 2 806 12546 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-23 16:33:47
3047 3256 3 806 12546 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-23 16:33:47
3048 3257 4 806 12546 32 Neem Soap 100gm NULL 34011110 60 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3600.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-23 16:33:47
3049 3258 5 806 12546 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-23 16:33:47
3050 3259 6 806 12546 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-23 16:33:47