UPS XML: Support Thread

lat9:

I've just submitted v1.7.4 of UPSXML to the Zen Cart moderators for review; I'll post back here once available for download.

 This release contains changes associated with the following GitHub issues:

#14: Remove unwanted slash in shipping-icon link
#15: Remove quotes around numeric-field values in installation SQL
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=126

I've just submitted v1.7.5 to the Zen Cart moderators for review and will post back once it's available for download.

 This release corrects the following GitHub issues:

#16: Incorrect message display when zipcode is invalid
#17: Restore 'MODULE_SHIPPING_UPSXML_RATES_ORIGIN' configuration setting.

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=126

We have negotiated rates with UPS rather than stock published rates. How do we activate, or access, those rates with this plugin? We are already using the plugin, have for years, so I'm not asking about installing. Rather getting the rates we've negotiated.

Thanks.

If you configure it with your account information, then yes, it will give you negotiated rates.

@greg_beyer, what version of UPSXML is currently in use? I ask because the plugin's undergone some significant changes over the past couple of years.

Hi Lat9,

We're on 1.7.2 And its configured (and always has been) with our shipper number, key, login and password.

The shipping rates shown in ZC are much higher (double) those provided when we ship the same items using UPS's native WorldShip client. WorldShip is the UPS desktop client that we use to generate shipping labels from ZC orders. WorldShip is configured with the same shipper number as UPS XML. It doesn't require a login and PW and API key as does UPS XML, BTW -- only the shipper number.

Having reviewed the change logs in UPS XML in 1.7.3, 1.7.4 and 1.7.5, I'm not seeing anything that would account for this discrepancy.

Thanks for any insights. I also going to turn on debug of UPS XML, see if I can glean anything from that.

Here's some additional information. I turned on debug, and generated the attached log file.

UPS XML calc'ed a rate of $111.44 for a 12 lb package sent 2d day air. (we ship perishable food, it must go 2DA to western locations). We are in Atlanta.

We then entered the same package weight, to same zip, and with same shipping (2d day air) into UPS Worldship desktop application. It calc'ed a rate of $63.82.

Of course the $111.44 rates scares off the customers when they're in the shopping cart.

The 63.82 is our negotiated rate with UPS. The 111.44 is the published rate -- what any joe would pay walking up to a UPS Store with the package.

So the question is why is the negotiated rate not coming back via UPS XML?

I don't see any errors in the log file. I have redacted sensitive credentials, etc.

Apparently that account isn't authorized for negotiated rates, as found in the UPS response:

<RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning>

Thank you, lat9. I should have caught that :blush:

It seems clear that there is an issue with the account on the UPS side which is not allowing the negotiated rates to be returned. I have provided this information, along with the raw log file, to UPS.

I just installed the UPSXML from the standard UPS version that was not calculating insurance. I have a lot of high value items on my site and we were losing that money on transactions.

The rates seem to be calculating fine as long as you are logged in. If you are not logged in, the rates show as stanard rates without insurance. I could not find any settings that would affect this. I am worried about potential customers checking the estimated shipping rates and then when they sign up the cost is drastically different.

Site is v1.5.5f
upsxml is 1.7.5

eairtool:

I just installed the UPSXML from the standard UPS version that was not calculating insurance. I have a lot of high value items on my site and we were losing that money on transactions.

The rates seem to be calculating fine as long as you are logged in. If you are not logged in, the rates show as stanard rates without insurance. I could not find any settings that would affect this. I am worried about potential customers checking the estimated shipping rates and then when they sign up the cost is drastically different.

Site is v1.5.5f
upsxml is 1.7.5
You're correct. The shipping module currently looks for an "order" (i.e. during the checkout process) to gather the subtotal to be submitted to UPS (otherwise defaulting to a 100.00 value).

I'll create an issue on the UPSXML GitHub (https://github.com/lat9/upsxml) to track this change.

lat9:

You're correct. The shipping module currently looks for an "order" (i.e. during the checkout process) to gather the subtotal to be submitted to UPS (otherwise defaulting to a 100.00 value).

I'll create an issue on the UPSXML GitHub (https://github.com/lat9/upsxml) to track this change.
I've got this update staged for v1.7.6 of the shipping module. You can edit your copy (line 109), changing from:

            $this->pkgvalue = (MODULE_SHIPPING_UPSXML_INSURE == 'False' || !isset($order)) ? 100 : ceil($order->info['subtotal']);

to

            $this->pkgvalue = (MODULE_SHIPPING_UPSXML_INSURE == 'False' || !isset($order[B]->info['subtotal'])) ? ceil($_SESSION['cart']->total)[/B] : ceil($order->info['subtotal']);

lat9, big thanks! That worked perfectly.

eairtool:

lat9, big thanks! That worked perfectly.
... and thanks back to you for the confirmation that the code posted above corrects the issue!

I'll get that packaged up over the weekend for v1.7.6.

I've just submitted v1.7.6 of UPSXML for the Zen Cart moderators' review and will post back here once it's approved.

 This release contains changes associated with the following GitHub issue:

#18: Correct shipping-estimator quotes, when insurance is included.

We operate a B2B site (1.55f, php 7.1). I have the Quote Type (Residential / Commercial) set to Commercial, resulting in lower rates being returned. That fits the majority of my customers.

The problem is many business operate from residences. When a customer ships to a residence, the site is undercharging them by a significant amount. On premium services it is often $20 or more.

Any ideas are appreciated.

@lat9, thanks very much for the work on this module.

You could use the UPS 'address validation service' to determine whether the ship-to address is commercial vs. residential, clone the upsxml module so that one instance is for residential and one is for commercial.

Then update each of the upsxml versions to disable themselves if the address validation indicates that the address isn't valid for the service.

lat9:

I've just submitted v1.7.6 of UPSXML for the Zen Cart moderators' review and will post back here once it's approved.

 This release contains changes associated with the following GitHub issue:

#18: Correct shipping-estimator quotes, when insurance is included.
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=126

I've just submitted v1.7.7 of UPS XML for the Zen Cart moderators' review; I'll post back when it's available for download.

 This release contains changes associated with the following GitHub issues:

#19: Correct PHP notices generated.
#20: Display "New version available" only from admin's Modules->Shipping
#21: Correct "Next Day Air Early" quotes not being returned.
#22: Restructure distribution.
#23: Sort quotes returned by cost.