fx_franchise_order_product

4,737 rows · 33 columns · page 12 / 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
551 760 53 84 12517 50 Sun Screen NULL 330499 44 250.0 699.0 0.0 0.0 559.2 473.9 85.3 30756.0 11000.0 24604.8 0.0 0.0 0.0 0.0 18.0 3753.27 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 23:11:39
552 761 54 84 12517 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 0.0 0.0 0.0 0.0 5.0 53.33 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 23:11:39
553 762 55 84 12517 53 Terra care 2 kg NULL 3103100 71 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 106500.0 31950.0 85200.0 0.0 0.0 0.0 0.0 5.0 4057.14 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 23:11:39
554 763 56 84 12517 5 Thyro Care NULL 2936900 21 250.0 899.0 0.0 0.0 719.2 684.95 34.25 18879.0 5250.0 15103.2 0.0 0.0 0.0 0.0 5.0 719.2 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 23:11:39
555 764 57 84 12517 36 Toilet Cleaner 500ml NULL 3924101 180 30.0 150.0 0.0 0.0 120.0 101.69 18.31 27000.0 5400.0 21600.0 0.0 0.0 0.0 0.0 18.0 3294.92 101.69 3294.92 21600.0 INR 0 0.0 0.0 2025-11-07 23:11:39
556 765 58 84 12517 11 Vitamin B12 Drop NULL 2106909 126 190.0 749.0 0.0 0.0 599.2 570.67 28.53 94374.0 23940.0 75499.2 0.0 0.0 0.0 0.0 5.0 3595.2 570.67 3595.2 75499.2 INR 0 0.0 0.0 2025-11-07 23:11:39
557 766 59 84 12517 10 Vitamin D3 Drop NULL 2106909 131 190.0 749.0 0.0 0.0 599.2 570.67 28.53 98119.0 24890.0 78495.2 0.0 0.0 0.0 0.0 5.0 3737.87 570.67 3737.87 78495.2 INR 0 0.0 0.0 2025-11-07 23:11:39
558 767 60 84 12517 23 Women Fuel Juice NULL 2202999 6 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 11994.0 1200.0 9595.2 0.0 0.0 0.0 0.0 5.0 456.91 1523.05 456.91 9595.2 INR 0 0.0 0.0 2025-11-07 23:11:39
559 768 61 84 12517 54 Wonder grow 100ml NULL 3105 55 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 77000.0 27500.0 61600.0 0.0 0.0 0.0 0.0 5.0 2933.33 1066.67 2933.33 61600.0 INR 0 0.0 0.0 2025-11-07 23:11:39
560 769 1 85 12534 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 23:24:21
561 770 2 85 12534 70 Premium Hand belt NULL 9404 1 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 9999.0 600.0 7999.2 2.5 190.46 2.5 190.46 0.0 0.0 7618.29 380.91 7999.2 INR 0 0.0 0.0 2025-11-07 23:24:21
562 771 3 85 12534 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 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 23:24:21
563 772 4 85 12534 52 Bhoo sanjeevni 5 kg NULL 3103100 1 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 1600.0 450.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 1219.05 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 23:24:21
564 773 5 85 12534 38 Dish Wash 500ml NULL 3924101 5 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 425.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 155.93 140.34 920.0 INR 0 0.0 0.0 2025-11-07 23:24:21
565 774 6 85 12534 39 Fabric Wash 1000ml NULL 3924101 5 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2005.0 750.0 1604.0 9.0 122.34 9.0 122.34 0.0 0.0 271.86 244.68 1604.0 INR 0 0.0 0.0 2025-11-07 23:24:21
566 775 7 85 12534 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 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 23:24:21
567 776 8 85 12534 33 Herbal Soap 100gm NULL 30049011 61 28.0 100.0 0.0 0.0 80.0 76.19 3.81 6100.0 1708.0 4880.0 2.5 116.19 2.5 116.19 0.0 0.0 76.19 232.38 4880.0 INR 0 0.0 0.0 2025-11-07 23:24:21
568 777 9 85 12534 34 Herbo2o Toothpaste NULL 33061090 22 45.0 199.0 0.0 0.0 159.2 134.92 24.28 4378.0 990.0 3502.4 9.0 267.13 9.0 267.13 0.0 0.0 134.92 534.26 3502.4 INR 0 0.0 0.0 2025-11-07 23:24:21
569 778 10 85 12534 24 Immunomax 24/7 Caps NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 23:24:21
570 779 11 85 12534 25 Manicalcium Tablets NULL 2009899 2 95.0 399.0 0.0 0.0 319.2 304.0 15.2 798.0 190.0 638.4 2.5 15.2 2.5 15.2 0.0 0.0 304.0 30.4 638.4 INR 0 0.0 0.0 2025-11-07 23:24:21
571 780 12 85 12534 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-11-07 23:24:21
572 781 13 85 12534 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 23:24:21
573 782 14 85 12534 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 640.0 609.52 30.48 1600.0 400.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 609.52 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 23:24:21
574 783 15 85 12534 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-07 23:24:21
575 784 16 85 12534 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-07 23:24:21
576 785 17 85 12534 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 23:24:21
577 786 18 85 12534 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 23:24:21
578 787 19 85 12534 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 23:24:21
579 788 1 86 12529 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-07 23:32:19
580 789 2 86 12529 71 Bio magnetic water pad NULL 9404 2 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 9000.0 2000.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 3428.57 342.86 7200.0 INR 0 0.0 0.0 2025-11-07 23:32:19
581 790 3 86 12529 3 BP Care Capsules NULL 2936900 1 160.0 599.0 0.0 0.0 479.2 456.38 22.82 599.0 160.0 479.2 2.5 11.41 2.5 11.41 0.0 0.0 456.38 22.82 479.2 INR 0 0.0 0.0 2025-11-07 23:32:19
582 791 4 86 12529 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 23:32:19
583 792 5 86 12529 17 Memory Booster Juice NULL 2009899 2 120.0 349.0 0.0 0.0 279.2 265.9 13.29 698.0 240.0 558.4 2.5 13.29 2.5 13.29 0.0 0.0 265.9 26.59 558.4 INR 0 0.0 0.0 2025-11-07 23:32:19
584 793 6 86 12529 32 Neem Soap 100gm NULL 34011110 19 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1140.0 190.0 912.0 2.5 21.71 2.5 21.71 0.0 0.0 45.71 43.43 912.0 INR 0 0.0 0.0 2025-11-07 23:32:19
585 794 7 86 12529 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 23:32:19
586 795 8 86 12529 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-07 23:32:19
587 796 9 86 12529 46 Root Vitality Hair Oil NULL 3305901 3 54.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 162.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 194.29 29.14 612.0 INR 0 0.0 0.0 2025-11-07 23:32:19
588 797 10 86 12529 5 Thyro Care NULL 2936900 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 23:32:19
589 798 1 87 12543 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-07 23:34:58
590 799 2 87 12543 33 Herbal Soap 100gm NULL 30049011 15 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 420.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 76.19 57.14 1200.0 INR 0 0.0 0.0 2025-11-07 23:34:58
591 800 3 87 12543 34 Herbo2o Toothpaste NULL 33061090 7 45.0 199.0 0.0 0.0 159.2 134.92 24.28 1393.0 315.0 1114.4 9.0 85.0 9.0 85.0 0.0 0.0 134.92 169.99 1114.4 INR 0 0.0 0.0 2025-11-07 23:34:58
592 801 4 87 12543 17 Memory Booster 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 23:34:58
593 802 5 87 12543 32 Neem Soap 100gm NULL 34011110 27 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1620.0 270.0 1296.0 2.5 30.86 2.5 30.86 0.0 0.0 45.71 61.71 1296.0 INR 0 0.0 0.0 2025-11-07 23:34:58
594 803 6 87 12543 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 23:34:58
595 804 1 88 12544 40 Bamboo Brush NULL 96032100 2 25.0 110.0 0.0 0.0 88.0 74.58 13.43 220.0 50.0 176.0 9.0 13.43 9.0 13.43 0.0 0.0 74.58 26.85 176.0 INR 0 0.0 0.0 2025-11-07 23:38:29
596 805 2 88 12544 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-07 23:38:29
597 806 3 88 12544 38 Dish Wash 500ml NULL 3924101 1 85.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 85.0 184.0 9.0 14.04 9.0 14.04 0.0 0.0 155.93 28.07 184.0 INR 0 0.0 0.0 2025-11-07 23:38:29
598 807 4 88 12544 39 Fabric Wash 1000ml NULL 3924101 5 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2005.0 750.0 1604.0 9.0 122.34 9.0 122.34 0.0 0.0 271.86 244.68 1604.0 INR 0 0.0 0.0 2025-11-07 23:38:29
599 808 5 88 12544 34 Herbo2o Toothpaste NULL 33061090 30 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1350.0 4776.0 9.0 364.27 9.0 364.27 0.0 0.0 134.92 728.54 4776.0 INR 0 0.0 0.0 2025-11-07 23:38:29
600 809 6 88 12544 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-07 23:38:29