ibraheemnabeelfauzi
commented
2 years ago Hello @gkmbala please check the following doc as it contains many tips on how rectify this issue: https://docs.shipperhq.com/troubleshooting-matrixrates/#No_Shipping_Methods_are_Available
Thank you.
Hi, No shipping methods are not showing in checkout page, So I can't do the payment. Instance: M2.4.3-p1
I am getting some log details in debug.log file:
[2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = :region_id AND STRCMP(LOWER(dest_city),LOWER(:city))= 0 AND :postcode LIKE dest_zip )","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":region_id":0,":city":"Bradford",":postcode":"BD3 9TR",":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = :region_id AND dest_city='*' AND :postcode LIKE dest_zip )","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":region_id":0,":postcode":"BD3 9TR",":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = :region_id AND STRCMP(LOWER(dest_city),LOWER(:city))= 0 AND dest_zip ='*')","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":region_id":0,":city":"Bradford",":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = '0' AND STRCMP(LOWER(dest_city),LOWER(:city))= 0 AND dest_zip ='*')","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":city":"Bradford",":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = '0' AND dest_city ='*' AND :postcode LIKE dest_zip )","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":postcode":"BD3 9TR",":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Select: ["(website_id = :website_id)","AND (dest_country_id = :country_id AND dest_region_id = :region_id AND dest_city ='*' AND dest_zip ='*')","AND (condition_name = :condition_name)","AND (condition_from_value < :condition_value)","AND (condition_to_value >= :condition_value)"] [] [2022-04-14 14:27:52] main.DEBUG: Bindings: {":country_id":"GB",":region_id":0,":website_id":1,":condition_name":"package_value",":condition_value":149.98} [] [2022-04-14 14:27:52] main.DEBUG: SQL Results: [{"pk":"560","website_id":"1","dest_country_id":"GB","dest_region_id":"0","dest_city":"*","dest_zip":"*","dest_zip_to":"","condition_name":"package_value","condition_from_value":"124.9900","condition_to_value":"10000000.0000","price":"0.0000","cost":"0.0000","shipping_method":"2-3 Working Days"},{"pk":"563","website_id":"1","dest_country_id":"GB","dest_region_id":"0","dest_city":"*","dest_zip":"*","dest_zip_to":"","condition_name":"package_value","condition_from_value":"124.9900","condition_to_value":"10000000.0000","price":"4.9900","cost":"0.0000","shipping_method":"Next Working Day (only In-Stock items)"}] []