Tax table not showing up

Hi there,

Thank you for reaching out!

I understand that after saving the standard tax rates in WooCommerce >> Settings >> Tax >> Standard rates, the row you’ve added simply disappears.

That does sound odd and the thread you’ve linked to seems to be slightly different – the tax rates were not applied on the cart/checkout pages. That seems to have been related to automated tax calculation with WooCommerce Services.

Can you please specify whether you are unable to save the tax rates in WooCommerce >> Settings >> Tax >> Standard rates or you are able to save the tax rates there but those aren’t applied during checkout? Also, are you using automated tax calculation with WooCommerce Services?

If the tax rates in WooCommerce >> Settings >> Tax >> Standard rates are not saved at all and automated tax calculation is not enabled in WooCommerce >> Settings >> Tax – there’s a chance this behaviour is caused by a plugin/theme conflict on your site as this is not something I am able to replicate on my own test site.

Read more about plugin and theme conflicts in the Self-Service Guide on WooCommerce.com.

How to test for conflicts

The best way to determine if this behaviour is being caused by a theme and/or plugin is to:

1. Temporarily switch your theme to the Storefront theme.
2. Check if the checkout fields are being loaded. If they are – it is a conflict with your theme. If not, continue to the next step.
3. Temporarily deactivate all plugins except WooCommerce and Square. You can do this manually or use a plugin to help (see below for tools).
4. Try to reproduce the problem again. If the problem is resolved, it is a plugin conflict. To figure out which plugin is causing the problem, continue to the next step.
5. Reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

For more detailed instructions, check out How to test for plugin and theme conflicts:

https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Please let us know how that goes.

Tools to help with troubleshooting

You can clone your site to a staging environment and perform tests without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

Hello Grigaswp,

This is what I do:

1. I open Woocommerce tax page
2. I enter the tax information I want
3. I save the changes
4. The tax table appears blank. The same happens if I upload a CSV file. It tells me that it was uploaded successfully but the table is not updated.

So, my problem is the following:

If the tax rates in WooCommerce >> Settings >> Tax >> Standard rates are not saved at all and automated tax calculation is not enabled in WooCommerce >> Settings >> Tax – there’s a chance this behaviour is caused by a plugin/theme conflict on your site as this is not something I am able to replicate on my own test site.

Therefore, Woocommerce must be dealing with some plugin as you say. I will use WP Staging to find out which plugin is in conflict with the Woocommerce core.

I will inform you if I can solve it.

Thank you very much for your information, very useful.

Greetings and thank you.

• This reply was modified 5 years, 2 months ago by jotaceawm.

Hi there,

Thank you for confirming that you are still not able to save the tax rates in WooCommerce >> Settings >> Tax >> Standard rates!

I’ll leave this thread open and do let us know about your findings from a plugin/theme conflict test.

Best regards,
G

Hi,

I followed the steps you indicated.

I changed the theme to Storefront and deactivated all plugins except Woocommerce and WP Staging. It still doesn’t work. It stays charging and the tax row is not saved.

I do not know what else to do. I find it very strange that it doesn’t work that way…

Thank you very much for the help.

Greetings.

Hi @jotaceawm

Thanks for the reply! WooCommerce settings not saving, or in this case, changes to the Standard Tax table are likely caused by aggressive caching by the web host or a permissions issue with the database.

I’d suggest you contact your host to have them take a closer look at your installation. They can review PHP error logs and disable any caching tools they may have enabled.

We hope you can get this issue sorted out with the web host!

Thanks again,

Hello @johndcoy

I have updated the WooCommerce templates. Because some were obsolete. But it still doesn’t work.

In fact, I have realized that it also does not allow me to save the shipping areas.

I’m going to get in touch with my hosting telling you what you say. Let’s see what solution you offer me.

I keep you informed.

Thank you very much for your help.

Greetings.

Hi @johndcoy

I contacted the hosting and they sent me the PHP error logs. Everything indicates that it is a WordPress database error. I hit a piece of one of the errors in the logs:

[05-Feb-2020 21:55:04 UTC] Error Table ‘user.wp_woocommerce_tax_rates’ doesn’t exist in WordPress database engine for query
SELECT tax_rates. *, COUNT (locations.location_id) as postcode_count, COUNT (locations2.location_id) as city_count
FROM wp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1 = 1 AND tax_rate_country IN (‘ES’, ”) AND tax_rate_state IN (‘C’, ”) AND tax_rate_class = ” AND ((locations.location_type IS NULL)

How can i fix this?

Greetings and thank you.

Hi @jotaceawm

Thanks for the reply.

[05-Feb-2020 21:55:04 UTC] Error Table ‘user.wp_woocommerce_tax_rates’ doesn’t exist in WordPress database engine for query...

It appears a table that is trying to be written to doesn’t exist. So there is something likely keeping WooCommerce from writing to it – probably a permissions issue. If the user.wp_woocommerce_tax_rates does exist, then try removing it manually from the database then save the tax tables under WooCommerce > Settings > Taxes.

It likely will be created again when there is an attempt to write to it.

Screenshot link: https://d.pr/i/Mq89qa

If you are not using a plugin to manage taxes, the last option would be to reinstall WooCommerce and make sure its database is updated as well. You can update the WooCommerce database under WooCommerce > Status > Tools.

Howdy @jotaceawm

We haven’t heard back from you so we are going to mark this thread as resolved. If you or anyone else is seeing a similar issue after removing the table and reinstalling WooCommerce, feel free to create a new support request.

Thanks,

Hello Jhon

In my base of data, all tables that refer to WooCommerce are “corrupted”, in other words, empty. They have been deleted. Surely by the action of a plugin.

I have reinstalled WooCommerce again and everything is working correctly.

Greetings and thanks for the help.