Polylang & CSV Importer – Import Export Multilingual Content

1 May 25, 2023

Import your CSV/XML records in multiple languages to Posts, Pages, Custom Posts, Taxonomies, Tags, Categories, or WooCommerce Products and export them with WP Ultimate CSV Importer. Fully compatible with Polylang Free, Polylang Pro, and Polylang for WooCommerce addon. Adding even more convenience to your multilingual content management.

Supported Modules

Posts Pages Custom Posts Tags
Categories WooCommerce Products Taxonomies  

 

Step to follow Before import

Add two additional fields in CSV/XML file

Generate a CSV or XML file containing data for Posts, Pages, Custom Posts, or any other content you wish to import, which incorporates these two additional fields: language_code and translated_post_title. 

 

post csv polylang fields

 

The language_code field holds the language code value for both your default and translated content. The translated_post_title field includes the title value of the original record(the post that you have translated into many languages). Note that you need to mention the value for ‘translated_post_title’ only in the translated records. This will establish a connection between your translated post and the original/default post.

 

CSV Headers Description Sample values
language_code Provide the language code of the content fr
translated_post_title Provide default post title value to relate CMS

 

Importing content into a multilingual website

  • Upload your CSV/XML file using the WP Ultimate CSV Importer plugin.
  • Choose ‘New items’ and select the desired post type from the dropdown menu. You can select “posts” for importing posts, or choose “pages” “custom posts” or other options.
  • Click Continue and map the CSV/XML field headers with the related WP fields. While you map, you can find a section for Polylang Settings Fields. Make sure to map the fields inside this section.

  polylang settings fields widget in mapping  

  • Give a name for the mapping and proceed to the next step.
  • By default, the media handling section is enabled. If you are importing external URL images, leave it enabled.
  • Click the “Import” button to instantly import the data. Alternatively, you can choose ‘Do you want to Schedule this import?’ to schedule the import process.
  • If scheduling, provide the schedule date, time, frequency, and time zone. Then click the Schedule button.
  • For more information on importing content, refer to the how to import into WordPress documentation.

 

 

Export content from a multilingual site

You can export multilingual content of posts, pages, custom posts, or other post types from your website.

  • Move to the Export tab in the plugin.
  • Select the desired post type or module to export their data.
  • If choosing Custom Posts, select one custom post from the dropdown to export its data.
  • Click Continue.
  • Provide a name for the file to export.
  • Select the file type for export such as CSV, XML, XLS, or JSON.
  • Click Export to instantly export the data or enable the ‘Do you want to schedule this export?’ option and provide the schedule date, frequency, time zone, and time if scheduling.
  • The downloaded file will be saved to your computer’s desktop.

 

 

Updating translated records data with the CSV Importer plugin

To update the existing translated records data, follow these steps:

  • Upload the updated CSV or XML file.
  • Choose Existing items and select the post type.
  • Click Continue.
  • Select the “Use template” button to use the previously saved mapping template, or click “Create new mapping” to map the CSV header fields with WP fields.
  • Click Continue.
  • Disable media handling if you do not use any external URL images in your CSV/XML. Otherwise, leave it enabled and click Continue.
  • In the import configuration section, enable the ‘Do you want to handle the duplicate on existing records ?’ and select a field to handle duplicates. Available fields include post_title, ID, and post_name.
  • Click Update to promptly update the data on your website.
  • If desired, you can schedule the update process by enabling the “Do you want to Schedule this Import?” and providing the schedule details.
  • Once you have filled in the details, click Schedule Update.

 

Frequently Asked Questions

1. Which Polylang addon is supported by the CSV Importer plugin?

The plugin supports the Polylang for WooCommerce addon.

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

The CSV Importer imports WooCommerce products with their taxonomies.

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.