fx_franchise_order_product

4,737 rows · 33 columns · page 23 / 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
1101 1310 34 175 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 17:13:54
1102 1311 35 175 12555 1 Stem Cell Powder NULL 2936900 5 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 12495.0 3745.0 9996.0 2.5 238.0 2.5 238.0 0.0 0.0 1904.0 476.0 9996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1103 1312 36 175 12555 50 Sun Screen NULL 330499 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
1104 1313 37 175 12555 5 Thyro Care NULL 2936900 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
1105 1314 38 175 12555 36 Toilet Cleaner 500ml NULL 3924101 6 30.0 150.0 0.0 0.0 120.0 101.69 18.3 900.0 180.0 720.0 9.0 54.91 9.0 54.91 0.0 0.0 101.69 109.83 720.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1106 1315 39 175 12555 44 Vital Glow Face Scrub NULL 3304300 6 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1950.0 426.0 1560.0 9.0 118.98 9.0 118.98 0.0 0.0 220.34 237.97 1560.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1107 1316 1 176 12533 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 17:29:50
1108 1317 1 177 12554 48 glow face wash NULL 3304999 200 250.0 380.0 0.0 0.0 304.0 257.63 46.37 76000.0 50000.0 60800.0 9.0 4637.29 9.0 4637.29 0.0 0.0 257.63 9274.58 60800.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1109 1318 2 177 12554 27 Multicharge Cap NULL 2009899 100 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 149900.0 45000.0 119920.0 2.5 2855.24 2.5 2855.24 0.0 0.0 1142.1 5710.48 119920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1110 1319 3 177 12554 20 Premium Berry Juice 1000ml NULL 2936900 50 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 174950.0 37500.0 173950.0 2.5 4141.66 2.5 4141.66 0.0 0.0 3313.33 8283.33 173950.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1111 1320 4 177 12554 70 Premium Hand belt NULL 9404 60 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 599940.0 36000.0 86400.0 2.5 2057.14 2.5 2057.14 0.0 0.0 1371.43 4114.29 86400.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1112 1321 5 177 12554 61 Radiation chip NULL 902221 20 325.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 6500.0 15984.0 9.0 1219.12 9.0 1219.12 0.0 0.0 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1113 1322 6 177 12554 31 Vegan Plant Protein Powder NULL 21061000 50 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 149950.0 50000.0 119960.0 2.5 2856.19 2.5 2856.19 0.0 0.0 2284.95 5712.38 119960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1114 1323 7 177 12554 49 Anti Dandruff Serum NULL 3304999 50 250.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 12500.0 39960.0 9.0 3047.8 9.0 3047.8 0.0 0.0 677.29 6095.59 39960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1115 1324 8 177 12554 6 Asthma Care NULL 30049011 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1116 1325 9 177 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 20 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 32000.0 9000.0 25600.0 2.5 609.52 2.5 609.52 0.0 0.0 1219.05 1219.05 25600.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1117 1326 10 177 12554 3 BP Care Capsules NULL 2936900 50 160.0 599.0 0.0 0.0 479.2 456.38 22.82 29950.0 8000.0 23960.0 2.5 570.48 2.5 570.48 0.0 0.0 456.38 1140.95 23960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1118 1327 11 177 12554 4 Diabetic Care Capsules NULL 2936900 40 250.0 899.0 0.0 0.0 719.2 684.95 34.25 35960.0 10000.0 28768.0 2.5 684.95 2.5 684.95 0.0 0.0 684.95 1369.9 28768.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1119 1328 12 177 12554 38 Dish Wash 500ml NULL 3924101 100 85.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 8500.0 18400.0 9.0 1403.39 9.0 1403.39 0.0 0.0 155.93 2806.78 18400.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1120 1329 13 177 12554 39 Fabric Wash 1000ml NULL 3924101 50 150.0 401.0 0.0 0.0 320.8 271.86 48.94 20050.0 7500.0 16040.0 9.0 1223.39 9.0 1223.39 0.0 0.0 271.86 2446.78 16040.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1121 1330 14 177 12554 19 Fat loss Juice 500 ml NULL 30049011 50 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 74950.0 12500.0 73950.0 2.5 1760.71 2.5 1760.71 0.0 0.0 1408.57 3521.43 73950.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1122 1331 15 177 12554 37 Floor Cleaner 500ml NULL 3924101 100 80.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 8000.0 15920.0 9.0 1214.23 9.0 1214.23 0.0 0.0 134.92 2428.47 15920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1123 1332 16 177 12554 60 Foot patch NULL 30051090 30 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 59970.0 15000.0 47976.0 2.5 1142.29 2.5 1142.29 0.0 0.0 1523.05 2284.57 47976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1124 1333 17 177 12554 58 Green shield 250ml NULL 3105 20 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 50000.0 16000.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 1904.76 1904.76 40000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1125 1334 18 177 12554 55 Grow master 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 40600.0 17000.0 32480.0 2.5 773.34 2.5 773.34 0.0 0.0 1546.67 1546.67 32480.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1126 1335 19 177 12554 2 Heart Care Capsules NULL 2936900 50 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 21250.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1127 1336 20 177 12554 33 Herbal Soap 100gm NULL 30049011 2000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 200000.0 56000.0 160000.0 2.5 3809.53 2.5 3809.53 0.0 0.0 76.19 7619.05 160000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1128 1337 21 177 12554 34 Herbo2o Toothpaste NULL 33061090 1001 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199199.0 45045.0 159359.2 9.0 12154.51 9.0 12154.51 0.0 0.0 134.92 24309.03 159359.2 INR 0 0.0 0.0 2025-11-11 18:31:23
1129 1338 22 177 12554 24 Immunomax 24/7 Caps NULL 2009899 30 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 13500.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1130 1339 23 177 12554 30 Iron Capsules NULL 30049011 30 250.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 7500.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1131 1340 24 177 12554 15 Kidney Stone Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1132 1341 25 177 12554 18 Lady Care Juice 500ml NULL 2009899 50 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 12500.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1133 1342 26 177 12554 16 Liver Care Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1134 1343 27 177 12554 25 Manicalcium Tablets NULL 2009899 50 95.0 399.0 0.0 0.0 319.2 304.0 15.2 19950.0 4750.0 15960.0 2.5 380.0 2.5 380.0 0.0 0.0 304.0 760.0 15960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1135 1344 28 177 12554 12 Melatonin Drop NULL 2106909 50 190.0 749.0 0.0 0.0 599.2 570.67 28.53 37450.0 9500.0 29960.0 2.5 713.34 2.5 713.34 0.0 0.0 570.67 1426.67 29960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1136 1345 29 177 12554 17 Memory Booster Juice NULL 2009899 100 120.0 349.0 0.0 0.0 279.2 265.9 13.3 34900.0 12000.0 27920.0 2.5 664.76 2.5 664.76 0.0 0.0 265.9 1329.52 27920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1137 1346 30 177 12554 56 Micro magic 500ml NULL 3105 30 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 60900.0 25500.0 48720.0 9.0 3715.93 9.0 3715.93 0.0 0.0 1376.27 7431.86 48720.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1138 1347 31 177 12554 7 Morning Fresh Churan NULL 30049011 100 40.0 199.0 0.0 0.0 159.2 151.62 7.58 19900.0 4000.0 15920.0 2.5 379.05 2.5 379.05 0.0 0.0 151.62 758.1 15920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1139 1348 32 177 12554 32 Neem Soap 100gm NULL 34011110 2000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 120000.0 20000.0 96000.0 2.5 2285.72 2.5 2285.72 0.0 0.0 45.71 4571.43 96000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1140 1349 33 177 12554 9 Omega 369 NULL 2936900 34 260.0 999.0 0.0 0.0 799.2 761.14 38.06 33966.0 8840.0 27172.8 2.5 646.97 2.5 646.97 0.0 0.0 761.14 1293.94 27172.8 INR 0 0.0 0.0 2025-11-11 18:31:23
1141 1350 34 177 12554 28 Ortho Joint Shield NULL 2009899 30 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 13500.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1142 1351 35 177 12554 72 Pain Relief Patch NULL 30051090 150 200.0 800.0 0.0 0.0 640.0 609.52 30.48 120000.0 30000.0 96000.0 2.5 2285.72 2.5 2285.72 0.0 0.0 609.52 4571.43 96000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1143 1352 36 177 12554 8 Piles Care NULL 30049011 50 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 12500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1144 1353 37 177 12554 41 Premium Coco Body Lotion NULL 3304300 200 250.0 699.0 0.0 0.0 559.2 473.9 85.3 139800.0 50000.0 111840.0 9.0 8530.17 9.0 8530.17 0.0 0.0 473.9 17060.34 111840.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1145 1354 38 177 12554 14 Premium Aloe Vera VEG caps NULL 2936900 50 100.0 359.0 0.0 0.0 287.2 273.52 13.68 17950.0 5000.0 14360.0 2.5 341.9 2.5 341.9 0.0 0.0 273.52 683.81 14360.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1146 1355 39 177 12554 47 Premium Hair Care Shampoo NULL 3305109 30 150.0 699.0 0.0 0.0 559.2 532.57 26.63 20970.0 4500.0 16776.0 2.5 399.43 2.5 399.43 0.0 0.0 532.57 798.86 16776.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1147 1356 40 177 12554 13 Premium NONI VEG caps NULL 2936900 30 150.0 501.0 0.0 0.0 400.8 381.71 19.09 15030.0 4500.0 12024.0 2.5 286.29 2.5 286.29 0.0 0.0 381.71 572.57 12024.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1148 1357 41 177 12554 43 Quench Kiss Lip Balm NULL 3304300 6 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 210.0 955.2 9.0 72.86 9.0 72.86 0.0 0.0 134.92 145.71 955.2 INR 0 0.0 0.0 2025-11-11 18:31:23
1149 1358 42 177 12554 57 Safe guard 250ml NULL 3105 30 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 75000.0 24000.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1904.76 2857.14 60000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1150 1359 43 177 12554 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-11 18:31:23