Import ingredients from CSV
Add or update many ingredients at once from a spreadsheet. Group Admins and Outlet Admins can do this.
Import your file
- Open Ingredients and click Import CSV.
- Click Download sample CSV. It has the exact column headers and an example row using your cost centres.
- Fill in one row per ingredient and save it as a CSV.
- Click Click to choose a CSV file and select it.
- Check the preview. Each row is marked New, Update or skipped with the reason.
- Click Import and check the summary.
The columns
| Column | Required | What to enter |
|---|---|---|
name | Yes | Ingredient name |
category | Yes | Such as Produce or Dairy |
cost_centre | Yes | Such as Kitchen or Bar |
supplier | No | Must match a supplier you've already added |
stock_unit | Yes | How you buy and count it, such as kg |
recipe_unit | Yes | How recipes use it, such as g |
recipe_per_stock | Yes | Recipe units in one stock unit, such as 1000 |
unit_cost | Yes | Cost per stock unit |
on_hand | No | Opening stock, in stock units |
par_min | Yes | Reorder point |
par_max | Yes | Top-up level, at least par min |