Use the Import-Export feature when you need to translate your store product catalog as a whole. Export the existing categories and product data into a .CSV file, edit this file, and then import it back into the store.

Using this method, you can translate product and category names as well as brief and full descriptions and the rest of the details you need.

Before translating your product catalog, make sure the respective language pack is installed.

To translate a product catalog:

1. Export the current catalog data:

  • Go to the Export page of your store Admin area (Catalog -> Export):

541-export-page.png

As a result, you will get a .CSV file with the default labels’ names and values.

2. Open the exported .CSV file in any spreadsheet editor (MS Excel, LibreOffice Calc, etc.)

3. Delete all the tables except for SKU and the tables marked with EN (the labels marked with EN can be translated and imported back).

You should get a file content similar to the following:

export-products-en.png

4. Rename the EN tables to match the target language (e.g. change name_en to name_de if your target language is German).

5. Fill in the new tables with the translation (e.g. the name_de table should contain the name of a product/category in German).

As a result, you will get a file similar to the one shown below:

product-csv-de.png

6. Save the .CSV file with the SKU and DE tables and import it back to your store as described in How to Import Data.

Did this answer your question?