Support » Plugin: WooCommerce » Tax table not showing up

  • Resolved jotaceawm

    (@jotaceawm)


    Hello community,

    My taxes are not showing up. on the settings page, standard rates. I insert row with the country code ES, 21.00% and the other spaces with an asterisk. It is not saved.

    I tried to upload a CSV, it puts me that everything is OK. And then when I give you to show taxes that table is blank. By the way, it has saved, but after it does, the “Save Changes” button fades (so that you cannot save again).

    I looked for a thread and saw that this user is the same as me. But nothing is resolved in this thread.

    https://wordpress.org/support/topic/taxes-are-not-showing-up/

    Can you help me?

    Greetings and thank you.

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support grigaswp

    (@grigaswp)

    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 1 month, 3 weeks ago by jotaceawm.
    Plugin Support grigaswp

    (@grigaswp)

    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.

    Plugin Support John Coy

    (@johndcoy)

    Automattic Happiness Engineer

    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.

    Plugin Support John Coy

    (@johndcoy)

    Automattic Happiness Engineer

    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](https://d.pr/i/Mq89qa+)
    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.

    Plugin Support John Coy

    (@johndcoy)

    Automattic Happiness Engineer

    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.

Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.