fx_franchise_order_product

4,737 rows · 33 columns · page 74 / 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
3651 3860 1 944 12555 94 PAVANA DROPS NULL 30041211 10 0.0 699.0 0.0 0.0 499.0 475.24 23.76 6990.0 0.0 4990.0 2.5 118.81 2.5 118.81 0.0 0.0 4752.38 237.62 4990.0 INR 3 2.0 95.05 2026-02-11 15:57:49
3652 3861 2 944 12555 95 STRI VEDA NULL 30049011 10 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 25000.0 0.0 15000.0 2.5 357.14 2.5 357.14 0.0 0.0 14285.71 714.29 15000.0 INR 3 2.0 285.71 2026-02-11 15:57:49
3653 3862 3 944 12555 96 TRIM VEDA NULL 30049011 10 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 25000.0 0.0 15000.0 2.5 357.14 2.5 357.14 0.0 0.0 14285.71 714.29 15000.0 INR 3 2.0 285.71 2026-02-11 15:57:49
3654 3863 1 945 14569 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-02-11 18:01:01
3655 3864 2 945 14569 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-11 18:01:01
3656 3865 3 945 14569 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-11 18:01:01
3657 3866 4 945 14569 50 Sun Screen NULL 330499 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-11 18:01:01
3658 3867 1 946 14569 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-11 19:26:04
3659 3868 1 947 13836 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-02-12 15:19:05
3660 3869 2 947 13836 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-12 15:19:05
3661 3870 3 947 13836 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-02-12 15:19:05
3662 3871 4 947 13836 9 Omega 369 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-02-12 15:19:05
3663 3872 5 947 13836 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-12 15:19:05
3664 3873 1 948 14569 32 Neem Soap 100gm NULL 34011110 3 0.0 60.0 0.0 0.0 48.0 45.71 2.29 180.0 0.0 144.0 2.5 3.43 2.5 3.43 0.0 0.0 137.14 6.86 144.0 INR 3 2.0 2.74 2026-02-12 20:18:43
3665 3874 2 948 14569 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-02-12 20:18:43
3666 3875 1 949 12521 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-13 14:18:36
3667 3876 2 949 12521 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-13 14:18:36
3668 3877 3 949 12521 32 Neem Soap 100gm NULL 34011110 8 0.0 60.0 0.0 0.0 48.0 45.71 2.29 480.0 0.0 384.0 2.5 9.14 2.5 9.14 0.0 0.0 365.71 18.29 384.0 INR 3 2.0 7.31 2026-02-13 14:18:36
3669 3878 4 949 12521 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-02-13 14:18:36
3670 3879 1 950 12546 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-02-13 15:07:59
3671 3880 2 950 12546 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-02-13 15:07:59
3672 3881 1 951 12545 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-13 15:32:07
3673 3882 2 951 12545 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-13 15:32:07
3674 3883 3 951 12545 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-02-13 15:32:07
3675 3884 4 951 12545 50 Sun Screen NULL 330499 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-13 15:32:07
3676 3885 5 951 12545 34 Toothpaste NULL 33061090 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-02-13 15:32:07
3677 3886 6 951 12545 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-13 15:32:07
3678 3887 1 952 12546 6 Asthma Care NULL 30049011 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-02-13 15:51:51
3679 3888 1 953 14569 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-02-13 16:07:07
3680 3889 2 953 14569 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-02-13 16:07:07
3681 3890 1 954 14569 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-02-13 16:10:33
3682 3891 2 954 14569 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-02-13 16:10:33
3683 3892 1 955 14569 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-02-13 16:22:29
3684 3893 2 955 14569 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-13 16:22:29
3685 3894 1 956 12526 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 3 2.0 99.05 2026-02-13 17:48:09
3686 3895 2 956 12526 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-02-13 17:48:09
3687 3896 3 956 12526 6 Asthma Care 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-13 17:48:09
3688 3897 4 956 12526 4 Diabetic Care Capsules 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-02-13 17:48:09
3689 3898 5 956 12526 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-13 17:48:09
3690 3899 6 956 12526 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-02-13 17:48:09
3691 3900 7 956 12526 19 Fat loss Juice 500 ml NULL 30049011 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-13 17:48:09
3692 3901 8 956 12526 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-13 17:48:09
3693 3902 9 956 12526 48 Glow bliss face wash NULL 3304999 10 0.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 0.0 3040.0 9.0 231.86 9.0 231.86 0.0 0.0 2576.27 463.73 3040.0 INR 3 2.0 51.53 2026-02-13 17:48:09
3694 3903 10 956 12526 33 HALDI CHANDAN 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-02-13 17:48:09
3695 3904 11 956 12526 2 Heart Care Capsules NULL 2936900 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-13 17:48:09
3696 3905 12 956 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-02-13 17:48:09
3697 3906 13 956 12526 28 Ortho Joint Shield 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-02-13 17:48:09
3698 3907 14 956 12526 72 Pain Relief Patch NULL 30051090 5 0.0 800.0 0.0 0.0 600.0 571.43 28.57 4000.0 0.0 3000.0 2.5 71.43 2.5 71.43 0.0 0.0 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-02-13 17:48:09
3699 3908 15 956 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-02-13 17:48:09
3700 3909 16 956 12526 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-13 17:48:09