UPS and USPS are charging store more than my store is charging customer.

[CarolineBogart]

Thank you in advance :)

Both UPS and USPS are suddenly charging the zen cart customer significantly less than UPS and USPS are charging the store in actual rates.

UPS charges on shopping cart are not matching up to what UPS is actually charging on UPS site.

Order # 65024 a 3 lb package was charged on cart 13.03. the actual UPS charge was 18.52

Order # 65090 a 7 lb package was charged on cart 15.57. the actual UPS charge was 25.20

USPS charges on shopping cart are not matching up to what USPS is actually charging on our USPS click n ship account.

there is a walk up window price which i believe is what the cart is pricing and a commercial price. i believe we should be the commercial price


Order # 65476 a 2 lb package was charged on cart 11.10. the actual USPS charge was 8.85


Order # 65457 a 7 lb package was charged on cart 25.40. the actual USPS charge was 21.48

zen 1.57b

URL
b hyphen naturals dot c-o-m

upgraded to 1.5.7b several months ago


outsourced the procedure


nothing below has changed for at least 5 months:


freeoptions
freerules
ups
usps


tabbed products pro


ultimate urls




bluepay
freecharger


sales report
sales report with graphs




HTTP SERVER: apache
MYSQL: 5.7.33


server os: linux 3.10.0


PHP 7.3.27 (zend 3.3.27)


MySQL Mode: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION


PROBLEM STARTED: 3/2/21


As far as I know there are no changed in zen admin or in hosting

USPS:


United States Postal Service


You will need to have registered an account with USPS at https://secure.shippingapis.com/registration/ to use this module


USPS expects you to use pounds as weight measure for your products.


USPS Version Date
2020-09-24 K11


Enable USPS Shipping
True


Full Name or Short Name
Long


Enter the USPS Web Tools User ID
493DOTB(redacted by moderator)


Which server to use
production


Quote Sort Order
Price-LowToHigh


Handling Fee - US
0


Handling Fee - International
0


Handling Per Order or Per Box
Box


Decimal Settings
3


Tax Class
--none--


Tax Basis
Shipping


Shipping Zone
--none--


Sort Order
0


All Packages are Machinable?
False


USPS Options
--none--


USPS Domestic Transit Time Calculation Mode
NEW


USPS Domestic minimum Length
8.625


USPS minimum Width
5.375


USPS minimum Height
1.625


USPS International minimum Length
9.50


USPS minimum Width
1.0


USPS minimum Height
5.50


Enable USPS First-Class filter for US shipping
True


Shipping Methods (Domestic and International)
0, .21875, 0.00, 0, .8125, 0.00, 0, .8125, 0.00, 0, .9375, 0.00, 0, 70, 0.00, 0, 70, 0.00, Priority MailTM, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 15, 0.00, 0, 20, 0.00, Priority Mail ExpressTM, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, .21875, 0.00, 0, 4, 0.00, 0, 4, 0.00, Priority Mail InternationalRM, 0, 66, 0.00, 0, 4, 0.00, 0, 4, 0.00, 0, 20, 0.00, 0, 20, 0.00, 0, 66, 0.00, 0, 4, 0.00, 0, 70, 0.00, 0, 70, 0.00


Extra Services (Domestic)
Certified MailRM, N, USPS TrackingTM Electronic, N, USPS TrackingTM, N, Insurance, N, Priority Mail Express Insurance, N, Priority Mail Insurance, N, Adult Signature Restricted Delivery, N, Adult Signature Required, N, Registered MailTM, N, Collect on Delivery, N, Return Receipt, N, Certificate of Mailing (Form 3665), N, Certificate of Mailing (Form 3817), N, Signature ConfirmationTM Electronic, N, Signature ConfirmationTM, N, Priority Mail Express 1030 AM Delivery, N, Certified MailRM Restricted Delivery, N, Certified MailRM Adult Signature Required, N, Certified MailRM Adult Signature Restricted Delivery, N, Signature ConfirmationTM Restricted Delivery, N, Signature ConfirmationTM Electronic Restricted Delivery, N, Collect on Delivery Restricted Delivery, N, Registered MailTM Restricted Delivery, N, Insurance Restricted Delivery, N, Insurance Restricted Delivery (Priority Mail Express), N, Insurance Restricted Delivery (Priority Mail), N


Extra Services (International)
Registered Mail, N, Insurance, N, Return Receipt, N, Electronic USPS Delivery Confirmation International, N, Certificate of Mailing, N


Retail pricing or Online pricing?
Retail


Debug Mode
Logs

USPS VERSION DATE 2020-07-01


ENABLE UPS SHIPPING
TRUE


UPS PICKUP METHOD
CC


UPS PACKING
CP


RESIDENTIAL DELIVERY?


RES


HANDLING FEE 
0


HANDLING PER ORDER OR PER BOX


BOX


TAX CLASS
--NONE--




TAX BASIS
SHIPPING
SHIPPING ZONE
--NONE--
SORT ORDER OF DISPLAY


2


Shipping Methods:
Nxt AM, Nxt AM Ltr, Nxt, Nxt Ltr, Nxt PR, Nxt Save, Nxt Save Ltr, 2nd AM, 2nd AM Ltr, 2nd, 2nd Ltr, 3 Day Select, Ground, Canada,World Xp, World Xp Ltr, World Xp Plus, World Xp Plus Ltr, World Expedite, WorldWideSaver
1DA, 1DPL, 2DA, 3DS, GND

[05-Mar-2021 00:38:04 America/Chicago] Request URI: /index.php?main_page=checkout_process, IP address: 68.184.183.227
#1  each() called at [/home/myclient/public_html/includes/modules/payment/bluepay_an.php:346]
#2  bluepay_an->before_process() called at [/home/myclient/public_html/includes/classes/payment.php:252]
#3  payment->before_process() called at [/home/myclient/public_html/includes/modules/checkout_process.php:91]
#4  require(/home/myclient/public_html/includes/modules/checkout_process.php) called at [/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#5  require(/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/myclient/public_html/index.php:35]
--> PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 346.


[05-Mar-2021 00:38:04 America/Chicago] PHP Notice:  Undefined variable: data in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 348
[05-Mar-2021 00:38:12 America/Chicago] PHP Notice:  Undefined property: bluepay_an::$transaction_id in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 500

[05-Mar-2021 00:35:20 America/Chicago] Request URI: /index.php?main_page=checkout_process, IP address: 76.173.42.219
#1  each() called at [/home/myclient/public_html/includes/modules/payment/bluepay_an.php:346]
#2  bluepay_an->before_process() called at [/home/myclient/public_html/includes/classes/payment.php:252]
#3  payment->before_process() called at [/home/myclient/public_html/includes/modules/checkout_process.php:91]
#4  require(/home/myclient/public_html/includes/modules/checkout_process.php) called at [/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#5  require(/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/myclient/public_html/index.php:35]
--> PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 346.


[05-Mar-2021 00:35:20 America/Chicago] PHP Notice:  Undefined variable: data in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 348
[05-Mar-2021 00:35:28 America/Chicago] PHP Notice:  Undefined property: bluepay_an::$transaction_id in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 500

[04-Mar-2021 22:51:57 America/Chicago] PHP Notice:  Undefined index: products_name in /home/myclient/public_html/includes/functions/functions_lookups.php on line 148
[04-Mar-2021 22:51:57 America/Chicago] PHP Notice:  Undefined index: products_name in /home/myclient/public_html/includes/functions/functions_lookups.php on line 148
[04-Mar-2021 22:51:57 America/Chicago] PHP Notice:  Undefined index: master_categories_id in /home/myclient/public_html/includes/functions/functions_lookups.php on line 435

[04-Mar-2021 18:29:53 America/Chicago] PHP Notice:  Undefined property: freeoptions::$quotes in /home/myclient/public_html/includes/modules/shipping/freeoptions.php on line 196

[04-Mar-2021 15:24:40 America/Chicago] Request URI: /index.php?main_page=checkout_process, IP address: 47.37.17.72
#1  each() called at [/home/myclient/public_html/includes/modules/payment/bluepay_an.php:346]
#2  bluepay_an->before_process() called at [/home/myclient/public_html/includes/classes/payment.php:252]
#3  payment->before_process() called at [/home/myclient/public_html/includes/modules/checkout_process.php:91]
#4  require(/home/myclient/public_html/includes/modules/checkout_process.php) called at [/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#5  require(/home/myclient/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/myclient/public_html/index.php:35]
--> PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 346.


[04-Mar-2021 15:24:40 America/Chicago] PHP Notice:  Undefined variable: data in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 348
[04-Mar-2021 15:24:48 America/Chicago] PHP Notice:  Undefined property: bluepay_an::$transaction_id in /home/myclient/public_html/includes/modules/payment/bluepay_an.php on line 500

[04-Mar-2021 14:25:42 America/Chicago] PHP Notice:  Undefined index: products_name in /home/myclient/public_html/includes/functions/functions_lookups.php on line 148
[04-Mar-2021 14:25:42 America/Chicago] PHP Notice:  Undefined index: products_name in /home/myclient/public_html/includes/functions/functions_lookups.php on line 148
[04-Mar-2021 14:25:42 America/Chicago] PHP Notice:  Undefined index: master_categories_id in /home/myclient/public_html/includes/functions/functions_lookups.php on line 435

[02-Mar-2021 10:41:52 America/Chicago] PHP Notice:  Undefined offset: 0 in /home/myclient/public_html/storemanager/orders.php on line 903

[01-Mar-2021 06:50:26 America/Chicago] PHP Notice:  Undefined index: products_id in /home/myclient/public_html/includes/modules/pages/product_reviews/header_php.php on line 22
[01-Mar-2021 06:50:26 America/Chicago] PHP Notice:  Undefined index: products_id in /home/myclient/public_html/includes/modules/pages/product_reviews/header_php.php on line 26
[01-Mar-2021 06:50:26 America/Chicago] PHP Notice:  Undefined index: products_id in /home/myclient/public_html/includes/modules/pages/product_reviews/header_php.php on line 26
[01-Mar-2021 06:50:26 America/Chicago] PHP Notice:  Undefined index: products_name in /home/myclient/public_html/includes/functions/functions_lookups.php on line 148
[01-Mar-2021 06:50:26 America/Chicago] PHP Notice:  Undefined index: master_categories_id in /home/myclient/public_html/includes/functions/functions_lookups.php on line 435

[swguy]

Caroline, the reason you couldn't see your posts is that they were marked as spam. I just approved this one so now people will be able to see it.

You have posted a bunch of logs that are unrelated to your problem. Please start by turning off PHP notices on your site.

For UPS, you should switch from the UPS module to UPSXML, which permits you to use your own account and get preferred rates.

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

[mc12345678]

Don't know if the above has been fully corrected yet or not, but here's a few things I generated to try to troubleshoot the situation in addition to what swguy stated.

When does it appear that all those mydebug logs began being generated?
When was the last time it seemed as if the customer requested shipping cost matched the charged price? Yes, understand the possibility that purchases may not occur daily, but it does help narrow down the window.

Some of those issues in the logs are a factor of basically the php version as it relates to the code used.
What is the lowest php version that you can select to use?

[lat9]

For the USPS shipping, you can change your setting for Retail pricing or Online pricing from Retail to Online.

[CarolineBogart]

Caroline, the reason you couldn't see your posts is that they were marked as spam. I just approved this one so now people will be able to see it.

thank you!

You have posted a bunch of logs that are unrelated to your problem. Please start by turning off PHP notices on your site.

I looked in logging, then in php.ini/user.ini/cpanel php ini editor, and cannot figure who is telling zen to output info to ./logs. Is there another spot?

For UPS, you should switch from the UPS module to UPSXML, which permits you to use your own account and get preferred rates.

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

Thank you. I switched UPS to the xml version. It's up and running. I will ask for confirmation on rate quality tomorrow.

I had the same issue with USPS. Do we have a similar update?

Unbelievably helpful, thank you again.

[CarolineBogart]

Don't know if the above has been fully corrected yet or not, but here's a few things I generated to try to troubleshoot the situation in addition to what swguy stated.

When does it appear that all those mydebug logs began being generated?
When was the last time it seemed as if the customer requested shipping cost matched the charged price? Yes, understand the possibility that purchases may not occur daily, but it does help narrow down the window.

I cannot figure where those logs are coming from. Logging is off in the main menu.

The discrepancies started for both UPS and USPS about 3 days before my post, give or take two days.

At swguy's suggestion, upsxml is now installed and running. Have yet to verify rates are equal to counter rate values, will find that out tomorrow.

At the time of my post, UPS and USPS logs were off. I turned USPS logs on at swguy's suggestion, and will post those here in a bit.

Some of those issues in the logs are a factor of basically the php version as it relates to the code used.
What is the lowest php version that you can select to use?

Site is running php 7.3.

[CarolineBogart]

Thank you, we're making progress.

Serious concern, there is a filename that is easily figured out in the /logs directory that contains the upsxml login and access info.

Regarding logs that I don't know how to turn off, they have the filename associated with the logging info in Configuration->Logging, they should not be printed as directions to log are "false."

I have USPS logs running. I will find the latest USPS order and attempt to match it with logged data. If I find the discrepancy I will report back.

[lankeeyankee]

One thing to keep in mind. UPS (and FedEx) will often charge by dimensional weight and (by default) zen cart has no way of telling the shipping service the box dimensions required by the cart contents. The rates displayed on your site will be for actual-weight only, and if your box is over the relatively small dimensional limit it will go by dimensional-weight instead of actual and could be substantially higher, especially for zones further away from the shipping origin.

I have been tinkering on and off for years with some code that will attempt to match a predefined box to the cart contents. It even has the ability to program if a product is nestable inside of another product and thus should not be added into the dimension calculation, and even more is adding an item to different nesting groups so you can create rules such as nesting group A can nest with group B, but not group C for more granular control. It's working at around 95% accuracy, but requires programmed dimensions of every product. I plan on releasing as a module at some point once I get it closer to 99% and get my long-suffering site overhaul completed, so maybe next decade

[CarolineBogart]

Would anyone have any idea how I can fix the fact that UPS is sending a subtotal that is significantly lower than its subtotal?

I'm kind of desperate, client is losing $100/day on shipping charges.

For example, below:

Here the 03 ground is returning with $14.26 GRAND TOTAL despite its own SUBTOTAL being $20.22. World Ship charged $21.43.

UPS Subtotal: $20.22
UPS Grand Total: $14.26
World Ship: $21.43

<RatedShipment><Service><Code>03</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning>
<BillingWeight>
<UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement>
<Weight>4.0</Weight></BillingWeight>
<TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>20.22</MonetaryValue></TransportationCharges>
<ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges>
<TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>20.22</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery/><ScheduledDeliveryTime/><RatedPackage>
<TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>20.22</MonetaryValue></TransportationCharges>
<ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges>
<TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>20.22</MonetaryValue></TotalCharges>
<Weight>4.0</Weight>
<BillingWeight>
<UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement>
<Weight>4.0</Weight></BillingWeight></RatedPackage>
<NegotiatedRates><NetSummaryCharges>
<GrandTotal><CurrencyCode>USD</CurrencyCode><MonetaryValue>14.26</MonetaryValue></GrandTotal></NetSummaryCharges>
</NegotiatedRates></RatedShipment>

[CarolineBogart]

UPSXML Transportation Charges: $20.22
UPSXML Grand Total: $14.26
UPSXML Discrepancy: $5.96

UPSXML Grand Total Zen Charges Customer: $14.26
WorldShip Charges: $21.43
CUSTOMER UPS SHIPPING CHARGE LOSS: $7.17