contents in prodcut archive page and product single page can't be translated

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

Problem:
You are trying to translate strings on the product archive page and product single page in WooCommerce using WPML. After updating the French content on the product archive page created by Elementor and creating a new product single page, the translated English content does not display.
Solution:
We discovered that some database records were blocking the proper communication between your site and the ATE's servers. To resolve this, we recommend running the following SQL queries on your database:

delete from wp_options where option_name = 'wpml.ate_sync.lock.key';
delete from wp_options where option_name = 'wpml.ate_sync.lock';

Please ensure to make a full backup of your site before applying these changes. If the issue persists after applying this fix, it might be due to other reasons or the solution might be 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 this does not resolve your issue, please open a new support ticket at WPML support forum for further assistance.

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: Bug

This topic contains 17 replies, has 0 voices.

Last updated by Mateus Getulio 2 weeks, 5 days ago.

Assisted by: Mateus Getulio.

Author	Posts
October 14, 2024 at 2:04 pm
jing-yingM	Background of the issue: I am trying to translate strings on the product archive page and product single page in WooCommerce using WPML. I have updated my French content on the product archive page created by Elementor and created a new product single page. I translated the French content to English, but the English version doesn't show. Symptoms: The translated English content on the product archive page and product single page is not displaying. Questions: Could you log into my WooCommerce site and help me investigate this issue?
October 14, 2024 at 2:31 pm
October 14, 2024 at 3:27 pm #16286986
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello there, I followed the steps to try to fix the issue: - Go to WPML >> Support >> Troubleshooting page and press the below buttons: - Clear the cache in WPML - [Products] Synchronize posts taxonomies - Synchronize local job ids with ATE jobs - Synchronize translators and translation managers with ATE - Assign translation status to duplicated content - Set language information - Go to WPML >> Support >> Troubleshooting page and press the below buttons: - Clear the cache in WPML - [Products] Synchronize posts taxonomies - Synchronize local job ids with ATE jobs - Synchronize translators and translation managers with ATE - Assign translation status to duplicated content - Set language information Also, the WP memory limit needed to be increased. PHP memory is fine, but WordPress was using 40Mb. The minimum requirements for WPML are 128 MB. (Kindly check this page https://wpml.org/home/minimum-requirements/) I increased it by adding the following code in your wp-config.php file right before the /* That's all, stop editing! Happy publishing. / line: / Memory Limit */ define('WP_MEMORY_LIMIT', '256M'); define( 'WP_MAX_MEMORY_LIMIT', '256M'); After taking those steps I can see the products fully translated now, please check the screenshot for reference. Can you please review it and confirm that it is fixed now? Best, Mateus
October 14, 2024 at 6:34 pm #16287510
jing-yingM	Hi Thanks for your investigation and response. The product page in the screenshot that you shared with me was created one month ago, it was no problem. The issue happened in last week. So Could you please check the URL as below? The issue still can't be removed. product archive page :hidden link single product page:Court Carré Rond-Citrouille Dorée (in the screenshot) Thank you
October 15, 2024 at 1:26 pm #16291054
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hi there, I tried checking the specific product you shared as an example and it looks like there's no English translation available for it yet, please check the screenshot. I looked for a few other examples but so far I couldn't reproduce the issue. Can you please review it? Thank you. Mateus
October 15, 2024 at 3:55 pm #16291818
jing-yingM	Hi I have reviewed this prodcut Court Carré Rond-Citrouille Dorée , Please click {+} button, you can see the english translation is 100% completed. But I don't konw why it shows there is no English translation. Please find the screenshot.
October 15, 2024 at 5:15 pm #16292121
jing-yingM	Hi I restet the configuration of "Custom Fields Translation "and the status changed below. Because I created new atrributes (product colour& product style) in last week and didn't update the"Custom Fields Translation ". "Updating affected posts for changes in translatable fields _default_attributes, attribute_pa_package, attribute_pa_colour, attribute_pa_style, _wp_attachment_context. 0 / 172 0%" "Updating affected posts for changes in translatable fields _elementor_template_widget_type. 0 / 337 0%" I have waited for long time ,but the progress is still 0%. Is it related with the issue above? Thank you
October 15, 2024 at 7:35 pm #16292485
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello there, I checked it and the last issue you reported is a known issue where some duplicated queries get added to the table icl_background_task. It is being investigated to be fixed in definitive, meanwhile I applied the workaround available in here and this specific issue has been fixed: https://wpml.org/errata/wpml-causing-backend-slowness-and-duplicated-queries/ Regarding the issue with the product, while I was able to add the translation and save it, like you mentioned, I did notice that the translation was already loaded indicating it was already translated before despite the + icon. On top of that if I edit the main language product and switch to English it doesn't load the English product but rather an empty product. It is also no creating the package for that product within WPML > Packages. There's something strange going on that I need to check. I enabled the debug mode but it didn't generate any errors. Is it possible to reach out to the hosting provider support and ask them to share today's error logs(October 10th), you can add it to the server and tell me the location or share it with me using a text sharing service such as pastebin.com or a file sharing service such as dropbox or Google drive. Also, are you able to create a staging site where I can debug this freely without affecting the live site? I enabled private fields for your next reply so that you can share it with me. Thank you, please let us know. Mateus
October 16, 2024 at 11:52 am
October 17, 2024 at 11:19 am #16299758
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hey there, I checked this out but so far I couldn't find a fix for it. I asked my colleagues to have a look at this issue in order to see if there's anything I'm missing. I'll come back here as soon as one of my colleagues reply back to me (which it shouldn't take long). Thanks,
October 21, 2024 at 10:10 am #16311564
jing-yingM	Hi Thanks for your response. I have waited for the soulution for one week,How about the situation now? Thank you
October 21, 2024 at 8:19 pm #16314370
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello there, This is an extremely odd bug which is making it take a longer to investigate. We feel like we're making progress but it is soon to say for sure. We're actively debugging this and we'll keep you posted. Thank you for your patience and we'll update you as soon as possible.
October 21, 2024 at 8:51 pm #16314426
jing-yingM	Hi Ok, I understand. This issue is very urgent and it has disturbed the sale promotion schedule of my woocommerce store because the product page can't be launched. How much longer do you need to investigate? Thank you
October 21, 2024 at 9:12 pm #16314474
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	While we can't give you an ETA of when we'll find a definitive fix, I have a workaround I can offer you in the meantime. We noticed that by exporting the XLIFF of the product, translating it and importing it back, the product gets fully translated: - Go to WPML -> Translation Management - Search for your product and send it for Translation - Go to WPML > Translations, locate the product and select it - Click on export to XLIFF 1.2 - Open the XLIFF using an editor and translate it - Still on the WPML > Translations screen at the bottom of the page import the file Please check this documentation for more information: Manually Downloading XLIFF Files Using Desktop CAT Tools with WPML I understand this solution isn't optimal, but it a temporary workaround we can offer just until we're working hard to fix this for good. We thank you for your understanding.
October 25, 2024 at 8:06 am #16329390
jing-yingM	Hi Thanks for your response. I have updated the English version by following your resolution above. I think it takes too long time to download and manually translated the xliff file . So , Please continue to help me investigate this issue and keep update with me . Thank you