Documentation/Product Import Export Plugin for WooCommerce/Steps to Import Multilingual Products (Using WPML)

Steps to Import Multilingual Products (Using WPML)

The Product Import Export Plugin for WooCommerce can be easily used for importing multilingual products with just three easy steps.

  1. Install, Activate and Configure the WPML Plugins
  2. Prepare the CSV to be imported.
  3. Import products using our Import Export plugin.

Install, Activate and Configure the WPML Plugins

The product import export plugin is compatible with popular WPML plugins like Multilingual Tools, WPML Media, WPML Multilingual CMS, WPML String Translation, WPML Translation Management, and WooCommerce Multilingual. However, it is essential to install, activate and configure these plugins in prior to importing multilingual products into your WordPress site.

Prepare the CSV to be Imported

Product Import Export plugin facilitates import of multilingual products with the help of a CSV file. 

Apart from the default columns, three additional columns namely; wpml:language_code, wpml:original_product_id, wpml:original_product_sku must be included in the CSV for importing multilingual products. The name of the columns and its format (underscore and colon) should be specified exactly in the same manner as it is given above.

  • In the wpml:language_code column, enter the code of the language to which the site has to be translated.
  • The product ID of the products can be entered in the wpml:original_product_id column.
  • Similarly, the product SKU can be entered in the wpml:original_product_sku column.

Sample CSV for WPML importing will be as shown below. Click Sample CSV of WPML to download a sample.

In the above example, you can see a product with parent SKU as A11 and product_id as 111. In order to import this product in English, Italian and German, you will have to include three additional columns wpml:language_code, wpml:original_product_id, wpml:original_product_sku. Then, enter the code ‘en’ for English, ‘it’ for Italian, ‘de’ for German in the wpml:language_code column and enter 111 in the wpml:original_product_id column.

Note: Either product ID or SKU has to be given for importing products, needn’t have to enter both of them.

Import Products using our Import Export Plugin

The steps involved in importing products is in the same manner as how normal products are imported. To know more about how the products are imported, click here.

  • Was this article helpful?
  • YesNo