fx_franchise_order_product

4,737 rows · 33 columns · page 11 / 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
501 710 3 84 12517 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 0.0 0.0 0.0 0.0 5.0 1656.67 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-07 23:11:39
502 711 4 84 12517 70 Premium Hand belt NULL 9404 18 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 179982.0 10800.0 143985.6 0.0 0.0 0.0 0.0 5.0 6856.46 7618.29 6856.46 143985.6 INR 0 0.0 0.0 2025-11-07 23:11:39
503 712 5 84 12517 61 Radiation chip NULL 902221 10 325.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 3250.0 7992.0 0.0 0.0 0.0 0.0 18.0 1219.12 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-07 23:11:39
504 713 6 84 12517 31 Vegan Plant Protein Powder NULL 21061000 2 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 5998.0 2000.0 4798.4 0.0 0.0 0.0 0.0 5.0 228.5 2284.95 228.5 4798.4 INR 0 0.0 0.0 2025-11-07 23:11:39
505 714 7 84 12517 79 ALKALINE JUG NULL 8421 5 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 74995.0 17500.0 59996.0 0.0 0.0 0.0 0.0 18.0 9151.93 10168.81 9151.93 59996.0 INR 0 0.0 0.0 2025-11-07 23:11:39
506 715 8 84 12517 21 All Fuel Juice NULL 22029990 5 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 12495.0 1750.0 12395.0 0.0 0.0 0.0 0.0 5.0 590.24 2360.95 590.24 12395.0 INR 0 0.0 0.0 2025-11-07 23:11:39
507 716 9 84 12517 6 Asthma Care NULL 30049011 24 250.0 899.0 0.0 0.0 719.2 684.95 34.25 21576.0 6000.0 17260.8 0.0 0.0 0.0 0.0 5.0 821.94 684.95 821.94 17260.8 INR 0 0.0 0.0 2025-11-07 23:11:39
508 717 10 84 12517 40 Bamboo Brush NULL 96032100 85 25.0 110.0 0.0 0.0 88.0 74.58 13.42 9350.0 2125.0 7480.0 0.0 0.0 0.0 0.0 18.0 1141.02 74.58 1141.02 7480.0 INR 0 0.0 0.0 2025-11-07 23:11:39
509 718 11 84 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 68 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 108800.0 30600.0 87040.0 0.0 0.0 0.0 0.0 5.0 4144.76 1219.05 4144.76 87040.0 INR 0 0.0 0.0 2025-11-07 23:11:39
510 719 12 84 12517 71 Bio magnetic water pad NULL 9404 6 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 27000.0 6000.0 21600.0 0.0 0.0 0.0 0.0 5.0 1028.57 3428.57 1028.57 21600.0 INR 0 0.0 0.0 2025-11-07 23:11:39
511 720 13 84 12517 3 BP Care Capsules NULL 2936900 74 160.0 599.0 0.0 0.0 479.2 456.38 22.82 44326.0 11840.0 35460.8 0.0 0.0 0.0 0.0 5.0 1688.61 456.38 1688.61 35460.8 INR 0 0.0 0.0 2025-11-07 23:11:39
512 721 14 84 12517 4 Diabetic Care Capsules NULL 2936900 45 250.0 899.0 0.0 0.0 719.2 684.95 34.25 40455.0 11250.0 32364.0 0.0 0.0 0.0 0.0 5.0 1541.14 684.95 1541.14 32364.0 INR 0 0.0 0.0 2025-11-07 23:11:39
513 722 15 84 12517 38 Dish Wash 500ml NULL 3924101 197 85.0 230.0 0.0 0.0 184.0 155.93 28.07 45310.0 16745.0 36248.0 0.0 0.0 0.0 0.0 18.0 5529.36 155.93 5529.36 36248.0 INR 0 0.0 0.0 2025-11-07 23:11:39
514 723 16 84 12517 39 Fabric Wash 1000ml NULL 3924101 166 150.0 401.0 0.0 0.0 320.8 271.86 48.94 66566.0 24900.0 53252.8 0.0 0.0 0.0 0.0 18.0 8123.31 271.86 8123.31 53252.8 INR 0 0.0 0.0 2025-11-07 23:11:39
515 724 17 84 12517 19 Fat loss Juice 500 ml NULL 30049011 7 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 10493.0 1750.0 10353.0 0.0 0.0 0.0 0.0 5.0 493.0 1408.57 493.0 10353.0 INR 0 0.0 0.0 2025-11-07 23:11:39
516 725 18 84 12517 22 Fit Fuel Juice NULL 2009899 4 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 7996.0 800.0 7916.0 0.0 0.0 0.0 0.0 5.0 376.95 1884.76 376.95 7916.0 INR 0 0.0 0.0 2025-11-07 23:11:39
517 726 19 84 12517 37 Floor Cleaner 500ml NULL 3924101 125 80.0 199.0 0.0 0.0 159.2 134.92 24.28 24875.0 10000.0 19900.0 0.0 0.0 0.0 0.0 18.0 3035.59 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 23:11:39
518 727 20 84 12517 60 Foot patch NULL 30051090 52 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 103948.0 26000.0 83158.4 0.0 0.0 0.0 0.0 5.0 3959.92 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 23:11:39
519 728 21 84 12517 58 Green shield 250ml NULL 3105 14 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 35000.0 11200.0 28000.0 0.0 0.0 0.0 0.0 5.0 1333.33 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 23:11:39
520 729 22 84 12517 55 Grow master 500ml NULL 3105 33 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 66990.0 28050.0 53592.0 0.0 0.0 0.0 0.0 5.0 2552.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 23:11:39
521 730 23 84 12517 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 23:11:39
522 731 24 84 12517 33 Herbal Soap 100gm NULL 30049011 1593 28.0 100.0 0.0 0.0 80.0 76.19 3.81 159300.0 44604.0 127440.0 0.0 0.0 0.0 0.0 5.0 6068.57 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 23:11:39
523 732 25 84 12517 34 Herbo2o Toothpaste NULL 33061090 597 45.0 199.0 0.0 0.0 159.2 134.92 24.28 118803.0 26865.0 95042.4 0.0 0.0 0.0 0.0 18.0 14497.99 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 23:11:39
524 733 26 84 12517 24 Immunomax 24/7 Caps NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 0.0 0.0 0.0 0.0 5.0 171.31 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 23:11:39
525 734 27 84 12517 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 0.0 0.0 0.0 0.0 5.0 513.71 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 23:11:39
526 735 28 84 12517 15 Kidney Stone Juice NULL 2009899 11 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3839.0 1320.0 3071.2 0.0 0.0 0.0 0.0 5.0 146.25 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 23:11:39
527 736 29 84 12517 18 Lady Care Juice 500ml NULL 2009899 16 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 23984.0 4000.0 19187.2 0.0 0.0 0.0 0.0 5.0 913.68 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 23:11:39
528 737 30 84 12517 16 Liver Care Juice NULL 2009899 46 120.0 349.0 0.0 0.0 279.2 265.9 13.3 16054.0 5520.0 12843.2 0.0 0.0 0.0 0.0 5.0 611.58 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 23:11:39
529 738 31 84 12517 25 Manicalcium Tablets NULL 2009899 23 95.0 399.0 0.0 0.0 319.2 304.0 15.2 9177.0 2185.0 7341.6 0.0 0.0 0.0 0.0 5.0 349.6 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 23:11:39
530 739 32 84 12517 12 Melatonin Drop NULL 2106909 38 190.0 749.0 0.0 0.0 599.2 570.67 28.53 28462.0 7220.0 22769.6 0.0 0.0 0.0 0.0 5.0 1084.27 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 23:11:39
531 740 33 84 12517 17 Memory Booster Juice NULL 2009899 52 120.0 349.0 0.0 0.0 279.2 265.9 13.3 18148.0 6240.0 14518.4 0.0 0.0 0.0 0.0 5.0 691.35 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 23:11:39
532 741 34 84 12517 56 Micro magic 500ml NULL 3105 24 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 48720.0 20400.0 38976.0 0.0 0.0 0.0 0.0 18.0 5945.49 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 23:11:39
533 742 35 84 12517 7 Morning Fresh Churan NULL 30049011 157 40.0 199.0 0.0 0.0 159.2 151.62 7.58 31243.0 6280.0 24994.4 0.0 0.0 0.0 0.0 5.0 1190.21 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 23:11:39
534 743 36 84 12517 32 Neem Soap 100gm NULL 34011110 3122 10.0 60.0 0.0 0.0 48.0 45.71 2.29 187320.0 31220.0 149856.0 0.0 0.0 0.0 0.0 5.0 7136.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 23:11:39
535 744 37 84 12517 9 Omega 369 NULL 2936900 57 260.0 999.0 0.0 0.0 799.2 761.14 38.06 56943.0 14820.0 45554.4 0.0 0.0 0.0 0.0 5.0 2169.26 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 23:11:39
536 745 38 84 12517 28 Ortho Joint Shield NULL 2009899 14 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 6300.0 16788.8 0.0 0.0 0.0 0.0 5.0 799.47 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 23:11:39
537 746 39 84 12517 72 Pain Relief Patch NULL 30051090 52 200.0 800.0 0.0 0.0 640.0 609.52 30.48 41600.0 10400.0 33280.0 0.0 0.0 0.0 0.0 5.0 1584.76 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 23:11:39
538 747 40 84 12517 8 Piles Care NULL 30049011 49 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44051.0 12250.0 35240.8 0.0 0.0 0.0 0.0 5.0 1678.13 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 23:11:39
539 748 41 84 12517 41 Premium Coco Body Lotion NULL 3304300 25 250.0 699.0 0.0 0.0 559.2 473.9 85.3 17475.0 6250.0 13980.0 0.0 0.0 0.0 0.0 18.0 2132.54 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 23:11:39
540 749 42 84 12517 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 0.0 0.0 0.0 0.0 5.0 68.38 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 23:11:39
541 750 43 84 12517 47 Premium Hair Care Shampoo NULL 3305109 78 150.0 699.0 0.0 0.0 559.2 532.57 26.63 54522.0 11700.0 43617.6 0.0 0.0 0.0 0.0 5.0 2077.03 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 23:11:39
542 751 44 84 12517 13 Premium NONI VEG caps NULL 2936900 27 150.0 501.0 0.0 0.0 400.8 381.71 19.09 13527.0 4050.0 10821.6 0.0 0.0 0.0 0.0 5.0 515.31 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 23:11:39
543 752 45 84 12517 45 Premium radiance face serum NULL 3304991 16 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 19200.0 4800.0 15360.0 0.0 0.0 0.0 0.0 18.0 2343.05 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 23:11:39
544 753 46 84 12517 43 Quench Kiss Lip Balm NULL 3304300 15 35.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 525.0 2388.0 0.0 0.0 0.0 0.0 18.0 364.27 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 23:11:39
545 754 47 84 12517 46 Root Vitality Hair Oil NULL 3305901 59 54.0 255.0 0.0 0.0 204.0 194.29 9.71 15045.0 3186.0 12036.0 0.0 0.0 0.0 0.0 5.0 573.14 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 23:11:39
546 755 48 84 12517 57 Safe guard 250ml NULL 3105 24 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 60000.0 19200.0 48000.0 0.0 0.0 0.0 0.0 5.0 2285.71 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 23:11:39
547 756 49 84 12517 35 Sanitary Pad (15 pcs) NULL 9619001 370 40.0 380.0 0.0 0.0 304.0 304.0 0.0 140600.0 14800.0 112480.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 112480.0 INR 0 0.0 0.0 2025-11-07 23:11:39
548 757 50 84 12517 29 Shilajith NULL 30049011 21 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 37800.0 5250.0 30240.0 0.0 0.0 0.0 0.0 5.0 1440.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 23:11:39
549 758 51 84 12517 26 Spirulina Cap NULL 2009899 30 190.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 5700.0 21576.0 0.0 0.0 0.0 0.0 5.0 1027.43 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 23:11:39
550 759 52 84 12517 1 Stem Cell Powder NULL 2936900 55 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 137445.0 41195.0 109956.0 0.0 0.0 0.0 0.0 5.0 5236.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 23:11:39