laurentJ-5

Problem:
The client's website, with a default language of German, was experiencing issues with mismatched product counts across other languages (Spanish, English, and French). Additionally, the translation process was getting stuck at 12 products.
Solution:
1. We discovered that some products set to 'Draft' in translations were causing the mismatch. We advised the client to:
- Go to products.
- Switch to the secondary language and check for 'Draft' status.
- Change the status to 'Publish' either by 'edit-> publish' or 'quick edit-> publish'.
- Ensure all products have the correct status.
2. For the translation getting stuck, it was due to an invalid site key:
- Visit the account page at https://wpml.org/account/sites/
- Delete the old key.
- Unregister and re-register WPML on the site to get a new key.
3. We also optimized SQL queries and tweaked the code to improve performance and resolve server errors. Reference for code changes can be found here: https://wpml.org/errata/possible-performance-issue-highlighted-by-unexpected-calls-to-gzuncompress/

If this solution does not resolve your issue or seems outdated, we recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If issues persist, please open a new support ticket at WPML support forum.