A grocery price book is a small record of purchases you repeat. Its purpose is to help you recognize comparable prices, not to prove which store is always cheapest or predict the next promotion.
Start with a few items that matter to your household. A short record you maintain is more useful than a large spreadsheet full of mismatched products.
Choose repeat purchases
Pick five to ten goods you buy regularly and can identify precisely. Record the brand or specification when it affects acceptability, along with the package quantity. Decide what counts as an acceptable substitute before comparing prices.
Keep unlike products in separate groups. Different dietary requirements, formulations, or usable quantities may make a simple price comparison inappropriate. Your book should preserve those distinctions rather than hiding them to produce one ranking.
A notebook or an ordinary local spreadsheet is enough. Do not put payment-card details or account passwords in the record.
Use one comparison unit per item
For a product sold by mass, choose ounces, pounds, grams, or kilograms and use the same basis each time. Use a volume unit for liquids when that is the relevant declared quantity, and count only for equivalent items.
NIST's unit-pricing guide explains the value of consistent units across comparable package sizes. Source: NIST, Unit Pricing Guide.
The Unit Price Comparator can normalize compatible units and multipacks. Write the chosen display unit next to the result so that a future entry uses the same basis.
Create a small original template
Use these fields:
| Field | What to record |
|---|---|
| Checked date | When you saw or paid the price |
| Item specification | The product you can actually substitute |
| Seller or location | Enough to identify the offer |
| Pack quantity | Full net quantity, including multipacks |
| Pack price | The amount and applicable conditions |
| Unit price | Price per the chosen comparable unit |
| Conditions | Coupon, membership, limit, or delivery |
| Observation | Purchased, shelf quote, or online quote |
A quote and a completed purchase are different observations. If checkout adds a fee, either record it separately or include it consistently in the comparison.
Try three hypothetical entries
The following numbers and dates are invented examples. They are not prices observed at real stores.
| Example observation | Quantity | Price | Price per ounce |
|---|---|---|---|
| Hypothetical visit A | 18 oz | $3.60 | $0.20 |
| Hypothetical visit B | 24 oz | $5.28 | $0.22 |
| Hypothetical visit C | 32 oz | $6.08 | $0.19 |
The largest pack has the lowest unit price in this example, but visit A requires the smallest checkout payment. Neither conclusion tells you whether you can use the extra quantity.
If you record a real offer, add its actual date and eligibility. Do not carry a temporary coupon price forward as if it were still available.
Turn the record into a purchasing rule
Choose a rule that fits your constraints: “Compare the price per ounce, then buy only the quantity we expect to use before the next planned shop.” You can add a comfortable basket limit or a requirement that substitutes meet the same dietary needs.
Avoid driving to another store based only on a tiny item-price gap. Include actual extra travel or delivery costs if they matter, while recognizing that a shared shopping trip can have a different cost.
Your personal record is not a market index. A handful of observations cannot show a national trend or guarantee the best future price.
Maintain it with little effort
Update an entry when you actually shop or seriously compare an offer. Keep older observations dated rather than overwriting the history. Remove products you no longer use so maintenance stays manageable.
Before buying extra, check existing stock and intended use. FDA's food-waste guidance recommends planning meals and avoiding food quantities you cannot use before spoilage. Source: FDA, How to Cut Food Waste and Maintain Food Safety.
Read Unit Pricing Explained for calculation details and When Buying in Bulk Helps for the storage decision.
Method and limits: An original recordkeeping template and hypothetical price table. No actual retailer, local price history, typical saving, food-storage duration, or future-price claim is supplied.