fx_franchise_order_product

4,737 rows · 33 columns · page 6 / 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
251 460 10 74 12525 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-07 20:41:37
252 461 11 74 12525 58 Green shield 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-07 20:41:37
253 462 12 74 12525 55 Grow master 500ml NULL 3105 3 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 6090.0 2550.0 4872.0 2.5 116.0 2.5 116.0 0.0 0.0 1546.67 232.0 4872.0 INR 0 0.0 0.0 2025-11-07 20:41:37
254 463 13 74 12525 33 Herbal Soap 100gm NULL 30049011 36 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3600.0 1008.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 76.19 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:41:37
255 464 14 74 12525 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-07 20:41:37
256 465 15 74 12525 7 Morning Fresh Churan NULL 30049011 9 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1791.0 360.0 1432.8 2.5 34.12 2.5 34.12 0.0 0.0 151.62 68.23 1432.8 INR 0 0.0 0.0 2025-11-07 20:41:37
257 466 16 74 12525 32 Neem Soap 100gm NULL 34011110 83 10.0 60.0 0.0 0.0 48.0 45.71 2.29 4980.0 830.0 3984.0 2.5 94.86 2.5 94.86 0.0 0.0 45.71 189.71 3984.0 INR 0 0.0 0.0 2025-11-07 20:41:37
258 467 17 74 12525 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 2.5 19.03 2.5 19.03 0.0 0.0 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-07 20:41:37
259 468 18 74 12525 8 Piles Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:41:37
260 469 19 74 12525 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-07 20:41:37
261 470 20 74 12525 46 Root Vitality Hair Oil NULL 3305901 1 54.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 54.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 0 0.0 0.0 2025-11-07 20:41:37
262 471 21 74 12525 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-07 20:41:37
263 472 22 74 12525 35 Sanitary Pad (15 pcs) NULL 9619001 59 40.0 380.0 0.0 0.0 304.0 304.0 0.0 22420.0 2360.0 17936.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 17936.0 INR 0 0.0 0.0 2025-11-07 20:41:37
264 473 23 74 12525 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:41:37
265 474 24 74 12525 26 Spirulina Cap NULL 2009899 2 190.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 380.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-07 20:41:37
266 475 25 74 12525 50 Sun Screen NULL 330499 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-07 20:41:37
267 476 26 74 12525 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 20:41:37
268 477 27 74 12525 53 Terra care 2 kg NULL 3103100 5 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 7500.0 2250.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-07 20:41:37
269 478 28 74 12525 5 Thyro Care NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:41:37
270 479 29 74 12525 36 Toilet Cleaner 500ml NULL 3924101 10 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1500.0 300.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 101.69 183.05 1200.0 INR 0 0.0 0.0 2025-11-07 20:41:37
271 480 30 74 12525 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-07 20:41:37
272 481 31 74 12525 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-07 20:41:37
273 482 1 75 12517 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 29997.0 1800.0 23997.6 0.0 0.0 0.0 0.0 5.0 1142.74 7618.29 1142.74 23997.6 INR 0 0.0 0.0 2025-11-07 20:52:07
274 483 2 75 12517 6 Asthma Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 0.0 0.0 0.0 0.0 5.0 34.25 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:52:07
275 484 3 75 12517 40 Bamboo Brush NULL 96032100 1 25.0 110.0 0.0 0.0 88.0 74.58 13.42 110.0 25.0 88.0 0.0 0.0 0.0 0.0 18.0 13.42 74.58 13.42 88.0 INR 0 0.0 0.0 2025-11-07 20:52:07
276 485 4 75 12517 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 0.0 0.0 0.0 0.0 5.0 182.86 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-07 20:52:07
277 486 5 75 12517 38 Dish Wash 500ml NULL 3924101 21 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4830.0 1785.0 3864.0 0.0 0.0 0.0 0.0 18.0 589.42 155.93 589.42 3864.0 INR 0 0.0 0.0 2025-11-07 20:52:07
278 487 6 75 12517 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 0.0 0.0 0.0 0.0 18.0 146.81 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-07 20:52:07
279 488 7 75 12517 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 0.0 0.0 0.0 0.0 5.0 70.43 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 20:52:07
280 489 8 75 12517 37 Floor Cleaner 500ml NULL 3924101 9 80.0 199.0 0.0 0.0 159.2 134.92 24.28 1791.0 720.0 1432.8 0.0 0.0 0.0 0.0 18.0 218.56 134.92 218.56 1432.8 INR 0 0.0 0.0 2025-11-07 20:52:07
281 490 9 75 12517 60 Foot patch NULL 30051090 2 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 1000.0 3198.4 0.0 0.0 0.0 0.0 5.0 152.3 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 20:52:07
282 491 10 75 12517 33 Herbal Soap 100gm NULL 30049011 125 28.0 100.0 0.0 0.0 80.0 76.19 3.81 12500.0 3500.0 10000.0 0.0 0.0 0.0 0.0 5.0 476.19 76.19 476.19 10000.0 INR 0 0.0 0.0 2025-11-07 20:52:07
283 492 11 75 12517 34 Herbo2o Toothpaste NULL 33061090 33 45.0 199.0 0.0 0.0 159.2 134.92 24.28 6567.0 1485.0 5253.6 0.0 0.0 0.0 0.0 18.0 801.4 134.92 801.4 5253.6 INR 0 0.0 0.0 2025-11-07 20:52:07
284 493 12 75 12517 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 0.0 0.0 0.0 0.0 5.0 39.89 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:52:07
285 494 13 75 12517 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 0.0 0.0 0.0 0.0 5.0 39.89 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:52:07
286 495 14 75 12517 7 Morning Fresh Churan NULL 30049011 14 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2786.0 560.0 2228.8 0.0 0.0 0.0 0.0 5.0 106.13 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-07 20:52:07
287 496 15 75 12517 32 Neem Soap 100gm NULL 34011110 204 10.0 60.0 0.0 0.0 48.0 45.71 2.29 12240.0 2040.0 9792.0 0.0 0.0 0.0 0.0 5.0 466.29 45.71 466.29 9792.0 INR 0 0.0 0.0 2025-11-07 20:52:07
288 497 16 75 12517 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 0.0 0.0 0.0 0.0 5.0 38.06 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-07 20:52:07
289 498 17 75 12517 72 Pain Relief Patch NULL 30051090 3 200.0 800.0 0.0 0.0 640.0 609.52 30.48 2400.0 600.0 1920.0 0.0 0.0 0.0 0.0 5.0 91.43 609.52 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 20:52:07
290 499 18 75 12517 8 Piles Care NULL 30049011 8 250.0 899.0 0.0 0.0 719.2 684.95 34.25 7192.0 2000.0 5753.6 0.0 0.0 0.0 0.0 5.0 273.98 684.95 273.98 5753.6 INR 0 0.0 0.0 2025-11-07 20:52:07
291 500 19 75 12517 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-07 20:52:07
292 501 20 75 12517 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 0.0 0.0 0.0 0.0 5.0 137.14 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:52:07
293 502 21 75 12517 53 Terra care 2 kg NULL 3103100 1 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 1500.0 450.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1142.86 57.14 1200.0 INR 0 0.0 0.0 2025-11-07 20:52:07
294 503 22 75 12517 36 Toilet Cleaner 500ml NULL 3924101 25 30.0 150.0 0.0 0.0 120.0 101.69 18.31 3750.0 750.0 3000.0 0.0 0.0 0.0 0.0 18.0 457.63 101.69 457.63 3000.0 INR 0 0.0 0.0 2025-11-07 20:52:07
295 504 1 76 12517 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 0.0 0.0 0.0 0.0 18.0 92.75 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-07 20:59:30
296 505 2 76 12517 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 0.0 0.0 0.0 0.0 18.0 84.2 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-07 20:59:30
297 506 3 76 12517 37 Floor Cleaner 500ml NULL 3924101 2 80.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 160.0 318.4 0.0 0.0 0.0 0.0 18.0 48.57 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 20:59:30
298 507 4 76 12517 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 0.0 0.0 0.0 0.0 18.0 485.69 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-07 20:59:30
299 508 5 76 12517 46 Root Vitality Hair Oil NULL 3305901 6 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 324.0 1224.0 0.0 0.0 0.0 0.0 5.0 58.29 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-07 20:59:30
300 509 6 76 12517 36 Toilet Cleaner 500ml NULL 3924101 13 30.0 150.0 0.0 0.0 120.0 101.69 18.31 1950.0 390.0 1560.0 0.0 0.0 0.0 0.0 18.0 237.97 101.69 237.97 1560.0 INR 0 0.0 0.0 2025-11-07 20:59:30