Tax table not saving
-
Hello, I would prefer not to share the URL to the website I am developing as my client does not want their competition to know they are working on a new website.
The problem is that when I create a row for a tax rate, the entire row disappears as soon as I save it.
Here is what I have tried so far:
- deactivated all plugins – didn’t work
- checked to be sure that all the Woocommerce tax tables were present in the database. They are:
- deleted the woocommerce_tax_rate_locations table and tried again – didn’t work and the table was not recreated in the DB
- deactivated and reactivated Woocommerce and tried again – didn’t work
At this point, what other steps do you recommend?
-
Hi there,
Thanks for reaching out and sorry to hear of the troubles.
When you were testing with plugins deactivated, did you also test by switching to a default theme, like Storefront? If not, can you try that as well to rule out any theme conflicts?
When attempting to save the tax rate, did you spot any errors in the dev console? Also, what’s the WP Memory Limit set to?
I switched to the Twenty Twenty theme and boosted the memory limit to 256 and my tax table still won’t save.
Something I didn’t mention above is that this website is being developed on a staging server. There is an SSL certificate in place.
I did download, install and activate the Storefront theme. The tax table still won’t save.
Here is my system status if it helps:
### WordPress Environment ### WordPress address (URL): https://www.spacelift-theme.markhannondesign.com Site address (URL): https://www.spacelift-theme.markhannondesign.com WC Version: 4.3.1 REST API Version: ? 1.0.10 WC Blocks Version: ? 2.7.2 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 1.3.1 Log Directory Writable: ? WP Version: 5.4.2 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.16 PHP Post Max Size: 128 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.59.0 OpenSSL/1.0.2r SUHOSIN Installed: – MySQL Version: 5.6.40-84.0-log Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 4.3.1 WC Database Prefix: redc_ Total Database Size: 4.32MB Database Data Size: 2.67MB Database Index Size: 1.65MB redc_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB redc_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB redc_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB redc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB redc_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_nextend2_section_storage: Data: 0.05MB + Index: 0.06MB + Engine InnoDB redc_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_nextend2_smartslider3_sliders: Data: 0.06MB + Index: 0.03MB + Engine InnoDB redc_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB redc_options: Data: 1.08MB + Index: 0.06MB + Engine InnoDB redc_postmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB redc_posts: Data: 0.47MB + Index: 0.06MB + Engine InnoDB redc_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB redc_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB redc_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB redc_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB redc_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB redc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB redc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB redc_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 38 customize_changeset: 3 ditty_news_ticker: 1 nav_menu_item: 9 page: 25 post: 2 product: 4 revision: 59 wpforms: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (8) ### All-in-One WP Migration Unlimited Extension: by ServMask – 2.37 All-in-One WP Migration: by ServMask – 7.25 Ditty News Ticker: by Metaphor Creations – 2.2.17 Facebook for WooCommerce: by Facebook – 1.11.4 – Installed version not tested with active version of WooCommerce 4.3.1 Smart Slider 3: by Nextend – 3.4.1.8 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.0.3 WooCommerce: by Automattic – 4.3.1 WPForms Lite: by WPForms – 1.6.1 ### Inactive Plugins (1) ### Akismet Anti-Spam: by Automattic – 4.1.6 ### 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: #27 - /shop/ Cart: #134 - /cart/ Checkout: #135 - /checkout/ My account: #136 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Spacelift Products Version: 1.0.0 Author URL: https://underscores.me/ 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: ? Not declared ### Templates ### Overrides: – ### Action Scheduler ### Complete: 21 Oldest: 2020-07-20 14:58:38 +0000 Newest: 2020-07-29 15:01:22 +0000 Pending: 1 Oldest: 2020-07-30 00:00:00 +0000 Newest: 2020-07-30 00:00:00 +0000
Howdy,
Thanks for your reply.
I see that there were some plugins still installed on the System Status Report you sent over, so I just wanted to confirm that those were only reactivated after your conflict testing was completed?
Also, are you seeing any errors in the dev console when attempting to save the tax row? If so, could you post a screenshot of that error? You can use https://snipboard.io/ to send screenshots here. You’ll just drag and drop the image into the window, and it will generate a URL to paste here.
Last, sometimes firewalls or security settings can cause data not to save like this. Would you be able to check in with your web host to see if there’s anything installed that could be blocking this request?
Thanks and looking forward to your reply.
Hello laceyrod, yes, I had reactivated the plugins after attempting to save the tax table with all plugins deactivated and having switched to the twenty twenty theme.
There wasn’t much to be found in my console and it didn’t change when I tried again to save the tax table:
I will check with my host regarding any security settings or firewalls they may have in place that could interfere with with saving the tax table.
Hi @figure2. Did you manage to resolve this issue or is it still a problem? Did it persist after updating to the latest version of WooCommerce?
The problem is not resolved, even after the update and my web host (Siteground) tells me that there is nothing on their hosting platform that would interfere with creating tax tables.
I suspect that the tables may be being created, but something is preventing them from displaying on the tax table settings page.
I am also having this issue. When I try to manually insert a row on the standard tax rates, it doesn’t save. The tables are in the database (viewing with PHPmyadmin) but no data is being written there. I created a clean install of wordpress on my server with the storefront theme and a clean install of woocommerce. No other plugins installed except for what comes with the default wp 5.5.1 installation (downloaded fresh). PHP max input vars are 2080, memory limit is 500M, max input time is 120, max execution time is 180. SoapClient is not installed, but woo says that is only required for certain gateway plugins, I plan on getting that installed later.
Here is a screen shot of the chrome console with LogXMLHttpRequests on:
rekrapt, this problem is bigger than the Woocommerce mods realize (or will admit to). If you do a simple google search:
From earlier this year: https://www.ads-software.com/support/topic/creating-tax-rates-tables-in-woo-commerce-not-working
From 2019: https://www.ads-software.com/support/topic/tax-table-not-showing-up
From 2018: https://www.ads-software.com/support/topic/standard-tax-rates-changes-not-saving
Including you and myself, this makes 5 people having this issue. At least 5 people I know about. I suspect there are more.
I sincerely hope Woocommerce will find a solution.
Well, figure2, that’s discouraging. Thanks for those links. Funny that this is happening with a clean WP installation and nothing but the WooCommerce plugin. That pretty much rules out the notion that some other plugin is causing this problem. And, I can’t imagine what a theme would have to do with saving tax tables in the back-end. Just doesn’t make any sense to me.
Hi @rekrapt and @figure2. It definitely sounds like something is interfering with either the tables being created or with your store pulling data from the tables. I recommend you reinstall WooCommerce by FTP. Deactivate WooCommerce temporarily. Then you can download the zip file, unzip it and then overwrite the existing files on your server by FTP. Then activate WooCommerce and go to WooCommerce > Status > Tools to verify the database.
I recommend that you try this on a staging site first to see if it helps. Please let me know how it goes.
I was busy with a few other projects. I followed the steps you suggested and the problem persists. The tax table disappeared as soon as I saved.
Hi all,
Any News on this situation ? thanks for sharing any solution, Maybe i can work directly on the database ? which name is the specific table for taxe rate ? maybe i could put my rate there directly ?
Thanks
- The topic ‘Tax table not saving’ is closed to new replies.