Merchandising Field guide

Pricebook hygiene: keeping a c-store pricebook clean and profitable

A routine for a clean c-store pricebook: UPCs, departments, costs, margins, store prices, promotions, shelf tags and the weekly checks that matter.

By the CornerHawk team Published 6 min read

Yellow and white price tags on the shelf edge under boxes of crackers

Your pricebook is the most important file in your store, and probably the most neglected. Every sale, every margin report, every scan data file, every reorder and every shelf tag starts there. When it’s messy, everything downstream is a little bit wrong, and nobody knows by how much.

The good news: a clean pricebook isn’t a big project. It’s a short weekly routine and a few rules everyone follows.

What “clean” means

A clean pricebook has:

  • One item per product. No duplicates under different barcodes or descriptions.
  • Correct barcodes. The UPC the register scans matches the product on the shelf.
  • The right department on every item, so taxes, age limits and reports are right.
  • Current costs that match your last invoice.
  • Retail prices you chose on purpose, with margin in a range you expect.
  • Shelf tags that match the register.
  • Settings that matter: tax, minimum age, EBT, tracked inventory, manufacturer for tobacco.

The problems, and what they cost

Problem What goes wrong
Duplicate items Sales split across two records; inventory and reorders wrong for both
Missing UPC (rung on department key) No item-level sales; stock never leaves inventory; scan data misses it
Wrong department Wrong tax, wrong age check, wrong margin report
Stale cost Margin reports lie; you may be selling below cost without knowing
Wrong pack size Receiving adds the wrong quantity; unit cost is wrong
Shelf tag ≠ register Customer complaints, and in many places, a pricing compliance issue
Untracked tobacco manufacturer Item missing from scan data files

Every one of these is common, and every one is cheap to fix when caught early.

Rule 1: Scan, don’t key

Every time a cashier rings an item on a department key instead of scanning it, you lose item-level information. You don’t know what sold, inventory doesn’t go down, and the item can’t appear in scan data.

Sometimes it’s necessary: the item isn’t in the system yet. That’s exactly why you should review department rings weekly. Group them by department and price. “Grocery, $3.49, rung 22 times this week” is almost certainly one item that needs to be added.

Shop-floor tip: Keep a “not in system” notepad at the register. When an item doesn’t scan, the cashier writes the description and price, rings it on the department key, and the manager adds it the next morning.

Rule 2: Costs come from invoices

Costs typed in by hand go stale. Costs from posted invoices stay current. When you receive and post an invoice, item costs should update from it, and the change should be logged.

Then review what moved. A cost increase is a decision point: absorb it, or pass it on. If you don’t look, you’ve decided to absorb it.

A worked example

Say a 20 oz soda costs you $1.20 a unit and sells for $2.29.

Margin = (2.29 − 1.20) ÷ 2.29 = 47.6%

The next invoice shows $1.32 a unit. If retail stays at $2.29:

Margin = (2.29 − 1.32) ÷ 2.29 = 42.4%

If your target for packaged beverages is 45%, the retail that hits it is:

Retail = cost ÷ (1 − margin) = 1.32 ÷ 0.55 = $2.40

Many stores round up to a price ending in 9, so $2.49. That’s a decision you can make in seconds if the system shows you the cost change. Without it, you’d find out at the end of the quarter, if ever.

Rule 3: Set margin targets by department

A default margin per department turns “is this price right?” into a quick check. Snacks at 35%, packaged beverages at 45%, HBA at 40%, whatever your numbers are. Then:

  • New items get a suggested retail.
  • Items far below target show up on a list.
  • Items with no cost at all show up too. Those are the most dangerous, because every margin report treats them as pure profit.

Rule 4: Every price change gets a new shelf tag

If the register price changes and the shelf tag doesn’t, you have a problem. Customers notice. In many places, weights and measures or consumer protection inspectors check that shelf prices match the register.

Build it into the routine:

  1. Change prices in the pricebook.
  2. Pull the list of items whose shelf price changed since the last labels were printed.
  3. Print the tags.
  4. Put them up before the new price takes effect at the register.
  5. Mark them printed so the list clears.

Electronic shelf labels can automate the last three steps, but the discipline is the same: the shelf and the register have to agree.

Rule 5: Promotions are not price changes

A 2 for $5 deal, a BOGO, a sale price for two weeks: these should be promotions with start and end dates, not changes to the regular retail. When you change regular retail for a sale, someone has to remember to change it back. Usually nobody does.

Promotions with dates start and stop on their own, show “you saved” on the receipt, and keep your regular price and margin intact. They also let you measure lift: did the deal actually sell more? Tobacco promotions in manufacturer programs often have to appear correctly in scan data, which is another reason to run them as real promotions. See how scan data works.

Rule 6: Store prices are exceptions

If you run more than one store, keep prices at the company level by default and use store-specific prices only where you mean to, like a location across from a competitor. Review store overrides every quarter. They have a way of outliving the reason they were set.

Rule 7: Know who changed what

Every price, cost and setting change should be logged: who, when, which store, from what to what, and why (manual edit, invoice, store price). When a margin suddenly drops, the log tells you where to look in seconds.

New items and big changes are worth a second look. A “needs verification” step, where a manager confirms new items and cost or retail changes, catches typos before they reach a week of sales.

The weekly routine

Monday, 20 minutes:

  • Review department rings. Add the items behind the biggest groups.
  • Review price mismatches: lines rung at a different price than the pricebook, and register price overrides.
  • Review cost changes from last week’s invoices. Decide on retail.
  • Verify new items.
  • Print shelf tags for changed prices.

Monthly:

  • Items below margin target or with no cost.
  • Items that haven’t sold in 30 days. Discontinue, discount or move them.
  • Duplicate check: same description, different barcodes.
  • Tobacco items missing a manufacturer or unit of measure.

Quarterly:

  • Store price overrides. Still needed?
  • Department margin targets. Still right?

How CornerHawk keeps the pricebook clean

CornerHawk’s pricebook and its work queues are built around this routine.

  • Item Logs records every price, cost and setting change with who, when, store and source. Work-queue tabs show needs verification (new items and cost or retail changes until a manager verifies them), missing default margin, and needs a label (shelf price changed since the last label was printed in that store).
  • Manually rung up groups department-key rings by store, department and price, with Create product prefilled from the group. Price mismatch lists register overrides, lines rung at a price different from the pricebook (promotions, coupons and rewards don’t count), and items whose cost differs from the last posted invoice.
  • Posting an invoice from Purchases updates unit and case cost and logs the change.
  • Promotions run with dates, weekdays, stores and priority, and show savings on the receipt.
  • Shelf labels print on standard Avery sheets with scannable barcodes, from a queue built from “needs a label.” Mark printed clears it. Electronic shelf labels are supported too, and update when the price changes.

The glossary has short definitions of pricebook, UPC, PLU and mix and match.

The short version

  • Scan, don’t key. Review department rings weekly.
  • Let invoices set costs. Review what moved.
  • Set margin targets by department.
  • Every price change gets a new shelf tag.
  • Run deals as promotions with dates.
  • Log and verify changes.

Quick answers

What is a pricebook?

The pricebook is your master list of everything you sell: each item's barcode, description, department, size, cost, retail price, tax and settings like age restriction or EBT eligibility. The register and every report depend on it.

How often should I update costs in the pricebook?

Every time you receive an invoice. The easiest way is to have posted invoices update item costs automatically, then review the items whose cost moved so you can decide whether to change retail.

Why does my register sell items at the wrong price?

Usually one of four things: the shelf tag wasn't reprinted after a price change, a store-level price override is in place, a promotion ended or didn't start, or the item exists twice under different barcodes.

What's a default margin and why set one?

A default margin is the target margin for a department, for example 35% for snacks. It lets you spot items priced below target and suggests a retail when you add new items or costs change.

#pricebook#pricing#margins#shelf-labels

→ Next step

Bring your pricebook. We’ll show you your store in it.

A 30-minute walkthrough on your kind of store: your departments, your vendors, your end-of-day. No slide deck.

Or write to hello@cornerhawk.com

A corner market on a wide street corner on a sunny day
Open late.
Closes itself.