In this tutorial, we will show you how to use generative AI to bulk translate WooCommerce products for Polylang translations.
Managing WooCommerce product translations with Polylang for WooCommerce can be time-consuming. You may even need to hire someone to translate your product titles, descriptions, SEO data, etc. But with WP Sheet Editor — AI, you can easily translate WooCommerce products using artificial intelligence. This will help you save a lot of time and ensure your translations are consistent, using the power of generative AI.
Tools to translate WooCommerce products with AI and Polylang
Here’s what you need in order to bulk translate WooCommerce products using artificial intelligence and Polylang.
Note. We assume you already have these plugins installed and activated on your WordPress site:
Besides these plugins, you will need these three elements:
1- Plugin: WP Sheet Editor — WooCommerce Products
This plugin simplifies your product management by enabling you to view and edit hundreds or even thousands of products within an intuitive spreadsheet directly on WordPress. It offers powerful tools like advanced field-based search, seamless bulk editing for all product fields, and the ability to export and import data via CSV files.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
2- Extension: WP Sheet Editor — Polylang (Free)
This extension adds columns to edit the Polylang language and connect the translations on the spreadsheet.
3- Service: 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
4- 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
To view and manage your WooCommerce products in spreadsheet, you need to go to WP Sheet Editor > Edit products.
You’ll see all your products displayed in the spreadsheet.
As you will notice, the spreadsheet displayed the products depending on the Polylang language you select in the admin bar.
For example, here’s our English products:
And here’s our Spanish products:
Create the product translations
By “creating product translations” we mean that you must create products that contain the necessary values in the “Polylang – Translation of” and “Polylang – Language” columns.
We have already created the translations, but if you have not done it, you can read this complete tutorial (you don’t have to translate any content in the CSV), or follow these basic steps:
Step 1. Open the Export tool in WP Sheet Editor
Step 2. Export your products to a CSV file. (View the detailed steps here).
Step 3. Once on the CSV file, remove the “record_id” column from the CSV file if you are editing translations for a different language than the one in which it was originally exported. For example, if exported the English products and are creating the Spanish translations. In that case, you need to remove the “record_id” column, since you won’t edit the original posts, but create new translations from the CSV.
Step 4. Copy the content from the post title column in the main / default language into the “Polylang: Translation of” column.
Step 5. Replace the target language key with the target language key in the “Polylang: Language” column.
Step 6. Import the translations as new. (Detailed steps here).
Translate product data in WP Sheet Editor using AI
Now that you have exported and imported the newly created translations, you can start translating your products using artificial intelligence. WP Sheet Editor – AI is the best Polylang AI automatic translation tool.
To do this, you have at least two options.
Option 1: Translate products’ data in the spreadsheet cells
WP Sheet Editor — AI allows you to translate the content of your product fields directly into cells.
Just type ai: and then type either the full prompt or a pre-saved global prompt shortcut.
Important notes:
- You can only use a shortcut prompt if you have previously saved your global prompt. If you want to know more information about global prompts, you can read this guide.
- In this case, since the prompt we will use to translate our products’ data is really simple, we will write it directly in the cells.
- In order to translate products’ data, the cells must have content in the source language.
We will use a prompt like this:
ai:translate into Spanish, return the translation only
Make sure you customize the prompt by adding the language into which you want the data to be translated.
When we hit Enter, the AI will start working to complete this task:
And when the task is complete, you’ll see the values translated into the selected language:
Pro tip: You can paste the prompt into multiple cells to translate cells in bulk:
As you can see, we have translated multiple cells by pasting the AI prompt:
We have translated the product titles so far, but you can continue translating the product descriptions, SEO data, purchase notes, or any other field. Make sure you save the changes once you’re done translating your WooCommerce products with AI.
Option 2: Bulk translate your WooCommerce products with Polylang and AI
If you don’t want to translate your products’ data in the cells, you can do it in bulk, as WP Sheet Editor — AI uses a bulk AI API to accelerate the AI processes. You can read more about our bulk AI API here.
In this example, we will show you how to translate product titles, and you can apply the same values to any other field like descriptions, short descriptions, SEO title, SEO description, SEO keyword, Purchase Note, etc.
Let’s start by opening the Bulk Edit tool.
Now you need to select these values in order to translate any field’s content:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Title
- 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 manually.
- 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 Polylang and artificial intelligence
With WP Sheet Editor — AI, you can leverage the power of generative AI to generate and edit WordPress and WooCommerce content in minutes. In this case, you can easily translate product data using AI, which allows you to save a lot of time and effort. Discover how to become super productive and save a lot of time and money with WP Sheet Editor — AI.