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.
