Effortless Product Import & Export for Multilingual WooCommerce Stores

Expanding your WooCommerce store to a global audience? Managing multilingual product data can be challenging, but the Product Import Export Plugin for WooCommerce simplifies the process. This powerful plugin lets you effortlessly import and export products, reviews, tags, and categories, saving time and ensuring data consistency. Now fully integrated with WPML (WordPress Multilingual Plugin), this plugin enables smooth compatibility with multilingual WooCommerce websites.

Make sure you have:

• Installed and activated the Product Import Export Plugin for WooCommerce.
• Installed and configured the WPML core plugin.
• Activated the WPML String Translation add-on.
• Activated WPML Multilingual and Multicurrency for WooCommerce add-on and completed its quick setup wizard.

In a multilingual site, you can view products in different languages by switching the site’s language. Navigate to Dashboard > Products.
Selecting English displays all products added in English, while selecting German displays the products available in German.

To translate products from the source language to any target language:

1. Navigate to Translation Dashboard in the WPML plugin and click on Products.
   

2. This lists all the products and the related taxonomies, such as product categories and tags.
   

3. Select the product you need to translate and click on Translate your Content.
   

4. Choose a target language (in this case, German).
   You can choose from multiple AI translation engines. However, the WPML team recommends using their own Private Translation Cloud (PTC) for the best accuracy and results. WPML also displays the exact credit usage and cost before translation begins.
   You may also choose alternative translation options, such as Translate myself or Assign a translator.
   

When using the default Translate automatically option, you can choose how the translations should be published:

• Wait for review – translations are saved as drafts for later approval
• Publish and mark for review
• Publish without review – recommended for faster workflows

Click Translate. WPML automatically processes and translates the selected items into all chosen target languages.

If you choose Translate myself, the product is sent to the translation queue similar to automatic translations, but you will have to complete the translation manually. For this:

1. Click Translate on Step 2.
2. Select the product from the translation queue, and the translation window will appear. In the translation window, enter the content manually, and click on Save and Complete.
   

Your product will now appear translated in the chosen target language.

From the WordPress admin panel, go to WebToffee Import Export (Pro) → Export.

1. Step 1: Select post type
   Choose Product as the post type.

2. Step 2: Select an export method
   Choose your preferred export method.
3. Step 3: Filter data
   Apply filters to export specific products.
4. Step 4: Map and reorder export columns
   Review, map, and rearrange the columns as needed.
5. Step 5: Advanced options
   Apply any advanced export options or scheduling preferences.
6. Export
   Click Export to download the CSV file to your computer.

With the Product Import Export Plugin for WooCommerce, you can easily import multilingual products by following the steps below.

1. Install and configure WPML
Ensure all required WPML plugins are installed, activated, and configured.

2. Prepare the CSV file
To import multilingual products, your CSV must include the default product fields plus the following additional WPML mapping columns:

• wpml:language_code
• wpml:original_product_id
  or
• wpml:original_product_sku

The column names must be entered exactly as shown above, including the colon ( : ) and underscore ( _ ) formatting.

Column usage

• wpml:language_code → Enter the language code (e.g., en, de, it)
• wpml:original_product_id → Enter the product ID of the original product
• wpml:original_product_sku → Or, enter the SKU of the original product

Example

If the original product has:

• SKU: A11
• Product ID: 111

To import this product in English, Italian, and German, your CSV must include the three WPML columns.
Enter:

• en, it, de in wpml:language_code
• 111 in wpml:original_product_id (or use the SKU in the corresponding column)
  

3. Import the CSV

From the WordPress admin panel, go to WebToffee Import Export (Pro) → Import

• Step 1: Select Product as the post type.
• Step 2: Choose your preferred import method.
• Step 3: Map the import columns, ensuring the WPML columns are correctly mapped to their respective fields.
• Step 4: Configure any Advanced Options or scheduling preferences as needed.

Click Import to upload the CSV and complete the multilingual product import.