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.

As a CAUTION, users need to use the EXACT same values as inputted in the custom fields, otherwise Apicbase won't recognize them.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 F (Approved): This column indicates if the product is verified for production.

1 = Approved

0 = Not approved

Column G (Allowed in production): This column shows if the product is allowed in production.

1 = Allowed

0 = Not allowed

Column Q, R and S (Accounting/Category/Subcategory): These are set custom fields that you can change. It is important that you first set the values of these custom fields 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 O (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 P (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 T (Validated): In this column, you fill in if the allergen information of this ingredient is validated.

1 = Validated

0 = Not Validated

Column U contains the "validation date". Fill in the format: DD/MM/YYYY

Columns V - BG (Allergens): These are allergens that are officially recognized in a lot of countries.

1 = Contains

2 = May contain traces of

3 = Unknown

Columns CP - DD (Nutritional info): This is information about other possible products the ingredient can contain.

1 = contains this product

0 = Does not contain this product

Columns BH - CH (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 CI: here you can fill in the ppm for sulfites

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

- CJ: Validated:

1 = the nutrition data for this ingredient is checked and validated

0 = the nutrition data for this ingredient is not checked and validated

- CK: Validated at: date of validation
- CL: 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.
- CM: 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".

Columns DE - EF: Nutrition Data-Vitamins

Column EG: Custom column - This is a column set for custom fields that you can “Add/Change”.

As a CAUTION, users need to use the EXACT same values as inputted in the custom fields, otherwise Apicbase won't recognize them.

It is important to set the values of this custom field before you fill them in the template. Go to “Library Settings” then select “Custom Field Settings” then select “Add” on “Custom Ingredients Fields”

Custom fields

Add information that you can delete: You are not obliged to change the template but you have the option to switch it around. You would need to export the "Ingredients Excel File", delete some columns in that file and switch the other around and you will see that it also works. This won't break the import.