[Resolved] WooCommerce variations missing in secondary language
This thread is resolved. Here is a description of the problem and solution.
Problem:
Product variations were missing in some product translations.
Solution:
- Backup the site completely to prevent any issues.
- Going to WooCommerce -> WooCommerce Multilingual & Multicurrency page , then going to Attributes tab selecting the attribute and clicking on "Synchronize attributes and update product variations" button.
- Go to WooCommerce -> WooCommerce Multilingual & Multicurrency -> Status -> Troubleshooting then select "Fix translated variations relationships" and allow it to run completely.
When adding new WooCommerce variations in the primary language they are not added in the 2nd language. See screenshots.
Sync product stock quantity and status ( synchronizing min stock between translations ) on the troubleshooting page is not working. I see the spinning wheel in the bottom right, the product amount is decreasing to zero but after that variations have not been synced.
Not at this time but earlier today I see this error in the logs:
PHP Fatal error: Uncaught Error: Call to a member function get_stock_quantity() on bool in /home/381534.cloudwaysapps.com/gsggkexeze/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-product-data.php:350\nStack trace:\n#0 /home/381534.cloudwaysapps.com/gsggkexeze/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-variations-data.php(200): WCML_Synchronize_Product_Data->sync_product_stock()\n#1 /home/381534.cloudwaysapps.com/gsggkexeze/public_html/wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-variations-data.php(60): WCML_Synchronize_Variations_Data->sync_product_variations()\n#2 /home/381534.cloudwaysapps.com/gsggkexeze/public_html/wp-includes/class-wp-hook.php(308): WCML_Synchronize_Variations_Data->sync_product_variations_action()\n#3 /home/381534.cloudwaysapps.com/gsggkexeze/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filt...', referer: hidden link
before your ticket is assigned to one of my colleagues, please allow me to walk you through some initial debugging steps. This will help speed up the support process.
I found that you reported the same issue 2 years before.
I don't know if the error is related to the problem we have. Can you have a look at the shop?
I don't think it has ever been solved. Since I started working on this site which already existed my customer already had issues with WPML.
I am Subash and I will help you further here. Hope that is okay!
Sure, I can take a closer look at your site to see what the issue could be. I have enabled the private reply fields for you, please share the temporary access (WP-Admin and FTP) to the site through the private reply, preferably to a test site where the problem has been replicated.
Also, please let me know the exact steps and process to see/replicate the issue.
IMPORTANT: Please take a complete backup of the site to avoid data loss.
I tried a few things on the but that didn't worked I tried:
- Deactivating all Plugins except WPML and WooCommerce plugins.
- Changing the theme to a default theme.
- Going to WooCommerce -> WooCommerce Multilingual & Multicurrency page , then going to Attributes tab selecting the attribute and clicking on "Synchronize attributes and update product variations" button.
I noticed that the site is very very very slow, it takes 1+ minutes to load a setting page sometimes even with all plugins deactivated and also it looks like because of the slowness "Synchronize attributes and update product variations" button timeouts and does not works.
The speed issue here seems to be the root cause of the issue. Can you please troubleshoot the slow issue further with your hosting provider and try to solve that first then see if WPML issues goes away?
Also, would you please mind sharing the FTP details for the test site so that I can look further into the issue including the debug/error log? Also, will it be okay if I copy your site to my test/local environment to test the issue further?
After further troubleshooting the following steps resolved the issue on the site, can you please check and confirm from your end as well?
- Went to WooCommerce -> WooCommerce Multilingual & Multicurrency , clicked on "Attributes" tab and clicked on "Synchronize attributes and update product variations" button.
- Went to WooCommerce -> WooCommerce Multilingual & Multicurrency , clicked on "Status" tab then clicked on the "Troubleshooting" link at the end of the page then selected the following option and allowed it to run completely which took 5-10 minutes:
Sync products variations , Duplicate terms ( please select attribute ), Fix translated variations relationships
- Went to WPML -> Support, clicked on "Troubleshooting" link there then clicked on the "Remove ghost entries from the translation tables" , "Assign translation status to duplicated content" , "Set language information" and "Fix post type assignment for translations" buttons.
- Went back to WooCommerce -> WooCommerce Multilingual & Multicurrency , clicked on "Attributes" tab and clicked on "Synchronize attributes and update product variations" button.
Thanks for the guide. The process gets stuck at the first step. When I synchronize attributes and update product variations I see a spinning circle but this never ends. I've waited for about 30 minutes. Tried the others steps after that but the translated product still is missing variations.
Please backup the site completely to prevent any issues then share the site access credentials for me to check the issue. I have enabled the private reply for you to share the credentials safely.
- Backup the site completely to prevent any issues.
- Deactivate unnecessary plugins if there is any and also work with your host provider so that the site is faster and does not timeouts or shows database issues.
- Go to WooCommerce -> WooCommerce Multilingual & Multicurrency -> Status -> Troubleshooting then select "Fix translated variations relationships" and allow it to run completely as the site gave timeout and database error and I was not able to finish this process.
Hi Subash, I was able to solve it by creating a staging site on a larger server. Performed the steps on the staging and pushed changes back to live. Thanks for your help.
