UPS Compatibility with Ubercart Product Quote module

Wonderful work JoshuaPowell. I've adapted the UPS code to work for the general case, it appears that it was using the uc_product_quotes which didn't work on my system so I've updated to use uc_class_quotes for both the fedex and ups versions.

Let me know if you see any flaws in my logic. Hopefully we can get this pushed into UC core.

Ah, I didn't read the bottom half of your comment. I hadn't realized that there was a per product option as well which I would have clearly broken here. I'll amend and repost in a little bit.

Okay, here's the new patch that addresses the per-product and per-class shipping options for UPS. This also fixes a couple problems with the Fedex version and some documentation which I guess should probably be different patches but I'm eager to see if this patch breaks other people.

There is an issue with the UNION in SELECT queries in Drupal. Please refer to http://drupal.org/node/599664 .

voesech, is your patch in addition to uc_ups.patch listed above?

@sco_tt yes, you have to apply both my patch and the uc_ups.patch.

@jdexo in comment 2 on the page you posted the OP figured it out just fine. Have you not been able to use my patch because of this problem? For reference, this is running in production on one of our sites right now and working just fine.

@vosechu Sorry, I do not want to lead into misunderstanding, but I just ment that using UNION in your last patch in comment #4 849846-ups-update.patch (function uc_product_quote_services) will not work in drupal (provided that I correctly understand that patches should by applied sequentially up from post #1 till post #4).
Does your production use per-class quoting along with per-product quoting?
If I am somewhere mistaken, please, correct me.
Thank you.

Production uses both per class and per product. Unions are fine in Drupal but that issue you posted was sorta misguided. The OP figured out that he had a syntax problem in the next comment.

I doesn't work for me. It returns not only the shipping methods that I select but also quotes from USPS. After disabling and uninstalling and restoring ups module files it doesn't restore default settings, ubercart still shows only restricted shipping methods. I have to restore database to make it work normally.

Spongecat,

I'm sorry to hear that. Are you able to track down why this might be happening? The project we were using this on wasn't using USPS and I can't really test it without an account (nor do I have the time at the moment) but I'm very interested to see if you can find a fix and/or review code if you need someone to bounce ideas off of.

I actually gave up on this module for now. I was testing it on a live website and constant playing with database restore is not a good idea.