1. Help Center
  2. Product Development
  3. Ingredient management: the basics

Tips for filling in Apicbase ingredient Excel template

Using the ingredient template to input ingredient information can save you a lot of time. It is important to know which information you can fill in which columns. This article gives you tips on how to use the right values.

If you are new to importing ingredients into Apicbase, it is best to start with this article. Click here if you want toe learn more on downloading and uploading the ingredient file.

Column A (Apicbase ID): This column contains a unique Apicbase ID for this ingredient. The ID is created by Apicbase, you should never fill this in yourself. If you download a filled-in ingredient list of your existing ingredients, the Apicbase ID will be in there. If you download an empty template, this column will be empty. It is important that you use the correct Apicbase ID if you input new info on an existing ingredient. Read this article to learn more about the Apicbase ID.

Column G (Approved): This column indicates if the product is verified for production.

1 = Approved

0 = Not approved

Column H (Allowed in production): This column shows if the product is allowed in production.
1 = Allowed
0 = Not allowed
Column J, K and M (category/subcategory/accounting category): These are set custom fields that you can change. It is important that you first set the values of these custom field before you fill them in the template. The values you fill in, do have to be the exact values you have set.  If you want to read up on setting these custom fields, please read this article
Column S (Mass volume ratio): Here you fill in how many liters correspond to 1 kg of this ingredient. E.g. you fill in "0,9" if 1 kg of the product equals 0,9 liter.
Column T (waste%): Here you can set the waste percentage for this ingredient. Waste works on three levels: library, ingredient and recipe. If you want to learn about this, click here
Column U (Validated): In this column, you fill in if the allergen information of this ingredient is validated.

1 = Validated

0 = Not Validated

Column V contains the "validation date". Fill in the format: DD/MM/YYYY
Columns W - BD (Allergens): These are allergens that are officially recognized in a lot of countries. 
1 = Contains
2 = May contain traces of
3 = Unknown
Columns BE-CA (Nutritional info): This is information about other possible products the ingredient can contain. 
1 = contains this product
0 = Does not contain this product
Columns CB - CI (Dietary info): In these columns, you find info about specific diets. 
1 = this ingredient can be used for this diet
0 = this ingredient can not be used for this diet

Columns CJ: here you can fill in the ppm for sulfites

Columns CK - EG (Nutrition Data): In these columns, you find the values for the Nutrition Data.

    • CK: Validated:
1 = the nutrition data for this ingredient is checked and validated
0 = the nutrition data for this ingredient is not checked and validated
    • CL: Validated at: date of validation
    • CJ: for weight: here you fill in the quantity for which the nutritional info is specified. Generally, this is per 100grams, so you fill in "100" here in this case. 
    • CK: for weight unit: Here you fill in the unit for the quantity for which the nutritional info is specified. In the former example you fill in "g".