how to add all countries once at system-localisation-Geo zones(solved)

hi,
I would like to use "Weight Based Shipping" to all countries.

how to add all countries once at system-localisation-Geo zones,not need to select from dropdown menu one by one?
as you know ,there is 233 countries.

Thanks

You don't need any script for this. Create a geo zone, remember it's ID (for example, 9), then open PHPMyAdmin and enter this:

INSERT INTO oc_zone_to_geo_zone (`country_id`, `zone_id`, `geo_zone_id`, `date_added`, `date_modified`) SELECT country_id, 0, 9, '2015-04-06 07:55:18', '0000-00-00 00:00:00' FROM oc_country

Replace 9 with your actual geo zone ID and dates with the one you want. And you're done.

thekrotek wrote: ↑

Mon Oct 14, 2019 4:13 pm

You don't need any script for this. Create a geo zone, remember it's ID (for example, 9), then open PHPMyAdmin and enter this:

INSERT INTO oc_zone_to_geo_zone (`country_id`, `zone_id`, `geo_zone_id`, `date_added`, `date_modified`) SELECT country_id, 0, 9, '2015-04-06 07:55:18', '0000-00-00 00:00:00' FROM oc_country

Replace 9 with your actual geo zone ID and dates with the one you want. And you're done.

thanks ,it works,
by the way 1)the "0000-00-00 00:00:00" need to be changed to some date like "2015-04-06 07:55:18".
2)move your mouse's cursor to the "edit" button of the geo zone,you will the the geo_zone_id number at the bottom link line
please take a look at the attached image

tingwing wrote: ↑

Mon Oct 14, 2019 8:20 pm

by the way 1)the "0000-00-00 00:00:00" need to be changed to some date like "2015-04-06 07:55:18".

Not necessary. date_modified can be set to zero.