Post by tingwing » Mon Oct 14, 2019 12:34 pm

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

Attachments

weight shipping to all countries.JPG

weight shipping to all countries.JPG (111.49 KiB) Viewed 161 times

Last edited by tingwing on Mon Oct 14, 2019 8:21 pm, edited 1 time in total.

Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by thekrotek » 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.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by tingwing » Mon Oct 14, 2019 8:20 pm

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

Attachments

weight shipping to all countries2.JPG

weight shipping to all countries2.JPG (76.42 KiB) Viewed 112 times


my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by thekrotek » Mon Oct 14, 2019 8:41 pm

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.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: OSWorX and 34 guests