Sales Tax added to out of state customers (rarely)
-
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]
-
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)
So the last order had the billing & shipping address:
906 S Briargate Ln
Glendora, CA 91740Nothing 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.jpgI 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.2kSUHOSIN 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.24W3 Total Cache: by Frederick Townes – 0.10.1
WP-Optimize – Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.0.13WP 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.phpOutdated Templates: ?
Learn how to update
### Action Scheduler ###
Complete: 447
Oldest: 2019-11-25 17:38:34 -0700
Newest: 2019-12-19 13:44:13 -0700Pending: 0
Oldest: –
Newest: –Canceled: 0
Oldest: –
Newest: –In-progress: 0
Oldest: –
Newest: –Failed: 0
Oldest: –
Newest: –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
Link to image: https://d.pr/i/b6mZWMAm 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 addressIf you’re still seeing the same behavior, can you please share a screenshot of WooCommerce > Settings > TAX tab?
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!
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.
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.
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.
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.
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!!
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 theGeneral 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 ReportPlease make sure to redact any personal details in the screenshot you’re sharing with us.
- The topic ‘Sales Tax added to out of state customers (rarely)’ is closed to new replies.