Production Planning for Artisan Confectioners: Batches, Lot Numbers & Order Tracking
A tool-agnostic playbook for planning confectionery production: batch records, lot number conventions, EU traceability (one-step-up / one-step-down), linking batches to customer orders, FIFO for perishables, and the KPIs worth measuring.
Why Organized Production Planning Matters
Running a confectionery production kitchen on memory and sticky notes works—until it does not. A missed customer order, an ingredient shortage on production day, or a quality complaint you cannot trace back to a specific batch can damage both customer relationships and your food safety standing. Organized production planning turns reactive firefighting into a predictable, documented process.
For artisan and small-scale professional confectioners, formal production planning bridges the gap between recipe development and day-to-day operations. The core artifact is a production batch record — anchored to a saved recipe, scaled to a target yield, scheduled for a date, and tied (optionally) to a customer order. Whether you keep these records in a spreadsheet, a kanban board, dedicated batch-tracking software, or a notebook with carefully numbered pages, the discipline of structured batch records produces the same dividends: reproducible quality, complete traceability, and minimum-waste purchasing.
Three Core Reasons to Formalize Production Planning
Quality consistency: documented batch parameters (temperature, timing, yield) let you reproduce successful batches exactly and diagnose deviations. Customer commitments: linking batches to orders prevents double-booking your production capacity and ensures every order has a planned batch behind it. Cost control: knowing exactly what each batch consumes in ingredients lets you purchase precisely, reducing waste and preventing over-stocking of perishables like cream and fresh fruit.
What a Good Production Batch Record Contains
A production batch is a planned run of one specific recipe at one specific scale. Every batch should be anchored to a saved, validated recipe — never an ad-hoc formula scribbled on the day of production. Once you have the recipe, six fields cover everything else you need to schedule, execute, and trace the batch later.
Linked recipe (mandatory)
Every batch references a specific, version-controlled recipe in your recipe library. The recipe is the source of ingredient proportions, water activity, shelf-life prediction, and any food-safety parameters. If your recipe is still being refined, freeze the version you plan to produce before opening a batch record against it. Producing from a draft formula breaks reproducibility.
Target batch size
Set your target output in grams or kilograms (e.g., 2 kg of ganache filling). Scale every ingredient quantity proportionally from the recipe's reference formulation. The resulting ingredient list becomes your shopping and prep checklist for this specific batch — and your basis for theoretical-yield calculation later.
Production date (and optional deadline)
Choose the calendar date the batch will physically be produced. If the batch is tied to a customer order with a delivery commitment, also record the deadline date. A production calendar (spreadsheet, wall chart, or planner) keyed on this date is what makes capacity conflicts visible before they bite.
Linked customer order (optional)
If you already know which customer order this batch is for, link it now. You can also leave it open and assign later — for example, when you are reserving capacity in advance of confirmed orders.
Lot number (assign before cooking)
Pre-assign the lot number when you create the batch, not after production. Write it on the prep tray, the mixing bowl, the cooking pan, and every packaging label that will leave the kitchen. See the lot-number format section below.
Status field (Planned → In Progress → Completed)
Every batch lives in one of three explicit states. Keep this field updated in real time during the production session. Retrospective batch-bookkeeping destroys the data.
Print the Scaled Ingredient List Before Cooking
Whatever tool you use to record the batch, the prep stage benefits enormously from a printed (or tablet-displayed) ingredient checklist scaled to the batch size — quantities, units, and a checkbox per ingredient. Distribute it to whoever is in the kitchen before production day. Pre-confirmed mise en place eliminates the mid-batch "wait, did we weigh the cream?" delay and dramatically reduces ingredient-substitution errors.
Production Status Workflow: Planned, In Progress, Completed
Every production batch moves through three status stages. Keeping these statuses accurate is the single most important discipline for maintaining a reliable production history. Status updates take seconds but provide data that is invaluable for capacity planning, customer communication, and quality audit.
| Status | When to Apply | What It Unlocks | Key Action |
|---|---|---|---|
| Planned | Batch created, not yet started | Appears in production calendar; blocks ingredient capacity from being double-counted | Edit freely: date, size, linked order |
| In Progress | Production has physically started | Locks recipe link and batch size; enables production note entry | Add lot number, record actual start time |
| Completed | Batch finished, yield measured and verified | Records actual yield vs. theoretical; updates finished-product stock count (if tracked) | Enter actual yield, final notes, quality flag |
Production batch status stages, triggers, and resulting actions
Status Discipline: Update in Real Time, Not Retrospectively
Changing a batch to In Progress at the start of production and to Completed at the end sounds obvious, but many producers batch-update statuses weekly or monthly. Retrospective updates destroy the value of the production calendar for scheduling and eliminate your ability to accurately track what is currently being produced. Make status updates a physical habit: change the status on your phone or kitchen tablet as you start and finish each batch.
Adding Production Notes and Lot Numbers
Production notes are the narrative record of what actually happened during a batch, as opposed to what was planned. They are your primary tool for continuous improvement and for traceability in the event of a quality complaint or product recall. Two fields in particular are essential: the lot number and the actual yield.
Lot Numbers and Traceability
A lot number (also called a batch number) is a unique identifier assigned to every production run. It connects the finished product on the shelf—or in a customer's box—back to the specific production batch, the ingredients used, and the date of manufacture. Without lot numbers, you cannot conduct a targeted recall: you must recall everything.
Recommended Lot Number Format
Use a date-based prefix followed by a sequential counter for the day: YYYYMMDD-NNN (e.g., 20260219-001, 20260219-002) This format is human-readable, sorts chronologically in any system, and immediately tells you when a product was made. For businesses with multiple product categories, add a product code prefix: GAN-20260219-001 (ganache), CAR-20260219-001 (caramel) Avoid lot number schemes that use only sequential numbers (batch 1, batch 2) without a date component—after two years and thousands of batches, these become impossible to interpret without a separate log.
Record the lot number in your batch notes the moment you change status to In Progress. This is also the right moment to record which specific ingredient lot numbers you are using if your supplier provides them — high-quality chocolate and nut suppliers typically print lot codes on packaging. Linking your batch lot number to upstream supplier lot numbers gives you complete upstream traceability: if a supplier issues a recall on a specific couverture lot, you can immediately identify which of your batches used it, and which customer orders those batches fulfilled.
Recording Actual Yield vs. Theoretical Yield
Theoretical yield is the output the recipe predicts based on input weights. Actual yield is what you weigh at the end of production after evaporation, trimming, and handling losses. The difference between these two numbers—tracked over many batches—is one of the most actionable data points in production management.
A batch that consistently yields 4% less than theory may indicate an equipment calibration issue, a process deviation, or simply that your recipe's theoretical yield is incorrectly modeled. Either way, the trend is invisible without a record. When you close out a batch, weigh and record actual yield in grams or kilograms next to the theoretical figure. Compute yield efficiency as a percentage (actual / theoretical × 100). Over time, the rolling average of yield efficiency per recipe is one of the most diagnostic numbers in your operation.
Notes Worth Recording for Every Batch
Beyond lot number and yield, the following notes take less than two minutes to enter and create significant value over time: - Temperature deviations: oven ran 5°C hot; cream reached 95°C instead of 85°C - Substitutions: used glucose DE42 instead of DE60; replaced cream with a different fat content - Timing changes: extended cooking by 3 minutes due to slow crystallisation - Quality observations: surface texture slightly grainy; truffle centres softer than usual - Issues encountered: tempering machine needed reseeding mid-batch; one tray rejected These observations, linked to a lot number, turn a quality complaint six weeks later into a diagnosable event rather than a mystery.
Linking Production Batches to Customer Orders
Customer order management and production planning are two sides of the same coin. When you receive an order for 200 truffles for delivery on 28 February, you need to plan or assign a production batch that will produce enough units in time. The connection between orders and batches is what lets you know — at any moment — whether your kitchen's commitments and capacity are in balance.
Capture the customer order in writing
Record customer name, requested products, quantities, delivery date, and any allergen or labelling requirements. Each line item should specify a product (linked to a specific recipe) and a quantity in units. Verbal orders are a recipe for double-booking or forgotten deliveries — write everything down at the moment the order is taken.
Assign a production batch to each order line
For each product line in the order, link an existing planned batch or schedule a new one. Make explicit how many units the linked batch is expected to produce versus how many are required by the order — the gap tells you immediately whether a second batch is needed.
Track committed vs. available units
Maintain a running view of committed units (allocated to specific orders) versus available units (finished product not yet committed). The view prevents you from selling the same product twice or accepting an order when production capacity is already full for the date window.
Mark orders as fulfilled when shipped or collected
When the customer receives their order, update the order status to Fulfilled and record the lot numbers of the batches that supplied it. This closes the loop — giving you a permanent chain from order to production run to ingredient lot.
One Batch Can Fulfill Multiple Orders
A 2 kg ganache batch yielding ~160 truffles might supply 80 to one customer and 80 to another. Split the output of a single batch across multiple orders explicitly in your records, and ensure each order records the lot number of the supplying batch. Traceability is preserved even when batch output is divided — which is the common case for wholesale and event work.
Traceability: Why Lot Numbers Matter Beyond Compliance
Food traceability is often framed as a regulatory requirement—and it is, under EU Regulation (EC) No 178/2002 and equivalent national food law frameworks. But for small confectionery producers, the practical value of traceability goes beyond compliance. It is your first line of defence when something goes wrong.
Consider two scenarios. In the first, a customer contacts you 20 days after purchase to report that their box of truffles developed white surface bloom. Without lot numbers, you can only apologize and guess. With a lot number linked to the production batch, you can check that batch's production notes: was tempering completed correctly? Did the chocolates experience a temperature excursion during storage? Which supplier's couverture did that batch use? You can answer the complaint with specifics rather than speculation.
In the second scenario, your couverture supplier issues a recall for a specific lot of chocolate due to undeclared hazelnut contamination. With lot-number-linked production records, you can identify within minutes which of your production batches used the affected ingredient lot, which customer orders those batches fulfilled, and which customers need to be notified. Without these records, you must recall everything produced in the relevant period—a far more expensive and reputationally damaging outcome.
The One-Step-Up, One-Step-Down Rule
EU food law requires producers to be able to identify, for any finished product: (a) what ingredients went into it and from which suppliers, and (b) to whom it was sold or distributed. This is called one-step-up (upstream supplier traceability) and one-step-down (downstream customer traceability). Your lot number system, linked to production notes and order records, fulfills both requirements with minimal administrative burden.
Planning Multiple Batches: Calendar View and Conflict Prevention
Producing a single product on a quiet day is straightforward. Producing six different products across a busy week — each with different lead times, ingredient orders, and customer deadlines — requires a production calendar. The format can be a wall planner, a Google Calendar with one event per batch, a Trello board, or a spreadsheet — the medium is less important than the views it supports.
- Date view: see all batches scheduled for a specific day, with estimated production time and ingredient loads
- Week view: identify days where production is overloaded or underutilized for better leveling
- Deadline flags: batches linked to orders with approaching delivery dates highlighted (color-coding works well)
- Status overlay: plan-vs-actual comparison — how many planned batches are still in progress or unstarted on each date
- Recipe filters: view only ganache batches, or only caramel batches, to plan equipment-specific capacity (matters when one piece of equipment is a bottleneck)
Conflict prevention in small kitchens is primarily about equipment availability and human capacity, not ingredient availability. Two recipes that both require the depositor for two hours cannot both be scheduled for the same two-hour window. The calendar makes these overlaps visible before they become problems. As a rule of thumb, never schedule more than 75–80% of your available production hours on any given day—leave buffer for setup, cleaning, and unexpected delays.
Account for the Full Production Lead Time, Not Just Cooking Time
A ganache batch might take 45 minutes to cook and pour, but requires 12–24 hours of crystallisation time before enrobing, then another 2 hours for enrobing and finishing, followed by 24 hours of resting before packaging. The total production lead time is 38–50 hours from first cook to packaged product. Schedule batches with this full timeline in mind, not just the active cooking session.
Calculating Ingredient Needs Across Multiple Batches for Purchasing
One of the most practical outputs of a production planning system — whether it's a spreadsheet pivot table, a printed batch sheet, or a feature in production software — is aggregating ingredient requirements across multiple planned batches into a single purchasing list. The goal is to replace the error-prone act of opening each batch and summing quantities by hand.
For example, if you have six batches planned for the coming week—two ganache batches, two caramel batches, and two pâte de fruit batches—the ingredient report sums all requirements by ingredient. Rather than 400 g of cream for batch one and 350 g for batch three, you see a single line: 750 g cream. This is the number you take to your supplier or use to check your current stock.
Building a Weekly Ingredient Report
Regardless of tool, a weekly consolidated ingredient list needs four things:
1. Date range filter — typically the upcoming production week
2. Status filter — Planned batches only (don't include In-Progress or Completed batches, their ingredients are already committed)
3. Aggregation by ingredient — sum quantities of the same ingredient across all batches, in the same unit
4. Drill-down — for each ingredient line, the list of contributing batches and their share of the total
In a spreadsheet this is a pivot table on batch_id × ingredient with quantities as the value field. Run the report 3–4 days before your planned production week to leave time for ordering and delivery.
When purchasing for multiple batches, apply the FIFO (first in, first out) principle to perishable ingredients. Cream, fresh fruit purée, and eggs purchased for Monday's batch should be consumed before stock purchased for Friday's batch. Rotate stock physically so older items are at the front of the refrigerator. For shelf-stable ingredients like glucose syrup and couverture, check existing stock before ordering—a consolidated ingredient report will show you a 2 kg couverture requirement, but if you already have 800 g in storage, you only need to order 1.2 kg.
| Ingredient Category | Typical Storage Life | FIFO Priority | Notes |
|---|---|---|---|
| Fresh cream (35% fat) | 5–8 days refrigerated | Critical | Order as close to production date as possible |
| Fresh fruit purée (thawed) | 3–5 days refrigerated | Critical | Buy frozen; thaw only what you need |
| Eggs | 21–28 days refrigerated | High | Check use-by date; use oldest stock first |
| Butter | 30–60 days refrigerated | High | Can be frozen for longer storage |
| Glucose syrup | 12–18 months sealed | Low | Shelf-stable; rotate open containers |
| Invert sugar / trimoline | 12 months sealed | Low | Keep at room temperature, tightly sealed |
| Couverture (chocolate) | 12–18 months if stored correctly | Low | 15–18°C, 50–60% humidity, away from odours |
| Fruit pectin / gelatin | 24 months | Very low | Store dry; inspect for moisture exposure |
Ingredient storage life and FIFO priority by category
Best Practices for Production Planning
The following practices are drawn from the operational patterns of small-scale professional confectionery producers who run consistent, high-quality production with minimal administrative overhead. None of them require complex systems—they require consistent habits.
- Use a consistent batch naming convention: Recipe code + date + sequence (e.g., DKG-20260219-001 for Dark Ganache batch 1 on 19 February 2026). Names that follow a pattern are searchable and sortable; ad-hoc names are not.
- Assign lot numbers before you start cooking, not after: Write the lot number on a label and stick it to the mixing bowl or pan before production begins. If something goes wrong mid-batch, you have already identified it.
- Update batch status before leaving the kitchen: Make it a non-negotiable end-of-session habit. A batch that was Completed today but not updated until tomorrow introduces inaccuracies into your production history.
- Record actual yield for every batch, even perfect ones: Yield data is only useful as a trend. A single measurement tells you nothing; twelve measurements reveal whether yield is stable, improving, or declining.
- Keep production notes brief but specific: Three bullet points with precise numbers are more useful than a paragraph of vague impressions. 'Cream heated to 93°C; enrobing at 31.5°C; 47 truffles produced' is a useful record. 'Batch went well, slight issue with tempering' is not.
- Review the previous week's batch history before planning the next week: Look for recurring yield issues, deviations that affected multiple batches, or patterns that indicate an equipment or process problem. Weekly review takes 10 minutes and often catches problems before they escalate.
Plan Batch Sizes as Multiples of Your Standard Recipe
If your standard recipe produces 500 g of ganache, plan batches in multiples: 500 g, 1 kg, 1.5 kg, 2 kg. This simplifies mental math when scaling, reduces the risk of scaling errors, and makes it easy to recognize when a batch is an unusual size. Avoid batch sizes like 780 g that do not follow a clear pattern—they are harder to reproduce accurately and are a common source of scaling errors.
Using Batch History for Quality Control
Cumulative production history is more valuable than any individual batch record. Over time, your archive of completed batches becomes a searchable database of production performance: yield trends by recipe, seasonal patterns in production efficiency, and correlations between specific production conditions and quality outcomes. Whether the records live in a folder of printed batch sheets, a shared spreadsheet, or production software, the discipline of keeping every completed batch on file is what makes pattern-recognition possible.
If a recipe's average yield drops from 96% to 90% over three months, the production history makes this trend visible. If every batch produced on humid summer days records a quality note about soft texture, the seasonal pattern becomes apparent. If batches using one supplier's couverture consistently produce better bloom resistance than another's, the data supports a sourcing decision. These insights are invisible without records and obvious with them.
Quick-Reference Production Planning Checklist
- Create production batches linked to saved recipes—never to ad-hoc formulas
- Set production dates and customer order deadlines before the production week begins
- Generate a consolidated ingredient list 3–4 days in advance and check against existing stock
- Apply FIFO to perishables: use oldest stock first, rotate refrigerator and dry storage
- Assign lot numbers before production begins—not after
- Update batch status to In Progress at the start of production and to Completed at the end
- Record actual yield for every batch and compare to theoretical yield
- Note any deviations, substitutions, or quality observations in the production notes
- Link completed batches to customer orders and mark orders as Fulfilled when shipped
- Review the previous week's batch history every Monday before planning the new week
Frequently Asked Questions
How to Calculate the Real Cost of Your Recipes
Ingredient pricing, yield loss accounting, food cost percentage, and break-even analysis for confectionery producers.
Maximising Confectionery Shelf Life
Practical strategies to extend shelf life through formulation, packaging choices, and storage conditions.
Related Topics
Related Articles
Scaling Recipes for Production: From Lab Batch to Commercial Run
A practical guide to scaling confectionery recipes from 500 g test batches to 50 kg production runs. Covers what scales linearly, what does not, equipment planning, and process parameter adjustment.
Exporting Professional PDF Data Sheets from Formul.io
Learn how to generate professional PDF data sheets from Formul.io for client sharing, production documentation, allergen declaration, and food safety certification preparation.
How to Use Ingredient Substitution Suggestions in Formul.io
Learn how to use Formul.io's substitution feature to adapt recipes for allergen restrictions, ingredient unavailability, and cost optimization — with instant metric impact previews.