Importing ingredients with the Horeko Excel import template

If we don’t have an automatic link to a supplier, you can use our Excel import template. You can fill it in yourself or ask your supplier to do it. 

Filling in the file

The first five columns must be filled in to import:

1. Artikelnummer (Item number)
   You can enter a fictitious item number if you don’t have an actual one yet. Make sure that this number does not match any other ingredient item numbers in the database.
2. Naam (Name)
3. Inhoud (Content)
   There are two ways to fill this in:
   Either by filling in one quantity, e.g. 500 for 500 grams of cheese. This is imported as 1x500 grams.
   Or you can import two quantities, e.g. 10x250 in the case of 10x250 millilitres of milk, which is imported as 10x250 millilitres.
4. Eenheid (Unit)
   You can choose between three units: kilos, litres, and pieces. For kilos and litres, you can also use grams, millilitres and centilitres.
5. Aanschafprijs exclusief BTW (Retail price excluding VAT)
   The other columns are optional.
   In the allergens columns, you can fill in the following four options:
   - Bevat (Contains)
   - Bevat niet (Does not contain)
   - Bevat mogelijk (May contain)
   - Onbekend (Not known)

If you don’t fill in anything, it will be categorised as Onbekend (Not known).

If you want to import the nutritional value, enter the nutritional value per 100 grams.

Importing

Save the completed file.

Add the supplier: Go to Manage (Kitchen) -> Suppliers -> Click + Add. You only need to fill in the name. All other information is optional.

Go to Importing -> Select the supplier -> Click Browse -> Upload the correct file ->

Click Start import.

Results

Once the import is complete, you can click View results to view the import results. This shows which ingredients have been imported/updated, which have remained unchanged and whether there are any ingredients that have not been recognised.

Under the Changed recipes tab, you can see what has changed in terms of cost and margin per recipe.

If you click Unrecognised import items, you can see which items could not be imported by supplier. If the usable quantity or unit is not filled in correctly, you can double-click an item to enter the correct values and import the ingredient.

The ingredients are now in your database!

Exporting as an import template

If you want to update or add to this supplier’s ingredients later on, you can easily export them in the import template.

Go to Ingredients-> Click Export -> Click Select a report -> Select Import template -> Select the supplier -> Click Select -> Click Export -> Select Excel. The file will then be downloaded, and you can make any necessary adjustments and then import it again.

By using this export, you ensure that you are using the same item numbers, as this will overwrite any data changed.

The price history of ingredients is saved and can be found in an ingredient under the History tab.

We recommend that you keep an eye on price changes from the suppliers you use this import method for and update them in Horeko if there are any changes. This keeps your margins up to date and allows you to take any action needed in good time.