UPS Shipping Module

Canada Address not Working - UPS Shipping Module

Canada Address not Working

by plamastus » Sun Apr 11, 2021 1:45 am

Hi,

Phoenix 1.0.8.0
PHP 7.4.16

A Canadian customer told me that the UPS shipping would not work for his address:
Patrick Test
10-1205 Riverside Dr
London, N6H 0H7
AB, Canada

I tried and it doesn't show it either. Any thoughts?
patrick
plamastus
VIP Member
VIP Member
Posts: 83
Joined: Fri Mar 12, 2021 2:09 am
Contact:

Re: Canada Address not Working

by zipurman » Sun Apr 11, 2021 2:18 am

Well for starters... London is in Ontario not Alberta!
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Canada Address not Working

by plamastus » Mon Apr 12, 2021 6:17 pm

Hi,

Phoenix 1.0.8.0
PHP 7.4.16

Looking more into the problem, customers from Canada are all having this problem. Apparently the Province/State is not saved in the sql db. What I see is entry_zone_id, but not Province/State and when it gets updated it doesn't save province/state. They are all defaulting to Alberta.
Is there a way the entry_zone_id can be used with this module instead?

Thanks,
patrick
plamastus
VIP Member
VIP Member
Posts: 83
Joined: Fri Mar 12, 2021 2:09 am
Contact:

Re: Canada Address not Working

by zipurman » Mon Apr 12, 2021 6:35 pm

The orders delivery_state would be responsible for populating this info in the shipping modules. The entry_zone_id is part of the address_book and has nothing to do with the shipping of an order. When an order is created and the address is chosen, it comes from the address_book and should save to the orders table. Something else must be broken.

You should check to see what their entry_zone_id in their address is and then make sure there are matching zones in your zones table.

Also check your countries table to make sure Canada's countries_id matches what you are seeing in zones and address_book for Canadian Addresses.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Canada Address not Working

by zipurman » Mon Apr 12, 2021 7:02 pm

I went to your store and was able to checkout with UPS showing and I am in Saskatchewan Canada. Maybe it's old imported customers that may have imported with issues? This could be fixed with a few SQL statements if it's just a matter of fixing Country IDs.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Canada Address not Working

by plamastus » Mon Apr 12, 2021 7:42 pm

Whenever you have the chance I would love that country IDs fix. Canada is the Important for now.

Thanks
patrick
plamastus
VIP Member
VIP Member
Posts: 83
Joined: Fri Mar 12, 2021 2:09 am
Contact:

Re: Canada Address not Working

by zipurman » Mon Apr 12, 2021 8:11 pm

Okay, I had a look. That is not the issue. Your data looks good, all of the addresses in Canada line up with the proper zone etc.

The shipping mod loads the $order object and uses the info in $order->delivery['state'] to target the state. The entry_zone_id etc that I was mentioning above, is fine ... it doesnt come into play until after the order is created ... the issue is before that. Something isnt working with the assignment of the $order->delivery array and that is breaking the shipping.

You have my email. Please email me details on a login that is having this issue and I can have a closer look.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Canada Address not Working

by plamastus » Tue Apr 13, 2021 12:56 pm

Hi,

My mistake I had Country incorrectly I actually typt my "County" ...Oooppps...

Thanks @zipurman for the help!!!
patrick
plamastus
VIP Member
VIP Member
Posts: 83
Joined: Fri Mar 12, 2021 2:09 am
Contact: