UPS discounted rates not showing in UPS XML

Hi Everyone,

I have searched the Zen Cart support and forum threads extensively for the solution to the problem I am having with no luck and I am hoping someone can give me the answer.

I have set up a shopping cart site at www.bigleyshoes.com/shop and I am having an issue with the UPS XML contribution. The account we have with UPS now has the negotiated discounted rates active on it and I have entered all the Access Key and UserID/Password information into the module correctly.

The problem I am having is that when I send an item with a certain weight and destination on the UPS site it comes up as $13 (discounted rate) but when I put the same item and destination into the UPS XML module it comes up as $22 (published rate). I am using the same method of shipping for both ways.

Is there something else I need to do so that the negotiated rates show up on my zen cart? I can't find a solution anywhere and any help would be greatly appreciated! :frusty:

I am not sure if this will be helpful or not but I have been using the UPS XML module for some time now. It seems to get the prioritized(3-day, 2nd Day, Next Day) negotiated rate right always seems to be a little off on the ground rates. I looked into it and could not figure it out so I just accept it that way. I would be interested if you find and solution though.

Marc

Thanks....would like to have a solution to this problem....it is very frustrating. UPS is impossible to deal with as they don't have any solutions to integrating the Online Tools to Zen cart or don't care to tell you how. The only solution I can find is this XML module and I need it to see discounted rates....some one help please!!!:cry:

The only other thing that I noticed in the past is that if your max package weight under 'configuration'>'shipping/packaging' is set too low then Zencart adds more packages and calculates the rate based on two or more packages going to the same address. Probably not your problem but I just remembered that it happened to me in the past when I started seeing that the customers were paying inflated rates.

Marc

I have another thread going on this issue...seems we are both having the same problem. As the XML module stands it seems it is not coded for negotiated rates, needs an aditional flag or so.

I'm working with UPS and hopefully will get this done. I will post the outcome / solution once I have it.

Good luck, I talked with people for weeks at UPS only to reach an abrupt stop when I got to the top. They insist that all integration be done by the software developer. I even brought it to there attention that there were many people that would like to utilize this module and the lower rates being shown during the checkout process would persuade more customers to choose UPS as their preferred shipping method. They just told me no.

Good luck and be sure to keep us posted.

Thanks,
Marc

marco....that sounds great....do you know when you would have this done approx? For our client we basically need it done yesterday type thing with them so the sooner the better. Thanks.

Is there no one with a solution to this problem? I can't be the only one needing discounted rates showing up in the UPS XML module. I was looking at osCommerce contributions and they have a UPS Rates & Service Gateway module that now includes a negotiated rates option.....is there some way this can be brought into the Zen Cart module?

I find it very interesting that this module has not been updated in 4 years and no one has added anything to it. Please someone help!!!!:cry:

Here is the version I modified for my website, it will return Negotiated Rates only. Read the readme file, you have to add your UPS account number to one line in the file!

Hope this helps...

I was looking over the module last night and once I change the "Quote Type" from "Residential" to "Commercial" everything was fine. The charged shipping rate on all of the orders that I did today were a perfect match with what Worldship was charging me when I printed the labels.

Marc

Trust me I had to make a few changes to get the discounted rates in the module I posted, if you are using world ship 2008 or earlier you must have Negotiated rates turned on to actually see and display them. The 2009 version and up will automatically show you these rates.

If you are using UPS.com and not world ship you have to have Negotiated turned on for that and only your rep can do that for you.

OK probably one thing I should have told you guys too, this is a Canadian store. I don't use Worldship I use regular UPS but the Canadian one.

Tat - I turned the Residential to Commercial and it still did not even come close to matching the discounted rates.

Marco - Thanks for sending that file I really appreciate it. I entered my account number on the line like the readme said and uploaded the file to includes/modules/shipping and when I went to check out the shipping module disappeared.....is there a reason for this? is the file you gave me not compatible with the version of UPS I am using?

Thanks for you help folks.....any more help you can give me to resolve this issue would be GREATLY appreciated!!! :shocking:

Not sure what version you are using, the one I modified can be found here: http://www.zen-cart.com/wiki/index.p...ules_-_UPS_XML

If you have the above version installed you should be able to over write it with mine.

Also not sure how you added your account number but the line you modify should look like below.

The XXXXXX of course would be your account number.

Code:

---

"        <ShipperNumber>XXXXXX</ShipperNumber>\n".

---

marco - yes I have that exact same version of the UPS XML and I overwrote the file in includes/modules/shipping with the one you gave me with my UPS shipper number inserted down on line 542 and all I get at the shipping portion of the checkout is nothing.....no shipping options at all.

The green light is on next to the UPS XML module in the backend and Zen Cart doesn't say that there are no shipping modules on but at shipping there is nothing.

I even turned off the module, reinstalled the whole thing with the edit version you gave to me and reactivated it and entered all my info and again....same thing....still nothing.

What could I be doing wrong to have this happen? Thanks for all your help so far but just need a little more if you got it?

Not sure why it is not working for you, I downloaded the original version and did a line by comparison and noticed a couple of lines commented out that was from another modification I did to the file awhile back.

So here is another file with just the negotiated rates feature, hopefully it works for you.

The only other idea that I have is maybe there is a conflict in PHP? I'm using version 5.2.9 if you are using 4.? Then that may be it as well.
Maybe someone else more knowledgeable in PHP can look at the file and see if my changes conflict with a lower version of PHP??

Ok also you will notice in this zip the directory structure, the modified file goes only in:

includes/modules/shipping

DO NOT override the file that is in your Admin directory that one is different, if you did that then that is your issue restore the original and just override the one in the above directory.

Marco.....THANKS SOOOOOO MUCH!!!!!! It works!!! I have been racking my brain on this for friggin weeks on this and you gave me the solution! Thank you sooo much I don't know how I can ever repay you, you have saved me sooo many headaches now. Anything you ever need just let me know.

You are the only one that came through with this solution and I can't believe there aren't more people after this solution.

Thanks again!:clap::clap::clap:

Marco...new problem arose!

WHen we go to the final stage of checkout I get an error that says "Shipping Method must be less then 64 characters". What does this mean? It won't le us complete the order.

Please help!!

Thanks

OK, it turns out that the numbers I was seeing were not my negotiated rates and I am getting Worldship set up tp see my negotiated rates as we speak.

I decided to try your contribution file but when I tried to ship a 3lb package from MA to OK the rates came up as:

Ground $3.00
3 Day $12.00
2nd Day $2.00
Next Day Saver $13.00

Also when I looked at my admin page I could not see all of the shipping methods and the "install/edit" area to the right was missing. The shipping methods that I could see went the full width of the screen.

What did I miss? Were there any other altered files? I quickly reverted to my backup upsxml.php file because this is a live site.

Marc

cspan27 I'm not sure what that could be, does the regular module works?

tat2nu I'm thinking your issue is that your online account is not setup for the negotiated rates, I would email UPS tech support and ask them if your UPS User Id and UPS Account number are authorized for negotiated rates. They are pretty good at responding the next day to these type of questions.

Also don't take your reps word for it talk to tech support, my rep thought I was and I had to show him the email from UPS stating that it was and have him authorize it.

Marco.....I figured it out and I don't know who is responsible for the glitch.....whether it is the module or Zen Cart itself but here is the solution:

It is only allowing 64 characters in length for the labels on the list ofcosts at check out. The shipping label that says "United Parcel Service (1 x 0.21lbs) ETA:........" far exceeds the 64 character count. So I went into the code and abbreviated United Parcel Service to UPS, which cut the label to below 64 characters and everything worked!!

Have you ever heard of this or has any one? I would like to change that 64 character limit to something higher but I don't know where to go to do this so right now I have found this solution. :D

I do not use any of that (1 x 0.21lbs) within the name so it keeps the names short and simple.

I have confirmed with UPS that my negotiated rates are set up. The negotiated rates show up in Worldship now just fine. I uninstalled the UPSXML module and reinstalled it with your modified file just to be sure. I even tried my UPS account number with both an upper case letter and a lower case letter but I still get similar results. Only the next day quote is now showing as $1.00 in stead of $13.00. So something changed a little but in the wrong direction. LOL.

I am going to try the mods on me new test site where I can tweak them without fear of losing sales or having to ship 'next day' for $1.00

Any ideas on what to look for?

Marc

OK, I had the UPS XML mod set up on a fresh 1.3.8s test site and it was returning published rates.

I changed the includes/modules/shipping/upsxml.php file with yours and added my UPS shipper number in the space described. I now am getting no rates returned at all for UPS.

Can it be that my negotiated rates were only installed today that they are just not showing up yet? I am confused to say the least at this point.

Marc

Once they turn it on from what I am told it takes 24 hours to start receiving the rates.

You can turn on the debug mode inside the file and see what UPS is returning to you.

Another way to check is to go to UPS.com and do some calculations if the discount rate is showing there then they should be on your website as well.

I am not set with UPS.com I use Worldship 11 and that is returning the correct rates and even give me the comparison to the published rates in my days end report.

I am a little confused. I created a upsxml.log file at includes/modules/shipping/upsxml.log

I un commented the next line to look like this

$this->logfile = '/upsxml.log';

Then while trying to check out with a test order on my test site no rates were returned for UPS at all and no errors given. I went back to my FTP program to check the upsxml.log file but it was still empty. Did I do something wrong here?

My test site is www.needlejig.com/test if you would take a look and see if there is something that I am missing.

Marc

I use worldship as well however to get the negotiated rates with this module UPS has to do some backend work, you have to email them and see what they say. Basically once you can login to UPS.com and see your discounted rates there you should be good to go with this module.

Thanks for the quick response.

OK, I set up a ups.com account that is associated with my UPS account number and I am seeing published rates on there. Can you tell me what department you contacted to get your negotiated rates to show online? I just hate being passed from person to person for days on end.

Marc

I emailed whatever the link was online, forgot now I think is a general form with options guiding you to the right department.

:clap: I got it!!!

Thanks guys. Once UPS got my webtools account to reflect the negotiated rates everything showed up perfectly.

Marc

Marco - How do you get rid of the (1 x 0.21lbs) thing in the title? I have looked everywhere and keep getting the same answer....to turn it off in Admin -> Config -> Shipping/Packaging. I have done this but it still shows up on check out.

Also quick question....now that everything checks out ok and the UPS module works, when someone places and order does that info get sent to my UPS account automatically? How do you deal with sending your customers tracking numbers and such?

Thanks.

You have to modify the file /includes/modules/shipping/upsxml.php

Change this code (around line 230)

PHP Code:

---

// BOF Time In Transit: 
        // comment out this section if you don't want/need to have expected delivery dates
        $this->servicesTimeintransit = $this->_upsGetTimeServices();
        if ($this->logfile) {
            error_log("------------------------------------------\n", 3, $this->logfile);
            error_log("Time in Transit: " . $this->timeintransit . "\n", 3, $this->logfile);
        }
        // EOF Time In Transit

        $upsQuote = $this->_upsGetQuote();
        if ((is_array($upsQuote)) && (sizeof($upsQuote) > 0)) {
            if (DIMENSIONS_SUPPORTED) {
                $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $this->boxCount . ($this->boxCount > 1 ? ' pkg(s), ' : ' pkg, ') . $totalWeight . ' ' . strtolower($this->unit_weight) . ' total)');
            } else {
                $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $shipping_num_boxes . ($this->boxCount > 1 ? ' pkg(s) x ' : ' pkg x ') . number_format($shipping_weight,2) . ' ' . strtolower($this->unit_weight) . ' total)');
            } 


---

to this code:

PHP Code:

---

// BOF Time In Transit: 
        // comment out this section if you don't want/need to have expected delivery dates
        // $this->servicesTimeintransit = $this->_upsGetTimeServices();
        // if ($this->logfile) {
        //    error_log("------------------------------------------\n", 3, $this->logfile);
        //    error_log("Time in Transit: " . $this->timeintransit . "\n", 3, $this->logfile);
        // }
        // EOF Time In Transit

        $upsQuote = $this->_upsGetQuote();
        if ((is_array($upsQuote)) && (sizeof($upsQuote) > 0)) {
            if (DIMENSIONS_SUPPORTED) {
                $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $this->boxCount . ($this->boxCount > 1 ? ' pkg(s), ' : ' pkg, ') . $totalWeight . ' ' . strtolower($this->unit_weight) . ' total)');
            } else {
                $this->quotes = array('id' => $this->code);
                // $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $shipping_num_boxes . ($this->boxCount > 1 ? ' pkg(s) x ' : ' pkg x ') . number_format($shipping_weight,2) . ' ' . strtolower($this->unit_weight) . ' total)');
            } 


---

I would suggest using the Quantum View Notify option when printing your UPS labels, your customer will be emailed the tracking details automatically.

Hey Marco - No....I don't want to get rid of the ETA: I want to get rid of the (1 x 0.21lbs). The instructions you sent me only got rid of the ETA and I would like to keep that part.

Also you say to use Quantium View to send customers their tracking numbers automatically? What the heck is Quantium view and how do I get it?

Thanks again!

Quote:

---

Originally Posted by tat2nu

I am not sure if this will be helpful or not but I have been using the UPS XML module for some time now. It seems to get the prioritized(3-day, 2nd Day, Next Day) negotiated rate right always seems to be a little off on the ground rates. I looked into it and could not figure it out so I just accept it that way. I would be interested if you find and solution though.

Marc

---

Hi Marc,

I'm hoping you can help me, I am trying to install the UPS XML Shipping module into my online store and cannot find any information on how to do this. Could you give me some information or point me in the right direction?

Thanks in advance.

Cynthia.

Thsi works great thank you!

HI,

the estimate does not show shipping rates by entering just zipcodes when the states/ provinces is not selected. the original UPS XML module shows rate with just zipcode without selecting states/provinces. this negotiated rate UPS XML does not work.

anyone knows how to fix this estimate rate for this negotiated rate UPS XML.?

thanks alot.

I am using this negotiated rates add-on, but have a problem with the info it passes on to the admin. Instead of passing the customer's selected shipping rate such as "UPS Standard" or "UPS 3 Day Select" on to the admin, all orders show as the module description such as "United Parcel Service (1 pkg x 1.60 lbs total)".

This is a problem, because I can't differentiate whether the customer has selected standard or express shipping... Does anyone else have this problem? How could I correct this?

Quote:

---

Originally Posted by abcisme

I am using this negotiated rates add-on, but have a problem with the info it passes on to the admin. Instead of passing the customer's selected shipping rate such as "UPS Standard" or "UPS 3 Day Select" on to the admin, all orders show as the module description such as "United Parcel Service (1 pkg x 1.60 lbs total)".

This is a problem, because I can't differentiate whether the customer has selected standard or express shipping... Does anyone else have this problem? How could I correct this?

---

This was not an error with this module. I had implemented this change and it stopped sending the info to the order.

Does anyone know how to make the UPSXML module work with the new zencart 1.5? I have another site on an older zencart and it works fine but when i try to install this on a fresh zencart 1.5 it does not seem to work.

I have discovered that when a customer uses an invalid zip code, instead of giving an error, this module gives a default rate of $11. Does this happen for anyone else?

The regular UPS XML module returns an accurate rate even if the zip code is invalid... I wonder if there is any way to return the published rates instead of the negotiated rates if the postal code is invalid?

To remove the weight part of the results, comment out

PHP Code:

---

            // if (DIMENSIONS_SUPPORTED) {
            //     $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $this->boxCount . ($this->boxCount > 1 ? ' pkg(s), ' : ' pkg, ') . $totalWeight . ' ' . strtolower($this->unit_weight) . ' total)');
            // } else {
            //     $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $shipping_num_boxes . ($this->boxCount > 1 ? ' pkg(s) x ' : ' pkg x ') . number_format($shipping_weight,2) . ' ' . strtolower($this->unit_weight) . ' total)');
            // } 


---

I have also found that entering an invalid post code will return incorrect postage. For example, 1 oz item to France post code 4650 is $8.50, an order of magnitude off. Really France should have 5 digit post code, but customers often get it wrong. Scary.

Would a moderator please delete my post #43. The solution works only in Estimate Shipping. During the checkout, it actually prohibits UPS methods from showing.

I think I finally figured out how to remove weight and number of packages:

PHP Code:

---

        if ((is_array($upsQuote)) && (sizeof($upsQuote) > 0)) {
             if (DIMENSIONS_SUPPORTED) {
                 $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $this->boxCount . ($this->boxCount > 1 ? ' pkg(s), ' : ' pkg, ') . $totalWeight . ' ' . strtolower($this->unit_weight) . ' total)');
             } else {
                 $this->quotes = array('id' => $this->code, 'module' => $this->title . ' (' . $shipping_num_boxes . ($this->boxCount > 1 ? ' pkg(s) x ' : ' pkg x ') . number_format($shipping_weight,2) . ' ' . strtolower($this->unit_weight) . ' total)');
             } 


---

to

PHP Code:

---

        if ((is_array($upsQuote)) && (sizeof($upsQuote) > 0)) {
             if (DIMENSIONS_SUPPORTED) {
                 $this->quotes = array('id' => $this->code, 'module' => $this->title );
             } else {
                 $this->quotes = array('id' => $this->code, 'module' => $this->title );
             } 


---

Recently the UPS XML module has had some issues. It's not functioning as it was a month ago which tells me there have been some changes on UPS's end. Anyone else having problems?

Could you provide any examples of what is NOT funtion the same as last month?

From UPS:

Helpdesk response:
We have received reports from customer using the Xpci Version of 1.0001 in their requests intermittently returning a file with only the XML declaration statement.
Please modify your code to use the version as shown in the developer guides:
<XpciVersion>1.0</XpciVersion>
</TransactionReference

Quote:

---

Originally Posted by In2Deep

From UPS:

Helpdesk response:
We have received reports from customer using the Xpci Version of 1.0001 in their requests intermittently returning a file with only the XML declaration statement.
Please modify your code to use the version as shown in the developer guides:
<XpciVersion>1.0</XpciVersion>
</TransactionReference

---

Published Rates XML Request Example:

<?xml version="1.0"?>
<AccessRequest xml:lang="en-US">
<AccessLicenseNumber>Your Access License</AccessLicenseNumber>
<UserId>Your User Id</UserId>
<Password>Your Password</Password>
</AccessRequest>
<?xml version="1.0"?>
<RatingServiceSelectionRequest xml:lang="en-US">
<Request>
<TransactionReference>
<CustomerContext>Your Customer Context</CustomerContext>
<XpciVersion>1.0</XpciVersion>
</TransactionReference>
<RequestAction>Rate</RequestAction>
<RequestOption>Rate</RequestOption>
</Request>
<Shipment>
<Shipper>
<Name>Shipper Name</Name>
<AttentionName>Shipper Attention Name</AttentionName>
<PhoneNumber>1234567890</PhoneNumber>
<FaxNumber>1234567890</FaxNumber>
<ShipperNumber>Your Shipper Number</ShipperNumber>
<Address>
<AddressLine1>Address Line 1</AddressLine1>
<City>City</City>
<StateProvinceCode>StateProvinceCode</StateProvinceCode>
<PostalCode>PostalCode</PostalCode>
<CountryCode>CountryCode</CountryCode>
</Address>
</Shipper>
<ShipTo>
<CompanyName>Ship To Company Name</CompanyName>
<AttentionName>Ship To Attention Name</AttentionName>
<PhoneNumber>1234567890</PhoneNumber>
<FaxNumber>1234567890</FaxNumber>
<Address>
<AddressLine1>Address Line 1</AddressLine1>
<City>City</City>
<StateProvinceCode>StateProvinceCode</StateProvinceCode>
<PostalCode>PostalCode</PostalCode>
<CountryCode>CountryCode</CountryCode>
</Address>
</ShipTo>
<ShipFrom>
<CompanyName>Ship From Company Name</CompanyName>
<AttentionName>Ship From Attention Name</AttentionName>
<PhoneNumber>1234567890</PhoneNumber>
<FaxNumber>1234567890</FaxNumber>
<Address>
<AddressLine1>Address Line 1</AddressLine1>
<City>City</City>
<StateProvinceCode>StateProvinceCode</StateProvinceCode>
<PostalCode>PostalCode</PostalCode>
<CountryCode>CountryCode</CountryCode>
</Address>
</ShipFrom>
<PaymentInformation>
<Prepaid>
<BillShipper>
<AccountNumber>Your Account Number</AccountNumber>
</BillShipper>
</Prepaid>
</PaymentInformation>
<Service>
<Code>59</Code>
<Description>2nd Day Air AM</Description>
</Service>
<Package>
<PackagingType>
<Code>02</Code>
<Description>UPS Package</Description>
</PackagingType>
<PackageWeight>
<UnitOfMeasurement>
<Code>LBS</Code>
</UnitOfMeasurement>
<Weight>5</Weight>
</PackageWeight>
<Dimensions>
<Length>10</Length>
<Width>5</Width>
<Height>7</Height>
</Dimensions>
</Package>
</Shipment>
</RatingServiceSelectionRequest>

There is also a Published Rates XML Response Example and a Published Rates XML Response Example and a Negotiated Rates XML Response Example

Have there been any updated fixes to this module to allow it to return a discounted rate?
The first few pages are from 2009 and I'm unsure if they'd work with the latest version of this module from 2014.

I'm trying to set this up as a replacement to Canada Post for the potential strike/lockout on July 2nd.

It seems to be working and returning standard rates, but I cannot get either this module to return a discounted 20% off rate based on a discount applied to my UPS account, or find any settings on UPS's end to force the discount. It's almost like there's a field missing in this module to pass along a UPS account number along with the username, password and key.

Any ideas of what I can try? I also wanted to set up a flat 5$ discount, simply by using the handling fee field, entering -5 seems to work, so I don't think the fix proposed earlier in this thread would work as it'd end up multiplying my discount.

I've tried the solution file posted on page two and my cart won't return any UPS rates. I also tried using a difference checking tool going line-by-line and simply adding the few lines of code into the 2014 version of the upsxml file from that solution on page two and it also didn't return any rates.

Not sure what else to try at this point to get it to work.