Guest Posted March 10, 2006 Share Posted March 10, 2006 (edited) OK I have figured out how to get accurate enough quotes using dimensional suport to call this UPSXML part of the contribution almost gamma. I am referring to the newer one I included with the roll-up. All I ended up changing was the order by statement in the packaging query from volume to package_id. For those of you that I just lost, it goes like this, I was getting whacked out quotes from UPS because this contrib always chose the longest box to pack thing's in which caused UPS to send back qoutes for OVERSIZED packages. Once I changed the order by parameter it started choosing boxes that made more sense. Still not perfect but better by far. JanZ I also found out that the weight problem was being caused by the packaging info. I don't know who set those weights for empty boxes but Jeesh! give us a break will ya! This is the line of code that I am referring to: CODE$packages_query = tep_db_query("select *, (package_length * package_width * package_height) as volume from " . TABLE_PACKAGING . " order by volume;"); I changed it to this: CODE$packages_query = tep_db_query("select *, (package_length * package_width * package_height) as volume from " . TABLE_PACKAGING . " order by package_id;"); I am now resetting all info in the packaging table to more realistic weights and costs and then I want to make it so the packaging info can also be vendor specific. Edited March 10, 2006 by HallMarc Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.