Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2018
    Posts
    11
    Plugin Contributions
    0

    Default Orders (rarely) missing shipping charge

    I have recent received 2 (out of many) orders that are missing shipping charge. They are from different customers about a week apart. This should not be possible as there should be no situation in which the customer is not forced to choose a shipping option.

    At least one of the customers has ordered before with shipping correctly charged.

    One order (xx188) is listed as "Trans. Type: cart", the other (xx420) "Trans. Type: expresscheckout"




    select * from orders_total where orders_id=xx420;
    +-----------------+-----------+------------+-----------+---------+-------------+------------+
    | orders_total_id | orders_id | title | text | value | class | sort_order |
    +-----------------+-----------+------------+-----------+---------+-------------+------------+
    | 296553 | xx420 | Sub-Total: | $53.89CDN | 53.8863 | ot_subtotal | 100 |
    | 296554 | xx420 | : | $0.00CDN | 0.0000 | ot_shipping | 200 |
    | 296555 | xx420 | HST (13%): | $7.01CDN | 7.0052 | ot_tax | 300 |
    | 296556 | xx420 | Total: | $60.89CDN | 60.8915 | ot_total | 999 |
    +-----------------+-----------+------------+-----------+---------+-------------+------------+
    4 rows in set (0.00 sec)

    select * from orders_total where orders_id=xx188;
    +-----------------+-----------+--------------+-----------+---------+-------------+------------+
    | orders_total_id | orders_id | title | text | value | class | sort_order |
    +-----------------+-----------+--------------+-----------+---------+-------------+------------+
    | 295557 | xx188 | Sub-Total: | $49.07CDN | 49.0748 | ot_subtotal | 100 |
    | 295558 | xx188 | : | $0.00CDN | 0.0000 | ot_shipping | 200 |
    | 295559 | xx188 | GST (5%): | $2.45CDN | 2.4537 | ot_tax | 300 |
    | 295560 | xx188 | BC PST (7%): | $3.44CDN | 3.4352 | ot_tax | 300 |
    | 295561 | xx188 | Total: | $54.96CDN | 54.9638 | ot_total | 999 |
    +-----------------+-----------+--------------+-----------+---------+-------------+------------+


    select * from orders where orders_id=xx188\G
    *************************** 1. row ***************************
    orders_id: xx188
    <snip>
    payment_method: PayPal
    payment_module_code: paypalwpp
    shipping_method:
    shipping_module_code:
    coupon_code:
    cc_type:
    cc_owner:
    cc_number:
    <snip>
    orders_status: 3
    orders_date_finished: NULL
    currency: CAD
    currency_value: 1.000000
    order_total: 54.96
    order_tax: 5.89
    paypal_ipn_id: 0


    select * from orders where orders_id=xx420\G
    *************************** 1. row ***************************
    orders_id: xx420
    <snip>
    payment_method: PayPal
    payment_module_code: paypalwpp
    shipping_method:
    shipping_module_code:
    coupon_code:
    cc_type:
    cc_owner:
    cc_number:
    <snip>
    orders_status: 3
    orders_date_finished: NULL
    currency: CAD
    currency_value: 1.000000
    order_total: 60.89
    order_tax: 7.01
    paypal_ipn_id: 0

  2. #2
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Orders (rarely) missing shipping charge

    With regards to the product ordered and the chosen destination, what is the expected (condition can also be recreated using ones own user account) availability of shipping options as configured for the store?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Feb 2018
    Posts
    11
    Plugin Contributions
    0

    Default Re: Orders (rarely) missing shipping charge

    There should be only 1 shipping option, which SHOULD look like this in the orders table (does look like this for orders that do work from the same regions)

    For order id: xx420
    shipping_method: Shipping Option (Canada Post Expedited - East Canada)
    shipping_module_code: zonetable

    For order id: xx188
    shipping_method: Shipping Option (Canada Post Expedited - British Columbia)
    shipping_module_code: zonetable

    zonetable is the only shipping module enabled. It is configured with 4 zones covering all of Canada, plus 1 zone for US (orders are not accepted outside Canada and US).

    Tax was correctly applied to those orders (which varies from province to province), so it can't be as simple as screwed up zones. Plus many other orders are placed from those same provinces with correct shipping charges.

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Orders (rarely) missing shipping charge

    What was the 'delivery address' for those orders that didn't get charged shipping?

  5. #5
    Join Date
    Feb 2018
    Posts
    11
    Plugin Contributions
    0

    Default Re: Orders (rarely) missing shipping charge

    Customer, delivery and shipping addresses are identical.

    I can't give out the full addresses for privacy reasons, but for one it contains
    Code:
                  billing_state: Ontario
                billing_country: Canada
    Which is part of the "East Canada" shipping zone

    And the other contains
    Code:
                  billing_state: British Columbia
                billing_country: Canada
    which is part of the "British Columbia" shipping zone.

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Orders (rarely) missing shipping charge

    You might get more response by posting your issue in the Canada Post Shipping plugin's support thread: https://www.zen-cart.com/showthread....da-Post-module. It sounds to me like some kind of configuration problem, but I'm not familiar with that shipping method.

 

 

Similar Threads

  1. v155 Orders occasionally removing shipping method and charge
    By HeathenMagic in forum PayPal Express Checkout support
    Replies: 1
    Last Post: 24 Sep 2017, 07:57 PM
  2. Free shipping for orders over $100 BUT if weighs more than 25 pounds, charge shipping
    By WWRepair in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 30 Aug 2012, 11:38 PM
  3. Single charge for multiple orders via perwieightunit shipping
    By jxl1 in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 20 Oct 2011, 01:32 PM
  4. How to not calculate shipping charge on international orders only?
    By 4-tec in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 3 Apr 2010, 10:24 AM
  5. Missing Shipping and Billing Info in Orders
    By plowe1 in forum Managing Customers and Orders
    Replies: 9
    Last Post: 21 May 2006, 02:06 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