Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2006
    Posts
    87
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Countries....need your list.

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

    Both the 2 & 3 letter codes
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Dec 2006
    Posts
    87
    Plugin Contributions
    0

    Default 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

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Countries....need your list.

    Thet are not errorneous countries- all are valid with country codes.
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,514
    Plugin Contributions
    126

    Default 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
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  6. #6
    Join Date
    Dec 2006
    Posts
    87
    Plugin Contributions
    0

    Default Re: Countries....need your list.

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

  7. #7
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,514
    Plugin Contributions
    126

    Default 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
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. v154 List of EU Countries
    By irishshoppercom in forum General Questions
    Replies: 2
    Last Post: 3 Aug 2015, 10:14 AM
  2. Where can I find original Countries List?
    By anita in forum General Questions
    Replies: 1
    Last Post: 2 Feb 2007, 05:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg