Convenience store inventory list for a small shop

The headoffis workspace is coming soon. Free tools and guides are available now.

A small convenience store sells hundreds of items from a few aisles, two or three coolers and a counter. The list that runs it needs one row for every item and size you sell, where each one sits, and how many you want there. Build it once from a full count, then keep it current through deliveries, counts and the occasional cut.

What does a convenience store sell?

Most independent shops carry the same broad groups, with the mix set by the neighborhood, the floor and local rules. The table shows common convenience store categories with example items.

Age-restricted products follow federal, state and local rules. For tobacco in the United States, start with the FDA's guidance on retail sales of tobacco products, then check your state and city.

Build the list one row per item and size

A convenience store product list that groups sizes on one line cannot tell you which size is running out. A 12 oz can, a 20 oz bottle and a 2 liter of the same soda are three rows. So are single bars and multipacks.

Give each row these columns:

• Item code. Your own SKU or the barcode number, never reused.
• Item and size. The name staff use, with the size.
• Category. One from a short fixed list, such as the table above.
• Location. Shelf, backroom or cooler, written the same way every time.
• Minimum. The quantity at which that spot needs more.
• Supplier. Who delivers it: a distributor, a beverage route or a cash and carry.
• Last counted. The date of the last count for that row.

Keep separate rows for the same item in different places. A case of water in the backroom and the facings in the cooler are two rows with two minimums. The cooler minimum tells staff when to refill; the backroom minimum tells you when to order. The inventory spreadsheet guide covers formulas for totals and low flags if you keep a convenience store inventory template in Excel or Google Sheets.

Sort rows in walking order, so a count follows the floor.

How to stock a convenience store

1. Count everything once, by location, to set opening quantities.
2. Set a minimum for each shelf and cooler row, enough to last until the next refill.
3. Refill shelves from the backroom first, before the rush hours.
4. Order when the backroom row reaches its minimum, not when the shelf is empty.
5. Check each delivery against the invoice before it goes out, and add it to the list the same day.
6. Put new stock behind old, especially in the dairy cooler.

Coolers hold drinks and dated food, so the temperature check belongs on the daily list. Food rules come from your state or local health department, which typically builds on the FDA Food Code.

Count fast movers more often

A convenience store stock list does not need the same attention on every row. Drinks, milk, bread, ice and the top snacks can change by dozens of units a day, while motor oil may sit for weeks. Count the fast and costly rows weekly, and the slow rows once a month or once a quarter.

Count one section at a time during a quiet hour, and do not restock a section while it is being counted. The cycle counting guide explains how to rotate sections and recount a surprising number. The free stocktake tool gives you a printable count sheet with a recount column, without an account.

For tax records, IRS Publication 538 explains how businesses that keep inventory account for it, and says a business keeping a running book inventory must take a physical inventory at reasonable intervals.

Reorder from the list

Good convenience store inventory management turns the list into the order. Before each order, filter the backroom rows at or below their minimum, check the shelf rows for the same items, and write the order from what is left. Order the amount that lasts until the next delivery, plus a small buffer for a busy weekend.

Delivery days drive the minimums. A beverage route that comes weekly needs a higher backroom minimum than a supplier who comes twice a week. The reordering guide covers when to order and how much, and the reorder point calculator works the arithmetic from your own daily sales and delivery time.

How much inventory does a convenience store need?

There is no single number. A store needs enough of each item to last from one delivery to the next, plus a buffer, and no more than its shelves, coolers and backroom can hold. Start from your own sales per day and delivery schedule rather than a figure from another store.

Prune slow lines when space is tight

Every new item takes a spot from something else. When a shelf is full, look at the rows that sold the fewest units over the last few months and have not been reordered. Cut one size before cutting a brand, and keep an item that regulars ask for by name. The dead stock guide covers clearing goods you already hold.

Keep a separate supplies list

Bags, receipt rolls, coffee cups and lids, cleaning products and price labels are not for sale, but running out stops the store. Keep a short convenience store supplies list on its own sheet with a minimum for each, and check it with the backroom count.

Where headoffis fits

headoffis is coming soon. When it opens, stock is counted per location. Every store has a Backroom, and each fixture on the store map is a location. Each location can have its own low-stock threshold, products at or below it appear in Alerts, and replenishment suggestions come from recorded sales. Counts are whole units, with no expiry tracking or point-of-sale connection. The convenience store page shows a worked example.

← All posts