• Resolved Vadim

    (@vadimdude)


    Hi there,

    There seems to be unexpected behavior in WooCommerce currently. I have deactivated all the other plugins and activated a standard 2021 theme. Here’s the situation:

    In my tax options, I have manually entered standard tax rates, different one for each Canadian province. I have it also set to calculate tax based on billing.

    In my shipping zones, I have 1 zone defined with a region and postcode wildcards.

    Then, on checkout page, this is what needs to happen in order for the tax name/amount to be properly updated in the order-review table via AJAX:

    1. All the required fields need to be filled (billing AND shipping)
    2. The shipping region and postcode NEED to match the zone I have set up

    Only then, when I start switching the billing provinces, does the tax name/amount gets properly updated. When the above 2 conditions are not met, the tax name/amount stay the same (one of the standard tax rates I defined) after each Ajax call triggered by the billing province select box changes.

    Would you be able to provide any guidance on the issue?

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://localhost/fan
    Site address (URL): https://localhost/fan
    WC Version: 5.9.0
    REST API Version: ? 5.9.0
    WC Blocks Version: ? 6.1.0
    Action Scheduler Version: ? 3.3.0
    WC Admin Version: ? 2.8.0
    Log Directory Writable: ?
    WP Version: 5.8.2
    WP Multisite: –
    WP Memory Limit: 10 GB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.41 (Ubuntu)
    PHP Version: 7.4.3
    PHP Post Max Size: 512 MB
    PHP Time Limit: 50000
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.27-0ubuntu0.20.04.1
    Max Upload Size: 50 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.9.0
    WC Database Prefix: wp_
    Total Database Size: 8.02MB
    Database Data Size: 6.11MB
    Database Index Size: 1.91MB
    wp_woocommerce_sessions: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.09MB + Index: 0.16MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 2.09MB + Index: 0.06MB + Engine InnoDB
    wp_postmeta: Data: 0.34MB + Index: 0.25MB + Engine InnoDB
    wp_posts: Data: 2.52MB + Index: 0.06MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 29
    acf-field-group: 5
    attachment: 43
    collection: 5
    color: 11
    nav_menu_item: 9
    page: 18
    post: 1
    product: 49
    product_variation: 36
    revision: 201
    shop_order: 17
    wp_block: 1
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ?Error messages should not be shown to visitors.
    
    ### Active Plugins (1) ###
    
    WooCommerce: by Automattic – 5.9.0 (update to version 6.0.0 is available)
    
    ### Inactive Plugins (10) ###
    
    Admin Columns: by AdminColumns.com – 4.4.4
    Admin Menu Editor: by Janis Elsts – 1.10
    Advanced Custom Fields PRO: by Delicious Brains – 5.10.2
    Contact Form 7: by Takayuki Miyoshi – 5.5.3
    Custom Post Type UI: by WebDevStudios – 1.10.1
    Delivery & Pickup Date Time for WooCommerce: by CodeRockz – 1.3.18
    Improved Save Button: by Label Blanc – 1.2.1
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
    WooCommerce PayPal Payments: by WooCommerce – 1.6.3
    Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.3
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: CAD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Shop base: #415 - /all-products/
    Cart: #276 - /cart/
    Checkout: #277 - /checkout/
    My account: #278 - /my-account/
    Terms and conditions: #37 - /policies-disclaimers/
    
    ### Theme ###
    
    Name: Twenty Twenty-One
    Version: 1.4
    Author URL: https://www.ads-software.com/
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 278
    Oldest: 2021-11-23 02:23:12 +0000
    Newest: 2021-12-17 00:41:48 +0000
    
    ### Status report information ###
    
    Generated at: 2021-12-17 00:55:54 +00:00
    
Viewing 5 replies - 1 through 5 (of 5 total)
  • Hello,

    Could you share screenshots of how your shipping and taxes are configured?
    I recommend?https://snipboard.io?for easily sharing screenshots – please follow the instructions on the page, then paste the URL in this chat. It works with Chrome, Firefox, Safari, and Edge.

    Thread Starter Vadim

    (@vadimdude)

    Thanks for looking into it Maykato. Here are the screenshots:

    https://snipboard.io/i02ODz.jpg
    https://snipboard.io/cOGqpy.jpg
    https://snipboard.io/jBS1aE.jpg
    https://snipboard.io/41UkFK.jpg
    https://snipboard.io/fDKaQi.jpg

    Please let me know if anything else would help.

    Thread Starter Vadim

    (@vadimdude)

    Just a quick correction on my original post: condition #1 doesn’t have to be met, only the 2nd one does

    Hi @vadimdude

    Thank you for sharing the screenshots.

    Just a quick correction on my original post: condition #1 doesn’t have to be met, only the 2nd one does

    2. The shipping region and postcode NEED to match the zone I have set up

    Looking at this screenshot, I see that you’ve created a shipping zone using wildcards: M2*, M3*, M4*, M5*…

    Try adding space before the * – so it’s like M2 *, M3 *, M4 *, M5 *..., and check if that fixes the issue.

    Thread Starter Vadim

    (@vadimdude)

    Thanks for the suggestion, but that didn’t fix the issue.

    However, I figured out why this was happening. You see, my zone called “Locations not covered by your other zones” has a shipping method “Local pickup”. That’s a built-in WC shipping method and in its description it says that “By default, when using local pickup store base taxes will apply regardless of customer address.” (https://snipboard.io/93wlWO.jpg) So therefore, when the shipping postcode doesn’t match the Toronto zone (https://snipboard.io/cOGqpy.jpg), the checkout defaults to the local pickup. And that’s when the store base tax (in my case Ontario, Canada) gets applied no matter which billing province I select, and that’s why it wasn’t changing when I was switching the billing province.

    So, everything is working as intended. Thanks a lot for your help!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Tax based on billing only updates when a shipping zone is matched’ is closed to new replies.