Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default 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.

    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

    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

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,669
    Plugin Contributions
    104

    Default 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
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  3. #3
    Join Date
    Jul 2012
    Posts
    15,653
    Plugin Contributions
    17

    Default 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?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,267
    Plugin Contributions
    78

    Default 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.

  5. #5
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default Re: UPS and USPS are charging store more than zen cart is charging customer.

    Quote Originally Posted by swguy View Post
    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 View Post
    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 View Post
    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.

  6. #6
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default Re: UPS and USPS are charging store more than zen cart is charging customer.

    Quote Originally Posted by mc12345678 View Post
    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 View Post
    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.

  7. #7
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default 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.

  8. #8
    Join Date
    Jan 2007
    Posts
    1,481
    Plugin Contributions
    10

    Default 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

    Zen Cart and it's community are the best!!

  9. #9
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default 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>
    Last edited by CarolineBogart; 11 Mar 2021 at 06:36 AM.

  10. #10
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default 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

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. UPS double charging for items less than 1 pound
    By mek113 in forum Addon Shipping Modules
    Replies: 10
    Last Post: 18 Jan 2012, 05:14 PM
  2. store suddenly charging shipping for downloads
    By pjgscrap in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 6 Jul 2009, 04:55 PM
  3. Shipping Calc charging more than UPS site.. Cant figure ratio
    By STFlats in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 27 May 2008, 06:31 PM
  4. Store is not charging tax why?
    By wmorris in forum General Questions
    Replies: 3
    Last Post: 7 Aug 2007, 11:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR