Guest Posted November 24, 2003 Share Posted November 24, 2003 Ok I am back, after solving the USPS problem with rates. Only now, I am going to give a more descriptive and detailed explanation of my problem: IN THE ADMIN PANEL: CONFIGURAION/SHIPPING/PACKAGING = Unitied States; ZIP=94014, Max Package=35lbs, Tare Wt=0, No % increases. MODULES/SHIPPING for UPS = Enable=True; Pickup=CC; Packaging=CP; Delivery=RES; Handling Fee=0; Tax Class=None; Shipping Zone=None; Set Order=0. I am mailing FROM United States, Daly City, 94014. I am mailing TO United States, Daly City, 94014. Package Wt.=27lbs Package Size= 26LX25.5WX13.75H I am doing a DROP OFF to UPS. Shipping Charges to UPS Account. Your Packaging. Not insured. Amount of item is $649.00. From the UPS CALCULATION webpage I get: 91.02; 62.17; 54.32; 40.15; 31.54; 11.39. From the osCommerce Shoppiing Cart I get: 70.52; 41.66; 36.35, 25.57; 20.20; 10.73. I am not sure if I am pointing to the UPS production server or not. How do I do that? Thank You. Frank Link to comment Share on other sites More sharing options...
Guest Posted November 24, 2003 Share Posted November 24, 2003 Dear Community Members: I was told by a community member that they installed the shopping cart for lots of customers and it is working fine. Well, it is not working fine for me and I have been working on this problem for a long time. So I am not sure why it is working for someone else, when the UPS interface is an "obsolete and deprecated online interface". The following post is from a community member, so it looks like the UPS shipping module has a real problem and will not calculate the right rates and it does not look like it is going to get fixed. "Joined: 5-October 02 - From Fritz Clapp The rate is affected by the choice of pickup method, with RDP being the lowest and CC being higher. It should be mentioned (for the umpteenth time) that the osC shipping module for UPS and the UPS Choice contribution employ an obsolete and deprecated online interface, hence it is quite possible that the currently correct rates are not being obtained by them. Neither the standard osC module, nor the UPS Contribution which extends it, affects the rate for shipping. They merely report what comes back from UPS when a rate quote is requested." Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 what's the URL of your shop? I'd like to try it out and see what is going on. Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 Hey man I figured out your problem and its unavoidable unless someone knows the code to correct it.... From the UPS Website: Weight: 27 lbs.Dimensions: 26x25.5x13.75 in. Insured Value: Not Entered **Dimensional Weight applies (Billable Weight: 63.0 LBS) +Oversize 2(OS2) applies (Billable Weight: 70.0 LBS) That's why your rates on osCommerce are lower...osCommerce was not configured to calculate oversize packages and packages to which dimensional weight applies. osCommerce goes strictly by weight. I hope this helps now that you know the cause of the problem, even though I dont know what would be involved to correct it. Good Luck Link to comment Share on other sites More sharing options...
wizardsandwars Posted November 24, 2003 Share Posted November 24, 2003 Well, that would explain why it works for nearly everyone else, but not for this guy. Nice sluth work, dchockenberry. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 if you're being sarcastic, it's uncalled for. I do believe the size of his package is the problem. for UPS, when you enter certain higher dimensions, they start to calculate minimum weights. in his case, it is calculated as 63 lbs billable dimensional weight and 70 lbs. billable oversize weight. it says right there. just because it seems to work for everyone else, doesnt mean they have encountered a case of oversizing such as this. it's possible, and probable, that other people have not come across a large package of lower weight that doesn't kick in the dimensional and oversize calculations as figured on the website. the oscommerce module may not have been configured to take these instances into account. i'm not saying it's definitely the problem but its a start...considering the guy couldnt think of or find anything else wrong. there's no need to get smart when people are trying to help others...especially when you have nothing useful and/or informative to add yourself. Link to comment Share on other sites More sharing options...
Guest Posted November 24, 2003 Share Posted November 24, 2003 Don, Thank you for your reply and you are exactly right. I just now found the same problem. When you go to the UPS site and try to calculate your package it automatically increases the weight depending on the Dimensional Wt. For example, I have a package that is 26LX25.5WX13.75H and 27lbs, so UPS calculates a Dimensional Wt. of 49lbs (plus it includes a fuel surcharge of 1.25% or $1.47). Zip To and From is 94014. So, in order for me to correct the problem in the UPS module is to increase my wt. of the package to 49lbs, well lo and behold, my shopping cart is now correct, except for the ground rate (UPS is 11.39 and Shop Cart is 14.68). But now, a bigger problem arises and that is my USPS rates are now off, because I increased the weight of my products on the shopping cart admin page. It seems to me at this point that UPS and USPS are incompatible shipping modules, if you have odd sizes. A problem for me and not necessarily everyone else. A gentelman, sent me a personal message about this problem and I indicated to him that he needs to test his shopping cart rates against the UPS rates to determine if it is a problem for him. I have odd size packages apparently and that is a big problem. Anyone planning to fix this. Thanks for your help, Don. Frank Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 for the time being, or permanently if you feel like taking a few extra minutes, you can go to the USPS and UPS websites, calculate shipping rates for individual items, and then just set shipping rates for those items only as a specified amount. here is the contribution you can install: http://www.oscommerce.com/community/contri...ons,1333/page,2 its sort of a pain in the butt to have to go in and pre-calculate shipping but at least you can set rates for specific items and not have to worry about manipulating your handling fees and/or weight I haven't installed it (yet) so I can't tell you whether or not its easy to set up. Link to comment Share on other sites More sharing options...
Guest Posted November 24, 2003 Share Posted November 24, 2003 Don, Thank for the suggestion. I think I am going to remove UPS shipping module from my shipping options. Maybe I will go with FedEx. I may be shipping all over the U.S. and changing rates for my customers would be a royal pain in the butt. I would like it all automated and easy for the customer to select their own shipping option. But since I won't have nay options, they will just use USPS. Thanks for the tip. Frank Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 no problem...sometimes you just have to improvise or find another way. Link to comment Share on other sites More sharing options...
dchockenberry Posted November 24, 2003 Share Posted November 24, 2003 what you could also do is have one flat rate and then add several drop down options as product attributes for each part of the country that adds to the cost of the item itselt but explain in the product listing that it is for shipping fees. example: Product Options: Shipping To: Northeast (+$3.00) Southeast (+5.00) Southwest (+2.00) and so on, to compensate for your shipping costs, while maintaining a flat rate for that item. the 3 dollars for NE, 5 for SE, or 2 for SW would be added to the price of the product but it would cover your "extra shipping" if you make your flat rate based upon your region. its not an exact science but it is a way to automate it for different parts of the country. Those product options would be listed in your product description. Link to comment Share on other sites More sharing options...
wizardsandwars Posted November 25, 2003 Share Posted November 25, 2003 For the record, Don, you misinterpreted me. I was being genuine. Your suggestion was helpful, and it was something that I didn't know about, and hadn't thought about. Excellent work. Seriously. You might want to loosen up a bit, though. ;) ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
dchockenberry Posted November 25, 2003 Share Posted November 25, 2003 sorry about that....thanks for the compliment... Link to comment Share on other sites More sharing options...
Guest Posted November 25, 2003 Share Posted November 25, 2003 Don, You have been most helpful and I appreciate your help. I also like your creative ideas. I think after I launch, I will start playing with some of your ideas. Right now, I need something reliable and consistent and it looks like USPS is doing the right stuff. Good old U.S. of A comes through. Thanks a million and have a great holiday break. Don't eat too much turkey! Peace, Frank Link to comment Share on other sites More sharing options...
dchockenberry Posted November 25, 2003 Share Posted November 25, 2003 Hey no problem...always a pleasure to lend a helping hand. Happy Yard Bird Day to you too. Link to comment Share on other sites More sharing options...
cmos74 Posted November 29, 2003 Share Posted November 29, 2003 Got a question. I got a client that is going to use Zone rates 2-8 for shipping. They have a rate set for Orders Less than $25.00 for Ground and also for rush delivery. Here is where it gets tricky. When the order goes between $25.00 and $499.99 then the different zones have percentage rates like 13, 15, 17, 19 tec. and the rush rates have a 65 or 60 percent rate. I do not know how to set this up and also I do not know how to set it up when they watn to use Canada Post, DHL or Air Mail. Along with a message to contact the vendor after it is over. Can someone help me figure out this shipping mess so I can finish this up. One last thing.. I want to have a salesman codes at checkout. Something they are forced to fill in if they have it. Any ideas on this also. chris 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.