How do I delet Countries I dont ship to

[acjceo]

Hello All,

I have a quick guestion. How do i delet Countries more than one at a time? Is there a file some where i can edit the Countries list all at one time? Cause I deleting them one at a time from the admin area.

Thanks for all your Help.

[sanguisdesign]

the countries are not kept in a file, they are kept in a database.
the easiest way to delete the countries is to use an interface like phpMyAdmin
and "browse" the countries table and delete the once that you dont need.

[nj2miami]

Old post but maybe it will help someone out.

A quicker way, but to be used only if you feel comfortable.

In my case, I only wanted US and Canada to show. You will change the process based on what you want displayed. This is ideal if you are looking to only display a few of the many 230+ countries.

In a SQL Query window from whatever SQL manager you are using:

DELETE FROM `zen_countries` WHERE `zen_countries`.`countries_id` > X and `zen_countries`.`countries_id` < Y

Canada is country_id 38 and the US is country_id 223.

So for me, I ran the query 3 times.

#1 (This removes everything before Canada)
DELETE FROM `zen_countries` WHERE `zen_countries`.`countries_id` > 0 and `zen_countries`.`countries_id` < 38

#2 (This removes everything after Canada and before US)
DELETE FROM `zen_countries` WHERE `zen_countries`.`countries_id` > 38 and `zen_countries`.`countries_id` < 223

#3 (This removes everything after US)
DELETE FROM `zen_countries` WHERE `zen_countries`.`countries_id` > 223

These 3 steps will remove all countries except US & Canada.

Now, obviously, if you wanted other countries to remain, then your steps will be different, but this will allow you to remove blocks of countries at a time instead of single click deleting them.

[DrByte]

And all of this is obsolete information when Zen Cart v2.0 is released, because there will be an option to disable any countries you don't want to ship to, directly from within the admin interface. And, in that situation, you probably won't want all the country records to be missing from your database, so don't delete if you don't really need to.

[mithaimate]

suppose using the sql ..i delete the countries from the table ...as i ship only within India .. can my customer from the US (who may want to send gifts to india ) .. enter their US address..and the shipping adress remains within India?

[DrByte]

No. If you delete them, then all parts of the store that use them will be unable to use them.

[Richard.Tung]

Is there an alternative if you don't want to delete the countries from the sql database... because I just want to show Canada and USA in the signup form when they register so that they know that I only ship to those 2 countries right now?
If not... I guess I would have to write a shipping disclaimer...

Thanks..