Not able to get negotiated rates from UPS

[damionhickman]

It looks like AC does not send the <AccessRequest> node in its XML when getting a rate quote from UPS per the UPS.log.
UPS Says that the node, which contains AccessLicenseNumber, UserID and Password are required for negotiated rates, but there is no fields to enter these in AbleCommerce.

Is this a bug, and if so, what is the workaround?


Here is the portion that is missing from AbleCommerce's XML submission:

Code: Select all

<AccessRequest>
<AccessLicenseNumber>XXXXXXXXXXXXXXXX</AccessLicenseNumber>
<UserId>XXX..XXX</UserId>
<Password>XXXX..XXXX</Password>
</AccessRequest> 

[mazhar]

You can give your custom implementations of UPS provider in order to achieve this. Have a look at this topic http://wiki.ablecommerce.com/index.php/ ... ng_Carrier

At the bottom of that page there is link to forums thread containing complete source code of UPS shipping provider. Download that source code, extend it with your custom needs and then make use of your customized version of UPS provider instead of default one.

[jmestep]

We are working on the same problem and I do have a bug report into Able about it and we have been trying to determine whether we are getting negotiated rates or not. I put in custom code that stores those pieces of data instead of Able default and we are getting lower rates on that gateway than we are getting on a test gateway with no custom credentials. They still aren't as low as the rate chart UPS gave, but we are trying to determine if they include other charges UPS tacks on. On the test gateway, the rates we are getting match the ones you would get by going to the UPS site.
Once we get this figured out, I am supposed to update my support case with the results so Able can work on it if necessary.

[jmestep]

I am looking in Able source code (7.0.6) and they have two methods
Send Request to Provider, that includes
credentials.LoadXml("<?xml version=\"1.0\"?><AccessRequest><AccessLicenseNumber>" + this.AccessKey + "</AccessLicenseNumber><UserId>" + this.UserId + "</UserId><Password>" + this.Password + "</Password></AccessRequest>");

They also have SendRequestToProviderWithoutCredentials
Still digging....

[damionhickman]

You can give your custom implementations of UPS provider in order to achieve this. Have a look at this topic http://wiki.ablecommerce.com/index.php/ ... ng_Carrier

At the bottom of that page there is link to forums thread containing complete source code of UPS shipping provider. Download that source code, extend it with your custom needs and then make use of your customized version of UPS provider instead of default one.

That source is three years old and the resulting DLL does not have properties that Admin\Shipping\Providers\UPS\Configure.aspx.cs is trying to set, would I need a source-code license in order to add this negotiated rates functionality, or is there updated source code somewhere or is this bug fixed in 7.0.7?

[jmestep]

Here is a reply I got from UPS Level 3 support- all pieces are being passed by Able.

We are writing in regards to the issue you reported for a customer that is using the AbleCommerce e-commerce software to obtain rates from UPS and is not receiving a negotiated rate. This issue was escalated to UPS Third Level Developer Tools Support for investigation.

After checking the setup for the customer, we were able to determine that the setup to enable negotiated rates to be viewed via the UPS Developer Tools has not been completed for this customer. This setup would need to be completed by their UPS Account Representative. The customer should contact their UPS Account Representative and provide the following information:

"Please enable ABR Rates for user ID AbleCxxxx under the Negotiated Rates section of the Registration Services web site for the shipper account number that is being used to submit rate requests."

Once this setup is completed by the account representative, the customer should begin seeing negotiated rates as expected. We have verified that all fields needed to return a negotiated rate are being included in the requests that you are submitting. So, once this setup is complete, the should begin to be reflected in response. If you have any questions regarding this, please feel free to contact us. Thank you.

[damionhickman]

Thanks jmestep - that saves me a lot of time!

"Please enable ABR Rates for user ID AbleCxxxx under the Negotiated Rates section of the Registration Services web site for the shipper account number that is being used to submit rate requests."

How are you get the randomly generated userID (AbleCXXXXX) that's sent to UPS without needing to write your own script to intercept the XML POST that ablecommerce sends?

It seems that the <accessRequest> portion IS sent, but is REMOVED in the UPS.log file created by setting it to debug mode - why the omission?

I wrote my own script to capture mine, but i doubt that would be an acceptable solution for others.

[jmestep]

When I was troubleshooting this, I put code on the ship gateway page to show the userid. But the UPS high level tech support guy was able to look in there logs to find it. Actually, at first he found a different one that had been creating when I was adding and removing gateways so when I called him back, I had him look for the one that had been generated for the live gateway.
I've posted all the details to my bug report at Able, so maybe they will display the userid after it is created.

[damionhickman]

I captured the XML Ablecommerce is sending out and sent it over to UPS developer support, who told me that there's two portions missing from that XML that's preventing the Negotiated Rates from being sent out.

Thank you for your inquiry. There are two elements missing from your XML Rating Request that prevent UPS from returning the Negotiated Rates to you. First, the UPS account number associated with the Negotiated Rates contract is not listed in the <Shipper> container which is it required to be.

Second, the closed element <NegotiatedRatesIndicator/> is not listed in the request. This element must be in the Shipment\RateInformation container.

I made the above changes in your request and created a successful test that returned the discounted rate. Please make the above changes in your system.

http://damionhickman.com/steve/ac-request.gif

Here's an image of the XML that AC is sending to UPS, the portions in RED being the areas that are absent.

My question: how do I fix this - do I need a source code license?

[plugables]

Source for UPS gateway has already been made available. viewtopic.php?f=47&t=6651

You may write a custom version of UPS gateway to handle this.

[damionhickman]

Source for UPS gateway has already been made available. viewtopic.php?f=47&t=6651

You may write a custom version of UPS gateway to handle this.

Thanks but this code is outdated and does not function on AC 7.0.3+

[jmestep]

UPS backpedaled on what they had told me- I had to put the userid, password, shippernumber in to get the negotiated rates.
I tested it by changing what was in the database, but that broke if the client made another configuration change.
So I have made code changes on a couple of the admin pages after Able sent the request to set up the gateway originally, so my changes save the necessary credentials. I'm keeping my Able bug report up to day on developments.

[jmadlin]

Any update on this? I have a store in the UK and not geting any rates returned. I suspect that this is the same issue.

[jmestep]

I made a custom UPS dll and some changes to the admin page to send across the username, shippernumber and password and am able to get negotiated rates now. I have a bug report with Able to keep them up to date with my findings.

[jmadlin]

We dont own the source code. Would we need it in order to faciliatate this?