Countries....need your list.

16 Jan 2007, 3:52 AM

#1

New Zenner

Join Date:: Dec 2006
Posts:: 87
Plugin Contributions:: 0

Countries....need your list.

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.!

16 Jan 2007, 8:10 AM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Countries....need your list.

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

Both the 2 & 3 letter codes

16 Jan 2007, 7:24 PM

#3

ecommercegirl

New Zenner

Join Date:: Dec 2006
Posts:: 87
Plugin Contributions:: 0

Re: Countries....need your list.

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

16 Jan 2007, 7:28 PM

#4

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Countries....need your list.

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

16 Jan 2007, 7:46 PM

#5

swguy

Administrator

Join Date:: Feb 2006
Location:: Tampa Bay, Florida
Posts:: 10,710
Plugin Contributions:: 56

Re: Countries....need your list.

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

16 Jan 2007, 7:54 PM

#6

ecommercegirl

New Zenner

Join Date:: Dec 2006
Posts:: 87
Plugin Contributions:: 0

Re: Countries....need your list.

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

16 Jan 2007, 11:33 PM

#7

swguy

Administrator

Join Date:: Feb 2006
Location:: Tampa Bay, Florida
Posts:: 10,710
Plugin Contributions:: 56

Re: Countries....need your list.

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