fx_franchise_order_product

4,737 rows · 33 columns · page 70 / 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
3451 3660 12 891 12526 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-31 21:01:36
3452 3661 13 891 12526 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-31 21:01:36
3453 3662 14 891 12526 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-31 21:01:36
3454 3663 15 891 12526 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-31 21:01:36
3455 3664 16 891 12526 41 Premium Coco Body Lotion NULL 3304300 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-31 21:01:36
3456 3665 17 891 12526 35 Sanitary Pad (15 pcs) NULL 9619001 10 0.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 0.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 3040.0 0.0 3040.0 INR 3 2.0 60.8 2026-01-31 21:01:36
3457 3666 18 891 12526 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-01-31 21:01:36
3458 3667 1 892 12517 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 20 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 680020.0 0.0 370000.0 0.0 0.0 0.0 0.0 5.0 17619.05 352380.95 17619.05 370000.0 INR 2 0.0 500.0 2026-01-31 21:52:00
3459 3668 1 893 12516 93 FAMILY WELLNESS PACKAGE NULL NULL 15 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 390000.0 0.0 281250.0 2.5 6696.43 2.5 6696.43 0.0 0.0 267857.14 13392.86 281250.0 INR 1 0.0 0.0 2026-01-31 22:12:28
3460 3669 1 894 12517 93 FAMILY WELLNESS PACKAGE NULL NULL 10 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 260000.0 0.0 187500.0 0.0 0.0 0.0 0.0 5.0 8928.57 178571.43 8928.57 187500.0 INR 2 0.0 500.0 2026-01-31 22:13:39
3461 3670 1 895 12552 27 Multicharge Cap 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-31 22:26:29
3462 3671 1 896 13438 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-31 23:06:52
3463 3672 2 896 13438 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-31 23:06:52
3464 3673 1 897 12517 11 BRINGRAJ & SHIKAKAI NULL 33051090 20 0.0 1250.0 0.0 0.0 750.0 635.59 114.41 25000.0 0.0 15000.0 0.0 0.0 0.0 0.0 18.0 2288.14 12711.86 2288.14 15000.0 INR 2 5.0 635.59 2026-02-02 13:04:59
3465 3674 2 897 12517 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 20 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 25000.0 0.0 15000.0 0.0 0.0 0.0 0.0 5.0 714.29 14285.71 714.29 15000.0 INR 2 5.0 714.29 2026-02-02 13:04:59
3466 3675 1 898 12516 11 BRINGRAJ & SHIKAKAI NULL 33051090 15 0.0 1250.0 0.0 0.0 750.0 635.59 114.41 18750.0 0.0 11250.0 9.0 858.05 9.0 858.05 0.0 0.0 9533.9 1716.1 11250.0 INR 1 8.0 762.71 2026-02-02 13:05:48
3467 3676 2 898 12516 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 1 8.0 571.43 2026-02-02 13:05:48
3468 3677 1 899 12517 11 BRINGRAJ & SHIKAKAI NULL 33051090 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 0.0 0.0 0.0 0.0 5.0 35.71 714.29 35.71 750.0 INR 2 5.0 35.71 2026-02-02 13:50:53
3469 3678 1 900 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 2 5.0 1019.05 2026-02-02 16:08:14
3470 3679 1 901 13518 49 Anti Dandruff Serum NULL 3304999 2 0.0 999.0 0.0 0.0 799.0 677.12 121.88 1998.0 0.0 1598.0 9.0 121.88 9.0 121.88 0.0 0.0 1354.24 243.76 1598.0 INR 3 2.0 27.08 2026-02-02 16:31:09
3471 3680 2 901 13518 17 Memory Booster Juice NULL 2009899 5 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1745.0 0.0 1395.0 2.5 33.21 2.5 33.21 0.0 0.0 1328.57 66.43 1395.0 INR 3 2.0 26.57 2026-02-02 16:31:09
3472 3681 3 901 13518 56 Micro magic 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-02-02 16:31:09
3473 3682 4 901 13518 57 Safe guard 250ml NULL 3105 3 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 7500.0 0.0 5550.0 2.5 132.14 2.5 132.14 0.0 0.0 5285.71 264.29 5550.0 INR 3 2.0 105.71 2026-02-02 16:31:09
3474 3683 5 901 13518 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-02-02 16:31:09
3475 3684 1 902 12554 17 Memory Booster Juice NULL 2009899 20 0.0 349.0 0.0 0.0 279.0 265.71 13.29 6980.0 0.0 5580.0 2.5 132.86 2.5 132.86 0.0 0.0 5314.29 265.71 5580.0 INR 2 5.0 265.71 2026-02-02 17:06:55
3476 3685 1 903 14079 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-02-03 00:20:38
3477 3686 2 903 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-02-03 00:20:38
3478 3687 3 903 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-02-03 00:20:38
3479 3688 4 903 14079 33 HALDI CHANDAN 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-02-03 00:20:38
3480 3689 5 903 14079 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-02-03 00:20:38
3481 3690 6 903 14079 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-02-03 00:20:38
3482 3691 7 903 14079 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-02-03 00:20:38
3483 3692 8 903 14079 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-02-03 00:20:38
3484 3693 9 903 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-02-03 00:20:38
3485 3694 10 903 14079 34 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-02-03 00:20:38
3486 3695 1 904 12534 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-02-03 13:41:23
3487 3696 1 905 12534 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-02-03 14:26:06
3488 3697 1 906 12554 11 BRINGRAJ & 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 2 5.0 71.43 2026-02-03 15:32:58
3489 3698 2 906 12554 27 Multicharge Cap 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 2 5.0 114.29 2026-02-03 15:32:58
3490 3699 3 906 12554 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 2.5 123.81 2.5 123.81 0.0 0.0 4952.38 247.62 5200.0 INR 2 5.0 247.62 2026-02-03 15:32:58
3491 3700 4 906 12554 70 Premium Hand belt NULL 9404 2 0.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 19998.0 0.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 2 6.0 164.57 2026-02-03 15:32:58
3492 3701 1 907 12543 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-02-04 00:37:24
3493 3702 2 907 12543 48 Glow bliss 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-02-04 00:37:24
3494 3703 3 907 12543 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-02-04 00:37:24
3495 3704 4 907 12543 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-02-04 00:37:24
3496 3705 5 907 12543 18 Lady Care Juice 500ml 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-02-04 00:37:24
3497 3706 6 907 12543 16 Liver 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-02-04 00:37:24
3498 3707 7 907 12543 81 PREMIUM GLOW FACE WASH NULL 3404 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-02-04 00:37:24
3499 3708 8 907 12543 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-02-04 00:37:24
3500 3709 9 907 12543 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-02-04 00:37:24