UPS and USPS are charging store more than my store is charging customer.
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.
Quote:
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
Quote:
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
Code:
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
Code:
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
Code:
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
Code:
[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
Code:
[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
Code:
[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
Code:
[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
Code:
[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
Code:
[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
Code:
[02-Mar-2021 10:41:52 America/Chicago] PHP Notice: Undefined offset: 0 in /home/myclient/public_html/storemanager/orders.php on line 903
Code:
[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
Re: UPS and USPS are charging store more than zen cart is charging customer.
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
Re: UPS and USPS are charging store more than zen cart is charging customer.
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?
Re: UPS and USPS are charging store more than zen cart is charging customer.
For the USPS shipping, you can change your setting for Retail pricing or Online pricing from Retail to Online.
Re: UPS and USPS are charging store more than zen cart is charging customer.
Quote:
Originally Posted by
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.
thank you!
Quote:
Originally Posted by
swguy
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?
Quote:
Originally Posted by
swguy
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.
Re: UPS and USPS are charging store more than zen cart is charging customer.
Quote:
Originally Posted by
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.
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.
Quote:
Originally Posted by
mc12345678
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.
Re: UPS and USPS are charging store more than zen cart is charging customer.
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.
Re: UPS and USPS are charging store more than zen cart is charging customer.
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:shocking::laugh:
Re: UPS and USPS are charging store more than zen cart is charging customer.
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
Code:
<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>
Re: UPS and USPS are charging store more than zen cart is charging customer.
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