Steps to Import Multilingual Products (Using WPML)

Last updated on September 10, 2021

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

Install, Activate and Configure the WPML Plugins
Prepare the CSV to be imported.
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?
Yes, thanks!Not really

This article posted in Advanced Topics, Documentation, Product Import Export Plugin for WooCommerce

Written by

Shesna

Shesna is a technical content writer for WebToffee. She is familiar in working closely with the SMEs to break down complex technical information into a concise, easy to understand manner.

Comments (17)

Jaydeep Jagani

August 12, 2021

HI,

I am using WPML so I need to import product into 2 Language ( EN + FR ). I have checked your document in which you said to add 3 field “wpml:language_code, wpml:original_product_id, wpml:original_product_sku” but what about the title + content, if I want to change the title and description of product in French language then how can I do that ?

Also I have checked your sample csv in that also there is no field for language wise description

Reply
- Mark
  
  August 24, 2021
  
  Hi,
  
  You need to create a separate CSV row for each translation and in that row, you may please provide the data in the desired language.
  
  Reply
Evangelos

December 6, 2020

Hi,

Do you support importing product variations?

Thanks

Reply
- Mark
  
  December 8, 2020
  
  Hi,
  
  Currently, the plugin only supports WPML simple products. It does not support variable products.
  
  Reply
Danny Boktor

May 14, 2020

I am not seeing the french products in the CSV export. But I do see that the three columns that are required already exist in the column mapping. Why is it that it doesn’t get added to the CSV file?

Reply
- Alan
  
  May 14, 2020
  
  Hi,
  
  As per our understanding, you are having an issue with exporting the WPML products to the CSV file. Could you please try switching the admin panel language to French and try exporting the products.
  
  If the issue still persists please reach us via support.
  
  Reply
AcGieg

January 8, 2020

Hello,

When our site was located at domain.com/wordpress, we used to click at WooCommerce > Product Import-Export (http://www.domain.com/wp-admin/admin.php?page=wf_woocommerce_csv_im_ex)

Steps that we followed: https://www.webtoffee.com/steps-to-import-wpml-products/

And we were able to export all our products.

Fields that were being exported:
ID
post_title
post_name
post_excerpt
post_content
post_status
sku images
tax:product_cat
tax:product_tag
wpml:language_code
wpml:original_product_id
wpml:original_product_sku

When we moved our site to domain.com, the last 3 fields (wpml:language_code, wpml:original_product_id, wpml:original_product_sku) disappeared and now we can’t import or export products using these 3 fields.

The 3 fields are missing 🙁

Could you please help us recover those fields?

Thanks in advance!

Reply
usr.cm

November 6, 2019

When I import products with language “de”, sometimes I get the message “Product already processed”, so it does not allow me to import the item because it’s using the same sku or id than the main language (en).

When I get the message “Product updated successfully”, the product does not show in the german language.

I’ve been fighting for hours with trials and errors and I’m still unable to upload the german language translation for my woocommerce products 🙁

Reply
- usr.cm
  
  November 6, 2019
  
  solved
  
  Reply
  - Julien
    
    March 11, 2021
    
    Hello,
    
    sorry but how did you do ?
    I have same issue…
    
    Thank you !
    
    Reply
    - Alan
      
      March 16, 2021
      
      Hi,
      
      Please reach us via support with your CSV fiel so that we can check it.
      
      Reply
Haitham

February 28, 2019

Hi,

I’m using your plugin with wmpl, I’ve two questions here:

1- shall I duplicate all CSVcell from EN to AR language and translate any cell I want? so I’ll have two exact row except for the translation texts?

2- what about variation products? shall I do it the same? duplication parent SKU and it’s children ?

Reply
- Alan
  
  March 1, 2019
  
  Hi,
  
  1. Yes, you may please copy the data in the English(EN) products row to the second translation(AR) row and translate the fields as per your requirement. The final CSV will have two rows with the same data except for the translation text.
  
  2. Currently, the plugin supports importing/exporting of WPML simple products only. Support to importing/exporting of WPML variable products can be expected in future releases.
  
  Reply
  - David
    
    August 12, 2020
    
    Hi,
    i’m using your plugin with wmpl too and I’m looking to import WPML variable products. Is the integration of this functionality still planned in your plugin? If so, when will it be available. Thank you for your answer
    
    Reply
    - Alan
      
      September 10, 2020
      
      Hi,
      
      Currently, the plugin is compatible with WPML simple products only. Our WPML compatibility is still under development and will try to include the WPML variable support in the upcoming releases.
      
      Reply
      - Gerardo
        
        November 20, 2020
        
        Aby update for the wpml import variation functionality? I’m using your plugin and I would like to have that functionality.
      - Mark
        
        December 16, 2020
        
        Hi,
        
        Sorry to say that the plugin does not support importing WPML variable products. It supports only WPML simple products.

Cookie	Description
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lr	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_or	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qs	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.

Steps to Import Multilingual Products (Using WPML)

Install, Activate and Configure the WPML Plugins

Prepare the CSV to be Imported

Import Products using our Import Export Plugin

Written by

Comments (17)

Leave a Reply
Cancel reply

Leave a Reply

Our plugins

Steps to Import Multilingual Products (Using WPML)

Install, Activate and Configure the WPML Plugins

Prepare the CSV to be Imported

Import Products using our Import Export Plugin

Share this post

Written by

Comments (17)

Leave a Reply Cancel reply

Leave a Reply

Leave a Reply
Cancel reply