[SOLVED] Bulk assigning countries to Zones?

[Mandala]

Hi

I have decided to split shipping in to 2 zones:

United Kingdom
International

Is there a way to bulk assign all other countries to 'International' - instead of going through 240+ entries and individually assigning them to International?

Thanks!

[rocky]

The only way is to use an SQL query like the following in phpMyAdmin:

UPDATE `ps_country` SET `id_zone` = 1 WHERE `id_country` != 17

Change ps_ to your database prefix and 1 to the ID of the "International" zone. Change 17 to the ID of the United Kingdom country if it is different than the default ID. This query to change the zone of all countries except "United Kingdom" to the "International" zone.

[Mandala]

Thanks for the reply - but I had already gone through it the slow way

[printmeaparty]

I have the same issue , somehow zones got missing , now i get the error no courier available , how can i edit these in bulk anyone can help? see the image for what i mean

[printmeaparty]

ok this worked! thank you