Zone Rate shipping not working for Spain

Hi!

I need help with a problem I have not been able to fix. The problem is the following:

I use Zone Rates for my international shipping. For some reason it works for all countries except for Spain. I do have the correct ISO code for the country : ES.

I have tried entering the code as : ES, Es, es, I also tried adding SP just in case, but nothing seems to work. During checkout, customers who specify their country as Spain, are unable to proceed past the shipping calculation step, because the shopping cart does not recognize their country and does not calculate any shipping for them.

Can anybody offer any advice?

Thank you!

Could you paste the settings you are using for your various Zones here?

The idea is to Copy & Paste so we can look for odd typos ... :smile:

Yes, sure, here it is , Spain is my first zone all by itself since it is the "troublemaker"

Zone 1 Countries
ES

Zone 1 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Zone 1 Handling Fee
0

Zone 2 Countries
AU,AT,BE,FR,DE,CH,DK,GB,NL,IT,IE,PT,NZ,BR,FI,RU,AR,NO,PL,SG,TR,CA, SE

Zone 2 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Zone 2 Handling Fee
0

Zone 3 Countries
RO,MX

Zone 3 Shipping Table
2:27.00,3:28.00,4:32.00

Zone 3 Handling Fee
0

What do you think this table is saying for the shipping charges, if it were to be working:

Zone 1 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Also, what is suppose to happen after 5lbs? Right now, it looks like free shipping as nothing is defined ...

Are you repeating the rate for 1, 2 and 3lbs for any particular reason?

Yes, I am repeating the rate for a reason and I do not have anything that can go over 5 pounds, even when multiple items are purchased.

That is not my problem (I wish it were, it is a real easy one to fix). My problem is that zone rates do not work for Spain - that is the only country it doesn't work for. Everything else works great, but, I say again, it seems when a customer selects Spain as their country, I think somehow it is not getting recognized, because the shopping cart during checkout cannot go past the shipping step.

I can set up my test site for Spain ... :unsure:

What version of Zen Cart are you running?

Clean install or an Upgrade?

What do you see on the Version information in the Tools ... Server Info ...

Do you see Spain in your list of Countries?

Can you browse your database via phpMyAdmin and sort on the ISO codes and check for duplicates?

Can you check your address book table and make sure that it has the right codes in it for your test account for Spain?

Hi Ajeh!

What version of Zen Cart are you running?--------- I am running Zen Cart 1.3.8.a,

Clean install or an Upgrade?---------------- It was an upgrade from version 1.2.6

What do you see on the Version information in the Tools ... Server Info ...

Server Information
Server Host: box505.bluehost.com (74.220.219.105) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.27-3_1.intel.BHsmp Database: MySQL 5.0.45-community-log
Server Date: 10/23/2008 09:46:36 Database Date: 10/23/2008 09:46:36
Server Up Time: 09:46:36 up 11:05, 1 user, load average: 7.66, 8.40, 8.72 HTTP Server: Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 4.4.9 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 2,897 kB Database Index Size: 976 kB

Do you see Spain in your list of Countries? Yes, I do, I checked it!!

Can you browse your database via phpMyAdmin and sort on the ISO codes and check for duplicates? Yes, I did check, and there were no duplicates.

Can you check your address book table and make sure that it has the right codes in it for your test account for Spain?
I did get into the address book but I do not know how to check for the right codes - would you give me a hint?

Thank you so much for all of your help so far!

There was a bug, many moons ago, that did this and it was fixed ...

Are you sure all of the files on the server are current and up to date with the v1.3.8a files?

On checking the address_book you would want to make sure the right data is in the:
entry_postcode
entry_city
entry_state
entry_country_id
entry_zone_id

fields for the record ...

I do believe all files on the server are current with the 1.3.8.a version, but how can I check that to be 100% sure?

I checked the address book and all data appears to be correct, The ID assigned to Spain for all countries is 195, and for zone_ID for the customers from Spain I see different values, I guess they depend on where in Spain the customer is from, and the ones I see for zone_ID are: 131, 152, 161, 162. I am not quite sure where to look to make sure these numbers are correct

Just in case it would give you more info, here is what I find in (I will copy paste the first few rows from each table):

"Countries"

countries_ID :
Rows countries_id
1 181
1 182
1 183
1 184
1 185

countries_name:

Rows countries_name
1 Afghanistan
1 Albania
1 Algeria
1 American Samoa

countries_ISO_code_2: (it goes similarly for the countries_ISO_code_3, but with 3 letter codes)

Rows countries_iso_code_2
1 AD
1 AE
1 AF
1 AG
1 AI
1 AL

address_format_id:

Rows address_format_id
234 1
2 2
1 4
2 5

In "Address Book":

entry_zone_ID:
Rows entry_zone_id
4 131
2 139
3 152
9 161
2 162
2 170

elnaraniall:

I do believe all files on the server are current with the 1.3.8.a version, but how can I check that to be 100% sure?

I checked the address book and all data appears to be correct, The ID assigned to Spain for all countries is 195, and for zone_ID for the customers from Spain I see different values, I guess they depend on where in Spain the customer is from, and the ones I see for zone_ID are: 131, 152, 161, 162. I am not quite sure where to look to make sure these numbers are correct

I use Beyond Compare from scootersoftware.com to validate files ...

NOTE: The purchased version can do FTP compares vs the demo version which can compare files in two directories on your computer ...

As to the rows you posted, they don't have any meaning unless they are the correct rows and looked at in the correct context ... :smile:

Do I find out if they are the correct rows by verifying if all files are current with 1.3.8a?

I am thinking it is one of the php files on your server ...

how do I know which one?

You did not post all of your settings for the Zone Rate zone shipping module ...

This is what I have and ES works ...

Zone Based Rates

Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes


Zone 1 Countries
US,CA

Zone 1 Shipping Table
3:8.50,7:10.50,99:20.00

Zone 1 Handling Fee
0

Zone 2 Countries
ES

Zone 2 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Zone 2 Handling Fee
0

Zone 3 Countries


Zone 3 Shipping Table
3:8.50,7:10.50,99:20.00

Zone 3 Handling Fee
0

NOTE: I would use instead of:

1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

the settings for:

3:30.00,4:32.00,5:36.00

OK, here are all settings I have:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Zone 1 Countries
ES

Zone 1 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Zone 1 Handling Fee
0

Zone 2 Countries
AU,AT,BE,FR,DE,CH,DK,GB,NL,IT,IE,PT,NZ,BR,FI,RU,AR,NO,PL,SG,TR,CA, SE

Zone 2 Shipping Table
1:30.00,2:30.00,3:30.00,4:32.00,5:36.00

Zone 2 Handling Fee
0

Zone 3 Countries
RO,MX

Zone 3 Shipping Table
2:27.00,3:28.00,4:32.00

Zone 3 Handling Fee

Do you even see the other information that mine is set to on your site such as:

Skip Countries, use a comma separated list of the two character ISO country codes

Yes, I do see it, when I am in "edit" mode!