fx_franchise_order_product

4,737 rows · 33 columns · page 66 / 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
3251 3460 1 849 12554 3 BP 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 2 5.0 34.29 2026-01-27 20:52:56
3252 3461 1 850 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 10 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 16000.0 0.0 12500.0 2.5 297.62 2.5 297.62 0.0 0.0 11904.76 595.24 12500.0 INR 3 2.0 238.1 2026-01-28 13:25:47
3253 3462 1 851 12545 38 Dish Wash 500ml NULL 34029099 3 0.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 0.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-01-28 13:42:36
3254 3463 2 851 12545 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-28 13:42:36
3255 3464 3 851 12545 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-28 13:42:36
3256 3465 4 851 12545 43 Quench Kiss Lip Balm NULL 3304300 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-28 13:42:36
3257 3466 5 851 12545 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-28 13:42:36
3258 3467 6 851 12545 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-28 13:42:36
3259 3468 1 852 12534 48 glow face wash NULL 3304999 8 0.0 380.0 0.0 0.0 304.0 257.63 46.37 3040.0 0.0 2432.0 9.0 185.49 9.0 185.49 0.0 0.0 2061.02 370.98 2432.0 INR 3 2.0 41.22 2026-01-28 17:51:07
3260 3469 2 852 12534 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-28 17:51:07
3261 3470 3 852 12534 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-28 17:51:07
3262 3471 4 852 12534 15 KIDNEY 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 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-28 17:51:07
3263 3472 5 852 12534 16 Liver Care Juice NULL 2009899 3 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1047.0 0.0 837.0 2.5 19.93 2.5 19.93 0.0 0.0 797.14 39.86 837.0 INR 3 2.0 15.94 2026-01-28 17:51:07
3264 3473 6 852 12534 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-28 17:51:07
3265 3474 7 852 12534 28 Ortho Joint Shield 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-28 17:51:07
3266 3475 8 852 12534 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-28 17:51:07
3267 3476 9 852 12534 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-28 17:51:07
3268 3477 10 852 12534 47 Premium Hair Care Shampoo NULL 3305109 4 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2796.0 0.0 2236.0 2.5 53.24 2.5 53.24 0.0 0.0 2129.52 106.48 2236.0 INR 3 2.0 42.59 2026-01-28 17:51:07
3269 3478 11 852 12534 43 Quench Kiss Lip Balm NULL 3304300 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-01-28 17:51:07
3270 3479 12 852 12534 46 Root Vitality Hair Oil NULL 3305901 6 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 0.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1165.71 58.29 1224.0 INR 3 2.0 23.31 2026-01-28 17:51:07
3271 3480 13 852 12534 35 Sanitary Pad (15 pcs) NULL 9619001 12 0.0 380.0 0.0 0.0 304.0 304.0 0.0 4560.0 0.0 3648.0 0.0 0.0 0.0 0.0 0.0 0.0 3648.0 0.0 3648.0 INR 3 2.0 72.96 2026-01-28 17:51:07
3272 3481 14 852 12534 50 Sun Screen NULL 330499 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-01-28 17:51:07
3273 3482 15 852 12534 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-28 17:51:07
3274 3483 1 853 12523 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-28 18:02:24
3275 3484 2 853 12523 70 Premium Hand belt NULL 9404 1 0.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 9999.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-28 18:02:24
3276 3485 3 853 12523 38 Dish Wash 500ml NULL 34029099 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-28 18:02:24
3277 3486 4 853 12523 37 Floor Cleaner 500ml NULL 3924101 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-01-28 18:02:24
3278 3487 5 853 12523 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-28 18:02:24
3279 3488 6 853 12523 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-28 18:02:24
3280 3489 7 853 12523 18 Lady Care Juice 500ml 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-28 18:02:24
3281 3490 8 853 12523 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-01-28 18:02:24
3282 3491 9 853 12523 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-28 18:02:24
3283 3492 10 853 12523 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.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-28 18:02:24
3284 3493 11 853 12523 26 Spirulina Cap NULL 2009899 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-28 18:02:24
3285 3494 12 853 12523 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-01-28 18:02:24
3286 3495 13 853 12523 44 Vital Glow Face Scrub NULL 3304300 7 0.0 325.0 0.0 0.0 260.0 220.34 39.66 2275.0 0.0 1820.0 9.0 138.81 9.0 138.81 0.0 0.0 1542.37 277.63 1820.0 INR 3 2.0 30.85 2026-01-28 18:02:24
3287 3496 1 854 13438 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 3 2.0 11.43 2026-01-28 18:34:36
3288 3497 2 854 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-28 18:34:36
3289 3498 1 855 12547 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-28 19:57:54
3290 3499 1 856 12516 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 1 0.0 400.0 2026-01-29 15:38:38
3291 3500 1 857 12517 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 0.0 0.0 0.0 0.0 5.0 2500.0 50000.0 2500.0 52500.0 INR 2 0.0 300.0 2026-01-29 15:39:04
3292 3501 1 858 12527 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-29 15:53:35
3293 3502 1 859 12527 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.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-29 16:06:03
3294 3503 1 860 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-01-29 22:20:37
3295 3504 2 860 12521 33 Herbal Soap 100gm NULL 30049011 25 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.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-29 22:20:37
3296 3505 3 860 12521 34 Herbo2o Toothpaste NULL 33061090 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-29 22:20:37
3297 3506 4 860 12521 15 KIDNEY 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 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-29 22:20:37
3298 3507 5 860 12521 25 Manicalcium Tablets NULL 2009899 3 0.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 0.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-01-29 22:20:37
3299 3508 6 860 12521 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-29 22:20:37
3300 3509 7 860 12521 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-29 22:20:37