Adding Countries

[pietpetoors]

I would like to add some more countries to my Zen Cart. Mine only show some African countries. I installed Zencart 4 years ago and cannot remember if the other countries were there and if I deleted them or if I have to add each country separately.

I do not know all the provinces and areas in each country. Is there a file I can upload to add all the countries?

[RodG]

I would like to add some more countries to my Zen Cart. Mine only show some African countries. I installed Zencart 4 years ago

It's probably time to upgrade.

and cannot remember if the other countries were there and if I deleted them or if I have to add each country separately.

You probably deleted them (a common newbie mistake)

I do not know all the provinces and areas in each country. Is there a file I can upload to add all the countries?

From the latest ZenCart Distro file there are a couple of files in the /zc_install/sql folder - one called mysql_latin1.sql and another called mysql_utf8.sql that contain what appears to be a full list of the countries and zones. Backup your database, then use the ZenCart tools->InstallSQL_patches to 'import' the relevant sql file for your database (probably mysql_latin1.sql).

Cheers
RodG

ps. This is mainly an educated guess as to what you need to do. If someone gives different advice I suggest you do as they instruct rather than this.

[pietpetoors]

Thank you I will try that

[pietpetoors]

When I run it I get the following message:
"WARNING: An Error occurred, please refresh the page and try again"
Does not matter if I copy and paste the contents of those files or if I upload the file I get the same error message

[RodG]

When I run it I get the following message:
"WARNING: An Error occurred, please refresh the page and try again"
Does not matter if I copy and paste the contents of those files or if I upload the file I get the same error message

This sounds like a security error.

You have two options here.

1) Determine what is causing the error (and fix it)
2) Perform the update using phpMyAdmin

There is however a caveat with using option#2 in that if your Database tables have a prefix (eg "zen_") you'll need to edit the .sql file to add this prefix.

The quickest/easiest way to do this is with a text editor (not a word processor) with a search/replace function.

EG: Search for
"INSERT INTO countries"
Replace with
"INSERT INTO zen_countries"

and
Search for
"INSERT INTO zones"
Replace with
"INSERT INTO zen_zones"

and
Search for
"INSERT INTO configuration"
Replace with
"INSERT INTO zen_configuration"

Using phpmyadmin isn't difficult (but back up your database first). The process is
1) Select your database
2) Click the 'import' button and select your modified .sql file
3) Press 'Go'.

Alternatively, you can select the database, press the SQL button, then paste the code into the text box (Followed by Go).

If your database tables *don't* have a prefix then no edits are needed, simply import or paste the code.
If unsure, just look at the table names using phpmyadmin.

Cheers
RodG

[pietpetoors]

I added all the countries, but now I have some duplicates like:

Spain Albacete Albacete
Spain Alicante Alicante
Spain Alicante Alicante
Spain Almeria Almeria
Spain Almer�a Almer�a
Spain Asturias Asturias
Spain Asturias Asturias
Spain Avila Avila Info
Spain �lava �lava
Spain �vila �vila
Spain Badajoz Badajoz
Spain Badajoz Badajoz

Does it matter which ones I delete and which ones I leave?
Any idea why some show this symbol � ?

[nwjh]

If you have upgraded (carefully) to 1.5.4, There is an "Add Countries" button at the bottom of the countries listing in the Location/Taxes > Countries.