Author Topic: Adding countries and zones  (Read 411 times)

Offline aje001

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Adding countries and zones
« 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.

Offline maxter

  • Newbie
  • *
  • Posts: 49
  • Karma: +15/-0
    • View Profile
Re: Adding countries and zones
« Reply #1 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.

Offline aje001

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Adding countries and zones
« Reply #2 on: June 22, 2017, 09:19:45 PM »
Thanks, I'll give that a try

 

Cheap Prom dresses 2018