WPML – How to Translate WooCommerce Products Quickly

If you want to expand your business opportunities, a multi-language WooCommerce store may be the perfect solution. We are sure that this will increase your potential customers.

However, it is clear that managing a big catalog with thousands of products is tedious and difficult.

Now if you want to offer the products in multiple languages, it’s even more difficult to manage all the thousands of translations.

You need productivity tools to save months of work and automate as much as possible. And that’s what we’ll show you in this tutorial.

You will learn how to translate products and edit them quickly in a spreadsheet without having to open and edit them one by one.

For the multi language system, we’ll use the WPML plugin.

And for managing the translations quickly we will use the WooCommerce Products Spreadsheet plugin.

This plugin allows you to manage all your products in a spreadsheet, make advanced searches, apply massive changes in seconds, export your translations to Excel or Google Sheets, import translations from Excel or Google Sheets, etc.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Once both plugins are installed and activated, you need to follow these simple steps to translate hundreds of products quickly.

Step 1. Open the Products Spreadsheet

Go to WP Sheet Editor > Edit Products to open it.

The content of the spreadsheet will depend on the selected language.

  • Spreadsheet in English: It shows all our products in English.

  • Spreadsheet in Spanish: We can see no products because there are no translated products into this language.

  • Spreadsheet in Italian: We see no products in this spreadsheet because we’ve not translated products into this language.

Step 2. Translate all your products at once

Something great is that you don’t have to open your products one by one and create the translations. You can translate all your products at once.

With the spreadsheet in English, open the Bulk Edit tool with one click on the toolbar.

We’ll translate our product into Spanish and Italian. So you need to select these values to translate all your products at once.

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows).
  • What field do you want to edit: WPML – Duplicate
  • Select type of edit: Set value
  • Replace existing value with this value: To translate all your products into Spanish and Italian, enter “es, it”. Enter all the language codes separated by commas.
  • Click on Execute Now.

With these values, our spreadsheet editor will create copies of all the products from English into Spanish and Italian.

If you open the spreadsheet in Spanish, you’ll see that now the spreadsheet displays the copies of the English products.

If you open the spreadsheet in Italian, you’ll see that now the spreadsheet displays the copies of the English products.

Now we will translate the Spanish products as an example, but you can apply these same steps to the products in Italian or any other language.

Step 3. Edit the translation relationship in bulk

If you don’t edit the translation relationship, every change you apply to the parent product will be applied to your translations. But we don’t want that. We want to use different titles, content, etc. in every language.

Therefore, you need to edit all the product translation relationships in bulk.

Open the Bulk Edit tool with one click on the toolbar.

Now select these values to edit all the translation relationships:

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows).
  • What field do you want to edit: WPML – Relationship
  • Select type of edit: Set value
  • Replace existing value with this value: Translate separately
  • Click on Execute Now.

Step 4. Edit the translations in the spreadsheet

Now everything is ready to start translating.

As every product is unique, you need to use the spreadsheet to edit their titles, descriptions, SEO titles and descriptions, etc.

However, even if you edit them one by one, you can edit your products faster because you won’t have to open a lot of tabs. You can edit quickly in the cells, drag down to autocomplete values, copy paste into hundreds of cells, etc.

We’re editing the Spanish translation.

a) Edit the product titles

Go to the Title column and translate the text. Once you edit all the titles, click on Save to apply the changes.

b) Edit the product content and descriptions

Go to the Content column and edit the text there. You can edit the product content as simple text or use the TinyMCE editor by clicking on the “Edit” button located in the cell.

Once you finish editing your product content, click on Save to apply the changes.

c) Edit the SEO titles and descriptions

The SEO title and description columns will depend on the SEO plugin you’re using.

We’re using the SEO Press plugin, so we need to go to the Seopress Titles Title and edit the product SEO Titles. After that, go to the Seopress Title Desc column and edit the product SEO descriptions.

Note. The plugin automatically works with Yoast SEO, Rank Math, SEO Press, All in One SEO, and all the popular SEO plugins.

Once you’re done editing both columns for all the products, click on Save to apply the changes to all the products.

Important

  • Here we are translating the spanish translations. Now you can switch to the Italian language and edit the Italian translations
  • Our spreadsheet editor automatically keeps the Product Price, Stock, Dimensions, etc. updated in all the languages. So, you can edit product prices in the Spanish spreadsheet, and the changes will be applied to all the translations and the main language. This is big for your productivity!

Translating thousands of products is really simple!

WPML and WP Sheet Editor work perfectly together to improve your productivity to help you create and manage multi-language stores. You can save a lot of time creating and editing thousands of product translations.

Our blog has hundreds of tutorials to help you bulk edit your WooCommerce product translations in seconds.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu