1. Help Center
  2. Product Development
  3. Ingredient management: Advanced

How do I input ingredient translations?

Apicbase lets you input translations of ingredients if you have multilingual staff. This article shows you how to input the translations for ingredients.

The input of ingredient translations: this can be done in two ways.
  • Manual: if you want to add a translation to one or a couple of ingredients, you can do this manually very easily. Go to your ingredient overview and click on the "edit"-button of the ingredient you'd like to add a translation to. 

    Apicbase ingredient translations 1
    • Next, click on the abbreviation of your default language as you've set in your library settings to add a translation. If you want to know more about setting the translations in your library, check this article. In this case, that's English ("EN").

      Apicbase input translations
    • The fields you can translate are
      • "Product Name"
      • "Simplified Product Name"
      • "Storage Instructions"
      • "Description"
      • "Composition"

    • Now you can fill in the translation of this ingredient, as displayed in the screenshot below. Click "Save".

      Apicbase input translations 3
  • Through Excel: Imagine you want to add a translation to a bigger batch of ingredients, or even all the ingredients in your library. This is also possible. Go back to your ingredient overview, click "Import" and then click "Translations".

Apicbase input translations 4

  • Next, you can download a template where you can fill in the translations of your ingredients by clicking the highlighted link.

  • The template will be generated in the Export section. Download it here.

    Apicbase input translations 5
  • Below you can see an example of a translation file. Fill in the translations for the ingredient, save the file and then drag the file into the box of step 2.

    Apicbase input transaltions 6
  • You will now see this in step 3, and your ingredients will be translated:

     

You can only find the fields that are inputted in the default language in the translations Excel. So you first have to input the default language. You can also use the ingredient import Excel for this.

Please read these remarks before you start to import translations: 

  • Always use the official template and if you already have ingredients always start from a template exported from here.
  • You may hide columns whilst working in the document, but do not remove any columns, as this will end up in wrongly imported data.
  • The uploader tries to detect whether the first two lines are title lines. If you use the standard APIC template, do not change the title lines.
  • If you do not have certain information for a specific column, leave the column empty or with the pre-filled data - DO NOT REMOVE ANY COLUMNS.
  • The fields should contain only static data (no formulas, graphs, ...).
  • First time? Test it with a small amount!
  • One translation per line/row.