fx_franchise_order_product

4,737 rows · 33 columns · page 71 / 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
3501 3710 10 907 12543 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-02-04 00:37:24
3502 3711 1 908 12532 20 Premium Berry Juice 1000ml NULL 2936900 4 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 13996.0 0.0 10400.0 2.5 247.62 2.5 247.62 0.0 0.0 9904.76 495.24 10400.0 INR 3 2.0 198.1 2026-02-04 20:21:19
3503 3712 1 909 12528 4 Diabetic Care Capsules 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-02-05 15:01:23
3504 3713 2 909 12528 48 Glow bliss 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-02-05 15:01:23
3505 3714 3 909 12528 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 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-02-05 15:01:23
3506 3715 4 909 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-02-05 15:01:23
3507 3716 5 909 12528 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-02-05 15:01:23
3508 3717 6 909 12528 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-02-05 15:01:23
3509 3718 7 909 12528 34 Toothpaste NULL 33061090 25 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4975.0 0.0 3975.0 9.0 303.18 9.0 303.18 0.0 0.0 3368.64 606.36 3975.0 INR 3 2.0 67.37 2026-02-05 15:01:23
3510 3719 1 910 12548 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-02-05 15:35:25
3511 3720 2 910 12548 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-02-05 15:35:25
3512 3721 3 910 12548 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-02-05 15:35:25
3513 3722 4 910 12548 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-02-05 15:35:25
3514 3723 5 910 12548 53 Terra care 2 kg NULL 3103100 3 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 0.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-02-05 15:35:25
3515 3724 1 911 13438 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-02-05 22:03:41
3516 3725 2 911 13438 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-02-05 22:03:41
3517 3726 3 911 13438 48 Glow bliss 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-02-05 22:03:41
3518 3727 4 911 13438 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-02-05 22:03:41
3519 3728 5 911 13438 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-02-05 22:03:41
3520 3729 6 911 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-02-05 22:03:41
3521 3730 7 911 13438 8 Piles Care NULL 30049011 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-02-05 22:03:41
3522 3731 8 911 13438 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-02-05 22:03:41
3523 3732 9 911 13438 43 Quench Kiss Lip Balm NULL 3304300 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-02-05 22:03:41
3524 3733 10 911 13438 35 Sanitary Pad (15 pcs) NULL 9619001 6 0.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 0.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 1824.0 0.0 1824.0 INR 3 2.0 36.48 2026-02-05 22:03:41
3525 3734 11 911 13438 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-02-05 22:03:41
3526 3735 12 911 13438 34 Toothpaste NULL 33061090 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-02-05 22:03:41
3527 3736 13 911 13438 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-02-05 22:03:41
3528 3737 1 912 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-02-05 22:38:22
3529 3738 1 913 12527 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-02-06 10:47:44
3530 3739 2 913 12527 41 Premium Coco Body Lotion NULL 3304300 10 0.0 699.0 0.0 0.0 559.0 473.73 85.27 6990.0 0.0 5590.0 9.0 426.36 9.0 426.36 0.0 0.0 4737.29 852.71 5590.0 INR 3 2.0 94.75 2026-02-06 10:47:44
3531 3740 3 913 12527 10 RADIANCE GLOW DAY CREAM NULL 33049900 5 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 7120.0 0.0 3750.0 9.0 286.02 9.0 286.02 0.0 0.0 3177.97 572.03 3750.0 INR 3 2.0 63.56 2026-02-06 10:47:44
3532 3741 4 913 12527 35 Sanitary Pad (15 pcs) NULL 9619001 20 0.0 380.0 0.0 0.0 304.0 304.0 0.0 7600.0 0.0 6080.0 0.0 0.0 0.0 0.0 0.0 0.0 6080.0 0.0 6080.0 INR 3 2.0 121.6 2026-02-06 10:47:44
3533 3742 5 913 12527 5 Thyro Care 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-02-06 10:47:44
3534 3743 1 914 12528 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-06 17:17:53
3535 3744 2 914 12528 33 HALDI CHANDAN 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-02-06 17:17:53
3536 3745 3 914 12528 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-02-06 17:17:53
3537 3746 4 914 12528 41 Premium Coco Body Lotion NULL 3304300 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-02-06 17:17:53
3538 3747 5 914 12528 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-02-06 17:17:53
3539 3748 6 914 12528 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-06 17:17:53
3540 3749 1 915 12546 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 5 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 93500.0 0.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 3 2.0 1019.05 2026-02-06 20:20:56
3541 3750 1 916 12532 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 4 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 74800.0 0.0 42800.0 2.5 1019.05 2.5 1019.05 0.0 0.0 40761.9 2038.1 42800.0 INR 3 2.0 815.24 2026-02-06 20:21:33
3542 3751 1 917 12521 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 3 2.0 407.62 2026-02-06 21:52:01
3543 3752 1 918 14490 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-02-07 13:10:17
3544 3753 1 919 12517 49 Anti Dandruff Serum NULL 3304999 10 0.0 999.0 0.0 0.0 799.0 677.12 121.88 9990.0 0.0 7990.0 0.0 0.0 0.0 0.0 18.0 1218.81 6771.19 1218.81 7990.0 INR 2 6.0 406.27 2026-02-07 16:08:59
3545 3754 2 919 12517 38 Dish Wash 500ml NULL 34029099 6 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1380.0 0.0 1104.0 0.0 0.0 0.0 0.0 18.0 168.41 935.59 168.41 1104.0 INR 2 5.0 46.78 2026-02-07 16:08:59
3546 3755 3 919 12517 39 Fabric Wash 1000ml NULL 34029099 29 0.0 401.0 0.0 0.0 321.0 272.03 48.97 11629.0 0.0 9309.0 0.0 0.0 0.0 0.0 18.0 1420.02 7888.98 1420.02 9309.0 INR 2 5.0 394.45 2026-02-07 16:08:59
3547 3756 4 919 12517 37 Floor Cleaner 500ml NULL 3924101 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 0.0 0.0 0.0 0.0 18.0 48.51 269.49 48.51 318.0 INR 2 5.0 13.47 2026-02-07 16:08:59
3548 3757 5 919 12517 41 Premium Coco Body Lotion NULL 3304300 38 0.0 699.0 0.0 0.0 559.0 473.73 85.27 26562.0 0.0 21242.0 0.0 0.0 0.0 0.0 18.0 3240.31 18001.69 3240.31 21242.0 INR 2 6.0 1080.1 2026-02-07 16:08:59
3549 3758 6 919 12517 43 Quench Kiss Lip Balm NULL 3304300 29 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5771.0 0.0 4611.0 0.0 0.0 0.0 0.0 18.0 703.37 3907.63 703.37 4611.0 INR 2 6.0 234.46 2026-02-07 16:08:59
3550 3759 7 919 12517 36 Toilet Cleaner 500ml NULL 3924101 27 0.0 150.0 0.0 0.0 120.0 101.69 18.31 4050.0 0.0 3240.0 0.0 0.0 0.0 0.0 18.0 494.24 2745.76 494.24 3240.0 INR 2 5.0 137.29 2026-02-07 16:08:59