In this WordPress tutorial, we will show you how to export and import product translations for the Polylang for WooCommerce plugin.
Polylang for WooCommerce is a WordPress plugin that allows you to create multilingual WooCommerce stores. You can translate these types of WooCommerce contents:
- WooCommerce pages
- Simple products
- Variable products
- Grouped products
- WooCommerce categories
- WooCommerce tags
- WooCommerce attributes
By creating a multilingual WooCommerce store, you can increase your costumers and sales!
This is what you need to export and import product translations in specific languages:
- Polylang for WooCommerce
- WP Sheet Editor – WooCommerce Products
- WP Sheet Editor – Polylang extension
WP Sheet Editor – WooCommerce Products
We assume you already have WooCommerce, Polylang, and Polylang for WooCommerce, so we want to tell you about WP Sheet Editor.
This plugin allows you to view and manage your WooCommerce products in a spreadsheet on the WordPress admin dashboard.
If you want to increase your productivity in creating and managing multilingual WooCommerce stores, WP Sheet Editor is your best choice, because it contains these tools that can help you save hundreds of hours of work:
- Full Polylang compatibility – The spreadsheet displays products according to the language selected.
- Advanced search – You can use any field as a search filter, run combined searches, search for products based on language, etc.
- Duplicate products – You can easily create hundreds of a product
- Variations manager – You can convert simple products into variable products, create hundreds of variations with a few clicks, copy variations between products, etc.
- Bulk Editor – You can edit thousands of products at once with a few clicks: update prices in bulk, edit sale prices in bulk, change product descriptions in bulk, etc.
- Export – You can export products and variations to a CSV file to manage your products’ data in Excel, Google Sheets, or any other CSV editor
- Import – You can import products from a CSV file, including product translations created for Polylang
You can download the plugin here:
Besides installing the WP Sheet Editor plugin, you need to download and install the WP Sheet Editor – Polylang extension, which will add full compatibility between WP Sheet Editor and Polylang.
Follow the steps in the sections below in order to export and import WooCommerce product translations with Polylang and WP Sheet Editor:
View WooCommerce products based on Polylang language
To view your WooCommerce products in the spreadsheet, go to WP Sheet Editor → Edit Products.
The spreadsheet will display the products according to the selected language. If you do not select any specific language, you will see products in all languages.
Our main / default language is English, so if we select that language, the sheet will show the products in English.
But if we select another language, the spreadsheet will show the products in that language.
For example, we have selected the “Spanish” language, and the spreadsheet tries to show the products in Spanish.
However, since we have no translations for Spanish, the spreadsheet is shown empty.
Export WooCommerce Polylang translations to CSV
WP Sheet Editor allows you to export your WooCommerce products to a CSV file so that your translators can edit product translations in Excel, Google Sheets, or any other CSV file editor.
In this example, we are going to export the WooCommerce products in our default language to send the CSV to our translator to edit the translations in Excel or another app.
Note – If you want to export both products and variations, make sure you click on “Display variations” before exporting.
To export WooCommerce products in a specific language, we need to:
- Open the spreadsheet in the language in which we want to export. Select the language in the wp-admin bar.
- Open the Export tool.
Now you need to select these values in the Export tool:
- What columns do you want to export: Here we need to select the columns we want to export, making sure to select the Polylang: Translation of and the Polylang: Language columns
- Which rows do you want to export: In this example, we will export all the rows, so we need to select All the rows from my current search.
- What app will you use to edit this file: Select any of the available apps. We will select Microsoft Excel in this example.
- Click Start new export to download the CSV file to your computer.
Edit WooCommerce Polylang translations in a CSV
Now that we have exported the WooCommerce products in our default Polylang language, we can send the CSV to our translator to edit the translations of the products and variations.
In this example, we are going to create product translations and variations into Spanish, using Excel, Google Sheets or any other CSV file editor.
Important – You must ensure that the CSV of the translations complies with the following requirements:
- 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. In this case, we exported the English posts, but we are creating the Spanish translations, so we should remove the “record_id” column, since we are not editing the original posts, but creating new translations from the CSV.
- The column “Polylang: Translation of” must be filled in with the name of the post in the main / default language.
- The column “Polylang: Language” must be filled in with the translation language. In this case, we’ll enter “Español”.
Once you finish editing the translations in the CSV, you can proceed to import the Polylang translations’ data from the CSV to WordPress.
Import WooCommerce Polylang translations from CSV
WP Sheet Editor allows you to import WooCommerce product translations from a CSV file.
For this, you need to open the spreadsheet in the translation language to which you are going to import the translations.
In this example, we are going to use the Spanish language, so we need to select it in the admin bar.
After selecting the translation language is to open the Import tool.
Next, you need to select the CSV you’ll import from your computer:
- Source: CSV file from my computer
- CSV File: Click Choose file and select the CSV file from your computer.
- Click Next.
Then, you need to select the columns you want to import.
In this case, we will Import all the columns, but you can also Select individual columns to import.
Next, select how you’ll import the information.
In this example, we will import all translations as new, but you can also update existing translations.
Finally, you’ll be shown a preview of what the product translations will look like once they’re imported.
If everything’s OK, click The preview is fine, start import.
Translate WooCommerce products with Polylang and WP Sheet Editor!
WP Sheet Editor allows you to export your WooCommerce products in specific Polylang languages.
This allows you to edit post translations using Excel, Google Sheets or any other CSV editor.
Besides, you can import product translations from the CSV into WordPress with a few clicks.
You can download the plugin here:
Does this work with posts, pages, and other post types?
Here’s a tutorial on how export post translations. The method shown in that tutorial works with posts, pages, and custom post types.
Does this work for migrating translations from one site to another?
If you want to migrate translations from one site to another, you need to first migrate the taxonomy terms (tags, categories, etc.).
If this is not done first, there will be synchronization problems between the languages.
Here’s a tutorial on how to export and import taxonomy terms.