Knowledge Base

Polylang & CSV Importer – Import Export Multilingual Content

This guide will walk you through the process of importing multilingual content into your WordPress site using WP Ultimate CSV importer and Polylang. Polylang allows you to create a bilingual or multilingual WordPress site, and with WP Ultimate CSV importer, you can easily import translations for posts, pages, custom post types, WooCommerce data, etc.

Prerequisites

Before you begin, ensure you have the following:

  1. Polylang Plugin installed and configured.
  2. WP Ultimate CSV importer PRO Plugin installed.

How to Import WordPress Posts on Multilingual Websites #

Step 1: Preparing Your Import File #

Your import file should contain content for all languages in CSV, XML, or Excel format. Each row should represent a single post or page, with columns for different language content.

  • Important Columns: Make sure to include columns for:
    • Post Title: Provide the title of the desired posts to import on each row
    • Content: Enter the content of the posts on the desired row of the corresponding posts
    • Language code: Specify which language the content is associated with. For example, en for English, and fr for French. You can view the language code for your desired languages from the polylang language settings.
    • Translation Post title: The translated_post_ title should be empty on the original or source posts. However, on all translated posts, enter the source posts’ post title in the translated_post_title field. This will help identify the original posts of the translated content.
translations-columns-in-csv

Step 2: Importing Data with WP Ultimate CSV importer #

  1. Start a New Import: Navigate to WP Ultimate CSV Importer > Import/Update and browse your import file (CSV, XML, or Excel).
  2. Choose Import type: Select the Fresh Import option to import new posts.  If you want to update the existing posts, then select Update Content.
post-csv-upload-view

3. Configure Import Settings:

  • Select the post type to import (e.g., Post, Page, Custom Post Type).
  • To import Posts, Select Posts and click on Continue

4. Customize the field Mapping:

  • Map the WP post fields with their corresponding CSV fields
  • In the “Post Title” and “Content” fields, map the corresponding columns from your CSV or XML file.

Map the Polylang Settings field:

  • On the polylang fields, map the language_code field and translated_post_title field.
polylang-setting-fields-csv-importer
WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Terms and taxonomies:

If you want to import the post category, map the category field here. For this, you must also include the post category field in your CSV file. Also, to import post_tag, add the post_tag field in your CSV file and simply map this post_tag field.

terms-and-taxonomies-mapping-fields
  • Save the mapping template and click on Continue.

Step 3: Configure Import Settings #

Manage the media uploads and configure the import settings
Enable /Disable the below configuration based on your business needs. 

  • Enable safe prestate Rollback (Backup before import)
  • Do you want to SWITCH ON Maintenance mode while import?
  • Do you want to handle the duplicates in existing records?
importupdate-Configuration-settings-for-data-update
  • Do you want to Schedule this Import?

If scheduling, provide the scheduled date, time, frequency, and time zone. Then click the Schedule button.

importupdate-Schedule-import

If not, just click the Import.

Step 4: Review and Finalize the Import #

Verify Translations: After completing the import, visit the site to ensure the translations are correctly linked. Each post should have its translations linked and available in the language switcher on your website.

Importing categories and Post tags in Multi-language #

With CSV importer you can import your categories and post_tags along with the post. However, you can also import the translated content of your post categories and post tags even after importing the posts.

Make sure you have already imported the related post for which you need to import the post categories and post tags.

While importing, select the Import each record as “categories” from the drop-down

Advanced Topic: Importing WooCommerce Data in Multilingual Websites #

Import Woocommerce Product #

The import process for the WooCommerce product is the same as that of importing Posts explained above. 

  • First, prepare a CSV with the source product and translated products. Ensure to include the language_code and translated_post_title column 
post-csv-translation-column
  • Once you have prepared the CSV, start the import process.
  • Navigate to the WP Ultimate CSV importer-> Import/Update
  • Browse the prepared CSV file. Select the fresh import for the new import.
  • Select the data type as WooCommerce product and click on Continue
woo-products-csv-post-type-select-view
  • Map all the Woocommerce data of WP fields with its related CSV fields
  • Map the Polylang settings fields for language_code and translated_post_title
  • Once done with the Mapping, configure the import settings.
  • Click on Import. Now WooCommerce Products have been successfully imported into multilingual websites.

Importing WooCommerce Variations #

When importing WooCommerce products, variations will also be imported automatically. However, you have the option to import WooCommerce variations separately.

To begin, prepare your CSV file containing WooCommerce variations along with their translated content. While preparing the CSV, ensure that the product attributes are translated for multiple values and separated by a pipeline (|), just as they appear in the original content.

For example, your product CSV should look like this:

  • Product CSV attribute translation
product-csv-attribute-translation

Once your CSV file is ready, use the WP CSV Importer plugin by following the import steps outlined above.

During the import process:

  1. Select WooCommerce Variations as the post type.
  2. Map your Woocommmerce fields and polylang settings fields correctly.
  3. Complete the import.

This allows you to easily import WooCommerce variations for existing products on your site.

Importing WooCommerce Orders #

To import WooCommerce orders, start by preparing a CSV file with your WooCommerce orders and their translated content.

To know how to prepare a csv, refer to this article 

Once the CSV is ready, follow the import steps provided by the WP CSV Importer plugin.

Note: Make sure the corresponding products for the orders you are importing are already present on your WordPress site before proceeding with the order import.

To import:

  1. Select WooCommerce Orders as the post type.
  2. Map your fields.
  3. Configure the import settings and click Import.

Importing Images on Your Multilingual Website #

The WP CSV Importer makes it easy to import images to your site. First, compress (zip) the image files or folder you wish to import.

In your CSV file, reference the zipped folder (including the extension) in the Image field. If you zipped a folder containing multiple images, use the format foldername/imagename. For example, if you zipped a folder named pictures, and the image is WPexporter.jpg, use pictures/WPexporter.

Once your CSV is prepared:

  1. Go to the Media tab in the WP CSV Importer plugin.
Media-Import-Select-Media

2. Choose the Device option and browse for your zip file.

Media-Import-Choose-upload-Method

3. You’ll be prompted to select which images from the zip file to import. To import all images, check the box next to the name and click OK.

4. Upload the prepared CSV that contains fields like filename, title, caption, description, and alt text.

Media-Import-Upload-Media-and-CSV-fields

5. Select Fresh Import as you are importing new images.

6. Map the fields (they will auto-map if the CSV headers match the WordPress media fields).

7. Save the mapping template and complete the import configuration.

Click Import to upload the images to your Media Library.

Media-Import-Import-Succesfully

Exporting Content from a Multilingual Site #

With the WP CSV Importer, you can export content from a multilingual Polylang-powered site, including posts, pages, custom posts, WooCommerce products, variations, and more.

To export content:

  1. Go to the Export tab in the WP CSV Importer.
  2. Select the post type or module you want to export.
  3. If exporting custom posts, choose a specific post from the dropdown.
  4. Click Continue.
  5. Name the file you wish to export and select the export format (CSV, XML, XLS, or JSON).
  6. Click Export to download the data immediately, or enable the “Do you want to schedule this export?” option to set a scheduled export with the desired date, time, and frequency.

Once exported, click Download to save the file to your computer.

Updating Translated Records Data #

To update existing translated content, follow these steps:

  1. Upload the updated CSV or XML file.
  2. Choose Update Content and select the post type.
  3. Click Continue.
  4. You can either select the Use template button to use a saved mapping template or click Create a new mapping to map the CSV fields to WP fields.
  5. Continue configuring the import settings.
  6. Enable the “Do you want to handle duplicates?” option to prevent overwriting existing records. Choose a field (e.g., post_title, ID, post_name) to manage duplicates.
  7. Click Update to update the data.

If you wish to schedule the update:

  1. Enable the Schedule Import option.
  2. Set the schedule details (date, time, frequency, and timezone).
  3. Click Schedule Update.

This allows you to update your site with the latest translated content and keep your data synchronized.

Troubleshooting #

If you run into issues, here are some common solutions:

  • Language Missing: Ensure that the Polylang plugin is installed and activated and that all languages are correctly configured.
  • Translation Not Linked: Double-check that you are linking the original post to its translation using the Post ID and Translation ID fields.

Frequently Asked Questions #

1. Which Polylang Add-on is supported by the CSV Importer plugin?

The plugin supports the Polylang for WooCommerce Add-on.

2. What WooCommerce data can be imported by CSV Importer for Polylang?

The CSV Importer imports WooCommerce products with their taxonomies, WooCommerce orders, and Woocommerce Variations 

3. Does the plugin automatically translate the content?

No, it doesn’t. WP Ultimate CSV Importer only imports and exports multilingual content. You should add the translated content in CSV or XML and then you can import it with our plugin.

4. How to use the spreadsheet for each language?

It is easy to include all the translated content in a single CSV or single spreadsheet. You can easily differentiate each language by adding an extra column to the CSV such as language code. Provide the language code (en for English, ar for Arabic, fr for French)  corresponding to its translated content.

5. How to prepare the translations in a CSV file?

Step 1: Translate the original content to your desired languages.

Step 2: Open the Google spreadsheet 

Step 3: Enter your post content title and its translations in the rows and provide all the post content details in the column.

Step 4: Add two extra columns for the language code and the translated post title.

Step 5: Enter the desired language code corresponding to the translated post content. That is provide the language code “en” corresponding to the English post. And provide the language code “fr” corresponding to the French post.

Step 6: Enter the post title of the original content in the translated post title column of all the translated content. Leave the translated post title column of the original content empty.

Step 7: Once done, Save the file. CSV format.

6. How to import the Polylang translations quickly?

With WP CSV importer, it is easy to import the polylang translation quickly. The import steps are explained above in this documentation.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.