Skip Navigation

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.

Tagged: 

This topic contains 14 replies, has 0 voices.

Last updated by Lauren 1 month, 2 weeks ago.

Assisted by: Lauren.

Author Posts
May 19, 2025 at 7:31 pm #17050365

Lauren
WPML Supporter since 10/2015

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Of course, and I hope to have an update for you soon.

May 21, 2025 at 2:40 pm #17058140

Lauren
WPML Supporter since 10/2015

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

One of our developers has been looking closely into this and it's been a tough one to figure out. It appears there may be some kind of database corruption, but he found that removing a protion of the meta data resolves the issue. Please make a full backup of your databse first, and then see if you can run this directly in phpMyAdmin or using WP-CLI:

DELETE pm
FROM wp_postmeta pm
INNER JOIN wp_posts p ON p.ID = pm.post_id
WHERE pm.meta_key = '_wpml_word_count'
AND p.post_type = 'product';

Replace wp_ with your actual database prefix if it’s not wp_. Please let me know if this resolves the issue. Thanks!