Smackcoders
0
0

Knowledge Base

Polylang & CSV Importer – Import Export Multilingual Content

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 Add-on. Adding even more convenience to your multilingual content management.

Supported Modules

Posts Pages Custom Posts Tags Categories
Taxonomies WooCommerce Products WooCommerce variation Media Woocommerce Order ACF custom fields(basic,content)

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.

translations columns in csv

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: You need to mention the value to ‘translated_post_title’ for the posts you wish to translate. 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                    ar
        translated_post_title Provide default post title value to relate               CMS

Importing Post content into a multilingual website

Step 1: First, access the WP CSV Importer plugin by navigating to the left-side menu

Step 2:Click on Import/Update from the top sidebar

Step 3: Browse the csv that you want to import.

Step 4: Select the content type from the drop-down that you want to import. You can select posts, pages, custom posts, Woocommerce products, Woocommerce variations, media, etc.

Here I select Posts.

post upload view csv importer

Now click on Continue and select Create Mapping to import your posts.

Types of Mapping

The fields in the uploaded csv have been auto-mapped. You can also map the custom field that you have added to the csv for importing.

You can map your post-WP fields with their related CSV header in two different methods. The WP CSV importer plugin uses auto mapping when your csv fields are the same as that of WP fields. If you provide a different name in CSV then you need to manually map the field.

Advanced Mode:

Map the fields CSV header from the drop-down corresponding to its related WP fields

Drag and Drop Method:

Drag the appropriate CSV header from the right side menu and drop it on its related WP fields.

Polylang Settings field

Ensure the language_code and translated_post_title are mapped correctly.

polylang setting fields csv importer

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

Create WP custom fields:

You can also add mapping to any of the WP custom fields of your post by clicking on this Add custom field.

Media upload fields:

Browse the media file that you want to import as a zip.  Once done, save the mapping template with the unique name. Now click on Continue. 

Featured Image Media Handling:

Map all the related fields of Media. Enable the download of external images to your media if you want to download the external images to media. Choose the desired field on image handling. Enable the download of the post-content image option. Select the image sizes and map the Media SEO and advanced options. Click on Continue.

Import Configuration section

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 duplicate on existing records?
  • Do you want to Schedule this Import?
If scheduling, provide the scheduled date, time, frequency, and time zone. Then click the Schedule button. Finally, click on Import.

Verify and Review:

Once, the import is finished, click on view log to view the detailed report of importing the content by clicking on admin view on the report.

posts import log page view

You can see the detailed view of the posts that have been imported.

arabic translation post edit view

Or you can verify and confirm your Post Import by navigating to Post->All posts

posts list view translation column

Here you can see, that two posts get imported with the same post title and in different languages.

Importing categories and Post tags in Multi-language

With CSV importer you can import your categories and post_tas 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 importining, select the Import each record as “categories” from the drop-down

Importing Woocommerce Products in Multilingual Websites

The importing process includes the same step as explained in how to import post content in the above section.
  • First, prepare a csv with the original product and translated product


post csv translation column

  • Navigate to the CSV importer->Import/update-> Browse the desired csv file
  • Select the product type as Woocommerce Products


products csv post type selection view

  • The fields on the uploaded csv are auto-mapped. You can also add mapping to any custom fields that you can additionally create on the csv.
  • Configure the Import configuration steps as per your needs
  • Once done click on Import.
  • Now your Woocommerce products have been imported with its translated content.
Detailed view:

product imported in english language

List view:

Products list view translations column

Import Woocommerce variations

Importing WooCommerce products will also import the Woocommerce variations. However, you have an option to import your Woocommerce variation alone.

Prepare your csv with your Woocommerce variation and its translated content. While preparing CSV for Woocommerce variations, note that you have translated your  Product attributes for multiple values and separated them with the pipeline (|) as it is in the original content.

product csv attribute translation

Then import your csv with the WP CSV importer by the Importing steps explained above. While importing, make sure you have selected the post type as Woocommerce Variations, map your fields, and Import.  With this, you can easily import the Woocommerce  Variations for your existing Products.

Import Woocommerce Orders

To import Woocommerce orders, Prepare  a csv for your Woocommerce orders with  its translated content. To know how to prepare a csv, refer to  Once you prepared your CSV follow all the Importing steps of WP CSV importer plugin.

Makesure to select your Woocommerce orders as your content post type. Once done map your fields, configure import settings, and Import.  Note: Before importing Woocommerce orders, make sure your product corresponding to the respective orders will have already been imported in your WordPress site.

Import Images in your Multilingual Website.

With WP CSV importer, it is easy to import images alone. Before importing images first you need to zip the images or the image folder that you need to import.

While preparing csv you need to add the zip folder name in the Image field. If you zipped your folder that contains your images, then you need to enter  the foldername/imagename. For example, pictures/WPexporter. That is the pictures folder is zipped, where I need to import the WP exporter image. Once done, start the import process of WP CSV importer. Browse your csv and select the post type as Images from the drop-down.

Continue mapping your desired fields. It is important to upload your zipped file of your image that you need to import. And save the mapping template. Fill in the import configuration steps and click on Import. Now your images have been imported on your media library.

Export content from a multilingual site

With WP CSV importer, you can import as well as export your content in the multilingual website. You can export multilingual content of posts, pages, custom posts, or other post types, Woocommerce products, Woocommerce variations, etc 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 scheduled 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 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. 

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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