Import product descriptions with special characters

About this article

If you are planning on broadening your retail markets into Asia and would like your products to reflect the language of your chosen countries this guide will help you import product descriptions, both short and regular, to Centra.

How to Import Product Descriptions with Asian Characters (Chinese, Taiwanese, Japanese, Korean etc.)

The first thing you will need to do is have your English descriptions translated by a professional, this is something that you will have to source.

  1. Have your translations ready in an excel file like this:

You will need to name the columns as follows:

  • Description – cn (China)
  • Short Description – cn (or the locale you are trying to import: tw = Taiwan)
  • Product Name – the product name that matches the SKU
  • SKU – the SKU you would like to import to.

Having these columns will ensure that the import is successful to the specific product, and find it’s correct match. The easiest way would to get the columns right would be to export the products from Catalog > Products > Export.

​We recommend you use an office program called Libre Office, it is available for free download via their website. The reason we use this office program is because of the capabilities to save files in .UTF-8 (Unicode).

Once you have downloaded the program you need to open the excel file there

  1. Click “Open File” and make sure that it is the original excel file, the format should be .xlsx
  2. Now we need to save it in the correct format. To do this click File > Save As > Choose the file type “Text CSV” > Ensure that the “Edit filter settings” box is checked > Save.
  3. You will get a pop up like this where you choose “Use Text CSV Format”:

  4. The next stage is choosing the UTF-8 file format. Under Character set: select Unicode (UTF-8) > Leave all remaining fields as is > OK.

  5. Now it’s time to import the file to Centra.

To do this:

  • Go to CATALOG > PRODUCTS > Click the +IMPORT button (in the upper right corner) > Under “Import Type:” select Products.
  • Choose the file.
  • Under Import to stores: Select a store. Either Wholesale or Retail.
  • Leave all fields except for “Select file encoding” as is.
  • Under “Select file encoding:” use Mac (Unicode).
  • Click IMPORT

You then get a checklist where you need to control that all your products in the file have found the right match to the products in Centra. Then click IMPORT again. You have now successfully imported descriptions and short descriptions for products with Asian based characters.

Previous article: Import products in bulk