fx_franchise_order_product

4,737 rows · 33 columns · page 14 / 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
651 860 11 91 12548 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:54:32
652 861 12 91 12548 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 23:54:32
653 862 13 91 12548 41 Premium Coco Body Lotion NULL 3304300 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:54:32
654 863 14 91 12548 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 23:54:32
655 864 15 91 12548 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 23:54:32
656 865 16 91 12548 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 23:54:32
657 866 17 91 12548 50 Sun Screen NULL 330499 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 23:54:32
658 867 18 91 12548 53 Terra care 2 kg NULL 3103100 4 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 6000.0 1800.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 23:54:32
659 868 19 91 12548 36 Toilet Cleaner 500ml NULL 3924101 1 30.0 150.0 0.0 0.0 120.0 101.69 18.31 150.0 30.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.31 120.0 INR 0 0.0 0.0 2025-11-07 23:54:32
660 869 20 91 12548 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 23:54:32
661 870 1 92 12517 49 Anti Dandruff Serum NULL 3304999 20 250.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 5000.0 15984.0 0.0 0.0 0.0 0.0 18.0 2438.24 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-08 00:04:03
662 871 2 92 12517 44 Vital Glow Face Scrub NULL 3304300 20 71.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 1420.0 5200.0 0.0 0.0 0.0 0.0 18.0 793.22 220.34 793.22 5200.0 INR 0 0.0 0.0 2025-11-08 00:04:03
663 872 1 93 12516 49 Anti Dandruff Serum NULL 3304999 25 250.0 999.0 0.0 0.0 799.2 677.29 121.91 24975.0 6250.0 19980.0 9.0 1523.9 9.0 1523.9 0.0 0.0 677.29 3047.8 19980.0 INR 0 0.0 0.0 2025-11-08 00:05:04
664 873 2 93 12516 44 Vital Glow Face Scrub NULL 3304300 25 71.0 325.0 0.0 0.0 260.0 220.34 39.66 8125.0 1775.0 6500.0 9.0 495.76 9.0 495.76 0.0 0.0 220.34 991.53 6500.0 INR 0 0.0 0.0 2025-11-08 00:05:04
665 874 1 94 12517 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 0.0 0.0 0.0 0.0 18.0 2318.64 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-08 00:08:24
666 875 1 95 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-08 00:08:40
667 876 1 96 12517 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 0.0 0.0 0.0 0.0 18.0 1983.05 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-08 00:11:02
668 877 1 97 12516 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 9.0 991.52 9.0 991.52 0.0 0.0 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-08 00:11:41
669 878 1 98 12530 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-08 00:24:38
670 879 2 98 12530 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 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-08 00:24:38
671 880 3 98 12530 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 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-08 00:24:38
672 881 4 98 12530 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-08 00:24:38
673 882 5 98 12530 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 2.5 29.14 2.5 29.14 0.0 0.0 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-08 00:24:38
674 883 6 98 12530 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 9.0 118.98 9.0 118.98 0.0 0.0 101.69 237.97 1560.0 INR 0 0.0 0.0 2025-11-08 00:24:38
675 884 1 99 12521 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-08 00:35:07
676 885 2 99 12521 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-08 00:35:07
677 886 3 99 12521 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 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-08 00:35:07
678 887 4 99 12521 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-08 00:35:07
679 888 5 99 12521 60 Foot patch NULL 30051090 1 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 1999.0 500.0 1599.2 2.5 38.08 2.5 38.08 0.0 0.0 1523.05 76.15 1599.2 INR 0 0.0 0.0 2025-11-08 00:35:07
680 889 6 99 12521 33 Herbal Soap 100gm NULL 30049011 24 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2400.0 672.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 76.19 91.43 1920.0 INR 0 0.0 0.0 2025-11-08 00:35:07
681 890 7 99 12521 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-08 00:35:07
682 891 8 99 12521 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-08 00:35:07
683 892 9 99 12521 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-08 00:35:07
684 893 10 99 12521 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-08 00:35:07
685 894 11 99 12521 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-08 00:35:07
686 895 1 100 12527 33 Herbal Soap 100gm NULL 30049011 154 28.0 100.0 0.0 0.0 80.0 76.19 3.81 15400.0 4312.0 12320.0 2.5 293.33 2.5 293.33 0.0 0.0 76.19 586.67 12320.0 INR 0 0.0 0.0 2025-11-08 02:09:55
687 896 2 100 12527 34 Herbo2o Toothpaste NULL 33061090 36 45.0 199.0 0.0 0.0 159.2 134.92 24.28 7164.0 1620.0 5731.2 9.0 437.12 9.0 437.12 0.0 0.0 134.92 874.25 5731.2 INR 0 0.0 0.0 2025-11-08 02:09:55
688 897 3 100 12527 32 Neem Soap 100gm NULL 34011110 236 10.0 60.0 0.0 0.0 48.0 45.71 2.29 14160.0 2360.0 11328.0 2.5 269.71 2.5 269.71 0.0 0.0 45.71 539.43 11328.0 INR 0 0.0 0.0 2025-11-08 02:09:55
689 898 1 101 12527 70 Premium Hand belt NULL 9404 1 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 9999.0 600.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-08 02:21:46
690 899 2 101 12527 6 Asthma 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-08 02:21:46
691 900 3 101 12527 3 BP Care Capsules NULL 2936900 10 160.0 599.0 0.0 0.0 479.2 456.38 22.82 5990.0 1600.0 4792.0 2.5 114.09 2.5 114.09 0.0 0.0 456.38 228.19 4792.0 INR 0 0.0 0.0 2025-11-08 02:21:46
692 901 4 101 12527 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-08 02:21:46
693 902 5 101 12527 38 Dish Wash 500ml NULL 3924101 49 85.0 230.0 0.0 0.0 184.0 155.93 28.07 11270.0 4165.0 9016.0 9.0 687.66 9.0 687.66 0.0 0.0 155.93 1375.32 9016.0 INR 0 0.0 0.0 2025-11-08 02:21:46
694 903 6 101 12527 39 Fabric Wash 1000ml NULL 3924101 25 150.0 401.0 0.0 0.0 320.8 271.86 48.94 10025.0 3750.0 8020.0 9.0 611.7 9.0 611.7 0.0 0.0 271.86 1223.39 8020.0 INR 0 0.0 0.0 2025-11-08 02:21:46
695 904 7 101 12527 37 Floor Cleaner 500ml NULL 3924101 22 80.0 199.0 0.0 0.0 159.2 134.92 24.28 4378.0 1760.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-08 02:21:46
696 905 8 101 12527 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-08 02:21:46
697 906 9 101 12527 7 Morning Fresh Churan NULL 30049011 19 40.0 199.0 0.0 0.0 159.2 151.62 7.58 3781.0 760.0 3024.8 2.5 72.02 2.5 72.02 0.0 0.0 151.62 144.04 3024.8 INR 0 0.0 0.0 2025-11-08 02:21:46
698 907 10 101 12527 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-08 02:21:46
699 908 11 101 12527 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-08 02:21:46
700 909 12 101 12527 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-08 02:21:46