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 it and then import it back into the store.
Using this method, you can translate product and category names and brief and full descriptions, and the rest of the details you need.
Before translating your product catalog, ensure you installed the respective language pack.
To translate a product catalog:
Export the current catalog data:
Go to the Export page of your store Admin area (Catalog -> Export):
Export data as described in How to Export Data.
As a result, you will get a CSV file with the default labels’ names and values.
Open the exported CSV file in any spreadsheet editor (MS Excel, LibreOffice Calc, etc.)
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:
Rename the EN tables to match the target language (e.g., change name_en to name_de if your target language is German).
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:
Save the CSV file with the SKU and DE tables and import it back to your store as described in How to Import Data.
Related pages: