How to keep a convenience store price book clean
To keep a convenience store price book clean, make the file and the shelf agree, and fix drift every week before it piles up. The price book is the master list of everything you sell, with a UPC or PLU, description, department, cost and retail. It drifts one override at a time.
In short
- When the price book and the register disagree, fix the price book, not the register.
- Let invoices update cost, but keep the retail decision with a person.
- Share each item across stores and let retail vary, so price gaps are on purpose.
What is in a convenience store price book
Every item needs a UPC or PLU, a readable description, a department, a cost and a retail. Keep the tree shallow: a department, then a category under it. Two levels are enough for bulk changes.
Fields worth adding
- A description a cashier can read. MTN DEW 20Z, not ITEM 4471.
- Vendor and vendor item number, so invoice lines match.
- Age-restriction flags on tobacco and alcohol.
- Cost with a date, so you know the margin is current.
Why a price book drifts out of date
Almost all drift comes from four habits: register overrides, items created at the terminal, cost increases nobody read and promotions with no end date. Each one is reasonable in the moment and invisible on its own.
The fix is a short weekly routine. Review items whose cost moved on this week's invoices, decide on retail, then send and confirm. Once the backlog is cleared, it takes under an hour.
| Item | PLU | Cost | Retail | Margin |
|---|---|---|---|---|
| Coke 20oz | 10112 | 1.42 | 2.49 | 43.0% |
| Red Bull 12oz Pending change | 10442 | 2.05 2.19 | 3.29 | 33.4% |
| Doritos 2.75oz | 20881 | 1.58 | 2.79 | 43.4% |
| Gatorade 28oz | 10337 | 1.86 | 2.99 | 37.8% |
How do I send a price change to the POS
A price change only counts once it reaches the register. Change the item once, then Send to POS. The Neo connector app writes it to Gilbarco Passport, and each store moves from Queued to Applied.
Failed sends retry on their own and stay visible until they land. Then print the shelf tag, because a price that changes everywhere but the shelf starts an argument.
Batch 2211
14 items · Send to POS
- Easy Mart · Main StAppliedAttempts 16:04 AM
- Easy Mart · Route 9AppliedAttempts 16:04 AM
- Easy Mart · AirportAppliedAttempts 16:05 AM
How one price book works across multiple stores
Share the item across stores. There is no reason for one product to be two items at two stores.
Let retail vary where it should, because a highway store and a neighborhood store need not charge the same for water. What matters is seeing one item's price at every store on one screen.
Price book
4,212 items · one master
Easy Mart · Main St
Follows the book
Easy Mart · Route 9
Follows the book
Easy Mart · Airport
FlaggedRetail 3.49 (store) vs 3.39 (book)