WPML – How to Bulk Translate WooCommerce Products

In this tutorial, we are going to bulk translate WooCommerce products, using WooCommerce Multilingual by WPML and WP Sheet Editor – WooCommerce Products.

This method of massive product translation will allow you to save a lot of time.

You will not have to create translations one by one, but you will bulk create translations into different languages for all the products that have not been translated.

Here’s what you need to follow this tutorial:

• WooCommerce. You need to have WooCommerce installed on your website, plus the products for which you will create the translations.
• WooCommerce Multilingual & Multicurrency. This WPML plugin allows you to create a multilingual WooCommerce store on your website. You don’t need an English site and a Spanish site, for example. You can create content in several languages from the same website. Note. To use the multilingual features, you’ll need to use the WPML plugin, which is the core plugin that installs a multilingual system on your WordPress website. You can get WPML here.
• WP Sheet Editor – WooCommerce Products. This plugin allows you to edit products in bulk, using an intuitive spreadsheet within WordPress. In this case, it will help us to create translations into several languages for hundreds of products at once. Then, it will allow us to edit the translations easily from the spreadsheet, which will save us a lot of time.

After installing and activating the necessary plugins, you need to follow these steps to translate WooCommerce products in bulk.

1- Open the WooCommerce products spreadsheet

Go to WP Sheet Editor > Edit Products in wp-admin.

You’ll see a spreadsheet that shows your products as rows and the fields as columns.

Something important to notice is that WP Sheet Editor displays products depending on the WPML language selected.

In the screenshot below, you can see all the products in English, which is our main language.

If we change the language into Spanish, we’ll see all the Spanish translations we’ve made so far.

We created these translations using the normal translation method.

If we switch to Italian, we’ve also added some translations in that language.

2- Search for products missing translations in specific languages

If you have already translated some products, as in our case, WP Sheet Editor allows you to filter and edit the products missing translations in specific languages only.

This means you can exclude all the already translated products from this process.

Switch to the main language to view the products and open the Search tool.

Tick the Enable advanced filters checkbox.

Now use the WPML – Missing translations in this languages field to choose the languages you want.

In this case, we’ll search for all the products that haven’t been translated into Spanish and Italian.

Finally click on Run search.

Here are all the products that are missing translations in Italian and Spanish.

3- Bulk create WooCommerce product translations

Now it’s time to create product translations in bulk for several languages.

Important notes:

• WP Sheet Editor is not an automatic translation method. This means that titles, descriptions and other fields will not be translated into other languages. What WP Sheet Editor will do is create the translations in bulk, and then you can easily edit them using the spreadsheet (more on that below). If you’re interested in automatic translation, WPML has a feature for that, and you can buy automatic translation credits.
• With this, we don’t want to leave aside the multiple advantages of using WP Sheet Editor to manage your multi-language content. You can create translations in bulk, edit translations easily using the spreadsheet, export translations in a specific language to send to your translator in CSV format, and then import all translations of a specific language using the CSV sent to you by your translator. WP Sheet Editor boosts your productivity.

To create the translations in bulk, open the Bulk Edit tool.

Now select the following values in the Bulk Edit tool.

• 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: Here we need to add the code of each language into which we want to translate our products. In this case, we’ll enter “es” for Spanish, and “it” for Italian, separating them with commas.
• Click on Execute Now.

After bulk creating the product translations, you’ll see no products in the main language spreadsheet.

This happens because no product matches the search filter we have applied.

Of course, this only happens if you’ve translated all the products into the languages selected in the search filters.

If we switch into a secondary language, we’ll see that the translations have been created successfully. Here’s our Italian products.

And here’s our Spanish products, which we will use for the next sections as an example.

4- Bulk edit the WPML translation relationship

All the translations we have created will have the Duplicate from the main language translation relationship.

This means that all the changes we apply in the main language will be applied to the translation too.

Since we don’t want that, we need to change the translation relationship into Translate separately.

Of course, if you do not want to change all translation relationships to separate translation, you can apply this change using the spreadsheet, as each cell allows you to choose individually for each product.

We will do it using the Bulk Edit tool to save a lot of time.

Once you open the Bulk Edit tool, select the following values to bulk edit the WPML translation relationship.

• 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.

5- Bulk edit the WPML translations using WP Sheet Editor

Now you’re ready to start editing the product translations you have created, and for this, WP Sheet Editor is your best option.

For example, you can get all your product titles and paste them into a translation tool like Google Translate, DeepL, or Bing Translator.

Once you get the translation, paste it into the Title column.

This way you can translate hundreds or thousands of product titles with a few clicks.

If you want to edit the short descriptions for all the translations you have created, you can do it in the spreadsheet.

You can open the text editor as a pop-up by clicking on the “Edit” button.

Here’s what the text editor looks like, and you can save and go to the next product description with one click.

You can also edit the SEO titles, descriptions and keywords for all the translations you created with WP Sheet Editor.

It’s compatible with all popular SEO plugins for WordPress.

Here’s what the Yoast SEO columns look like in the spreadsheet.

Once you have edited all the product translations in one language, you can click on Save to apply the changes.

Being able to edit hundreds of translations in one place helps you save lots of hours!

6- Bulk edit the category, tag and attribute translations in a spreadsheet

When you translate WooCommerce products in bulk, WP Sheet Editor automatically creates the translations for your product taxonomies (categories, tags, and attributes).

You can save a lot of time if you edit the taxonomy translations using the WP Sheet Editor – Taxonomy Terms plugin.

Here are two useful tutorials:

• WPML – Translate WooCommerce Categories and Tags in Bulk
• WPML – How to Bulk Translate WooCommerce Attributes Quickly

This is how you can bulk create and manage product translations for your WooCommerce products with WooCommerce Multilingual and WP Sheet Editor – WooCommerce Products.

Click here to read other tutorials on how to manage WPML translations with WP Sheet Editor.