AbanteCart Community

eCommerce construction => Installation and Configuration => Configuration => Topic started by: aje001 on March 30, 2017, 04:09:19 AM

Title: Adding countries and zones
Post by: aje001 on March 30, 2017, 04:09:19 AM
Hi everyone, I apologise if this has already been covered somewhere on the foums, but I have not been able to find the answer...

When I initially set up my store, I deleted all the countries and zones instead of just turning them off.  Now we are expanding, and are going to start offering shipping to other countries.

My question is: Is there a quick/easy way to add a bunch of countries and zones?  Either a bulk import of a list, or re-install all the standard ones that come with the AbanteCart install.  I'd rather not have to sit there and manually add each country and zone individually if I can help it...

Thanks in advance.
Title: Re: Adding countries and zones
Post by: maxter on April 02, 2017, 07:12:52 PM
Unfortunately, there is not easy way if you non-technical.
You will need to do SQL insert into your database.

You can locate original database with all countries in here:
https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database.sql

Look for:
INSERT INTO `ac_countries`
and
INSERT INTO `ac_country_descriptions`

Do not forget to clear Abantecart cache after direct inserts or updates into database.
Title: Re: Adding countries and zones
Post by: aje001 on June 22, 2017, 09:19:45 PM
Thanks, I'll give that a try