• Resolved virtualgeorge

    (@virtualgeorge)


    Sales Tax Randomly Added
    I have a site that has been up for years and I keep everything updated. Recently there have been a few orders where sales tax was added to an out-of-state order when there should have been no sales tax. I only tax customers in AZ.

    If I go to the site and make an order with the same address in a previous order that was in error and enter the person’s same address it does not add sales tax to the order and I can not replicate the issue. Seems to working as it should.

    The business is in AZ and only charges sales tax for AZ residents. We sell to many states and it seems that the few times the sales tax was added in error were only to a few addresses in California. This just recently started on only a few orders.

    Any tips on how to troubleshoot or maybe I can add something that always prevents sales tax being added to any order with a California address?

    Oh one other detail that shouldn’t have any effect but the only thing that has changed in a few years is that I changed many of the products from variable to simple products. There are a lot of options so I started using addons for the options.

    Thanks!

    • This topic was modified 4 years, 11 months ago by virtualgeorge.

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Aashik P – a11n

    (@aashik)

    Hi there!

    The business is in AZ and only charges sales tax for AZ residents. We sell to many states and it seems that the few times the sales tax was added in error were only to a few addresses in California. This just recently started on only a few orders.

    This is definitely not expected behavior. Can you please cross-check in those orders if there is any mention of AZ in the shipping address or the Billing address?

    If not, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
    Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

    Along with that, please also share a screenshot of your TAX settings from WooCommerce > Settings > TAX > Standard rates (and any other rates you’ve defined)

    Thread Starter virtualgeorge

    (@virtualgeorge)

    So the last order had the billing & shipping address:
    906 S Briargate Ln
    Glendora, CA 91740

    Nothing close or confusing and I assumed as long as they choose any state BUT AZ it wouldn’t add tax.

    I have “standard rates” and “taxable goods rates” both set with the same info. Not sure why I used both but tax class for products are all set to standard. Here is a screenshot of my tax setup:
    https://axiaalloys.com/temp/axia-help1.jpg

    I noticed there is another update for woocommerce but I am only 1 update behind.
    Thanks for your help!

    ### WordPress Environment ###

    WordPress address (URL): https://axiaalloys.com
    Site address (URL): https://axiaalloys.com
    WC Version: 3.8.0
    REST API Version: ? 1.0.2
    Log Directory Writable: ?
    WP Version: 5.3.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 7.1.33 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 512 MB
    PHP Time Limit: 0
    PHP Max Input Vars: 1000
    cURL Version: 7.62.0
    OpenSSL/1.0.2k

    SUHOSIN Installed: –
    MySQL Version: 10.1.43-MariaDB
    Max Upload Size: 512 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 3.0.8
    WC Database Prefix: wpiu_
    MaxMind GeoIP Database: ?
    Total Database Size: 270.23MB
    Database Data Size: 202.12MB
    Database Index Size: 68.11MB
    wpiu_woocommerce_sessions: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
    wpiu_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpiu_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpiu_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpiu_woocommerce_order_items: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    wpiu_woocommerce_order_itemmeta: Data: 15.55MB + Index: 12.03MB + Engine InnoDB
    wpiu_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpiu_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpiu_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpiu_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpiu_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpiu_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpiu_aws_cache: Data: 3.85MB + Index: 0.00MB + Engine MyISAM
    wpiu_aws_index: Data: 0.45MB + Index: 0.00MB + Engine MyISAM
    wpiu_cart_notices: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_commentmeta: Data: 0.47MB + Index: 0.45MB + Engine InnoDB
    wpiu_comments: Data: 4.52MB + Index: 2.72MB + Engine InnoDB
    wpiu_feedmanager_channel: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpiu_feedmanager_country: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wpiu_feedmanager_errors: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_feedmanager_feed_status: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpiu_feedmanager_field_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_feedmanager_product_feed: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_feedmanager_product_feedmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpiu_feedmanager_source: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpiu_formcraft_3_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_formcraft_3_forms: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wpiu_formcraft_3_progress: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_formcraft_3_submissions: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wpiu_formcraft_3_views: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wpiu_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpiu_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_options: Data: 100.59MB + Index: 7.06MB + Engine InnoDB
    wpiu_pmxe_exports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxe_posts: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxe_templates: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxi_images: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpiu_pmxi_imports: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxi_posts: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wpiu_pmxi_templates: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wpiu_postmeta: Data: 42.58MB + Index: 33.13MB + Engine InnoDB
    wpiu_posts: Data: 5.52MB + Index: 3.78MB + Engine InnoDB
    wpiu_revslider_css: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
    wpiu_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_revslider_sliders: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpiu_revslider_slides: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
    wpiu_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpiu_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpiu_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpiu_term_relationships: Data: 1.52MB + Index: 0.34MB + Engine InnoDB
    wpiu_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wpiu_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_usermeta: Data: 7.52MB + Index: 6.03MB + Engine InnoDB
    wpiu_users: Data: 1.52MB + Index: 0.39MB + Engine InnoDB
    wpiu_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpiu_wc_product_meta_lookup: Data: 0.05MB + Index: 0.08MB + Engine MyISAM
    wpiu_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpiu_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (23) ###

    Advanced Woo Search: by ILLID – 1.84 – Not tested with the active version of WooCommerce
    Code Snippets: by Shea Bunge – 2.13.3
    FormCraft: by nCrafts – 3.2.26
    Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 5.3.9
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.1
    Slider Revolution: by ThemePunch – 5.3.1.5
    TAO Schedule Update: by TAO Digital – 1.15
    Tracking Code Manager: by IntellyWP – 1.12.0 – Not tested with the active version of WooCommerce
    Google Dynamic Remarketing: by Sinaps Marketing – 2.2
    WooCommerce Extended Coupon Features FREE: by Soft79 – 3.1.2 – Not tested with the active version of WooCommerce
    WooCommerce Cart Notices: by SkyVerge – 1.7.0 – Not tested with the active version of WooCommerce
    WooCommerce Google Ads Conversion Tracking: by Wolf+B?r Agency – 1.5.5 – Not tested with the active version of WooCommerce
    WooCommerce Google Analytics Integration: by WooCommerce – 1.4.15
    WooCommerce Product Add-ons: by WooCommerce – 3.0.16 – Not tested with the active version of WooCommerce
    WooCommerce UPS Shipping: by Automattic – 3.2.1 – Not tested with the active version of WooCommerce
    WooCommerce USPS Shipping: by WooCommerce – 4.4.4 – Not tested with the active version of WooCommerce
    WooCommerce Smart Coupons: by StoreApps – 3.3.0 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.8.0 – 3.8.1 is available
    WooSidebars: by WooCommerce – 1.4.5
    WP All Export Pro: by Soflyy – 1.5.7
    WP Media folder: by Joomunited – 4.9.3
    WP Product Feed Manager: by Michel Jongbloed – 1.17.1 – Not tested with the active version of WooCommerce
    WP Sitemap Page: by Tony Archambeau – 1.6.2

    ### Inactive Plugins (6) ###

    Cart Migration: by LitExtension – 1.0.0 – Not tested with the active version of WooCommerce
    UpdraftPlus – Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.16.14.24

    W3 Total Cache: by Frederick Townes – 0.10.1
    WP-Optimize – Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.0.13

    WP All Import – WooCommerce Add-On Pro: by Soflyy – 3.0.8 – Not tested with the active version of WooCommerce
    WP All Import Pro: by Soflyy – 4.5.7

    ### Settings ###

    API Enabled: ?
    Force SSL: ?
    Currency: USD ($)
    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: #20 – /shop/
    Cart: #21 – /cart/
    Checkout: #22 – /checkout/
    My account: #23 – /my-account/
    Terms and conditions: ? Page not set

    ### Theme ###

    Name: Flatsome Child
    Version: 3.0
    Author URL:
    Child Theme: ?
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.8.3
    Parent Theme Author URL: https://www.uxthemes.com/
    WooCommerce Support: ?

    ### Templates ###

    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php version 3.5.0 is out of date. The core version is 3.8.0
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/thankyou.php version 3.2.0 is out of date. The core version is 3.7.0
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome-child/woocommerce/emails/admin-new-order.php version 2.5.0 is out of date. The core version is 3.7.0
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php version 3.3.0 is out of date. The core version is 3.7.0
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php version 2.4.0 is out of date. The core version is 3.8.0
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php

    Outdated Templates: ?

    Learn how to update

    ### Action Scheduler ###

    Complete: 447
    Oldest: 2019-11-25 17:38:34 -0700
    Newest: 2019-12-19 13:44:13 -0700

    Pending: 0
    Oldest: –
    Newest: –

    Canceled: 0
    Oldest: –
    Newest: –

    In-progress: 0
    Oldest: –
    Newest: –

    Failed: 0
    Oldest: –
    Newest: –

    Plugin Support Aashik P – a11n

    (@aashik)

    Hi there!

    Thank you for getting back to us with your findings and System Status Report.

    Not sure why I used both but tax class for products are all set to standard. Here is a screenshot of my tax setup:
    https://axiaalloys.com/temp/axia-help1.jpg

    standard rate
    Link to image: https://d.pr/i/b6mZWM

    Am I right in understanding that even though you have two tax classes setup, Standard rates are the only tax classes assigned to your products?

    In that case, from the screenshot you’ve shared – only AZ needs to be charged tax.

    I noticed there is another update for woocommerce but I am only 1 update behind.

    From the System Status Report, while I do notice that the WooCommerce installed is at version 3.8.0, the WooCommerce database itself is at 3.0.8. For further steps:

    1. Reach out to your Web Host to ensure that you have the latest, working backup of your site
    2. Update everything on the site, including WooCommerce, and WooCommerce database (by accessing Dashboard > WooCommerce > Status > Tools > Update database)
    3. Check if you’re still seeing the same behavior upon trying to checkout using a different address

    If you’re still seeing the same behavior, can you please share a screenshot of WooCommerce > Settings > TAX tab?

    Thread Starter virtualgeorge

    (@virtualgeorge)

    I have updated the database. I had updated previously but I guess the update failed. I never noticed it was still the old DB version so thanks for pointing that out! It took me a few tries but is now showing the correct version.

    Could that have caused this error with the sale tax?

    How can be sure the problem is solved? I was never able to replicate the problem before even if I entered the exact same address as was on the orders with sales tax being added incorrectly.

    Thanks!

    Plugin Support Aashik P – a11n

    (@aashik)

    Could that have caused this error with the sale tax?

    I’m not 100% sure about that, but this is the first step before investigating further.

    How can be sure the problem is solved? I was never able to replicate the problem before even if I entered the exact same address as was on the orders with sales tax being added incorrectly.

    Interesting. After updating the database though, did you notice any similar orders where TAX was added even if the order was not from AZ?

    This is the only way to reconfirm this since you’re unable to replicate this behavior.

    If you’re still seeing this behavior though, the next step would be to ensure there are no conflicts on the site. This kind of problem is usually caused by either a conflict with your theme or with another plugin.
    ?
    The best way to determine this is to:
    ?

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    Thread Starter virtualgeorge

    (@virtualgeorge)

    Well there is no reason to test for a conflict IF I cannot replicate the issue.

    So just wondering why I have orders with the tax added but I cannot replicate by creating an order with the same exact address?

    I have never had an issue that I could not replicate and it does not seem to be an issue that others have experienced so must be something unique to my setup. Not sure what to tell the client ??

    I wonder if it could be a certain mobile device or operating system causing a glitch?

    Thanks for your help.

    Plugin Support Aashik P – a11n

    (@aashik)

    Hi there!

    Apologies for the delayed response here.

    Well there is no reason to test for a conflict IF I cannot replicate the issue.

    I wonder if it could be a certain mobile device or operating system causing a glitch?

    That’s a fair assumption, but we cannot confirm that there isn’t a conflict until no one is able to replicate this behavior. The conflict test may or may not help us narrow this down, but it is a starting step. Especially since this is not something that can be replicated on a stock WooCommerce installation which just runs Storefront as the theme.

    I’d also recommend checking with your WebHost to confirm that the cart, my-account and checkout pages are not cached.

    Let us know how the testing goes.

    Plugin Support Aashik P – a11n

    (@aashik)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thread Starter virtualgeorge

    (@virtualgeorge)

    This has not been resolved it is just so random that it is hard to test for. Happens about once a month and we have many out of state orders daily, average about 3-400 per month. I keep everything updated and today again we got another out of state order charged sales tax.

    Can’t reproduce using the same info on the order and no sense using a different theme yet as we would have to wait a month perhaps to see the error again?

    The only thing I can think of is I started using the built in import/export a few months ago, prior to that used wp all import pro to make updates for the last few years.

    Any ideas on what to do next?

    thx!!

    Plugin Support Aashik P – a11n

    (@aashik)

    Hi there!

    Sorry for the delayed response here. The topic was marked resolved due to inactivity.

    I understand that you’re still seeing the same behavior in your store, and it is quite tricky to narrow this down to a conflict due to the random nature of this.

    Can’t reproduce using the same info on the order and no sense using a different theme yet as we would have to wait a month perhaps to see the error again?

    The only thing I can think of is I started using the built in import/export a few months ago, prior to that used wp all import pro to make updates for the last few years.

    Ideally, that shouldn’t cause the behavior you’re seeing where only some orders are being charged TAX on out of state orders. Chances of this affecting TAX is slim as you’re not able to replicate the same behavior upon trying to make a new order using the same details as the customer who was charged TAX did!

    For further troubleshooting, please log in to your WooCommerce.com account and create a ticket to us at ?https://woocommerce.com/my-account/create-a-ticket/?form=ticket, and provide the following details along with the query:

    1. A link to this forum interaction
    2. Screenshots of orders (from order details page) where TAX was changed incorrectly.
    3. Screenshots of the product configuration page. Specifically the General tab
    4. Screenshot of tax configuration at WooCommerce > settings > TAX > Standard rates and WooCommerce > Settings > TAX > Taxable goods rates
    5. A copy of the latest System Status Report

    Please make sure to redact any personal details in the screenshot you’re sharing with us.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Sales Tax added to out of state customers (rarely)’ is closed to new replies.