How to Turn a Weekly Menu Into a Shopping List (Without Manual Math)

June 10, 2026 · 6 min read

The shopping list is the single most valuable — and most error-prone — document in a meal-prep week. Get it right and prep runs smooth; get it wrong and you're either short mid-cook or over-stocked in the walk-in. Here's exactly how a weekly menu becomes an accurate purchase list.

Step 1 — Scale every recipe to its production quantity

A recipe tells you what one batch needs. Multiply each ingredient by how many you're producing. If a bowl uses 8 oz of chicken and you're making 120, that's 960 oz of chicken from that meal alone.

Step 2 — Aggregate shared ingredients across the menu

Chicken probably shows up in three different meals. The shopping list doesn't care which recipe it came from — it needs the total. So you sum every appearance of each ingredient across the whole menu:

This is the step spreadsheets fumble, because the same ingredient lives in different tabs and different units. Miss one appearance and you under-buy.

Step 3 — Convert to purchase units

You buy chicken by the pound, not the ounce; oil by the gallon, not the tablespoon. Every aggregated total has to be converted into the unit you actually order in. Weight-to-weight and volume-to-volume are straightforward; converting volume to weight (a cup of one thing weighs differently than a cup of another) needs the ingredient's density, which is where manual lists tend to hand-wave.

Step 4 — Subtract what's already on hand

If you have 12 lb of chicken in the walk-in, you don't need to buy 87.5 — you need 75.5. Netting the required amount against inventory is the difference between buying what the week needs and buying the whole list again. Never let this number go negative: if you already have more than enough, the buy quantity is zero.

Step 5 — Group by supplier and price it

Finally, organize the list by supplier so each order is ready to send, and attach an estimated cost per line so you can see the week's spend before you commit. Grouping by supplier also surfaces when it's worth consolidating orders to hit minimums or cut delivery fees.

Why doing this by hand is so costly

Each of these five steps is simple. Doing all of them, for every ingredient, every week, without a mistake — that's the hard part. A single missed conversion or forgotten on-hand quantity shows up as either a frantic store run or product rotting in the walk-in. Both cost money; the second one costs margin you never see.

A good shopping list is just arithmetic done consistently. The value isn't the formula — it's never getting it wrong on a Sunday night.

Figures in this article are illustrative examples — your ingredient costs, yields, and margins will vary. Use your own numbers when you plan.