fx_franchise_order_product

4,737 rows · 33 columns · page 7 / 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
301 510 1 77 12523 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-07 21:02:50
302 511 2 77 12523 4 Diabetic Care Capsules 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 21:02:50
303 512 3 77 12523 38 Dish Wash 500ml NULL 3924101 10 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 850.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 155.93 280.68 1840.0 INR 0 0.0 0.0 2025-11-07 21:02:50
304 513 4 77 12523 39 Fabric Wash 1000ml NULL 3924101 28 150.0 401.0 0.0 0.0 320.8 271.86 48.94 11228.0 4200.0 8982.4 9.0 685.1 9.0 685.1 0.0 0.0 271.86 1370.2 8982.4 INR 0 0.0 0.0 2025-11-07 21:02:50
305 514 5 77 12523 37 Floor Cleaner 500ml NULL 3924101 1 80.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 80.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 21:02:50
306 515 6 77 12523 33 Herbal Soap 100gm NULL 30049011 138 28.0 100.0 0.0 0.0 80.0 76.19 3.81 13800.0 3864.0 11040.0 2.5 262.86 2.5 262.86 0.0 0.0 76.19 525.71 11040.0 INR 0 0.0 0.0 2025-11-07 21:02:50
307 516 7 77 12523 34 Herbo2o Toothpaste NULL 33061090 24 45.0 199.0 0.0 0.0 159.2 134.92 24.28 4776.0 1080.0 3820.8 9.0 291.42 9.0 291.42 0.0 0.0 134.92 582.83 3820.8 INR 0 0.0 0.0 2025-11-07 21:02:50
308 517 8 77 12523 30 Iron Capsules 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 21:02:50
309 518 9 77 12523 15 Kidney Stone Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-07 21:02:50
310 519 10 77 12523 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-07 21:02:50
311 520 11 77 12523 25 Manicalcium Tablets NULL 2009899 1 95.0 399.0 0.0 0.0 319.2 304.0 15.2 399.0 95.0 319.2 2.5 7.6 2.5 7.6 0.0 0.0 304.0 15.2 319.2 INR 0 0.0 0.0 2025-11-07 21:02:50
312 521 12 77 12523 17 Memory Booster Juice NULL 2009899 9 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3141.0 1080.0 2512.8 2.5 59.83 2.5 59.83 0.0 0.0 265.9 119.66 2512.8 INR 0 0.0 0.0 2025-11-07 21:02:50
313 522 13 77 12523 7 Morning Fresh Churan NULL 30049011 8 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1592.0 320.0 1273.6 2.5 30.32 2.5 30.32 0.0 0.0 151.62 60.65 1273.6 INR 0 0.0 0.0 2025-11-07 21:02:50
314 523 14 77 12523 32 Neem Soap 100gm NULL 34011110 289 10.0 60.0 0.0 0.0 48.0 45.71 2.29 17340.0 2890.0 13872.0 2.5 330.29 2.5 330.29 0.0 0.0 45.71 660.57 13872.0 INR 0 0.0 0.0 2025-11-07 21:02:50
315 524 15 77 12523 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 21:02:50
316 525 16 77 12523 8 Piles Care 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-07 21:02:50
317 526 17 77 12523 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-07 21:02:50
318 527 18 77 12523 47 Premium Hair Care Shampoo NULL 3305109 6 150.0 699.0 0.0 0.0 559.2 532.57 26.63 4194.0 900.0 3355.2 2.5 79.89 2.5 79.89 0.0 0.0 532.57 159.77 3355.2 INR 0 0.0 0.0 2025-11-07 21:02:50
319 528 19 77 12523 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-07 21:02:50
320 529 20 77 12523 35 Sanitary Pad (15 pcs) NULL 9619001 29 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11020.0 1160.0 8816.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 8816.0 INR 0 0.0 0.0 2025-11-07 21:02:50
321 530 21 77 12523 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 21:02:50
322 531 22 77 12523 1 Stem Cell Powder NULL 2936900 1 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 2499.0 749.0 1999.2 2.5 47.6 2.5 47.6 0.0 0.0 1904.0 95.2 1999.2 INR 0 0.0 0.0 2025-11-07 21:02:50
323 532 23 77 12523 50 Sun Screen NULL 330499 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 9.0 85.3 9.0 85.3 0.0 0.0 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-11-07 21:02:50
324 533 24 77 12523 36 Toilet Cleaner 500ml NULL 3924101 16 30.0 150.0 0.0 0.0 120.0 101.69 18.3 2400.0 480.0 1920.0 9.0 146.44 9.0 146.44 0.0 0.0 101.69 292.88 1920.0 INR 0 0.0 0.0 2025-11-07 21:02:50
325 534 25 77 12523 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-07 21:02:50
326 535 26 77 12523 10 Vitamin D3 Drop NULL 2106909 2 190.0 749.0 0.0 0.0 599.2 570.67 28.54 1498.0 380.0 1198.4 2.5 28.54 2.5 28.54 0.0 0.0 570.67 57.07 1198.4 INR 0 0.0 0.0 2025-11-07 21:02:50
327 536 1 78 12520 48 glow face wash NULL 3304999 4 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 1000.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-07 21:04:47
328 537 2 78 12520 20 Premium Berry Juice 1000ml NULL 2936900 1 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 3499.0 750.0 3479.0 2.5 82.83 2.5 82.83 0.0 0.0 3313.33 165.67 3479.0 INR 0 0.0 0.0 2025-11-07 21:04:47
329 538 3 78 12520 49 Anti Dandruff Serum NULL 3304999 5 250.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1250.0 3996.0 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-07 21:04:47
330 539 4 78 12520 3 BP Care Capsules NULL 2936900 3 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1797.0 480.0 1437.6 2.5 34.23 2.5 34.23 0.0 0.0 456.38 68.46 1437.6 INR 0 0.0 0.0 2025-11-07 21:04:47
331 540 5 78 12520 4 Diabetic Care Capsules 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 21:04:47
332 541 6 78 12520 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 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 21:04:47
333 542 7 78 12520 33 Herbal Soap 100gm NULL 30049011 46 28.0 100.0 0.0 0.0 80.0 76.19 3.81 4600.0 1288.0 3680.0 2.5 87.62 2.5 87.62 0.0 0.0 76.19 175.24 3680.0 INR 0 0.0 0.0 2025-11-07 21:04:47
334 543 8 78 12520 34 Herbo2o Toothpaste NULL 33061090 19 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3781.0 855.0 3024.8 9.0 230.71 9.0 230.71 0.0 0.0 134.92 461.41 3024.8 INR 0 0.0 0.0 2025-11-07 21:04:47
335 544 9 78 12520 30 Iron Capsules 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-07 21:04:47
336 545 10 78 12520 16 Liver Care Juice NULL 2009899 8 120.0 349.0 0.0 0.0 279.2 265.9 13.29 2792.0 960.0 2233.6 2.5 53.18 2.5 53.18 0.0 0.0 265.9 106.36 2233.6 INR 0 0.0 0.0 2025-11-07 21:04:47
337 546 11 78 12520 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-07 21:04:47
338 547 12 78 12520 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-07 21:04:47
339 548 13 78 12520 17 Memory Booster Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 2.5 66.47 2.5 66.47 0.0 0.0 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-07 21:04:47
340 549 14 78 12520 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-07 21:04:47
341 550 15 78 12520 32 Neem Soap 100gm NULL 34011110 44 10.0 60.0 0.0 0.0 48.0 45.71 2.29 2640.0 440.0 2112.0 2.5 50.28 2.5 50.28 0.0 0.0 45.71 100.57 2112.0 INR 0 0.0 0.0 2025-11-07 21:04:47
342 551 16 78 12520 9 Omega 369 NULL 2936900 3 260.0 999.0 0.0 0.0 799.2 761.14 38.06 2997.0 780.0 2397.6 2.5 57.09 2.5 57.09 0.0 0.0 761.14 114.17 2397.6 INR 0 0.0 0.0 2025-11-07 21:04:47
343 552 17 78 12520 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-07 21:04:47
344 553 18 78 12520 41 Premium Coco Body Lotion NULL 3304300 5 250.0 699.0 0.0 0.0 559.2 473.9 85.3 3495.0 1250.0 2796.0 9.0 213.25 9.0 213.25 0.0 0.0 473.9 426.51 2796.0 INR 0 0.0 0.0 2025-11-07 21:04:47
345 554 19 78 12520 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-07 21:04:47
346 555 20 78 12520 35 Sanitary Pad (15 pcs) NULL 9619001 15 40.0 380.0 0.0 0.0 304.0 304.0 0.0 5700.0 600.0 4560.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 4560.0 INR 0 0.0 0.0 2025-11-07 21:04:47
347 556 21 78 12520 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 21:04:47
348 557 22 78 12520 50 Sun Screen NULL 330499 5 250.0 699.0 0.0 0.0 559.2 473.9 85.3 3495.0 1250.0 2796.0 9.0 213.25 9.0 213.25 0.0 0.0 473.9 426.51 2796.0 INR 0 0.0 0.0 2025-11-07 21:04:47
349 558 23 78 12520 44 Vital Glow Face Scrub NULL 3304300 10 71.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 710.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 220.34 396.61 2600.0 INR 0 0.0 0.0 2025-11-07 21:04:47
350 559 1 79 12518 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-07 21:51:44