If you’re sending the template sheet to your suppliers for them to complete, please ensure that they only list the food and/or drinks they provide you with, omitting any non-food items.
How to import ingredients
Once you have a complete ingredient data sheet:
- Save the file as a .CSV file.
- Go to the import screen via one of the following methods:
- Click the Ingredients drop down menu (shown in the screenshot above) and click ‘Import’.
- On the Ingredients list screen, click the ‘Import ingredients’ button (top right of the screen).
- Follow the instructions on screen.
- ‘Import to’ field: Ingredients will be imported to your business ingredients list by default but if you’ve created your own lists you can import ingredients into these as well.
- Click ‘Upload and continue…’
- The next screen will show a preview of your data sheet. Click ‘Dummy run’ to get an idea of what will be imported. If you see that some records will be updated, this means that those ingredients may already exist in the system. For more help on this see the next section.
- To go ahead with the upload click ‘Run the full import’.
- You’ll get a confirmation message saying that the import is complete and your new ingredients will be ready to use in your recipes!
Updating existing ingredients using the import feature
When importing ingredients in Kafoodle Kitchen it’s possible that ingredients on your data sheet may already exist in your system. During the import, ingredients are deemed identical if the product name, supplier name, and supplier product code match. If this occurs, the information for the ingredient on the data sheet will overwrite the information for that ingredient in your system, even if it’s locked. Any conversions you’ve made for the ingredient will be preserved after any updates made during an import.
Please note: if you update nutritional values for an ingredient, the new values will not take effect in the recipes which use that ingredient. To update the nutritional values for a recipe which uses the updated ingredient, go to the recipe edit screen and on the ‘Ingredients and Allergens’ tab click ‘Recalculate’ to pull in the updated nutritional values. If a recipe uses a sub-recipe that has an updated ingredient, you must use the recalculate feature to update the sub-recipe nutritional values first, then recalculate for the main recipe.
When suppliers provide you with ingredient data you might come across a range of values for allergens, instead of the standard ‘Yes’ or ‘No’ values. The same goes for nutrition – you might run into all kinds of number formats and symbols which are not supported in Kafoodle Kitchen.
Since there is no common practice across different suppliers for allergen and nutrition data, we’ve built in a number of conversions for the most common values we’ve encountered so that importing ingredients is a much smoother process. See the tables below for how different values are handled.
Allergen data conversions
|Value||Conversion / Action|
|Present on site||Yes|
|Stored on site||Yes|
|Does not contain||No|
|Blank/empty cell||Invalid – upload will fail|
Note: any other values in the allergen columns will be ignored.
Nutrition data conversions
|Value||Conversion / Action|
|Values containing “-” e.g. “2-4”||The higher end value will be used|
|Values containing “%”||Invalid – upload will fail|
|N/A||The value will be deleted|
|Values containing “,” (commas)||Decimal points “.” will be used|
|Values containing “<” e.g. “<0.5”||The specified value will be used|