I want to translate woocommerce email text but the text don't appear

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

Problem:
The client was unable to find WooCommerce email texts in the WPML String Translation tool and the admin text finder.

Solution:
We recommend following these steps to translate WooCommerce email texts:
1. Navigate to WooCommerce > Réglages > Courriels;
2. Select the email type you want to translate, for example, "Commande échouée";
3. Enter some text into the Sujet field;
4. Save your changes and ensure the page loads completely;
5. Click on "translation" located under the field where you entered the text;
6. The string you inserted should now be available for translation.

It's important to note that unless you enter text into the field, the texts will not appear in the String Translation tool.

If this solution does not apply to your situation because it might be outdated or not relevant to your case, we encourage you to open a new support ticket. We also highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please contact us through the 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: Documentation request

This topic contains 23 replies, has 2 voices.

Last updated by Lucas Vidal de Andrade 1 year, 2 months ago.

Assisted by: Lucas Vidal de Andrade.

Author	Posts
March 4, 2024 at 2:50 pm #15370262
alexandreL-36	I want to translate woocommerce email text but the text don't appear in the string translation tool and in the admin text finder at the bottom of the page of string translation I following your current documentation but the email text don't appear This is the email text that don't appear Email Commande remboursée Votre commande n°{order_number} sur {site_title} a été remboursée Votre commande n°{order_number} sur {site_title} a été partiellement remboursée Remboursement partiel: commande n°{order_number} Email Facture client / Détails de la commande Votre dernière facture sur {site_title} Votre facture pour la commande n°{order_number} Facture pour la commande n°{order_number} sur {site_title} Email Réinitialisation du mot de passe Demande de réinitialisation de mot de passe for {site_title} Demande de réinitialisation de mot de passe Email Nouveau compte Votre compte sur {site_title} a été créé! Bienvenue sur {site_title} Email Completed Renewal Order Votre {blogname} reçu de commande de renouvellement du {order_date} Email On-hold Renewal Order Votre commande de renouvellement de {blogname} a été reçue ! Email Updated order Votre {site_title} commande {order_number} a été mise à jour Thanks for your help! The website : hidden link
March 4, 2024 at 6:50 pm #15371742
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello, Thank you for getting in touch with us. The standard WooCommerce e-mails are translated by default, and don't need any further manual translations. Can you confirm if this is working as expected for you? If you wish to customize, please scan the WooCommerce plugin beforehand and follow these steps: https://wpml.org/documentation/related-projects/woocommerce-multilingual/how-to-translate-woocommerce-emails/ Let me know if you need further assistance.
March 4, 2024 at 7:17 pm #15371772
alexandreL-36	Hello, the website is in 5 languages including Panjabi, Chinese Simplified and traditional. When I click on the email translation text button, I have no strings to translate. See my screen capture below. And I have the plugin Woocommerce subscription installed who has their own woocommerce emails to translate. I await your reply! Thanks! New threads created by Lucas Vidal de Andrade and linked to this one are listed below: https://wpml.org/forums/topic/split-i-want-to-translate-woocommerce-email-text-but-the-text-dont-appear/
March 5, 2024 at 10:58 am #15373891
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to a testing site where the issue is replicated. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it. Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you. IMPORTANT - Please make a backup of site files and database before providing us access. - If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link
March 6, 2024 at 1:23 pm #15379608
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello I checked the staging version of your website and indeed I could not find the strings for translation. I escalated your ticket to our development team, which will look for a permanent solution to your issue. That usually takes a few days, so I'll keep you posted. As for the translation of the Woo Subscriptions texts, I opened a new ticket for it. This way, we can ensure that both questions will be answered. I'll give you feedback there: https://wpml.org/forums/topic/split-i-want-to-translate-woocommerce-email-text-but-the-text-dont-appear/
March 8, 2024 at 11:47 am #15388880
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello, I got feedback from our devs. It seems that in your specific installation, the email texts weren't all properly registered for translation. We checked your database, and some of the fields that should hold the strings were actually empty. Please make a full backup of your website and follow these steps: 1. Access phpMyAdmin or other database manager of your choice 2. In 'wp_icl_strings', run the following query: DELETE FROM `wp_icl_strings` WHERE `context` LIKE 'admin_texts_woocommerce_%' AND `value` = '' AND `status` != '0' 3. Re-save all the e-mail options from WooCommerce That should re-register the texts and make them translatable, as expected. If you don't feel comfortable running SQL queries in your database, please let me know, so I can help you with that.
March 8, 2024 at 2:41 pm #15389876
alexandreL-36	Hello, I apply the SQL Query but the table wp_icl_strings you mention dosent exist. See my screen capture. Thanks!
March 8, 2024 at 3:10 pm #15389951
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello, Please check the prefix, sometimes it can differ in your installation. The default prefix is "wp_", but that can change. Let me know how it goes.
March 8, 2024 at 3:27 pm #15390067
alexandreL-36	Hello, I adjust the prefix but it doesn’t work. See my screen capture. Thanks!
March 8, 2024 at 4:54 pm #15390337
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	By looking at the tables in the left column, it looks like your prefix is actually 'n4nPY4LUe_'. Can you please check again?
March 11, 2024 at 12:09 pm #15394802
alexandreL-36	Hello, I apply the SQL Query on the database. I save all the email option. But the strings don't appear when I click on translation. See my screen capture. Thanks!
March 11, 2024 at 5:40 pm #15396879
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	I'd like to check your website once more. I tried using the credentials you sent me previously, but they are not valid anymore. Can you please send me access again? I've enabled the private box.
March 12, 2024 at 6:08 pm #15401061
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello, I performed the steps in the database, saved the options for the "New Order" e-mail, selected the Translate options for the Subject field and it worked as expected. Maybe I can try performing that on the live site if you wish. I activated the private fields. Please share website access with me, if you are ok with that. Please make sure to have a full website backup before proceeding. Thanks,
March 13, 2024 at 4:48 pm #15405567
Lucas Vidal de Andrade WPML Supporter since 11/2023 Languages: English (English ) Spanish (Español ) German (Deutsch ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello, I ran the query. Something important I didn't directly mention, but in order to translate the texts, you have to add a text on the email field (see screenshot). If you don't do that, WooCommerce will use the default translations it has built-in. I tested it on your live website and it's working as expected.
March 13, 2024 at 5:57 pm #15405708
alexandreL-36	Hello, I add the text on the field and I see the strings, I will translate all emails and keep this issue open if I have other issues with translating email. Thanks for your help!