fx_franchise_order_product

4,737 rows · 33 columns · page 21 / 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
1001 1210 1 164 12532 74 EXPLORER BOX NULL NULL 3 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 80991.0 0.0 31497.0 2.5 749.93 2.5 749.93 0.0 0.0 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-11 15:59:25
1002 1211 1 165 12544 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-11 16:17:48
1003 1212 1 166 12517 76 ELITE BOX NULL NULL 1 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 46494.0 0.0 18000.0 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-11 16:18:14
1004 1213 2 166 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-11 16:18:14
1005 1214 3 166 12517 74 EXPLORER BOX NULL NULL 3 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 80991.0 0.0 31497.0 0.0 0.0 0.0 0.0 5.0 1499.86 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-11 16:18:14
1006 1215 1 167 12555 48 glow face wash NULL 3304999 5 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 1250.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1007 1216 2 167 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 16:30:18
1008 1217 3 167 12555 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 29997.0 1800.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 16:30:18
1009 1218 4 167 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 16:30:18
1010 1219 5 167 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 16:30:18
1011 1220 6 167 12555 6 Asthma Care NULL 30049011 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:30:18
1012 1221 7 167 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 2.5 91.43 2.5 91.43 0.0 0.0 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1013 1222 8 167 12555 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1014 1223 9 167 12555 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1015 1224 10 167 12555 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1016 1225 11 167 12555 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 9.0 73.41 9.0 73.41 0.0 0.0 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-11 16:30:18
1017 1226 12 167 12555 19 Fat loss Juice 500 ml NULL 30049011 3 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 4497.0 750.0 4437.0 2.5 105.64 2.5 105.64 0.0 0.0 1408.57 211.29 4437.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1018 1227 13 167 12555 22 Fit Fuel Juice NULL 2009899 3 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 5997.0 600.0 5937.0 2.5 141.35 2.5 141.35 0.0 0.0 1884.76 282.71 5937.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1019 1228 14 167 12555 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1020 1229 15 167 12555 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 16:30:18
1021 1230 16 167 12555 58 Green shield 250ml NULL 3105 2 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 1600.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 1904.76 190.48 4000.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1022 1231 17 167 12555 55 Grow master 500ml NULL 3105 2 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 4060.0 1700.0 3248.0 2.5 77.33 2.5 77.33 0.0 0.0 1546.67 154.67 3248.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1023 1232 18 167 12555 2 Heart Care Capsules NULL 2936900 2 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 850.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 16:30:18
1024 1233 19 167 12555 33 Herbal Soap 100gm NULL 30049011 25 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 700.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 76.19 95.24 2000.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1025 1234 20 167 12555 34 Herbo2o Toothpaste NULL 33061090 20 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 900.0 3184.0 9.0 242.84 9.0 242.84 0.0 0.0 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1026 1235 1 168 12555 24 Immunomax 24/7 Caps 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 16:34:35
1027 1236 2 168 12555 30 Iron Capsules NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1028 1237 3 168 12555 15 Kidney Stone Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 2.5 33.24 2.5 33.24 0.0 0.0 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1029 1238 4 168 12555 18 Lady Care Juice 500ml NULL 2009899 2 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 500.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 16:34:35
1030 1239 5 168 12555 16 Liver Care Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 2.5 33.24 2.5 33.24 0.0 0.0 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1031 1240 6 168 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 16:34:35
1032 1241 7 168 12555 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1033 1242 8 168 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 16:34:35
1034 1243 9 168 12555 56 Micro magic 500ml NULL 3105 2 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 4060.0 1700.0 3248.0 9.0 247.73 9.0 247.73 0.0 0.0 1376.27 495.46 3248.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1035 1244 10 168 12555 7 Morning Fresh Churan NULL 30049011 3 40.0 199.0 0.0 0.0 159.2 151.62 7.58 597.0 120.0 477.6 2.5 11.37 2.5 11.37 0.0 0.0 151.62 22.74 477.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1036 1245 11 168 12555 32 Neem Soap 100gm NULL 34011110 20 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 200.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 45.71 45.71 960.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1037 1246 12 168 12555 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1038 1247 13 168 12555 28 Ortho Joint Shield 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 16:34:35
1039 1248 1 169 12516 76 ELITE BOX NULL NULL 5 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 232470.0 0.0 90000.0 2.5 2142.86 2.5 2142.86 0.0 0.0 17142.86 4285.71 90000.0 INR 0 0.0 0.0 2025-11-11 16:40:11
1040 1249 1 170 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 16:42:11
1041 1250 2 170 12555 8 Piles Care NULL 30049011 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
1042 1251 3 170 12555 41 Premium Coco Body Lotion NULL 3304300 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
1043 1252 4 170 12555 14 Premium Aloe Vera VEG caps NULL 2936900 3 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1077.0 300.0 861.6 2.5 20.52 2.5 20.52 0.0 0.0 273.52 41.03 861.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1044 1253 5 170 12555 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1045 1254 6 170 12555 13 Premium NONI VEG caps NULL 2936900 3 150.0 501.0 0.0 0.0 400.8 381.71 19.09 1503.0 450.0 1202.4 2.5 28.63 2.5 28.63 0.0 0.0 381.71 57.26 1202.4 INR 0 0.0 0.0 2025-11-11 16:42:11
1046 1255 7 170 12555 43 Quench Kiss Lip Balm NULL 3304300 3 35.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 105.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1047 1256 8 170 12555 57 Safe guard 250ml NULL 3105 3 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 7500.0 2400.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1904.76 285.71 6000.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1048 1257 9 170 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 16:42:11
1049 1258 10 170 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 16:42:11
1050 1259 11 170 12555 26 Spirulina Cap NULL 2009899 3 190.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 570.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