fx_franchise_order_product

4,737 rows · 33 columns · page 68 / 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
3351 3560 2 865 12532 27 Multicharge Cap NULL 2009899 6 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 8994.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 6857.14 342.86 7200.0 INR 3 2.0 137.14 2026-01-30 16:41:49
3352 3561 3 865 12532 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-01-30 16:41:49
3353 3562 4 865 12532 4 Diabetic Care Capsules NULL 2936900 5 0.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-01-30 16:41:49
3354 3563 5 865 12532 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-30 16:41:49
3355 3564 6 865 12532 39 Fabric Wash 1000ml NULL 34029099 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-30 16:41:49
3356 3565 7 865 12532 37 Floor Cleaner 500ml NULL 3924101 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-01-30 16:41:49
3357 3566 8 865 12532 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 7619.05 380.95 8000.0 INR 3 2.0 152.38 2026-01-30 16:41:49
3358 3567 9 865 12532 30 Iron Capsules NULL 30049011 3 0.0 899.0 0.0 0.0 719.0 684.76 34.24 2697.0 0.0 2157.0 2.5 51.36 2.5 51.36 0.0 0.0 2054.29 102.71 2157.0 INR 3 2.0 41.09 2026-01-30 16:41:49
3359 3568 10 865 12532 15 KIDNEY 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-30 16:41:49
3360 3569 11 865 12532 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-30 16:41:49
3361 3570 12 865 12532 25 Manicalcium Tablets NULL 2009899 6 0.0 399.0 0.0 0.0 319.0 303.81 15.19 2394.0 0.0 1914.0 2.5 45.57 2.5 45.57 0.0 0.0 1822.86 91.14 1914.0 INR 3 2.0 36.46 2026-01-30 16:41:49
3362 3571 13 865 12532 17 Memory Booster 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-30 16:41:49
3363 3572 14 865 12532 32 Neem Soap 100gm NULL 34011110 200 0.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 0.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 9142.86 457.14 9600.0 INR 3 2.0 182.86 2026-01-30 16:41:49
3364 3573 15 865 12532 9 Omega 369 NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-01-30 16:41:49
3365 3574 16 865 12532 28 Ortho Joint Shield NULL 2009899 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-30 16:41:49
3366 3575 17 865 12532 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-30 16:41:49
3367 3576 18 865 12532 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-01-30 16:41:49
3368 3577 19 865 12532 46 Root Vitality Hair Oil NULL 3305901 12 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 0.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-01-30 16:41:49
3369 3578 20 865 12532 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-30 16:41:49
3370 3579 21 865 12532 26 Spirulina Cap NULL 2009899 5 0.0 899.0 0.0 0.0 719.0 684.76 34.24 4495.0 0.0 3595.0 2.5 85.6 2.5 85.6 0.0 0.0 3423.81 171.19 3595.0 INR 3 2.0 68.48 2026-01-30 16:41:49
3371 3580 22 865 12532 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-30 16:41:49
3372 3581 23 865 12532 5 Thyro Care NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-01-30 16:41:49
3373 3582 24 865 12532 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-30 16:41:49
3374 3583 1 866 12546 4 Diabetic 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-30 18:00:07
3375 3584 2 866 12546 39 Fabric Wash 1000ml NULL 34029099 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-30 18:00:07
3376 3585 3 866 12546 33 Herbal Soap 100gm NULL 30049011 31 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3100.0 0.0 2480.0 2.5 59.05 2.5 59.05 0.0 0.0 2361.91 118.1 2480.0 INR 3 2.0 47.24 2026-01-30 18:00:07
3377 3586 4 866 12546 15 KIDNEY 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-30 18:00:07
3378 3587 5 866 12546 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-30 18:00:07
3379 3588 6 866 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-30 18:00:07
3380 3589 7 866 12546 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-30 18:00:07
3381 3590 8 866 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-30 18:00:07
3382 3591 9 866 12546 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-30 18:00:07
3383 3592 10 866 12546 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-30 18:00:07
3384 3593 1 867 14490 34 Herbo2o Toothpaste NULL 33061090 9 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1791.0 0.0 1431.0 9.0 109.14 9.0 109.14 0.0 0.0 1212.71 218.29 1431.0 INR 3 2.0 24.25 2026-01-30 20:09:40
3385 3594 2 867 14490 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-30 20:09:40
3386 3595 1 868 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-30 21:11:22
3387 3596 2 868 12552 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-30 21:11:22
3388 3597 3 868 12552 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-01-30 21:11:22
3389 3598 4 868 12552 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-30 21:11:22
3390 3599 5 868 12552 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-30 21:11:22
3391 3600 6 868 12552 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-30 21:11:22
3392 3601 7 868 12552 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-30 21:11:22
3393 3602 8 868 12552 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-30 21:11:22
3394 3603 9 868 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-30 21:11:22
3395 3604 10 868 12552 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-30 21:11:22
3396 3605 11 868 12552 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-30 21:11:22
3397 3606 12 868 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-30 21:11:22
3398 3607 13 868 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-30 21:11:22
3399 3608 14 868 12552 35 Sanitary Pad (15 pcs) NULL 9619001 3 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 0.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 912.0 0.0 912.0 INR 3 2.0 18.24 2026-01-30 21:11:22
3400 3609 15 868 12552 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-01-30 21:11:22