When listing your items into international market places you may need to translate the product data. The following guide will show you how to get your Veeqo Product data translated using Google's Translation Tool
1. Export your Products making sure to not export the description column
2. Once you have downloaded the file to your computer head to Google Sheets where you can upload the file. Click + New Spreadsheet button to create a new document.
With the new blank spreadsheet now open click on File>Open
A new window will appear, click on the Upload tab, then choose Select A File From Your Computer. Navigate to the CSV file that you downloaded and select this.
The spreadsheet will now open in in Google Sheets. Note down the reference of the columns you want to translate. In this example we are translating the Product Title, this is in column B. The data in this runs from B2 - B115
Scroll right until you reach the end of the spreadsheet data. In this example
Line 1 of this sheet contains the field headers, so click on line 2 of an empty column. Insert the following formula to use Google Translate in Google Sheets
=GOOGLETRANSLATE(B2, "en", "de")
Hit Return to confirm this. This formula will translate the cell B2 from English into German and insert the translation into the field that this formula has been typed into. To translate the rest of column B click on the cell that now contains the translated text. This will highlight the cell and a blue square will appear in the bottom right corner of the cell.
Click on the blue square and drag this down to match the end of the data contained in column B, in this example it is B115. This will copy the formula entered to all of the fields whilst automatically increasing "B2" by +1. This results in translating the next field down.
With this column still highlighted select Edit > Cut
With the translated text copied to the clipboard click on B2 (the first field that you want to translate. Scroll down to B115 (the last field that you want to translate) then hold down Shift and click on this cell with the Left Mouse button.
With the range of cells selected click Edit>Paste Special>Paste Values Only
This will replace the original text with the translated text. Now click Files>Download As>Separated Values (.CSV, CURRENT SHEET)
Head back to Veeqo and click on Products, then select the Import button.
Select Add File and navigate to the file you downloaded from Google Sheets. If you have multiple warehouses please select the warehouse that you'd like to import the products too. then press Import.
Veeqo will now update your products with the translated name and will be ready to list to your international store.
Fields To Translate For Amazon International Listings
Before you can publish your international products to Amazon you'll need to update the following:
- Product Title
- Variant Title
- Product Description
- Product Properties
Google Translate Languages
To translate between other languages please replace the "en" or "de" with the preferred language. Please use the table below to find out the two-letter code for your chosen language.
Important: Make sure you keep a backup of your native language products. This will be used to revert the products back to the original language once you have listed your translated products online.