No UPS Ship methods appear after adding a country

I attempted to add a Canada as a shipping destination in Zen version 1.3.7. To do this, I added Canada to zen_countries (38), and I added all the provinces to the zen_zones table. I also setup the GST tax for all Canada zones. UPS and Free Shipping are the only shipping modules I have enabled. When I try to check out with a Canadian address the UPS box appears under shipping method, but there are no options under it (they do appear for US orders). If I click "continue" the page refreshes with no errors, but I cannot advance to the payment page. What am I missing?

In phpMyAdmin ...

Do a search in your countries table for countries_id = 38 ... what do you get?

Do a search in your zones table for zone_country_id = 38 ... what do you get?

Ajeh:

In phpMyAdmin ...

Do a search in your countries table for countries_id = 38 ... what do you get?

Do a search in your zones table for zone_country_id = 38 ... what do you get?

Countries w/ country_id=38
38 Canada CA CAN 1

Zones w/ country_id=38
66 38 AB Alberta
67 38 BC British Columbia
68 38 MB Manitoba
69 38 NF Newfoundland
70 38 NB New Brunswick
71 38 NS Nova Scotia
72 38 NT Northwest Territories
73 38 NU Nunavut
74 38 ON Ontario
75 38 PE Prince Edward Island
76 38 QC Quebec
77 38 SK Saskatchewan
78 38 YT Yukon Territory

Check the address_format_id the default for Canada is 2 ...

Do any countries work on the shipping?

Ajeh:

Check the address_format_id the default for Canada is 2 ...

Do any countries work on the shipping?

The only other country I am using is US and the shipping works for US.

Have you an URL where we could perhaps peek at this? :smile:

Ajeh:

Have you an URL where we could perhaps peek at this? :smile:

http://fieldforest.net/store

If I use Canada for my address:

Test CA First Test CA Last
123 Somewhere
Toronto, ON M4B 1B4
Canada

I get on UPS shipping:

Shipping Method:
This is currently the only shipping method available to use on this order.
United Parcel Service (1 x 5.50lbs)

Aha! A clue ...

What Payment Modules are installed?

Do you have Zones set on the Payment Modules?

Ajeh:

Aha! A clue ...

What Payment Modules are installed?

Do you have Zones set on the Payment Modules?

Presently I have freeshipper and ups installed. For ups Shipping Zone is set to --none--. If I understand correctly, setting Shipping Zone to --none-- will apply ups to all zones. Correct?

Zone set to none means all that are defined ...

However, I am also wanting to know what Zones, if any are on the Payment Modules ...

What happens if you switch to Classic Template? Does the checkout work?

Ajeh:

Zone set to none means all that are defined ...

However, I am also wanting to know what Zones, if any are on the Payment Modules ...

What happens if you switch to Classic Template? Does the checkout work?

I'm only using the cc payment module and Payment Zone is set to --none--.

This is weird ...

Could you drop me a PM with access to your Admin that I could look to see if there is anything obvious here that is out of wack? :unsure:

Ajeh:

This is weird ...

Could you drop me a PM with access to your Admin that I could look to see if there is anything obvious here that is out of wack? :unsure:

I would like to, but I can't without my client's OK. I was hoping that there was something obvious that I missed in the shipping module. I will try to trouble shoot this some more on my own, and if I still can't get resolution I will get permission from the client to give you the admin login.

Get the Debug Tool from the Free Add Ons and see if it shows anything that might be wrong ...

I am suspecting something in the database ... but it could be a code issue ... :unsure:

Well, I have it working, but I'm not sure that it is functioning as expected.

Initially my UPS services were set to: 1DA, 2DA, 3DS, and GND

In the ups module I sent the the parameters passed to UPS to a file for both US and Canada:

US-
[sort_order] => 300
[tax_class] => 1
[tax_basis] => Shipping
[_upsProductCode] => GNDRES
[_upsOriginPostalCode] => 54157
[_upsOriginCountryCode] => US
[_upsDestPostalCode] => 54956
[_upsDestCountryCode] => US
[_upsRateCode] => Regular+Daily+Pickup
[_upsContainerCode] => 00
[_upsPackageWeight] => 2
[_upsResComCode] => 1

Canada-
[sort_order] => 300
[tax_class] => 1
[tax_basis] => Shipping
[_upsProductCode] => STD
[_upsOriginPostalCode] => 54157
[_upsOriginCountryCode] => US
[_upsDestPostalCode] => T1L1B3
[_upsDestCountryCode] => CA
[_upsRateCode] => Regular+Daily+Pickup
[_upsContainerCode] => 00
[_upsPackageWeight] => 2
[_upsResComCode] => 1

Notice that the _upsProductCode for US is GNDRES and for Canada it is STD. The same is true for the quoted values returned from UPS:

US-
[1DM] => 52.32
[1DA] => 21.01
[1DP] => 19.04
[2DA] => 12.32
[3DS] => 8.33
[GND] => 6.92

Canada-
[WXS] => 77.87
[XPD] => 75.70
[STD] => 21.89

When I saw that STD was being requested from UPS I checked the box in the ups module indicating that I wanted it as one of the services. Now "Canada Standard" appears as the only shipping option. Is this functioning the way one should expect? I would think I should still get the other shipping options for Canada. When STD is not enabled why is it requested from UPS and then not displayed as a shipping option? Do I have something configured incorrectly or is this the anticipated function? Is GND not allowed as a shipping option to Canada?

I found this too in the ups module (line 121):

if ( (zen_not_null($method)) && (isset($this->types[$method])) ) {
  $prod = $method;
  // BOF: UPS USPS
} else if ($order->delivery['country']['iso_code_2'] == 'CA') {
  $prod = 'STD';
  // EOF: UPS USPS
} else {
  $prod = 'GNDRES';
}

I guess it explains the behavior, but I don't understand the reason.

I have all checkboxes and on UPS for the same weight and zip code I get:

United Parcel Service (1 x 2.00lbs)
Worldwide Saver $81.81
Worldwide Expedited $79.44
Canada Standard $22.92