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.
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
1 = Allowed0 = Not allowed
1 = Validated
0 = Not Validated
1 = Contains2 = May contain traces of3 = Unknown
1 = contains this product0 = Does not contain this product
1 = this ingredient can be used for this diet0 = 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 validated0 = 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".