Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Languages and Zones


dazed and confused

Recommended Posts

Hello I am a extreme newbie at all this and right now I am very confused. I am wanted to change the zone but it won't allow me. Here is what I have done - I have changed the country to Australia and right now I want to change the zone what do I do???? I really need the help of all you wonderful experts out there.. :)

Link to comment
Share on other sites

  • 1 year later...

There are no zones for Australia in the original Oscommerce database so they need to be added.

 

REMEMBER TO BACKUP YOUR DATABASE BEFORE MAKING ANY CHANGES

 

 

In phpmyadmin run this query to add zones to the zone file

 

INSERT INTO `zones` (`zone_country_id`, `zone_code`, `zone_name`) VALUES
(13, 'ACT', 'Australian Capital Territory'),
(13, 'NSW', 'New South Wales'),
(13, 'NT', 'Northern Territory'),
(13, 'QLD', 'Queensland'),
(13, 'SA', 'South Australia'),
(13, 'TAS', 'Tasmania'),
(13, 'VIC', 'Victoria'),
(13, 'WA', 'Western Australia');

 

If these are not correct in spelling make whatever changes are needed keeping the same format. You can also add others before running your query if needed. Your countries_id is '13' so keep that consistent as it will not show in your zone drop down if it is anything different.

 

Good luck

Edited by KDM
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...