{"id":27,"date":"2009-06-22T17:36:00","date_gmt":"2009-06-22T17:36:00","guid":{"rendered":"http:\/\/www.codeboss.in\/web-funda\/?p=27"},"modified":"2009-06-22T17:36:00","modified_gmt":"2009-06-22T17:36:00","slug":"zen-cart-invalid-country-code-problem-with-shipping-and-payment-module","status":"publish","type":"post","link":"https:\/\/codeboss.in\/web-funda\/2009\/06\/22\/zen-cart-invalid-country-code-problem-with-shipping-and-payment-module\/","title":{"rendered":"Zen Cart &quot;Invalid Country Code&quot; problem with shipping and payment module"},"content":{"rendered":"<p>While using Zen Cart a common problem is the countries table. A lot of Shipping and Payment module throws errors and the reason is the invalid country code. The Zen Cart <span style=\"font-style:italic;\">countries<\/span> table at id 74 stores country &#8220;France, Metropolitan&#8221; with <span style=\"font-style:italic;\">countries_iso_code_2<\/span> => FX and <span style=\"font-style:italic;\">countries_iso_code_3<\/span> => FXX<\/p>\n<p>The problem is the ISO does not support FX as a valid country code. The ISO country and code list can be found here &#8211; <a href=\"http:\/\/www.iso.org\/iso\/english_country_names_and_code_elements\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iso.org\/iso\/english_country_names_and_code_elements<\/a><\/p>\n<p><span style=\"font-weight:bold;\">Soultion:<\/span><\/p>\n<p>In the Zen Cart database open tabel &#8220;countries&#8221;. For <span style=\"font-style:italic;\">countries_id<\/span> = 74 change <span style=\"font-style:italic;\">countries_iso_code_2<\/span> = FR and <span style=\"font-style:italic;\">countries_iso_code_3<\/span> = FRA. <\/p>\n<p>That will send the correct codes and hence there wont be any error. <\/p>\n<p>Also the row with id 74 can be deleted. But if a lot of customers have already registered by selecting country id 74, that wont be a good idea. Alternatively you can also do the following &#8211;<\/p>\n<p>In table <span style=\"font-style:italic;\">address_book<\/span> change the value for field <span style=\"font-style:italic;\">entry_country_id<\/span> to 73 for those whose value is 74<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While using Zen Cart a common problem is the countries table. A lot of Shipping and Payment module throws errors and the reason is the invalid country code. The Zen Cart countries table at id 74 stores country &#8220;France, Metropolitan&#8221; with countries_iso_code_2 => FX and countries_iso_code_3 => FXX The problem is the ISO does not&hellip; <a class=\"more-link\" href=\"https:\/\/codeboss.in\/web-funda\/2009\/06\/22\/zen-cart-invalid-country-code-problem-with-shipping-and-payment-module\/\">Continue reading <span class=\"screen-reader-text\">Zen Cart &quot;Invalid Country Code&quot; problem with shipping and payment module<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[57,66],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-php","tag-zen-cart","entry"],"_links":{"self":[{"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":0,"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"wp:attachment":[{"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codeboss.in\/web-funda\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}