cgchris99 Posted April 6, 2003 Share Posted April 6, 2003 Am I the the only one that realizes that the ups module calcs incorrectly? If your shipping based on weight and you get daily pickup then your calculated shipping is incorrect. There is a new setting besides the daily pickup setting. At ups.com you can see it. It is "Bill Shipping to UPS Account". If you set this yes, it gives you a cheaper shipping rate. If it is no then it is a more expensive rate. The oscommerce UPS module doesn't have this option. And since the ups module uses qcostcgi.cgi I don't think this option is available to set anyway. I have see this make an error of $11 in the shipping calculation. If I am wrong and there is way to correct this in oscommerce, please let me know. Thanks Link to comment Share on other sites More sharing options...
Ajeh Posted April 6, 2003 Share Posted April 6, 2003 Did you report this as a bug? Link to comment Share on other sites More sharing options...
cgchris99 Posted April 6, 2003 Author Share Posted April 6, 2003 No, how do I report it as a bug? Thanks Link to comment Share on other sites More sharing options...
Ajeh Posted April 6, 2003 Share Posted April 6, 2003 You can post a bug at: http://www.oscommerce.com/community/bugs Link to comment Share on other sites More sharing options...
cgchris99 Posted April 7, 2003 Author Share Posted April 7, 2003 Thanks, I posted it as a bug. I hope someone can fix it. But it looks like it will not be simple. Link to comment Share on other sites More sharing options...
Millie Posted April 10, 2003 Share Posted April 10, 2003 I've been searching the forums top to bottom for answers to this issue... I had to set the configuration to "customer counter" to avoid under charging on shipping which occurs if set to the correct status of "Daily Pickup" but this means that shipping is esculated on most, but not all orders. The calculations are inconsistant and only a small percentage are close to actual cost. Results do not match the UPS online calculator or UPS World Ship. Is anyone else comparing calculations with other UPS tools and noticing that the calculations do not match? Anyone found a resolution? I eager to resolve this but have limited skills. My old cart used qcost_dss.cgi and calculated without problems and I do not think "Bill Shipping to UPS Account" was configured in that... I'm just mentioning that because it may be another clue to resolving the problem, or not. Millie Link to comment Share on other sites More sharing options...
cgchris99 Posted April 10, 2003 Author Share Posted April 10, 2003 I compared it to ups.com and this is how I found out that there was a problem. I contacted UPS and I did receive an email stating that they were escalating the problem but that was a couple of days ago. I have not heard back from them. I ship some heavy items. Some are 70lbs and this can cause a your shipping to be off by about $11 usd. Link to comment Share on other sites More sharing options...
Ajeh Posted April 10, 2003 Share Posted April 10, 2003 I tried several online calculations and got matches on them. Can you give some examples that did not match? Link to comment Share on other sites More sharing options...
Millie Posted April 10, 2003 Share Posted April 10, 2003 I just checked calculations on 4 orders to generate some examples. I'll post my settings however I am toggling the Pickup Method to generatte the examples. 2 out of 4 produce inaccurate costs. It happens to be the larger packages and I wonder if it has something to do with the "Larger packages - percentage increase" setting which I have set at 20. The math doesn't calculate correctly for that to be true though. United Parcel Service Enable UPS Shipping True UPS Pickup Method RDP UPS Packaging? CP Residential Delivery? RES Handling Fee .015 Tax Class --none-- Shipping Zone --none-- Sort order of display. 0 Shipping Methods 1DA, 1DP, 2DA, 3DS, GND 33823 10.8# RDP $7.19 CC $ 9.61 Actual $7.18 14470 26.4# RDP $9.21 Low CC $12.41 Actual $10.98 38104 2.25# RDP $5.55 CC $ 7.30 Actual 5.54 04622 24# RDP $10.59 Low CC $14.35 Actual $12.36 Link to comment Share on other sites More sharing options...
cgchris99 Posted April 10, 2003 Author Share Posted April 10, 2003 The ones I notice that have the biggest errors are of course the heavy items. Put an item in your oscommerce store that weighs 50 lbs. I created a dummy customer that was across the country, like California. Make sure your shipping module is set regular daily pickup. Put the 50# item in your cart. See what the calculation for shipping is, write it down. Now go to ups.com enter the same information. Regular daily pickup, your package, etc. Right below Daily pickup you will see "Are you billing shipping charges to a UPS Account" Set it to YES Write down the shipping cost. Now go back and set "Are you billing shipping charges to a UPS account=NO You will see that with it set to NO the cost is much higher than when it is set to YES bill shipping = yes UPS Ground cost $39.32 bill shipping = no UPS Ground cost $28.43 Link to comment Share on other sites More sharing options...
Millie Posted April 10, 2003 Share Posted April 10, 2003 I agree that the cost is higher if you do not select "Billing to UPS Account" but the results do not indicate that it is the cause of the calculation error, using my examples above. I would expect that the actual cost would match if that was the source of the problem. Example 14470 26.4# RDP $9.21 Low CC $12.41 Actual $10.98 Billing to UPS Account = No $14.18 Millie Link to comment Share on other sites More sharing options...
cgchris99 Posted April 10, 2003 Author Share Posted April 10, 2003 So you are saying there are even more problems then just the fact that we cannot select "billing ups shipping account =yes" Link to comment Share on other sites More sharing options...
Millie Posted April 10, 2003 Share Posted April 10, 2003 I'm just brainstorming, looking for clues. However, since a similar UPS app works on another cart I use without this setting I think it is is default that "billing ups shipping account =yes" and I think it is possible another setting may be causing the problem. Since there are only 2 of us who have noticed a problem, maybe we have a setting configured incorrectly... I hope to find an answer! Millie Link to comment Share on other sites More sharing options...
Wild.Willy Posted April 10, 2003 Share Posted April 10, 2003 I am also having the same problem. I was wondering if anyone has looked at the code so we can set our systems for: "billing ups shipping account =yes" I also agree though that this may not be the actual cause of the problem but its a start to get our shipping numbers closer to actual. Willy Link to comment Share on other sites More sharing options...
Guest Posted April 10, 2003 Share Posted April 10, 2003 I have the same problem as you all ... There is no set pattern that I can find either... Some of the prices are with a few cents and some I am under charging by a couple $$'s ... Link to comment Share on other sites More sharing options...
Millie Posted April 12, 2003 Share Posted April 12, 2003 I've experimented with everything I can think of and can not find the cause of the calculation error. It seems like residential delivery surcharges are not being included in the shipping cost to me but I'm not 100% positive. This seems likely because only some of the addresses are affected and the calculation error is is the range of residential surcharges. (I ship all to residential addresses and have daily pickup.) So far I've failed at my own purpose but I found a setting incorrect in ups.php that will effect calculations if you are setting your shipping to commercial rates. The "COM' code needs to be set to "0". It is currently set to "2" in the ups.php file that I downloaded with the UPS Choice contribution. function _upsRescom($foo) { switch ($foo) { case 'RES': // Residential Address $this->_upsResComCode = '1'; break; case 'COM': // Commercial Address $this->_upsResComCode= '0'; break; I'm sorry I can't figure out the daily pickup/residential thing. :? Millie Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2003 Share Posted April 13, 2003 I might have found something... Its probably nothing but ! UPS used to charge $1.11 for residential delivery... Now it seems its random... THis is an error I can across today... My shopping cart calculates everything as residential and we have daily pickup... Shopping cart calculation : United Parcel Service (1 x 3.135lbs) (Ground): $5.76 Actual worldship price: Commercial $4.50 Residential $7.40 <<<< ALMOST $3 FOR RESIDENTIAL ! I don't know if UPS has additional tariffs for rural areas or areas a long way from a depot but this is most definitly the problem that occurs the most. Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2003 Share Posted April 13, 2003 My Next order I did worked out almost exactly right... Shopping cart calculations : United Parcel Service (1 x 2.112lbs) (Ground): $5.72 Actual : Commercial Delivery : $4.46 Residential Delivery : $5.61 <<< Differance of only $1.15 between residential and commercial... It seems UPS doesn't charge a flat fee anymore for residential delivery. Link to comment Share on other sites More sharing options...
Millie Posted April 13, 2003 Share Posted April 13, 2003 It seems UPS doesn't charge a flat fee anymore for residential delivery. UPS charges approx. $1 for residential and then certain areas have an additional residential surcharge of approx. $1.50. The residential surcharge applies to people who live in rural areas and small towns. Since the rates changed in January 2003 I haven't memorized the exact charges therefore my approx. values above reflect more accurately the 2002 rates. My experiments have lead me to believe that the calculation error has something to do with the residential surcharge not being included in the returned rates but I can't see how to fix it. The information that is sent to UPS seems to be correct... I tried hardcoding all my shipment settings in ups.php and the returned results were the same. I do not know what to try next. Millie Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2003 Share Posted April 13, 2003 Well it seems to me we aren't calculating the addititional $1.50 rural charge correctly... Most of my calculations come out really close except the rural ones. Link to comment Share on other sites More sharing options...
Guest Posted April 14, 2003 Share Posted April 14, 2003 Well I have had 4 more ups packages under charge today and they are all falling into the same bracket of not charging for the rural delivery. Everyone of them the differance between commercial and residential is $2.90... I calculate all residential but the rural charge is not on any of them... Anyone else have any ideas or comments??? Link to comment Share on other sites More sharing options...
oliver Posted April 14, 2003 Share Posted April 14, 2003 I saw yuor post and it semed that you might know about a problem i have. I was wondering if you know how the weight (which I will rename to "cubic meter") can be calculated on orders that customers write, just as it calculates the price, e.g the total weight of an order? We ship furniture on containers and need to know what the total weight (cubic) on an order will be to need exceed loadability. Would you know how that could be done or is that already in OSC and I just overlooked it? Thank you so much in advance, Thank you! Link to comment Share on other sites More sharing options...
Guest Posted April 14, 2003 Share Posted April 14, 2003 Millie, jab et al... Jusy wanted to confirm I am running into this as well. :( I was trying to cover for it by adding a $3 handling charge but it seems OSC isn't correctly computing that either. I still end up only making 20-70? per box which doesn't cover my packing supplies or labor (neither does 3 bucks, but it's better than 20?). I'm going to try switching to customer counter anyways and see if that helps. Glad to see it's not just me! Actually I bet most everyone is indeed affected but they're just not matching up charged vs. rates... :D :D Bailey Link to comment Share on other sites More sharing options...
Guest Posted April 15, 2003 Share Posted April 15, 2003 When I switched to customer counter I was overcharging every order by a couple bucks.. Obviously the rural area ones I was just covering. This is not an option for me as I am in a very competitive market and if I overcharge 80% of my orders on shipping, customers will move on to somewhere else that calculates shipping correctly. Link to comment Share on other sites More sharing options...
Daemonj Posted April 15, 2003 Share Posted April 15, 2003 Is there anyway that the current UPS shipping module be re-written/replaced/enhanced to use UPS's tools instead? Not only would that most likely resolve the problem but also keep up with any changes and new features that UPS implements. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.