Countries....need your list.

[ecommercegirl]

can someone forward me a list of the UK, australia, Us and Canada codes? i never heard of these countries listed in the admin.

thanks.!

[kobra]

Country codes are already in the admin > localization/taxes > countries > area

Both the 2 & 3 letter codes

[ecommercegirl]

thats not what I meant. I want an updated list without all these erronesous countries that are listed. I dont have time to look up each country and see where they are.. thanks

[kobra]

Thet are not errorneous countries- all are valid with country codes.

[swguy]

ecommercegirl, do you mean you ONLY want Canada, US, Aus, UK in your country table? If so, you might want to delete the existing table and repopulate it. See the zencart install script for a full list and just pull out the ones you want (or use a fancy sql delete if you prefer). Be sure to back up your d/b first!

good luck,
Scott

[ecommercegirl]

where would I find country codes for just us, uk, canada?

[swguy]

SELECT * FROM `countries` WHERE countries_name in ('United States', 'United Kingdom', 'Canada');

returns

38 Canada CA ...
222 United Kingdom GB ..
223 United States US ...

Scott