Background of the issue:
I had a properly configured setup with WPML along with WooCommerce. The website and the products have English as the main language and two secondary languages. Lately, I discovered that all content from the products in one secondary language is completely lost. Aside from products, all other post types (pages, posts, menus, etc.) are working correctly in all 3 languages. Link to a page where the issue can be seen: hidden link
Symptoms:
All content from the products in one secondary language is completely lost. I can see it both in the products list, where I see the globe icon for the default language, pencil for the first secondary language, and + sign for the third language which I have the issue. I expected to see the second language (Greek) loading correctly. Instead, I got no data available for the second language.
Questions:
Why is the product content missing for one secondary language?
How can I restore the lost translations for the products?
Please let me see if I understand the problem correctly.
1. The problem is only with the Greek translations. Is this correct?
2. You had translations from English into Green and not the Greek products shown in English. Is this also correct?
Please also tell me how you translated the products from English to Greek.
Did you use automatic translation?
If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply. Privacy and Security Policy
We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ **IMPORTANT**
- - Please backup the site files and database before providing us access. --
-- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.--
I can see that not all the Greek products are translated. In WPML -> Settings -> Post Types Translation, you selected "Translatable - use translation if available or fallback to default language" for "Products (product)," and because of this, the Greek products are shown in English. (This for itself is good.)
When I go to WPML -> Translation Management -> Jobs, I can see that all the products were translated long ago on 2021-07-18. Please see the attached screenshot.
Do you remember if you used WPML Classic Translation Editor or the Advanced Translation Editor to translate the products?
I must say that I don't see how a problem like this can happen unless someone intentionally or not deleted all the Greek products.
It can also happen if you move your site from another server and something goes wrong during the migration.
Did you migrate your site from another server before this problem happened?
To fix this problem, please restore your site from a backup before it occurred, if you have the option.
**** Important! Please make a full site backup (files and DB) before you proceed with those steps****
Indeed, some time ago we have switched to a new server. Nevertheless, the whole db has been dumped and restored successfully. As a result, theoretically all the posts are somewhere within the database.
An older backup is not available at least with the Greek data....
I can suggest another thing you should try. Please try the troubleshooting section. There is a specific troubleshooting page for WooCommerce Multilingual & Multicurrency and a general WPML troubleshooting page. You can read about it here.
I suggest you start with the WooCommerce Multilingual & Multicurrency troubleshooting page and, if that does not work, move to the WPML troubleshooting page. Here are the steps for the general troubleshooting. (The bolded options are more likely what you need, but you can try all the options while you are on this page).
1. Take a backup of your site's DB.
2. Go to WPML -> Support -> Troubleshooting (link)
3. Once on the troubleshooting screen, press the following buttons and check if it helps. Press each button at a time and wait for the process to complete.
- 'Disable cache for language switcher templates'
- 'Clear language information and repopulate languages' button (if it is showing)
- 'Synchronize posts taxonomies' for 'Products'
- 'Clear the cache in WPML'
- 'Remove ghost entries from the translation tables'
- 'Fix element_type collation'
- 'Fix WPML tables collation'
- 'Synchronize local job ids with ATE jobs'
- 'Synchronize translators and translation managers with ATE'
- 'Assign translation status to duplicated content'
- 'Set language information'
- 'Reset languages' Press this button only if you didn't add a custom language!
- 'Fix terms count'
- 'Fix post type assignment for translations'
- 'Cleanup and optimize string tables'
- 'Clear invalid strings'
*** Please backup your database before using this.***
