Home > Docs > Product Import Export Plugin for WooCommerce > Import Multilingual Products in a WooCommerce Store With WPML

Import Multilingual Products in a WooCommerce Store With WPML

Last updated on October 25, 2023

With the Product Import Export Plugin for WooCommerce, you can easily import multilingual products in three steps.

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

Prerequisite

For successful export of WPML multilingual WooCommerce Products, activate these 6 WPML plugins:

  • Multilingual Tools
  • WPML Media
  • WPML Multilingual CMS
  • WPML String Translation
  • WPML Translation Management
  • WooCommerce Multilingual.

Preparing the CSV to Import WPML products

The product Import Export plugin facilitates the import of multilingual products with the help of a CSV file. For updating multilingual products, apart from the default columns, these additional columns must be included in the CSV:

  • wpml:language_code
  • wpml:original_product_id
    (or)
    wpml:original_product_sku

During import, only one of these columns(wpml:original_product_id, wpml:original_product_sku) is required. 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. Download Sample CSV of WPML.

sample csv
Sample CSV

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.

Import Products using our Import Export Plugin

From the WordPress admin panel, navigate to the menu: WebToffee Import Export (Pro).

  1. Click on Import and specify the post type as Product.
  2. In step 2, select an import method.
  3. Map the import columns.
  4. In the next step, use the advanced options for import and scheduling import.
  5. Click on Import, and the CSV file gets downloaded to your computer.

The steps involved in importing products are the same as importing normal products. If you would like to know more about how the products are imported, you can click here.