Exporting WPML Multilingual WooCommerce Products

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Product Import Export for WooCommerce plugin provides the solution to all your needs of exporting products of different languages in a CSV file. The advantages of the plugin are as given below:

  • Product Export-Import plugin allows you to easily export a large number of translated products by using WPML (WordPress Multilingual) plugins.
  • Plugin exports all the details of translated products like images, category, SKU, regular price, sales prices, metadata, etc. into the CSV file flawlessly.

For more information about CSV format, see Setting Up Product Import Export Plugin For WooCommerce.

Pre-requisites

Activate WPML plugins: Multilingual Tools, WPML Media, WPML Multilingual CMS, WPML String Translation, WPML Translation Management and WooCommerce Multilingual.

Now, let’s understand the exporting of multilingual products through an example.

But, just before exporting, we will go through the steps to translate the products to another language.

How to translate product to another language by using WPML plugins?

  1. Navigate to Dashboard > Products. Under the English option,  you can see all the added products of the English language. The sample product is shown as below:Product page in English
  2.  Under the German option,  you can see all the added products of  the German language. The Sample product is shown as below:German product page
  3. Let’s translate English product to German. To do that click on English to see the product. It is as shown below:Translate WooCommerce Products
  4.  Select the required product and click Translate WooCommerce products, the window appears as shown below:Add German translation
  5. Click ‘+‘ sign to add German Translation, the window appears as shown below:Translation details
  6. Enter all the required translation fields.
  7. Select the Translation is Complete check-box.
  8. Click Save & Close. You get the message as shown below:Translation saved message
  9. Under the German option, you can see the translated product. It is shown as below:Translated products on the products pageSo, we have products as given below:
    English: Samsung Galaxy Ace Duos by Hike force
    German: Keyboard, Samsung Galaxy Ace Duos von HikeForce

Now, let’s export these products to CSV files.
Important: To export products of the specific language, please make sure that you have selected the same language at the admin dashboard.

  1. Navigate to Admin settings (WooCommerce > Product Im-Ex) of Plugin. Under the Product tab, the Export window appears as shown below:Product export page
  • Offset: Enter the product row number at which you wish to start the export.
  • Limit: Enter the number of products that you wish to export from Offset number.
  • Product Categories: Select the product category(s) so that plugin exports the products which are assigned to specific categories. The sample list of categories is as shown below:Export product by categories section
  • Product Types: Select the products type(s), so that the plugin exports products which are assigned to specific types. Sample list of product types is as shown below:Export products by product types
  • Sort Columns: Enter the column name(s) by which you want to sort the products in CSV file. If you want to sort the products by more than one column name, enter Comma (‘,’) in between the column names. post_parent and ID are added by default, and the other accepted columns for sorting the products are as given below:
    – post_author
    – post_date
    – post_title
    – post_name
    – post_modified
    – menu_order
    – post_modified_gmt
    – rand
    – comment_count
  • Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  • Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  • Include hidden meta data: Select the checkbox if you want to show hidden metadata of your products in CSV file. To get thumbnail IDs of the product images, select this checkbox.
  • Click Export Products, the CSV file gets auto-downloaded to your computer.
    For English, the sample exported product CSV file is as shown below:Sample CSV in EnglishNote: You can download the Exported Sample CSV for English Product. For German, the sample exported products CSV file is as shown below:Exported CSV in GermanNote: You can download the Exported Sample CSV for German Product.

To know more about other features of the plugin, read the documentation.

Try out our Product Import Export Plugin For WooCommerce to move products and reviews from/to your site easily.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *