Forums / Built-in Shipping and Payment Modules / Restoring missing zones in zones table

Restoring missing zones in zones table

Views: 935

Results 1 to 3 of 3
4 Mar 2013, 8:10 PM
#1
ronlee67 avatar

ronlee67

Totally Zenned

Join Date:
Sep 2006
Location:
Colorado Springs CO USA
Posts:
519
Plugin Contributions:
0

Restoring missing zones in zones table

A few years ago when I first implemented a Zencart shop I did not fully understand how zones were to be configured.
I removed many county listings for the United Kingdom from the zones table. Now I need to restore these and start configuring my zones correctly.

Is there a way (perhaps with a sql script) to update the zones table in an existing shop with all of the counties/provinces/states etc. and their code as they were originally provided in the installation package?

www.aspenshopsonline.com - ZenCart 1.3.9h
www.wilkssupply.com - ZenCart 1.3.9h
www.un-du.net - ZenCart 1.3.8a

4 Mar 2013, 9:20 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Restoring missing zones in zones table

Do a test install of the same version
export the zones table from it and import same into the install where they are missing

Zen-Venom Get Bitten

5 Mar 2013, 10:04 AM
#3
fairestcape avatar

fairestcape

Totally Zenned

Join Date:
Mar 2008
Location:
Cape Town & London (depends on the season)
Posts:
2,957
Plugin Contributions:
0

Re: Restoring missing zones in zones table

You need to be aware of the RELATIONAL nature of the database before you tackle this.

SEVERAL tables are involved, and if you get the ID's wrong, you could seriously compromise a range of things - including customer addresses, address formats, countries, states/provinces, taxes, shipping and zone definitions.