fx_franchise_order_product

4,737 rows · 33 columns · page 22 / 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
1051 1260 12 170 12555 1 Stem Cell Powder NULL 2936900 3 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 7497.0 2247.0 5997.6 2.5 142.8 2.5 142.8 0.0 0.0 1904.0 285.6 5997.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1052 1261 13 170 12555 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1053 1262 14 170 12555 53 Terra care 2 kg NULL 3103100 3 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 4500.0 1350.0 3600.0 2.5 85.72 2.5 85.72 0.0 0.0 1142.86 171.43 3600.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1054 1263 15 170 12555 5 Thyro Care NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1055 1264 16 170 12555 36 Toilet Cleaner 500ml NULL 3924101 3 30.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 90.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 101.69 54.92 360.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1056 1265 17 170 12555 44 Vital Glow Face Scrub NULL 3304300 3 71.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 213.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 220.34 118.98 780.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1057 1266 18 170 12555 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 2.5 80.0 2.5 80.0 0.0 0.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1058 1267 1 171 12555 32 Neem Soap 100gm NULL 34011110 100 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 1000.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-11-11 16:48:11
1059 1268 1 172 12555 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.43 408.0 INR 0 0.0 0.0 2025-11-11 16:49:07
1060 1269 1 173 12546 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-11 17:01:10
1061 1270 1 174 12532 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1062 1271 2 174 12532 37 Floor Cleaner 500ml NULL 3924101 8 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 640.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 17:02:00
1063 1272 3 174 12532 60 Foot patch NULL 30051090 3 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 5997.0 1500.0 4797.6 2.5 114.23 2.5 114.23 0.0 0.0 1523.05 228.46 4797.6 INR 0 0.0 0.0 2025-11-11 17:02:00
1064 1273 4 174 12532 34 Herbo2o Toothpaste NULL 33061090 12 45.0 199.0 0.0 0.0 159.2 134.92 24.29 2388.0 540.0 1910.4 9.0 145.71 9.0 145.71 0.0 0.0 134.92 291.42 1910.4 INR 0 0.0 0.0 2025-11-11 17:02:00
1065 1274 5 174 12532 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1066 1275 6 174 12532 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1067 1276 7 174 12532 36 Toilet Cleaner 500ml NULL 3924101 8 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1200.0 240.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 101.69 146.44 960.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1068 1277 1 175 12555 48 glow face wash NULL 3304999 10 250.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 2500.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1069 1278 2 175 12555 27 Multicharge Cap NULL 2009899 2 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 900.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-11 17:13:54
1070 1279 3 175 12555 20 Premium Berry Juice 1000ml NULL 2936900 3 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 10497.0 2250.0 10437.0 2.5 248.5 2.5 248.5 0.0 0.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1071 1280 4 175 12555 70 Premium Hand belt NULL 9404 4 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 39996.0 2400.0 5760.0 2.5 137.15 2.5 137.15 0.0 0.0 1371.43 274.29 5760.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1072 1281 5 175 12555 61 Radiation chip NULL 902221 3 325.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 975.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1073 1282 6 175 12555 31 Vegan Plant Protein Powder NULL 21061000 3 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 8997.0 3000.0 7197.6 2.5 171.37 2.5 171.37 0.0 0.0 2284.95 342.74 7197.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1074 1283 7 175 12555 49 Anti Dandruff Serum NULL 3304999 3 250.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 750.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1075 1284 8 175 12555 3 BP Care Capsules NULL 2936900 4 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2396.0 640.0 1916.8 2.5 45.64 2.5 45.64 0.0 0.0 456.38 91.28 1916.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1076 1285 9 175 12555 4 Diabetic Care Capsules NULL 2936900 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1077 1286 10 175 12555 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1078 1287 11 175 12555 19 Fat loss Juice 500 ml NULL 30049011 5 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 7495.0 1250.0 7395.0 2.5 176.07 2.5 176.07 0.0 0.0 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1079 1288 12 175 12555 37 Floor Cleaner 500ml NULL 3924101 10 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 800.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1080 1289 13 175 12555 2 Heart Care Capsules NULL 2936900 5 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2125.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1081 1290 14 175 12555 33 Herbal Soap 100gm NULL 30049011 20 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 560.0 1600.0 2.5 38.09 2.5 38.09 0.0 0.0 76.19 76.19 1600.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1082 1291 15 175 12555 34 Herbo2o Toothpaste NULL 33061090 10 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 450.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1083 1292 16 175 12555 24 Immunomax 24/7 Caps NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1084 1293 17 175 12555 30 Iron Capsules NULL 30049011 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1085 1294 18 175 12555 15 Kidney Stone Juice NULL 2009899 6 120.0 349.0 0.0 0.0 279.2 265.9 13.29 2094.0 720.0 1675.2 2.5 39.88 2.5 39.88 0.0 0.0 265.9 79.77 1675.2 INR 0 0.0 0.0 2025-11-11 17:13:54
1086 1295 19 175 12555 18 Lady Care Juice 500ml NULL 2009899 4 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1000.0 4796.8 2.5 114.21 2.5 114.21 0.0 0.0 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1087 1296 20 175 12555 16 Liver Care Juice NULL 2009899 4 120.0 349.0 0.0 0.0 279.2 265.9 13.29 1396.0 480.0 1116.8 2.5 26.59 2.5 26.59 0.0 0.0 265.9 53.18 1116.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1088 1297 21 175 12555 25 Manicalcium Tablets NULL 2009899 3 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1197.0 285.0 957.6 2.5 22.8 2.5 22.8 0.0 0.0 304.0 45.6 957.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1089 1298 22 175 12555 12 Melatonin Drop NULL 2106909 5 190.0 749.0 0.0 0.0 599.2 570.67 28.53 3745.0 950.0 2996.0 2.5 71.33 2.5 71.33 0.0 0.0 570.67 142.67 2996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1090 1299 23 175 12555 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1091 1300 24 175 12555 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1092 1301 25 175 12555 32 Neem Soap 100gm NULL 34011110 4 10.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 40.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 45.71 9.14 192.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1093 1302 26 175 12555 9 Omega 369 NULL 2936900 4 260.0 999.0 0.0 0.0 799.2 761.14 38.06 3996.0 1040.0 3196.8 2.5 76.11 2.5 76.11 0.0 0.0 761.14 152.23 3196.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1094 1303 27 175 12555 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1095 1304 28 175 12555 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1096 1305 29 175 12555 41 Premium Coco Body Lotion NULL 3304300 4 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2796.0 1000.0 2236.8 9.0 170.6 9.0 170.6 0.0 0.0 473.9 341.21 2236.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1097 1306 30 175 12555 13 Premium NONI VEG caps NULL 2936900 4 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2004.0 600.0 1603.2 2.5 38.17 2.5 38.17 0.0 0.0 381.71 76.34 1603.2 INR 0 0.0 0.0 2025-11-11 17:13:54
1098 1307 31 175 12555 43 Quench Kiss Lip Balm NULL 3304300 4 35.0 199.0 0.0 0.0 159.2 134.92 24.29 796.0 140.0 636.8 9.0 48.57 9.0 48.57 0.0 0.0 134.92 97.14 636.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1099 1308 32 175 12555 35 Sanitary Pad (15 pcs) NULL 9619001 2 40.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 80.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 608.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1100 1309 33 175 12555 29 Shilajith NULL 30049011 3 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 750.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-11 17:13:54