Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mexican zone install


ilustrate

Recommended Posts

i downloaded the Mexican Zone contribution but have no idea how to install it. it is basically just an sql file with all the states and values setup

 

like this but with all the states...

 

insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'AGS', 'Aguascalientes');

insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'BC', 'Baja California');

insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'BCS', 'Baja California Sur');

 

how do i import this? i use phpmyadmin for mySQL management.

 

do i upload this somewhere in the admin panel?

Link to comment
Share on other sites

I had the same problem... I downloaded the zones for the uk and it does have instructions, it has to be the same for mexico:

 

INSTALLATION

1. Start phpMyAdmin

2. Select 'Zones'

3. Click on 'SQL'

4. Click on 'Browse...' and select 'ukcounties.sql'

5. Click on 'Go'

6. You now have a complete list of UK counties in the database.

 

 

Just replace the name of the file with the one you have

Link to comment
Share on other sites

I had the same problem... I downloaded the zones for the uk and it does have instructions, it has to be the same for mexico:

 

INSTALLATION

1. Start phpMyAdmin

2. Select 'Zones'

3. Click on 'SQL'

4. Click on 'Browse...' and select 'ukcounties.sql'

5. Click on 'Go'

6. You now have a complete list of UK counties in the database.

Just replace the name of the file with the one you have

thanks a lot the instructions you gave me worked perfectly. i appreciate that.
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.
Note: Your post will require moderator approval before it will be visible.

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...