In this tutorial, we will show you how to bulk 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 into 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, and you don’t have to hire someone to translate your products.
Plugins to translate WooCommerce products with AI
Note. We assume you already have these plugins installed and activated on your WordPress site:
In addition to these plugins, you need the tools that will completely simplify your WooCommerce product management and translation into multiple languages using artificial intelligence:
1- WP Sheet Editor – WooCommerce Products
This plugin completely simplifies your product management by allowing you to view and edit hundreds or thousands of products in an intuitive spreadsheet within WordPress. It contains tools such as advanced search using any field, easy bulk edits for all your product fields, as well as export and import using CSV files.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
2- WP Sheet Editor – AI
WP Sheet Editor – AI is a smart tool that adds AI to every WP Sheet Editor spreadsheet. You can quickly create and edit WordPress content in bulk with just a few clicks. It makes your work easier and helps you manage WordPress faster with the power of AI.
You can sign up here:
Sign up to the WP Sheet Editor - AI Service - or - Check the features
3- External API provider
The AI functionality in WP Sheet Editor relies on an external API like OpenAI, OpenRouter, etc. You’ll need an account with the provider and an API key to connect.
WP Sheet Editor – AI is compatible with these AI providers:
- Open AI for text and images (more info here)
- OpenRouter (more info here)
- Any other provider that uses the same format as OpenAI.
Follow this guide to learn how to set up AI providers in WP Sheet Editor – AI.
Open the WooCommerce products spreadsheet
Once you have installed all the required components, you need to open the WooCommerce products spreadsheet.
To do this, go to WP Sheet Editor > Edit products, and you’ll see all your products displayed in the spreadsheet.
Important: As you will see, the spreadsheet shows the products in the selected language. If you want to change a language, you can do it in the admin bar.
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.
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.
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.
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.