fx_franchise_order_product

4,737 rows · 33 columns · page 17 / 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
801 1010 9 107 12517 39 Fabric Wash 1000ml NULL 3924101 96 150.0 401.0 0.0 0.0 320.8 271.86 48.94 38496.0 14400.0 30796.8 0.0 0.0 0.0 0.0 18.0 4697.82 271.86 4697.82 30796.8 INR 0 0.0 0.0 2025-11-09 12:31:27
802 1011 10 107 12517 19 Fat loss Juice 500 ml NULL 30049011 5 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 7495.0 1250.0 7395.0 0.0 0.0 0.0 0.0 5.0 352.14 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-09 12:31:27
803 1012 11 107 12517 37 Floor Cleaner 500ml NULL 3924101 200 80.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 16000.0 31840.0 0.0 0.0 0.0 0.0 18.0 4856.95 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-09 12:31:27
804 1013 12 107 12517 2 Heart Care Capsules NULL 2936900 4 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1700.0 4796.8 0.0 0.0 0.0 0.0 5.0 228.42 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-09 12:31:27
805 1014 13 107 12517 33 Herbal Soap 100gm NULL 30049011 5 28.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 140.0 400.0 0.0 0.0 0.0 0.0 5.0 19.05 76.19 19.05 400.0 INR 0 0.0 0.0 2025-11-09 12:31:27
806 1015 14 107 12517 24 Immunomax 24/7 Caps NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 0.0 0.0 0.0 0.0 5.0 285.52 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
807 1016 15 107 12517 30 Iron Capsules NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
808 1017 16 107 12517 15 Kidney Stone Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 0.0 0.0 0.0 0.0 5.0 66.48 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
809 1018 17 107 12517 18 Lady Care Juice 500ml NULL 2009899 5 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 1250.0 5996.0 0.0 0.0 0.0 0.0 5.0 285.52 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
810 1019 18 107 12517 16 Liver Care Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 0.0 0.0 0.0 0.0 5.0 66.48 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
811 1020 19 107 12517 25 Manicalcium Tablets NULL 2009899 5 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1995.0 475.0 1596.0 0.0 0.0 0.0 0.0 5.0 76.0 304.0 76.0 1596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
812 1021 20 107 12517 12 Melatonin Drop NULL 2106909 4 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2996.0 760.0 2396.8 0.0 0.0 0.0 0.0 5.0 114.13 570.67 114.13 2396.8 INR 0 0.0 0.0 2025-11-09 12:31:27
813 1022 21 107 12517 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 0.0 0.0 0.0 0.0 5.0 37.9 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-09 12:31:27
814 1023 22 107 12517 32 Neem Soap 100gm NULL 34011110 1 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 10.0 48.0 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 0 0.0 0.0 2025-11-09 12:31:27
815 1024 23 107 12517 9 Omega 369 NULL 2936900 5 260.0 999.0 0.0 0.0 799.2 761.14 38.06 4995.0 1300.0 3996.0 0.0 0.0 0.0 0.0 5.0 190.29 761.14 190.29 3996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
816 1025 24 107 12517 28 Ortho Joint Shield NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 0.0 0.0 0.0 0.0 5.0 285.52 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
817 1026 25 107 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-09 12:31:27
818 1027 26 107 12517 13 Premium NONI VEG caps NULL 2936900 6 150.0 501.0 0.0 0.0 400.8 381.71 19.09 3006.0 900.0 2404.8 0.0 0.0 0.0 0.0 5.0 114.51 381.71 114.51 2404.8 INR 0 0.0 0.0 2025-11-09 12:31:27
819 1028 27 107 12517 29 Shilajith NULL 30049011 5 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 9000.0 1250.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-09 12:31:27
820 1029 28 107 12517 26 Spirulina Cap NULL 2009899 5 190.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 950.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
821 1030 29 107 12517 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 0.0 0.0 0.0 0.0 5.0 102.74 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-09 12:31:27
822 1031 30 107 12517 36 Toilet Cleaner 500ml NULL 3924101 200 30.0 150.0 0.0 0.0 120.0 101.69 18.31 30000.0 6000.0 24000.0 0.0 0.0 0.0 0.0 18.0 3661.02 101.69 3661.02 24000.0 INR 0 0.0 0.0 2025-11-09 12:31:27
823 1032 1 108 12516 20 Premium Berry Juice 1000ml NULL 2936900 2 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.66 6998.0 1500.0 6958.0 2.5 165.66 2.5 165.66 0.0 0.0 3313.33 331.33 6958.0 INR 0 0.0 0.0 2025-11-09 13:31:28
824 1033 2 108 12516 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 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-09 13:31:28
825 1034 3 108 12516 13 Premium NONI VEG caps NULL 2936900 5 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2505.0 750.0 2004.0 2.5 47.72 2.5 47.72 0.0 0.0 381.71 95.43 2004.0 INR 0 0.0 0.0 2025-11-09 13:31:28
826 1035 1 109 12516 33 Herbal Soap 100gm NULL 30049011 50 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1400.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 76.19 190.48 4000.0 INR 0 0.0 0.0 2025-11-09 13:35:25
827 1036 1 110 12516 33 Herbal Soap 100gm NULL 30049011 50 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1400.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 76.19 190.48 4000.0 INR 0 0.0 0.0 2025-11-09 13:37:52
828 1037 1 111 12516 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-09 13:42:51
829 1038 1 112 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 13:54:46
830 1039 2 112 12516 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-09 13:54:46
831 1040 3 112 12516 13 Premium NONI VEG caps NULL 2936900 10 150.0 501.0 0.0 0.0 400.8 381.71 19.09 5010.0 1500.0 4008.0 2.5 95.43 2.5 95.43 0.0 0.0 381.71 190.86 4008.0 INR 0 0.0 0.0 2025-11-09 13:54:46
832 1041 1 113 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 14:07:35
833 1042 2 113 12516 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-09 14:07:35
834 1043 3 113 12516 13 Premium NONI VEG caps NULL 2936900 5 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2505.0 750.0 2004.0 2.5 47.72 2.5 47.72 0.0 0.0 381.71 95.43 2004.0 INR 0 0.0 0.0 2025-11-09 14:07:35
835 1044 1 114 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 14:17:22
836 1045 2 114 12516 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-09 14:17:22
837 1046 3 114 12516 14 Premium Aloe Vera VEG caps NULL 2936900 10 100.0 359.0 0.0 0.0 287.2 273.52 13.68 3590.0 1000.0 2872.0 2.5 68.38 2.5 68.38 0.0 0.0 273.52 136.76 2872.0 INR 0 0.0 0.0 2025-11-09 14:17:22
838 1047 4 114 12516 13 Premium NONI VEG caps NULL 2936900 10 150.0 501.0 0.0 0.0 400.8 381.71 19.09 5010.0 1500.0 4008.0 2.5 95.43 2.5 95.43 0.0 0.0 381.71 190.86 4008.0 INR 0 0.0 0.0 2025-11-09 14:17:22
839 1048 1 115 12516 48 glow face wash NULL 3304999 1 250.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 250.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-09 14:26:51
840 1049 1 116 12516 72 Pain Relief Patch NULL 30051090 10 200.0 800.0 0.0 0.0 640.0 609.52 30.48 8000.0 2000.0 6400.0 2.5 152.38 2.5 152.38 0.0 0.0 609.52 304.76 6400.0 INR 0 0.0 0.0 2025-11-09 14:29:51
841 1050 1 117 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 15:58:33
842 1051 1 118 12526 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-09 16:16:59
843 1052 2 118 12526 37 Floor Cleaner 500ml NULL 3924101 20 80.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 1600.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-09 16:16:59
844 1053 3 118 12526 32 Neem Soap 100gm NULL 34011110 100 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 1000.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-11-09 16:16:59
845 1054 4 118 12526 46 Root Vitality Hair Oil NULL 3305901 20 54.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 1080.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 194.29 194.29 4080.0 INR 0 0.0 0.0 2025-11-09 16:16:59
846 1055 5 118 12526 36 Toilet Cleaner 500ml NULL 3924101 20 30.0 150.0 0.0 0.0 120.0 101.69 18.3 3000.0 600.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-11-09 16:16:59
847 1056 1 119 12557 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 16:21:33
848 1057 1 120 12539 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 16:35:54
849 1058 1 121 12524 70 Premium Hand belt NULL 9404 5 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 49995.0 3000.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-09 16:36:10
850 1059 2 121 12524 40 Bamboo Brush NULL 96032100 10 25.0 110.0 0.0 0.0 88.0 74.58 13.42 1100.0 250.0 880.0 9.0 67.12 9.0 67.12 0.0 0.0 74.58 134.24 880.0 INR 0 0.0 0.0 2025-11-09 16:36:10