fx_franchise_order_product

4,737 rows · 33 columns · page 76 / 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
3751 3960 11 962 12541 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-14 18:04:42
3752 3961 12 962 12541 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-14 18:04:42
3753 3962 13 962 12541 34 Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-02-14 18:04:42
3754 3963 1 963 12542 62 3*6 BED WITH BRACELET NULL 94041000 8 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 103992.0 0.0 63840.0 0.0 0.0 0.0 0.0 3.0 1859.42 61980.58 1859.42 63840.0 INR 3 2.0 1239.61 2026-02-16 15:02:31
3755 3964 1 964 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 77475.73 2324.27 79800.0 INR 2 6.0 4648.54 2026-02-16 15:03:21
3756 3965 1 965 12542 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-16 15:06:32
3757 3966 1 966 12545 38 Dish Wash 500ml NULL 34029099 4 0.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 0.0 736.0 9.0 56.14 9.0 56.14 0.0 0.0 623.73 112.27 736.0 INR 3 2.0 12.47 2026-02-17 21:26:21
3758 3967 2 966 12545 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-17 21:26:21
3759 3968 3 966 12545 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-17 21:26:21
3760 3969 4 966 12545 17 Memory Booster Juice NULL 2009899 4 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1396.0 0.0 1116.0 2.5 26.57 2.5 26.57 0.0 0.0 1062.86 53.14 1116.0 INR 3 2.0 21.26 2026-02-17 21:26:21
3761 3970 5 966 12545 7 Morning Fresh Churan NULL 30049011 8 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1592.0 0.0 1272.0 2.5 30.29 2.5 30.29 0.0 0.0 1211.43 60.57 1272.0 INR 3 2.0 24.23 2026-02-17 21:26:21
3762 3971 6 966 12545 43 Quench Kiss Lip Balm NULL 3304300 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-17 21:26:21
3763 3972 7 966 12545 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-02-17 21:26:21
3764 3973 8 966 12545 34 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-02-17 21:26:21
3765 3974 1 967 12545 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-02-18 22:10:34
3766 3975 2 967 12545 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-02-18 22:10:34
3767 3976 3 967 12545 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-02-18 22:10:34
3768 3977 4 967 12545 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-02-18 22:10:34
3769 3978 5 967 12545 81 PREMIUM GLOW FACE WASH NULL 3404 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-18 22:10:34
3770 3979 6 967 12545 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-18 22:10:34
3771 3980 1 968 12545 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-19 09:59:47
3772 3981 1 969 13438 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-19 17:23:59
3773 3982 1 970 13438 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-19 17:28:17
3774 3983 2 970 13438 43 Quench Kiss Lip Balm NULL 3304300 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-02-19 17:28:17
3775 3984 3 970 13438 29 Shilajith NULL 30049011 2 0.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 3000.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 0.0 2.0 2026-02-19 17:28:17
3776 3985 1 971 14079 33 HALDI CHANDAN SOAP 100gm NULL 30049011 11 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1100.0 0.0 880.0 2.5 20.95 2.5 20.95 0.0 0.0 838.1 41.9 880.0 INR 3 2.0 16.76 2026-02-21 22:05:21
3777 3986 2 971 14079 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-02-21 22:05:21
3778 3987 1 972 12526 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-02-23 17:08:12
3779 3988 2 972 12526 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-23 17:08:12
3780 3989 3 972 12526 19 Fat loss Juice 500 ml NULL 30049011 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-02-23 17:08:12
3781 3990 4 972 12526 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-23 17:08:12
3782 3991 5 972 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-23 17:08:12
3783 3992 6 972 12526 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-02-23 17:08:12
3784 3993 7 972 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-02-23 17:08:12
3785 3994 8 972 12526 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 4 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 5000.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-23 17:08:12
3786 3995 9 972 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-02-23 17:08:12
3787 3996 10 972 12526 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-02-23 17:08:12
3788 3997 11 972 12526 35 Sanitary Pad (15 pcs) NULL 9619001 5 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-02-23 17:08:12
3789 3998 1 973 12526 34 Toothpaste NULL 33061090 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-02-23 17:23:35
3790 3999 1 974 13518 32 Neem Soap 100gm NULL 34011110 9 0.0 60.0 0.0 0.0 48.0 45.71 2.29 540.0 0.0 432.0 2.5 10.29 2.5 10.29 0.0 0.0 411.43 20.57 432.0 INR 3 2.0 8.23 2026-02-24 16:00:37
3791 4000 1 975 12540 48 Glow bliss 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-02-25 14:55:22
3792 4001 2 975 12540 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-25 14:55:22
3793 4002 3 975 12540 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-25 14:55:22
3794 4003 4 975 12540 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-25 14:55:22
3795 4004 1 976 12517 7 Morning Fresh Churan NULL 30049011 100 0.0 199.0 0.0 0.0 159.0 151.43 7.57 19900.0 0.0 15900.0 0.0 0.0 0.0 0.0 5.0 757.14 15142.86 757.14 15900.0 INR 2 5.0 757.14 2026-02-26 14:28:51
3796 4005 1 977 12516 7 Morning Fresh Churan NULL 30049011 100 0.0 199.0 0.0 0.0 159.0 151.43 7.57 19900.0 0.0 15900.0 2.5 378.57 2.5 378.57 0.0 0.0 15142.86 757.14 15900.0 INR 1 8.0 1211.43 2026-02-26 14:29:32
3797 4006 1 978 12548 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-26 23:50:58
3798 4007 2 978 12548 39 Fabric Wash 1000ml NULL 34029099 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-02-26 23:50:58
3799 4008 3 978 12548 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-26 23:50:58
3800 4009 4 978 12548 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-26 23:50:58