Products: Import Recipes (Products, Ingredients and Recipe Cards)

Import recipes from a flat sheet or a costing workbook, link each to its master product, review and create the ingredients it needs, and import sub-recipes.

Import recipes with their products and ingredients

Products > Recipes > the more menu > Import recipes (admins). The same import is on the Products table menu. It takes two kinds of file and walks through four steps: File, Columns (or Recipes found), Ingredients, Preview.

Two kinds of file

  • A flat sheet: one ingredient line per row, with a recipe name on each line (a blank recipe cell continues the recipe above). Download the template for the full column set: Recipe name, Ingredient, Ingredient code, Quantity (g or kg), Characterising, Cook yield, Sub-recipe, Master product, Product SKU, Product barcode, Units per batch, Grams of recipe per unit, Ingredient cost per kg, Ingredient supplier, Ingredient allergens. Any column layout works: you match the columns on the next step, and Match with AI can match the ones it does not know.

  • A costing workbook: one sheet per menu item, laid out as a card with an Ingredient, Cost per kilo and Weight header. The first block on each sheet is the finished recipe, named after the sheet (sizes and yields in the sheet name are read, not kept in the name). Every other block beside or below it is a component, imported as a sub-recipe. The Recipes found step lists every block per sheet: untick anything that is not a recipe, name components that had no title (a name is suggested from the finished recipe's line that uses it, and Suggest names with AI can help), and choose what to do when the same component appears with different proportions on two sheets. The same component with the same proportions is imported once.

The Ingredients review

Nothing is saved until the end. Every ingredient the file uses is sorted into one of these:

  • Matched: an exact match on item code, name or a remembered spelling, in your list or the Superfood library. Nothing to decide.

  • Suggested: close to an ingredient you already have (the same words in another order, a plural, or one letter different in a longer word). Use existing is preselected, and the file's spelling is remembered on that ingredient so the next import matches it on its own. You can create a new ingredient or skip those lines instead.

  • New: nothing matches. Each is created with the name, code, cost per kilo, supplier and allergens from the file, all editable here. Untick a row to skip its lines. Tidy names with AI offers tidier spellings as suggestions you can edit.

  • Recipes in this file: lines that name another recipe in the file become sub-recipe lines, never ingredients.

New ingredients start with no nutrition. Add it on the Ingredients page afterwards so the recipes calculate.

Master products

A recipe with a Master product, Product SKU or Product barcode links to that product, matched by SKU, then barcode, then name (a trailing pack size like 600g is ignored). In a costing workbook, finished recipes link to the product of the same name. Grams of recipe in one unit come from the first of these that applies: the file's Grams of recipe per unit; the batch divided by Units per batch (a costing card costed per item counts as one unit unless its title says otherwise, for example yield 8 serves or (20 pcs)); the product's own unit size when this will be its only recipe; otherwise the whole batch, flagged for you to set on the product's Bill of materials tab. Products the file names but you do not have can be created from the switch on the review step. A product's other recipe links are kept unless you turn on Replace a product's existing recipe links.

Costs

Cost per kilo from the file fills ingredients that have no cost yet. Turn on Update cost per kilo on matched ingredients to overwrite the ones that already have one. The Superfood library is never changed.

Re-imports

Recipes match by name. A recipe already in your list keeps its id and gets the file's lines, so importing the same file twice is safe. Sub-recipes import before the recipes that use them.

Linking recipes from the product import

The product import has two new columns: Recipe and Recipe grams per unit. They link a product to a recipe already in Products > Recipes (the product import never creates recipes). Without grams per unit the link uses the recipe's whole batch and says so.

v13.84