This thread is resolved. Here is a description of the problem and solution.
Problem:
You are trying to translate over 300 products from English to Spanish using WPML, but only a few products are displayed in the translation management dashboard.
Solution:
The issue might be due to some database corruption. We recommend making a full backup of your database first. After securing your data, you can try to resolve the issue by running the following SQL command in phpMyAdmin or using WP-CLI:
DELETE pm<br />FROM wp_postmeta pm<br />INNER JOIN wp_posts p ON p.ID = pm.post_id<br />WHERE pm.meta_key = '_wpml_word_count'<br />AND p.post_type = 'product';
Remember to replace 'wp_' with your actual database prefix if it’s not 'wp_'.
If this solution does not apply to your case, or if it seems outdated, we highly 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 the issue persists, please open a new support ticket.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
This topic contains 14 replies, has 0 voices.
Last updated by 1 month, 2 weeks ago.
Assisted by: Lauren.