quick way to delete all countries except for 2?

7 Sep 2007, 6:05 PM

New Zenner

Join Date:: Sep 2007
Posts:: 12
Plugin Contributions:: 0

quick way to delete all countries except for 2?

I am only going to be selling to 2 countries and was wondering if there is a quick way to delete the rest of them without going through the 2 step process for each one.

TIA

8 Sep 2007, 4:52 PM

jeking

Totally Zenned

Join Date:: Oct 2005
Location:: Chicago, IL USA
Posts:: 1,592
Plugin Contributions:: 0

Re: quick way to delete all countries except for 2?

I have gone into phpMyAdmin and you can check several rows at a time. It's quicker than through Zen but still takes some time.

8 Sep 2007, 6:30 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: quick way to delete all countries except for 2?

NOTE: based on the assumption that these are the 2 countries_id you do not wish to delete are 223 and 38 ...

NOTE: this also assumes you are wise enough to make a database backup before running these commands ...

DELETE from countries WHERE countries_id != 223 and countries_id !=38;

DELETE from zones WHERE zone_country_id != 223 and zone_country_id != 38;