Build your feed, update prices & stocks

Build your feed, update prices & stocks

Translations – how to do and why they are needed.

Translation of text from one language to another

Translating text from one language to another works through the Google translation API.

It is configured through the Settings of the Main Feed and works when the product is copied from the supplier’s feed to the Main Feed or at the level of the supplier’s feed and works when the price list is loaded.

In the Settings of the feed in the line “Google Translate” it is necessary to register from which language to translate, to which language to translate and ApiKey according to the formula: From | To | ApiKey. The language codes can be found here.

Replacing one word with another

This translation option requires compiling a dictionary and works when the product is copied from the supplier’s feed to the Main Feed. Additionally, you can call translations from the dictionary during the import of products into the price list  through functions.

The function “translations” is needed, for example, for the following cases in the processing of prices.
1. Replace one word from the original price list with another, or delete it altogether.
For example, in the product description, there is a phone number that must be deleted or changed to your own.
2. Massively change one word / phrase to another.
For example, when you need to convert sizes from the US system to the Russian system.

A set of translations is compiled.

Go to the “Words replacement” tab:

 

Compiling a dictionary of translations:

 

Setting up translations for files in Excel format.

In the advanced settings of Excel download, a formula is set for the required field,
for example,
= Translator.StringFullChange (F) — replaces phrases one to one
or
= Translator.TranslateText (F) — used to replace the original word with a new one inside the text.
Where F = the column from which the source string will be taken for translation.

It is important to understand that it is the words that are replaced, not the parts of the words.

If you need to replace parts of words, then use the standard C# function — string.Replace (“from”, “to”)

An example of translating option values in the price list

Setting up translations for files in any format.

Go to Functions — Content — Translation prices:

 

Select the price and fields for which you want to start the translation and click “Run”: