Skip to content Skip to sidebar

Home › Support › English Support › [Resolved] Some products aren't fully translated

[Resolved] Some products aren't fully translated

This thread is resolved. Here is a description of the problem and solution.

Problem:
If you're experiencing issues with WooCommerce product translations not fully appearing, such as missing prices or add-to-cart buttons in certain languages, and encountering a false message in 'WooCommerce > WCML > Status' indicating untranslated products despite all appearing translated, this might be due to a specific database data corruption.
Solution:
We recommend the following steps to resolve this issue:
1. Use your hosting provider’s phpMyAdmin tool to run the following SQL query. This will set the related translation jobs to finished, which should correct the status of the affected products:

UPDATE wp_icl_translation_status SET status = 10 WHERE status = 0 AND needs_update = 0;

2. Navigate to Products → All → Trash in your WordPress dashboard and empty the trash.
Please ensure to create a full backup of your website and database before performing these actions.

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. Should you need further assistance, please do not hesitate to open a new support ticket at WPML support forum.

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 3 replies, has 0 voices.

Last updated by Dražen 3 weeks, 1 day ago.

Assisted by: Dražen.

Author Posts
December 18, 2025 at 12:41 pm #17674717

violetaI-2

Hello,
Can you help me sort out a WooCommerce product translation issue that I am experiencing?
I have automatically translated with credits my WooCommerce products. But it seems that they haven't fully translated.
For example:
- The English version is just fine: hidden link
- but the Bulgarian is not showing price, nor option for configuration, nor add-to-card button: hidden link

in the same time, when I go to "WooCommerce > WCML > Status" i see that there are 109 products that aren't translated but when I go to translate them there are no untrsanslated products (all products are with checks or when I filter I see no products for translation).
December 18, 2025 at 2:26 pm #17675035

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

thanks for patience.

I have checked further, but could not find a fix for false message in WCML > Status saying that 20 Bulgarian translations missing.

I have escalated further this to our 2nd tier.

I will update you here when I have some news to share, note it may take a day or two.

Kind regards,
Drazen
December 18, 2025 at 2:33 pm #17675084

violetaI-2

Thank you. Looking forward!
December 23, 2025 at 11:58 am #17684507

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

Thank you for your patience. Our second-tier team has checked and further investigated the issue.

It appears that there is a specific database data corruption that caused the incorrect error message to appear. We attempted to reproduce the issue, but it seems it may only occur after a particular set of actions or a specific scenario.

To resolve this, please follow the steps below:

- Using your hosting provider’s phpMyAdmin tool, run the following SQL query.
This will set the related translation jobs to finished, which will then mark the affected products as translated.

UPDATE wp_icl_translation_status
SET status = 10
WHERE status = 0 AND needs_update = 0;

- Go to Products → All → Trash and empty the trash.

After completing these steps, the issue should be resolved and the correct status should be displayed.

⚠️ Please make sure to create a full backup of your website and database before performing any actions, just in case.

If anything is unclear, you run into issues or you need help with steps and want us to do it for you, feel free to let us know.

Best regards,
Dražen