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.
