remove countries and zones

9 Oct 2007, 6:02 PM

New Zenner

Join Date:: Oct 2007
Posts:: 28
Plugin Contributions:: 0

remove countries and zones

Is there any way to remove countries and zones in bulk? Our company only sell in within the boarders of South Africa, so I need to remove all non relevant zones and countries, but removing them one by one is tedious. Please help

26 Jan 2008, 9:51 PM

softdux

New Zenner

Join Date:: Jan 2008
Location:: Johannesburg, South Africa
Posts:: 24
Plugin Contributions:: 0

Re: remove countries and zones

You'd be able todo this from the MySQL DB, if you know some SQL commands :)

26 Jan 2008, 11:22 PM

webskipper

Totally Zenned

Join Date:: Nov 2007
Location:: USA
Posts:: 876
Plugin Contributions:: 2

Re: remove countries and zones

I need help with this also.

I want to create a NOSHIP Zone.

I have downloaded one of the smaller sized SQL files to add a Zone.

I have also trimmed a list of ISO codes.

What information do I need to modify the SQL list of Countries to include Countries I will not do business with?

Which do I need?

ISO
2-alpha
ISO
3-alpha
IANA
Internet
UN
Vehicle
IOC
Olympic