fx_franchise_order_product

4,737 rows · 33 columns · page 80 / 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
3951 4160 1 1009 12521 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-03-06 21:59:44
3952 4161 2 1009 12521 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-03-06 21:59:44
3953 4162 1 1010 12532 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-03-07 17:52:30
3954 4163 1 1011 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-03-07 21:01:56
3955 4164 2 1011 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-03-07 21:01:56
3956 4165 3 1011 12526 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-03-07 21:01:56
3957 4166 4 1011 12526 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-03-07 21:01:56
3958 4167 5 1011 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-03-07 21:01:56
3959 4168 6 1011 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-03-07 21:01:56
3960 4169 7 1011 12526 33 HALDI CHANDAN 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-03-07 21:01:56
3961 4170 8 1011 12526 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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-03-07 21:01:56
3962 4171 9 1011 12526 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-03-07 21:01:56
3963 4172 10 1011 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-03-07 21:01:56
3964 4173 1 1012 12526 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-03-09 20:18:47
3965 4174 2 1012 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-03-09 20:18:47
3966 4175 3 1012 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-03-09 20:18:47
3967 4176 4 1012 12526 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-03-09 20:18:47
3968 4177 5 1012 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-03-09 20:18:47
3969 4178 6 1012 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-03-09 20:18:47
3970 4179 7 1012 12526 12 PREMIUM 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-03-09 20:18:47
3971 4180 8 1012 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-03-09 20:18:47
3972 4181 9 1012 12526 95 STRI VEDA NULL 30049011 1 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 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-03-09 20:18:47
3973 4182 10 1012 12526 50 Sun Screen NULL 330499 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-03-09 20:18:47
3974 4183 11 1012 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-03-09 20:18:47
3975 4184 12 1012 12526 96 TRIM VEDA NULL 30049011 2 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 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-03-09 20:18:47
3976 4185 1 1013 12521 18 Lady Care Juice 500ml 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-03-09 22:11:44
3977 4186 1 1014 12539 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-03-11 20:12:03
3978 4187 2 1014 12539 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-03-11 20:12:03
3979 4188 3 1014 12539 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-03-11 20:12:03
3980 4189 1 1015 12539 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-03-11 20:13:26
3981 4190 1 1016 12539 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-03-11 20:34:48
3982 4191 1 1017 12539 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-03-13 10:54:59
3983 4192 1 1018 14079 33 HALDI CHANDAN SOAP 100gm NULL 30049011 25 0.0 100.0 0.0 0.0 80.0 76.19 3.81 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-03-13 14:10:02
3984 4193 1 1019 12526 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-03-13 14:43:10
3985 4194 2 1019 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-03-13 14:43:10
3986 4195 3 1019 12526 33 HALDI CHANDAN 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-03-13 14:43:10
3987 4196 4 1019 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-03-13 14:43:10
3988 4197 5 1019 12526 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-03-13 14:43:10
3989 4198 6 1019 12526 12 PREMIUM 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-03-13 14:43:10
3990 4199 7 1019 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-03-13 14:43:10
3991 4200 8 1019 12526 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-03-13 14:43:10
3992 4201 9 1019 12526 34 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-03-13 14:43:10
3993 4202 1 1020 12517 32 Neem Soap 100gm NULL 34011110 926 0.0 60.0 0.0 0.0 48.0 45.71 2.29 55560.0 0.0 44448.0 0.0 0.0 0.0 0.0 5.0 2116.57 42331.44 2116.57 44448.0 INR 2 6.0 2539.89 2026-03-13 17:47:27
3994 4203 1 1021 14902 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-03-13 22:12:48
3995 4204 2 1021 14902 55 Grow master 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-03-13 22:12:48
3996 4205 3 1021 14902 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-03-13 22:12:48
3997 4206 4 1021 14902 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-03-13 22:12:48
3998 4207 1 1022 14569 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-03-14 10:25:41
3999 4208 2 1022 14569 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-03-14 10:25:41
4000 4209 1 1023 14569 93 FAMILY WELLNESS PACKAGE NULL NULL 1 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 26000.0 0.0 18750.0 2.5 446.43 2.5 446.43 0.0 0.0 17857.14 892.86 18750.0 INR 3 2.0 357.14 2026-03-14 10:31:53