Print Page | Close Window

Shipping Rates Still Wrong!

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=419
Printed Date: December/08/22 at 4:39pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: Shipping Rates Still Wrong!
Posted By: jkc101
Subject: Shipping Rates Still Wrong!
Date Posted: September/12/05 at 2:39pm
Has anyone been able to get the UPS shipping rates to calculate correctly? I'm shipping a package today that the shipping plug-in returned a rate that is $11.84 less than what the actual UPS charge is for the same package via the internet!   I've downloaded the current CSV zone from UPS and it's still way off!

Any idea why?

I can't afford to give that much away due to shipping rate errors!

Help!!!!

Thanks

JKC101



'----------------------------------------------------------- ---------
' Requires myups.csv file which contains the applicable ups zones for your zip code in the same folder
' Requires ups-zones.mdb in the /fpdb folder with the most up-to-date ups charges per zone
' Assumes you have a daily pickup service and are shipping the most expensive residential charges
'----------------------------------------------------------- ---------

I found this section in the upsinstant.asp...My question is...where do I find the "ups-zones.mdb" I don't have that DB? Could this be my problem?

JKC101



Replies:
Posted By: Techno Geek
Date Posted: September/12/05 at 4:29pm
UPS rates that are provided to us do not include the fuel and the other surcharges so the fees are going to be considerably less. That is why you can add your own surcharge.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: wscharen
Date Posted: September/22/05 at 11:47am
Hi JKC101,

Have you been able to get the UPS rates to work on your site? I am having problems as well. Sometimes the rates are correct sometimes they are way off.

-------------
Wendy


Posted By: jkc101
Date Posted: September/22/05 at 12:43pm
No ma'am....

The shipping plug-in seems to be lacking considerable flexablity.   It assumes all packages are "Residential" unless Air is selected. The fuel surcharge is not considered at all. There is no place to allow for "Over Sized" packages. And I believe the insurance value is base on Invoice total. (Would be nice to insure only the "Wholesale" value since that's all I would be out in the event of a loss!)

I have been trying to find a balance by adjusting the "Surcharge" and the "Additional" package charges in the shipping/forms/index.asp. (Note: The changes did not apply through the asp, so jus edit the Shippingini.xml directly, notice the bottom section and correct the default ship from info!) This methode, so far, is High on smaller shipments and Under on larger shipment.

I just gave up on the FedEx portion, nowhere to start and no vaild "CSV" file for FedEx.

JKC



Posted By: Techno Geek
Date Posted: September/26/05 at 11:30am
Fuel surchage is not considered because it is not provided. FYI.

The other thing is that we've implemented the new USPS, UPS, FedEx and DHL API in the .NET product so that is an option and we will give you an upgrade discount if you consider going that route.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: wesonline
Date Posted: September/26/05 at 2:15pm
Just to let you know. We set DHL as our shipper and it seemed to have worked. If fact, the the quoted rates were a little less than the rates we got when going directly to UPS and FedEX. The DHL implementation in "PRO" appears to be totally different than the way UPS and FedEX are implementated in "PRO", there are no tables to download and try to keep insync. The DHLreal.asp module appears to go directly to DHL's web site to get it rates.


Posted By: Techno Geek
Date Posted: September/26/05 at 5:18pm
That's right, both DHL and USPS are handled through XML GET/POST.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: wesonline
Date Posted: September/26/05 at 5:23pm
Any chance that UPS nad FedEx will also be upgraded to XML GET/POST? I believe both now offer this capability.


Posted By: Techno Geek
Date Posted: September/27/05 at 8:48am
There is a good chance we will but it will be done in the SalesCart NET product since it is much more easier, flexible and scalable to do this sort of thing in ASP .NET.

In fact the FedEx API is already integrated with SalesCart NET so that leaves UPS I believe.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: jkc101
Date Posted: September/27/05 at 9:00am
So....

Do all the PRO users that purchased in the last year get a free upgrade to .Net so we can have an accurate shipping rate too?

Just a thought.....I could be wrong!

JKC


Posted By: Techno Geek
Date Posted: September/27/05 at 9:22am
Sorry but you do get a nice discount. You might want to call and ask.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: jkc101
Date Posted: September/27/05 at 2:35pm
Do you think they will pro-rate the discount since I purchased PRO in June, and just got the website up in September?




Posted By: Techno Geek
Date Posted: September/28/05 at 9:39am
I don't think we could pro-rate the discount because you already own SalesCart PRO and I'm sure that you're beyond the 30 day refund period.

That's why we have the discount for the existing customers.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: Jacktoz
Date Posted: October/18/05 at 12:54pm
Hello,

I'm having the same problem with an upgrade from Standard 2.0 w/shipping plug-in to 3.0 w/ shipping plug-in. I was interested to read that the quote does not include UPS sur-charges as that explains the difference on the basic shipping charge difference betwee that calculated by UPS vs. the Sales Cart plug-in. What the my plug-in is not doing is calculating insurance charges. On some of our bigger ticket items, (say a $6K preamp,) that can be a $20+ undercharge. I don't recall this ever being a problem with the previous plug-in.

Has something changed or have I missed something in the setup?

There is also reference to the ups-zones.mdb in the /fpdb folder. I do not have this.

Thanks for any help that might be provided.

Jack


Posted By: davidmurphy
Date Posted: October/24/06 at 7:49am
Bump,
I too would like to know about the ups-zones.mdb file. What is it and where is it? I do have a ship-zones.mdb


Posted By: admin
Date Posted: October/24/06 at 4:44pm
The ship-zone.mdb is a deprecated file from an older version....you can simply ignore it or delete it if you like.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk