A change to any recipe in the master recipe sheet rebuilds that product's ingredient list, allergen highlights and label PDF within minutes. Packing staff always print the current label, and the quality manager keeps a dated version history for audits.
Typical results
≈4 hrs/wk
Quality team retyping time saved
100%
Labels printed from the current version
Under 5 min
To pull a label's history for an audit
Figures reflect typical results for this kind of automation.
The challenge
Recipes change often as suppliers and costs shift, and each change means retyping an ingredient list and checking allergens across the range. Labels are edited by hand in a design file, old versions linger on the packing room computer, and a swapped ingredient can reach the shelf with the wrong allergen declaration. Audits mean digging through folders.
Before and after
Time from recipe change to updated label
−99%Quality team time on label edits per week
−80%Label mismatches found in internal checks per quarter
−100%The automation
When an ingredient or quantity changes in the master recipe sheet, the automation rebuilds the product's ingredient list in descending order of weight with allergens in bold, and updates the allergen matrix for the whole range. A new label PDF with product name, net weight, shelf life and a batch-code field is saved to the shared folder the label printer uses. The old version moves to an archive with its change date, so packing staff only see the current file.
How it works
- 01
Recipe change saved
An ingredient or quantity change in the master recipe sheet starts the update.
- 02
Ingredient list rebuilt
Ingredients are sorted by weight in descending order, with allergens shown in bold.
- 03
Allergen matrix updated
The matrix for the whole range is refreshed from the same ingredient flags.
- 04
New label PDF
A label with product name, net weight, shelf life and a batch-code field replaces the file the printer uses.
- 05
Old version archived
The previous label moves to the archive with its change date, ready for audits.
Starts from
- Master recipe sheet
Delivers
- New label PDF for printer
- Updated allergen matrix
- Archived old version
The impact
Labels match the recipe within 10 minutes of a change, and the packing room can only print the current version. Retyping ingredient lists stops, which saves the quality team about 4 hours a week, and audit requests are answered from a dated version history in minutes.
Questions about this automation
How does it know which ingredients are allergens?
Each ingredient row in the master sheet carries allergen flags, set once by the quality manager, such as gluten, milk, egg, nuts or sesame. When a recipe uses that ingredient, the flags carry through to the ingredient list in bold and into the allergen matrix, so the label never depends on someone remembering.
Does it change how labels are printed?
No. The printer keeps printing from the same shared folder, and the automation replaces the file there with the new version. The batch-code field stays blank on the PDF, so packing staff or the printer software fill it at print time, the same way they do today.
What does the quality manager set up first?
A master recipe sheet with ingredients, weights and allergen flags, plus the current label layout. Simple automations like this are usually live within days, and the first run rebuilds every label in the range so the quality manager can check each one against its recipe a single time.