Importing translated products for free in WooCommerce

Importing translated products for free in WooCommerce

Importing translated products for free in WooCommerce 150 150 Benjamin Durin

A client of mine has hundreds of products to enter into their new site and they use two languages: English and Chinese.

The official solution from WPML is to use a paid plugin. That’s a shame! I don’t want to buy another plugin.

Well, there is another solution and it’s too bad it’s not in WPML documentation. All you need is WPML and at least WooCommerce 3.1x. These are the steps to follow:

  1. Create the products in the main language (English for me) or import them from a CSV file.
  2. In WPML – Translation Management, duplicate all the products to the secondary language (Chinese).
WPML Translation Management
Duplicating content in WPML Translation Management
  1. Return to Products in Woocommerce, select Chinese then click Export.
Exporting Products
Exporting Products in WooCommerce
  1. Translate the products in the exported file. Don’t forget to change the headers back to English.
  2. Import back the translated CSV file in Chinese. Don’t forget to check the Update Existing Products box.
Importing translated products
Importing translated products in WooCommerce

And that’s all there is to it. It’s pretty straightforward and free.