In this tutorial, we will show you how to automatically translate WooCommerce products using AI and WooCommerce Multilingual by WPML.
A multilingual WooCommerce store helps your business reach more people around the world. It allows customers to shop in their own language, which increases your sales opportunities. A store in many languages can also appear in more search results, helping more people find your products.
However, managing a store in multiple languages is not an easy task, especially when it comes to translating your WooCommerce products into several languages. But with WP Sheet Editor – AI, you can now translate your products using artificial intelligence directly in an intuitive spreadsheet. It’s the perfect multilingual AI translation tool for WooCommerce.
Using AI to translate WooCommerce products saves you time and money, as you can do it in a few minutes, without hiring external translators.
Table of Contents
Tools to translate WooCommerce products with AI
Note: We assume you already have these plugins installed and activated on your WordPress site:
1- WP Sheet Editor – Products Spreadsheet
This plugin simplifies your product management by allowing you to view and edit hundreds or thousands of products and variations in a spreadsheet within WordPress. It includes advanced search, bulk edits, and CSV/Excel import/export tools.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
2- WP Sheet Editor – AI
WP Sheet Editor – AI integrates AI into all WP Sheet Editor spreadsheets. You can quickly create, edit, and translate WordPress content in bulk with just a few clicks.
You can sign up here:
Sign up to the WP Sheet Editor - AI Service - or - Check the features
3- External AI Provider
The AI functionality relies on an external API like OpenAI, OpenRouter, etc. You’ll need an account and API key to connect. WP Sheet Editor – AI supports:
- OpenAI for text and images (more info)
- OpenRouter (more info)
- Any other provider compatible with OpenAI API format
Follow this guide to set up AI providers in WP Sheet Editor – AI.
Open the WooCommerce products spreadsheet
To edit products, go to WP Sheet Editor > Edit Products. The spreadsheet will display products based on the WPML language selected in the admin bar. Here are the products in our original language (English).
If we change the language in the admin bar to Spanish, for example, we will see that we do not currently have any products translated into that language.
The same thing happens if we switch the language to French; we don’t have any products in that language.
Automatic AI translation of WooCommerce products
WP Sheet Editor – AI provides a new dedicated column: AI – WPML Auto translate to languages. This column allows you to automatically translate all product fields supported by WPML: titles, descriptions, excerpts, SEO data, and custom fields… All without manually entering prompts.
Here’s how it works:
Option 1: Auto translate with AI in the spreadsheet
Open the WooCommerce products spreadsheet in the main language (e.g., English).
Locate the AI – WPML Auto translate to languages column in the spreadsheet.
Then, enter the language codes you want to translate to in the AI – WPML Auto translate to languages column. For example: “es” for Spanish, “fr” for French, “it” for Italian, etc.
Once you have added the translation languages, you need to click Save to start the automatic AI translation process. The AI will generate translations for all fields that WPML supports, saving you hours of manual work.
If you now switch the WPML language into any of the translation languages you added in the AI: WPML Auto translate to languages column, you’ll see your products translated.
Option 2: Bulk translate with AI automatically
If you prefer to translate all products and variations at once, you can do it using the Bulk Edit tool.
Important: When running many AI prompts at the same time, WP Sheet Editor – AI uses the Bulk AI API to handle them all together. This makes the process much faster. For example, doing 10 prompts one by one might take 60 seconds, but with the Bulk AI API, it can finish in just 6 seconds. Learn more.
Select these values in the Bulk Edit tool in order to bulk translate WooCommerce products with AI:
- Select the rows that you want to update: Edit all rows from the current search
- What field do you want to edit: AI – WPML Auto translate to languages
- Select type of edit: Set value
- Replace existing value with this value: Enter the language codes separated by commas (e.g., “es,fr,it”)
- Select Edit only parent products, for example.
- Click Execute Now.
Frequently Asked Questions
Which fields will be translated automatically?
All fields that WPML and WooCommerce Multilingual consider translatable will be automatically translated with AI. That includes product titles, content, short description, SEO meta data, etc.
Will variations be translated automatically?
Yes. Product variations will be automatically translated; for example, variation descriptions.
Manual AI translation of WooCommerce products
While the automatic translation column is the fastest way to translate your WooCommerce products, you may prefer a more flexible approach in certain cases.
For example, you might want to adjust prompts, use custom translation instructions, or process only specific fields.
In those cases, you can use the manual AI translation process. This gives you complete control over how each product field is translated, allowing you to combine precision and automation as needed.
Step 1. Create the WPML translations of your products
We have a detailed tutorial about creating product translations with WPML. You can read it by clicking here.
But if you want the basic steps, here they are:
First, you can go to the WPML – Duplicate column, and select the languages into which you want to translate your products.
Once you’re done, click on Save.
If you now change the WPML language in the admin bar, you’ll see that the spreadsheet shows products in the selected language.
Here you can see the English products.
Here you can see the newly created Spanish translations.
And here you can see the French translations we have just created.
Step 2. Change the translation relationship in the target languages
WPML allows you to select the translation relationship to 1) Duplicate from the main language or 2) Translate separately.
In this case, you need to open the spreadsheet in a translation language (not the main language), and select Translate separately in the WPML – Relationship column.
Make sure you Save the changes once you’re done.
Step 3. Translate product titles, descriptions, and SEO data with AI
Now you can implement multilingual AI translation into your WooCommerce products. Let’s see how to translate your products with artificial intelligence.
Optional: WP Sheet Editor – AI allows you to save global AI prompts for use in WP Sheet Editor spreadsheet cells, in the generation of new rows (products), and even in the Bulk Edit tool. You can read this guide to learn how to save global prompts. However, since the translation requires a fairly simple prompt, we will show you how to apply that prompt in the cells and using the bulk edit tool.
In the spreadsheet cells, you can enter a simple prompt like this:
ai:translate into Spanish
Or this:
ai:translate into Spanish, return the translation only.
Important. Make sure you customize the prompt by adding the language into which you want the data to be translated.
Once you hit Enter, the AI will start processing the request.
When the task is complete, you’ll see your data translated into the selected language.
You can paste the same prompt into multiple cells and columns in order to translate multiple data at once.
Once you have translated all the cells and columns you want, you need to Save the changes.
Optional: Bulk translate products’ data using AI
If you don’t want to translate in the cells, you can open the Bulk Edit tool and translate specific fields in all your products using AI. For example, you can translate product titles, product descriptions, or even SEO data for all your products at once.
For example, here are the values you need to select in order to translate SEO descriptions using the Bulk Edit tool:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: SEO Description
- Note: This is just an example, so you can select any other field here, depending on the case: Title, Content, Description, SEO Keyword, SEO Title, SEO Description, Purchase Note, Custom Fields added by other plugins, etc.
- Select type of edit: AI prompt
- Note: The selected option (AI prompt) is useful for adding the prompt manually, but if you have pre-saved a global prompt named “Translate into Spanish”, for example, the Select type of edit dropdown will show something like “AI Command – Translate into Spanish”. In that case, you won’t have to add the prompt.
- In this example, we will use this prompt:
Translate the $current_value$ into Spanish, return the translation only.
- AI Provider: If you have configured multiple AI providers and models, you can select the one you want to complete this task.
- Prompt: If you selected “AI Prompt” in “Select type of edit”, you need to add the prompt text here.
- You can click on Show preview to preview the result before saving the changes. This is useful for adjusting the prompt for better results before requesting the AI to complete the task.
- Once you’re done, click on Execute Now.
Important: When running many AI prompts at the same time, WP Sheet Editor – AI uses the Bulk AI API to handle them all together. This makes the process much faster. For example, doing 10 prompts one by one might take 60 seconds, but with the Bulk AI API, it can finish in just 6 seconds. Learn more.
Translate WooCommerce products with AI and WPML
Translating WooCommerce products into different languages can be quick and easy with the right tools. WP Sheet Editor – AI and WooCommerce Multilingual by WPML help you manage your store’s translations in a simple way. Using AI saves you time and money while making your store ready for customers all over the world.