Zone Rate shipping not working for Spain

[elnaraniall]

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!

[Ajeh]

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

[elnaraniall]

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

[Ajeh]

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

[Ajeh]

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?

[elnaraniall]

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.

[Ajeh]

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

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?

[elnaraniall]

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!

[Ajeh]

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

[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