Updating Ingredient Prices in Bulk (Without Errors)

The reprice problem

Ingredient prices do not move gently. They move in blocks, because that is how suppliers issue them — a whole price list revised at once, usually annually or quarterly, sometimes with a mid-year fuel or packaging surcharge on top.

For a small food business this creates a specific and slightly awkward job. It is not intellectually difficult; it is just large. Four hundred ingredient records, each needing a new figure. And it is a job with an unusual property: doing it badly is invisible. If you skip fifty ingredients, nothing breaks. No alarm sounds. Your recipe costs simply become quietly, systematically too low, your margins look better than they are, and you carry on pricing off numbers that stopped being true weeks ago.

That is why the reprice is worth taking seriously as an operation, not just as data entry. It is one of the few routine tasks where the failure mode is silent.

Why doing it by hand is where errors enter

Manual repricing fails in reliably predictable ways, and it is worth naming them because each one has a different fix.

• Transcription errors. £14.50 becomes £1.450 or £145.00. A misplaced decimal on a flour sack will not look obviously wrong in a long list, but it will make one recipe's cost absurd and you may not notice which.
• Partial completion. You get through 280 of 400, are interrupted by a delivery, and come back convinced you finished. There is no marker in the data showing where you stopped.
• Arithmetic drift. Applying 6% by hand across hundreds of lines means hundreds of small roundings, some up, some down, some done in your head at the end of a long afternoon.
• Unit confusion. The supplier quotes per 16kg sack; your record is per kilo. Applying the sack price to a per-kilo record inflates that ingredient sixteen-fold, and it will only surface as a bizarre-looking recipe cost.
• No record of what you did. When something looks wrong in three weeks, you have no way to establish whether the old figure was £14.50 or £14.05, or when it changed.

A bulk edit removes the first four of these outright: one instruction, applied consistently, to a selection you can see before you commit. The fifth is what version history and price history are for.

The three ways to reprice, and when each is right

Every bulk price change is one of three operations. Choosing the right one is most of the skill.

1. Set an exact price

You replace the price with a specific figure. Use this when you have a real quoted number — a new contract price, a negotiated rate, a price list you are typing straight from. It is the most accurate option because it involves no derivation at all, and you should reach for it whenever you actually have the figures. In bulk, it is most useful when a group of items all move to the same price: a range of boxes, a set of standardised trays, a category priced at one rate.

2. Apply a percentage (±%)

You raise or lower the selection by a proportion. Use this when the change is proportional — the classic supplier-wide "all prices increase by 6% from 1 September". Percentages preserve the relative cost of expensive and cheap lines, which is what you want when the underlying driver is inflation, currency or a general cost pass-through. It is also the right tool for a seasonal uplift across a category.

The trap: percentage increases compound. Two 5% rises are not a 10% rise, they are 10.25%. Over a few years of quarterly adjustments this matters more than people expect.

3. Apply a fixed amount (±£)

You add or subtract the same sum from every item in the selection. Use this when the change is flat regardless of item value — a delivery surcharge spread across lines, a packaging levy, a fuel supplement, a per-unit handling charge. A fixed amount hits cheap lines proportionally harder than expensive ones, which is correct when the underlying cost genuinely is flat.

The trap: applying a fixed amount to a selection with very mixed values. Adding 30p to both a £1.20 herb pot and a £22 cheese wheel is a 25% rise on one and 1.4% on the other. That may be exactly right, but decide it deliberately rather than by accident.

Try the free recipe cost calculator →

Worked example: a 6% supplier rise

Here is a supplier who has raised their whole list by 6%. These are the ingredients as they appear in a small bakery's records, before and after.

What it does to recipe costs

This is the part that matters, and the part a percentage on an ingredient list does not tell you directly. A 6% rise from one supplier does not put 6% on every recipe — only on the recipes whose inputs all come from that supplier.

Two things jump out. First, the recipes that rise by the full 6% are the ones sourced entirely from that supplier — the sourdough and the brownie. The sponge, the sausage roll and the celebration cake rise by less, because part of their cost sits with a different supplier. Second, no single line here is a disaster. A percentage point of gross margin does not sink a bakery.

The danger is cumulative. Absorb four of these in a row without ever adjusting your prices and the sourdough has gone from 80% GP to roughly 75% — which, at the volumes a bakery runs, is real money. Our margin drift calculator exists precisely to show what that looks like over time.

Check your margin drift over time →

Sanity-checking after a bulk change

The instinct after a big change is either to check nothing or to check everything. Both are wrong. Check the places where being wrong is expensive.

1. Spot-check your highest-volume lines first. Flour, butter, sugar, eggs — whatever you buy every week. An error on a weekly line compounds every week; an error on something you use twice a year does not. Open five of them and confirm the new figure against the supplier's actual price list, not against your own arithmetic.
2. Check the margins on your best sellers. Cost errors become pricing errors, and pricing errors do their damage through the products you sell most of. Pull up your top five by volume and look at the gross margin before and after. If a margin has moved by an amount you cannot explain, something in the reprice is wrong.
3. Scan for implausible directions. In a rise, anything that went down is suspect. Usually it means a minus sign, or a percentage applied where a fixed amount was meant.
4. Scan for implausible magnitudes. Sort by the size of the change. Anything that moved dramatically more than the headline figure is almost always a unit mismatch.
5. Reconcile against one real invoice. The best single test available. Take the next delivery note from that supplier and check three or four lines against your records. If they agree, the reprice landed.

How bulk editing works in FoodCore

Bulk editing is available on every FoodCore plan, including Essentials at £25/month inc. VAT (£250 a year). It is not held back for higher tiers, because the businesses that most need to reprice four hundred ingredients quickly are often the smallest ones, with the least time.

What you can change in bulk

• Bulk price changes across ingredients using any of the three methods above — set an exact price, apply ±%, or apply ±£.
• Bulk supplier changes — reassign a group of ingredients to a different supplier in one go, which is what you need when you switch wholesalers.
• Bulk brand, category and unit changes — for tidying a list that has grown organically, and for fixing the unit inconsistencies that cause repricing errors in the first place.
• Bulk publish and delete on recipes — for seasonal ranges going live or coming off.

The honest detail: what happens when something is blocked

Bulk operations have a failure mode that is worth being explicit about, because most tools handle it badly. If one item in a batch of two hundred cannot be changed, what should happen? Fail the whole batch? Silently skip it?

FoodCore does neither. A recipe that is blocked because it is tied to an in-progress production run reports itself by name, and the rest of the batch still goes through. You get told exactly what did not change and why — a named recipe, not a count of failures — and the other 199 items are updated as intended.

This matters for two reasons. Practically, you are not forced to redo the whole operation because one recipe was mid-bake. More importantly, you are never left with the worst outcome in data work: an operation that appears to have succeeded while quietly skipping things. Silent partial failure is how you end up three months later with a handful of ingredients still on last year's prices and no idea which ones. The reason a recipe is protected at all is sound — a batch that is currently being produced should not have its recipe changed underneath it — and the way it is surfaced means the protection never costs you visibility.

Growth adds undo and price history

Two features on the Growth plan (£40/month inc. VAT) and above turn repricing from a one-way operation into a reviewable one:

• Version history and undo. A bulk change can be reviewed after the fact and reversed. If you applied 6% to the wrong supplier's selection, or applied it twice, you are not reconstructing four hundred old prices from an email.
• Supplier price history. You can see what an ingredient used to cost and when it moved. This is what converts individual repricing events into something useful — a view of which inputs are actually driving your cost increases, and which supplier's rises you should be challenging or shopping around.

Growth also adds the cost calculator, stock control, production runs and the production calendar. For the full picture of how costs flow through to recipes, see the recipe costing guide.

A repeatable reprice routine

1. Filter to one supplier. Never reprice across your whole ingredient list at once — you cannot verify a selection you cannot describe.
2. Check the selection before acting. Does the count look right? If the supplier lists 180 lines and your filter returns 240, something is mis-tagged.
3. Apply the rule. Percentage for proportional rises, fixed amount for flat surcharges, exact price where you have real figures.
4. Handle exceptions separately. Lines that moved differently get their own smaller selection, or individual edits.
5. Spot-check. Highest-volume ingredients, then margins on best sellers, then anything that moved oddly.
6. Reconcile against the next invoice. The only test that uses the supplier's numbers rather than yours.
7. Then review your sell prices. Separate job, done after the costs are trustworthy.

Bulk price updates: frequently asked questions

Start a 7-day free trial — no card required →

Further resources

• GOV.UK: rates and thresholds affecting business costs
• FSA: business guidance for food businesses
• Handling supplier price increases in a food business
• Food business profit margins explained
• The recipe costing guide
• FoodCore free recipe cost calculator
• FoodCore margin drift calculator