Grocery price book: track prices once, know a real sale forever

Buying strategy · 9 min read · Published Oct 21, 2026

Every grocery shopper carries a feeling about prices: chicken "seems expensive", the big coffee tin "looks like a deal". Feelings are how stores win. A shelf tag can shout SALE over a price that is higher than last month's regular price, and a package can quietly shrink while its price holds still, so the "same" item costs more per bite with no visible change at all. A price book replaces the feeling with a lookup. It is a small, personal record of what you actually paid for the items you actually buy, kept in the one form that cannot be fooled: price per unit. This guide builds one as a decision tool — with a target price for every staple and a rule for how much to buy — on a maintenance budget of about fifteen minutes a week, because the best system is the one still running in three months.

What goes in the book (and what does not)

Start smaller than your ambition. The classic format is a page per item or category in a notebook, a column for each store, filled in from receipts after each shop — and the digital version is the same grid in a spreadsheet on your phone. Either way, five fields per entry earn their space:

• Item and brand — specific enough to match next time ("cheddar block, store brand"), because brand is part of the price.
• Package size — non-negotiable. Manufacturers can shrink packages without warning, and a price history without sizes will swear nothing changed while the unit cost climbed.
• Price paid and date — the date is what turns a list into a calendar, as the sale-cycle section shows.
• Store — prices are per store, not per item; the same basket is two different bills at two chains.
• Unit price — the only number you compare. Everything else is bookkeeping for this column.

Cover the ten to twenty items you buy every week or two — the staples that make up most of your bill — and add a few products each shop rather than attempting a census of the store. Price-book keepers who try to record everything quit; keepers who record their twenty staples build, within a couple of months, a reference no flyer can argue with. Keep the book where the decisions happen: in the bag, or synced to the phone in your pocket at the shelf.

Unit price: the column that survives shrinkflation

Unit price is the total price divided by the measure — grams, millilitres, count. The worked example from a long-running price-book guide makes the arithmetic plain: a block of cheese at $5 for 32 ounces is $5 ÷ 32, about 15.6 cents per ounce. Compare that figure, never the sticker, and two things become visible. First, the bigger package is not automatically the better buy; sometimes the mid-size wins per ounce, which is the entire trap of bulk pricing. Second, shrinkflation stops being invisible: when the 500-gram box becomes 450 grams at the same price, the sticker history says "no change" while the unit price rises by a ninth — and your book says so.

In a spreadsheet the column maintains itself: price in one column, amount in the next, and a formula dividing the first by the second (scaled per 100 grams or per litre, if that reads more easily). Update the price when it changes and the unit price recalculates. On paper, do the division once per entry with the phone calculator; it takes seconds and it is the whole game.

The target price: the decision the book exists for (decision framework)

After a few months of entries, each staple shows three prices: its usual price, its sale price, and the lowest unit price you have actually paid. That lowest honest figure becomes the staple's target price, and it splits every future sighting into two actions:

• At or below target: stock up — buy the sale-cycle quantity from the next section, storage permitting.
• Above target: buy only what the week needs, or nothing if the pantry can cover it. A "sale" priced above your target is not a sale for you, whatever the tag says.

Two refinements keep the framework honest. Refresh targets seasonally, because produce and baking staples genuinely move with the calendar, and a target set in strawberry season will never fire in January. And pair the book with store rotation rather than store pilgrimages: when you are already near the store where pasta is cheapest, buy a few weeks' worth there; buy the sauce where it is cheap on a different trip. The book tells you where each staple's target lives; your normal routes do the rest, with no special trips burning the savings in fuel.

Sale cycles set the quantity (tested procedure)

1. Log every shop from the receipt the same day — date, store, size, price — while it takes two minutes, not twenty.
2. After six to eight weeks, read the dates. Dated entries reveal how often each staple's sale recurs; that interval is its sale cycle.
3. Set the stock-up quantity: weekly use multiplied by the cycle length, capped by what your storage and the product's life honestly allow. Enough to reach the next sale — not a bunker.
4. At the shelf, compare unit price to target and act on the framework: stock up at target, bridge-buy above it.
5. Review monthly in the same fifteen minutes: retire items you stopped buying, promote new regulars, refresh stale targets. A price book only pays if it stays current and gets used to plan trips — that single warning appears in every durable guide to the method, because it is the difference between a book and a souvenir.

What success looks like: a flyer lands and, instead of wondering, you know — this price beats your target on two items, matches it on none, and the rest is theatre. Your stock-ups land at the lowest unit prices of the season, your pantry carries you between sales, and the weekly bill falls without a single coupon touching it.

FAQ

Paper or app? Whichever you will still be using in three months. Paper lives in the shopping bag and never needs charging; a spreadsheet computes unit prices for you and syncs between phone and computer, with offline access for in-store checks. The fields matter, not the medium.

How many items should I track? Ten to twenty true staples to start, added a few per shop. The staples dominate the bill; the exotic item you buy twice a year cannot repay the effort of tracking it.

My store prints unit prices on shelf tags. Do I still need the book? The tag gives you today's comparison in that store. The book adds the two things a tag cannot: your other stores, and time — what this item cost at its best, and when that price is likely to return.

A boundary worth stating: the price book governs staples, not treats, gifts, or one-off ingredients for a special meal. Buy the birthday cake ingredient at the price on the day; the book's authority covers the twenty items whose repeated purchase actually compounds. Keeping that boundary is part of what makes the fifteen-minute habit sustainable — the book stays a sharp tool for the spending that repeats, instead of homework about every dollar that moves.

Back to all guides →