Zen Cart "Invalid Country Code" problem with shipping and payment module

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 “France, Metropolitan” with countries_iso_code_2 => FX and countries_iso_code_3 => FXX

The problem is the ISO does not support FX as a valid country code. The ISO country and code list can be found here – http://www.iso.org/iso/english_country_names_and_code_elements

Soultion:

In the Zen Cart database open tabel “countries”. For countries_id = 74 change countries_iso_code_2 = FR and countries_iso_code_3 = FRA.

That will send the correct codes and hence there wont be any error.

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 –

In table address_book change the value for field entry_country_id to 73 for those whose value is 74