18 replies [Last post]
Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
Was this information Helpful?

I built a site for a client and deployed using Ubercart for my cart solution. My client just shipped his first order to Canada (from Dallas) and he is reporting a large discrepancy in shipping.

Ubercart calculated $13.75 but my client was charged $28.75 by UPS.

Does anyone have insight into this issue? I don't even know where to start troubleshooting. His other shipping quotes, all domestic, have been accurate for the most part.

-=-
Troy Dalmasso

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Yikes. That's no good. Was

Yikes. That's no good.

Was there a discrepancy in the way Ubercart asks for a quote and the way the package was actually shipped? Look through the UPS settings in both the Admin section and in the product's shipping settings. I hope it's something like that which is easy to fix, rather than some peculiarity that UPS has with international shipments.

If you can't find anything, try getting quotes from ups.com. See what settings you need to get both prices. That will be a good clue.

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
UPS wants the "complete XML request and response files"

UPS are going to help me troubleshoot this but they have requested the "complete XML request and response files associated with the error".

Can anyone tell me how I'd go about getting these two files when using Ubercart?

At first, I was thinking I'd get this info from Firebug but then I remembered that this is just the ajax XML and not what they need. What they need is the communique between my server and the UPS server and I don't know where to start on this one.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: UPS wants the "complete XML request and response files"

Turn on the debug output from the shipping quotes settings. This will display the request and response XML to administrators on the checkout page.

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
UPS reviewed the XML and they say the quote was correct

UPS has reviewed the XML and they say the quote was correct.

I went to the UPS site and got a quote from there to compare to the one generated by Ubercart. In the UPS web based quoting system there is a separate section for international quotes; in Ubercart there is not.

Am I missing something that I still need to install for Ubercart to work with UPS quotes for shipments to Canada?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: UPS reviewed the XML and they say the quote was correct

How does the quote on ups.com compare to the data found in the XML request? There are a lot options that I didn't write code for, but they looked to be very special edge cases to me.

okeedoak's picture
Offline
Joined: 07/31/2008
Juice: 17
Re: Re: UPS reviewed the XML and they say the quote was correct

Were international shipments coded for? Or were they considered edge cases?

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
as mentioned...

As mentioned earlier in this thread, Ubercart calculated $13.75 but my client was charged $28.75 by UPS.

I don't see any options in Ubercart pertaining to international shipping. But when I go to the UPS site, International is an option. It is with this option that I get an accurate quote.

Please advise.

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
your question

I guess I don't understand your question. Should I look through the XML and see what was sent and try to compare it to the fields involved when using the site?

I'm not sure I'm going to understand all the XML but I will have a look.

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
attachment xml?

Should I post the XML here? Is there anything in it that would post a security issue?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: attachment xml?

You can post the XML here. Use <code> tags so that it formats easily. Censor your username and password in the first part, and any part of the addresses you don't want the Internet to know about. UPS built a nice schema, so human readers can generally figure out from the tag name what a particular piece of data means.

International orders were not specifically coded for because the documentation described a dozen different edge cases. I wouldn't think a shipment from the US to Canada would be hit by one of these, but I suppose I missed something.

okeedoak's picture
Offline
Joined: 07/31/2008
Juice: 17
Re: Re: attachment xml?

Were any of the other supported shipping carriers coded for international orders? USPS? Other?

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
here is the XML

I've removed the creds but the rest is there. If you see something that explains this please let me know?

AttachmentSize
debugForForum.txt 22.92 KB
Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
Re: here is the XML

I thought I'd mentioned here in this thread that there is an error in the XML. I've read back through the thread and I don't see anything regarding this. So perhaps, this is an issue I'd brought up with UPS directly but their support is email based and they really haven't been all that helpful.

Here is the error:

undefined:
Hard 111210: The requested service is unavailable between the selected locations.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Re: here is the XML

OK. I haven't added in the services that deal with international shipments. They probably weren't included because they were giving me errors when I was testing the module. I'll have to deal with that somehow so that they can be included. And also the Poland-specific services, I suppose.

TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: Re: Re: here is the XML

I really don't understand the conclusion that Ubercart has a problem - from everything that's been posted so far it appears Ubercart is doing exactly the right thing.

1) The XML being generated by Ubercart and attached to the above post is requesting individual quotes for each and every UPS service option you have enabled. NOT ALL of these services can be used for a package shipped from Texas to Ontario. For instance, "UPS 2nd Day Air A.M." is not an allowed service, hence the error message "The requested service is unavailable between the selected locations" (which only shows up in the debug view, after the error response return from UPS as shown in your attachment).

2) The service that *is* returning a quote is "UPS Standard Rate: $13.75". If I go to the UPS web site and use their quote form to determine the rate to send a 0.3 lb package, in customer supplied packaging, size 9"x7"x1", value $36.00 USD, from postal code 75225 to postal code L5N5K9, UPS tells me that it should cost about $12 today (the exact number varies depending on shipment date). This indicates that the UPS web site is GIVING THE SAME ANSWER as Ubercart, when the same parameters are input. Note that the UPS web site ALSO fails to show the services that generate the hard errors, indicating that those services are really not available for this combination of shipping parameters.

3) You said "UPS has reviewed the XML and they say the quote was correct."

I'm not claiming the UPS module is perfect, but there's no evidence that it's the cause of the discrepancy you're seeing. So your problem remains "Ubercart calculated $13.75 but my client was charged $28.75 by UPS" but the conclusion that Ubercart calculated wrong is just unwarranted by the facts you've presented so far.

It seems to me that the root of the problem is you're comparing apples to oranges. The parameters that Ubercart used to get a quote, and that I used to get a quote on the UPS web site, CANNOT be the same (or perhaps the only) parameters that UPS used to rate the actual package. You're the only one who can figure out what was different, but let me propose a few things to look for:

Was the package really sent by "UPS Standard" or did you ship via a faster (thus more expensive) method?

Was the package really 0.3 lbs, or is that just the weight of just the products - UPS bills based on the weight of the box, not its contents. A higher weight means a higher shipping cost.

Was the package 9"x7"x1" in Customer Packaging? Or did you use one of the UPS-supplied shipping envelopes such as the UPS Pak bubble-envelope? The package used affects the price as well as the available services.

Did you ship the package at a UPS customer counter, or did you mail it from a third-party retail outlet (which can and will charge more)?

For international shipping, did you check the box on the waybill to bill the duties and taxes to the *receiver*? Or did you check the box that bills these to the *shipper* ? If you left it blank, I think it gets billed to the shipper.

Did you specify Saturday Delivery on the waybill? Then you will pay more. (This is one of the options Lyle says he didn't code for - by default Ubercart assumes *no* Saturday Delivery).

Again, I'm just guessing - I don't know anything about how it was actually shipped. Figuring out why you paid $28 instead of the $13 quoted on the UPS website (and by Ubercart) is something that only you can do at this point. Find the difference(s) between the actual shipping conditions and the parameters that you type into the UPS website and you will have the answer. If all the parameters are the same, but UPS quoted you $13 and actually charged you $28, then UPS should be able to explain WHY. But since the UPS website and Ubercart are both quoting the same number, I don't get how you conclude this is a problem with Ubercart.

<tr>.
Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
project manager confirmed

My project manager used the web site and confirmed what the client reported. I haven't done this myself but I'm about to do so.

Thank you so much TR and Lyle for taking the time to look into this. I think we are closing to solving this mystery and I'm betting it was some other added expense (perhaps the duties)?

I'll report back what I find here in a bit.

Troy Dalmasso's picture
Offline
Joined: 08/06/2008
Juice: 106
Problem Solved!

The client must have assumed that duties and taxes were included in the quote. I don't know how my project manager got the same incorrect quote unless he too set shipper to pay the fees?

Anyway, the problem is solved now and I want to thank those that took the time to look into this.

Troy

okeedoak's picture
Offline
Joined: 07/31/2008
Juice: 17
Re: Re: Re: Re: here is the XML

Lyle appears to be saying that Ubercart doesn't handle international shipping. Is this right? Can anyone either confirm or deny?