Problem: The client is experiencing issues with translating products on their WordPress site using WPML. The translations are stuck at 'in progress', and products are not being translated as expected. Solution: We have confirmed that all systems, including the Advanced Translation Editor (ATE), are now functioning correctly. There may be a short delay as the system processes a backlog of jobs. We recommend trying the translation process again and checking if the issue persists.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, please visit our known issues page and confirm that you have installed the latest versions of themes and plugins. If the problem continues, we highly recommend opening a new support ticket for further assistance at our support forum.
**Problem:**
The user (cristianS-23) reported that WPML displayed a notification indicating "90 translations waiting for review," but no translations were found in the queue under Posts, Pages, Products, or Knowledge Base sections. The user wanted to resolve this issue and ensure it does not recur.
**Solution:**
1. **Investigation:**
- Confirmed no translations were marked as "waiting for review" in the interface.
- Identified that the issue likely stemmed from incorrect entries in the `icl_translation_status` database table.
2. **Fix:**
- Suggested editing the database to update the `review_status` column in the `icl_translation_status` table to `'ACCEPTED'`.
- Clarified that this might fix the immediate issue but noted the root cause could be related to plugin or theme conflicts.
3. **Implementation:**
- User manually applied the suggested database change, which resolved the issue.
4. **Preventive Action:**
- Advised disabling the review feature if not required to prevent similar issues.
- Provided steps to disable the feature:
- Navigate to **WPML > Settings**.
- Under **Automatic translation**, select **"Publish right away without reviewing"** and save the settings.
**Outcome:**
The issue was resolved, and the user chose to mark translations as accepted before disabling the review feature. Additional support was offered but not required.
