Managing stock and inventory in a pet shop: a practical playbook

A pet shop lives on thin margins and on products that expire, spoil or fall out of fashion. The capital locked in stock often equals several weeks of sales, and every euro sitting on the shelf is a euro you cannot use to pay suppliers, rent or wages. Inventory management works on three fronts at once: it frees up cash by cutting pointless holdings, it protects margin by reducing expiry waste, and it supports turnover by preventing stockouts on the products people look for most.

The delicate part is balance. Too much stock means blocked capital, crowded shelves, products that expire and returns to negotiate with suppliers. Too little means customers who walk in, cannot find their usual brand of food and go elsewhere, often for good. The goal is not a full storeroom but the correct one, and the difference shows up in the bank account at the end of the quarter.

For food and perishables the golden rule is FEFO, first-expired-first-out: whatever expires first leaves first, not whatever arrived last and happens to be easiest to grab. It sounds obvious, but in practice staff tend to put new stock at the front because it is what they have just unloaded, and older batches slide to the back until they expire. The result is a silent waste that erodes margin month after month.

1. 1

   Check dates on arrival

   When an order comes in, read the expiry dates before shelving. A batch with too little shelf life left should be flagged to the supplier at once, not discovered three months later on the shelf.

2. 2

   Load from behind

   Restock the shelf by placing new stock behind what is already there, so the customer picks up the older batches first. This applies to kibble, wet food, treats and antiparasitics alike.

3. 3

   Mark near-expiry stock

   Products with under sixty days of shelf life left should be flagged with a sticker or moved to a priority clearance zone, perhaps with a small dedicated promotion.

4. 4

   Record write-offs

   Every expired or damaged product should be logged with its cause and value. Without that figure you will never know what waste really costs you or where to act.

FEFO rotation is especially critical for wet food, fresh and chilled products, supplements and over-the-counter veterinary items, where the expiry window is short and the loss is total. For long-life canned goods the risk is lower, but the discipline still matters, because a customer who spots a short date trusts the shop less.

Not every product deserves the same care. ABC analysis ranks lines by the contribution they make to turnover or margin, so you can concentrate time and capital where they pay off most. The principle is Pareto's: a small share of products generates most of the business, while a long tail of items turns over slowly and risks becoming dead stock.

In practice, the dry and wet foods of the most-requested brands and cat litter are almost always class A: they must be protected from any stockout. Many accessories, niche toys and slow-selling flavour variants end up in class C, where it pays to hold very few units, order them only when needed and free the shelf for products that move. Reviewing the classification every three or four months stops the tail from quietly growing.

The reorder point is the quantity at which you must place the order so you do not run out before the new stock arrives. You work it out from how much you sell each day and how long it takes between ordering and delivery, adding a buffer for surprises. The practical formula is simple: reorder point equals average daily sales times delivery days, plus safety stock.

• Average daily sales: how many units of that line leave on a normal day, worked out over a representative period and not an unusual week.
• Supplier lead time: the days between sending the order and stock reaching the shelf, including receiving time.
• Safety stock: the buffer that covers demand spikes and delivery delays, higher for class A products and for unreliable suppliers.
• Maximum level: the ceiling beyond which ordering makes no sense, to avoid tying up capital or risking expiry on perishables.

The min-max system ties these thresholds together: when stock falls to the minimum (the reorder point) you order back up to the maximum. For a bag of a top-selling brand of kibble with a three-day delivery and sales of four bags a day, the reorder point will sit around sixteen bags, twelve to cover delivery plus four of safety. For a class C accessory that sells one unit a month, the minimum can be zero and the order goes out only on a customer's request.

The value of stock recorded in the system and the real value on the shelf always drift apart, through theft, breakage, till errors, unrecorded write-offs and badly handled returns. That gap, known as shrinkage, has to be measured and kept under control. The only way to do it is to count stock regularly, not once a year but continuously.

1. 1

   Adopt cycle counting

   Instead of shutting the shop for an annual stocktake, count a small group of lines on rotation every day or every week. Within a few weeks you have covered everything without closing and without overtime.

2. 2

   Count class A products first

   The lines that are worth the most and move the most should be counted more often, even monthly. The long tail of class C can be counted once or twice a year.

3. 3

   Investigate the gaps

   When a count does not add up, find the cause: a keying error, an unrecorded return, an expiry thrown away without logging it, or possible theft. Correcting the number without understanding why fixes nothing.

4. 4

   Protect at-risk lines

   Antiparasitics, supplements and small pricey accessories are the classic targets for theft. Move them near the till or into monitored areas and track shrinkage on these categories.

A shrinkage rate held under one or two per cent of turnover is considered normal in retail; higher figures point to a problem of process, surveillance or recording that needs addressing at once. The difference between a shop that knows how much it loses and one that finds out at year end is huge, because only the first can act in time.

Running everything from memory or on a sheet of paper only works with a handful of lines. As soon as the shop grows you need a management system with barcode scanning that updates stock on every sale and every delivery. It need not be expensive or complicated: a product catalogue, a link to the till, reorder-point alerts and a basic report of sales by line are enough.

• A clean catalogue: each product with a single code, no duplicates, with brand, format and ABC class clearly set.
• Real-time stock: a sale takes items off, a delivery adds them, so the on-screen figure mirrors the shelf.
• Reorder alerts: the system flags when a line hits its reorder point, so you do not notice at an empty shelf.
• Sales history: the data to work out turnover, seasonality and ABC classes without guessing.

The supplier relationship is the other half of the job. Lead times, minimum orders and volume discounts decide how much capital you have to tie up. A high minimum order forces you to buy more than you need and slows turnover; a fast, reliable delivery lets you hold lower stock. For niche products, special orders and pre-orders keep the shelf clear of lines that turn over only now and then, moving capital to where it truly counts.

Without numbers, stock management stays a gut feeling. A handful of metrics, checked monthly or quarterly, are enough to see whether your capital is working or sleeping. You do not need to track them all: pick two or three and follow them over time, because the value is in the trend more than in the absolute number.

The turnover ratio and days of inventory tell you how fast capital comes back; GMROI tells you whether each euro of stock is actually producing margin. A product can turn over a lot on a laughable margin, or turn over little on a very high one: GMROI puts the two together and is the most honest metric for deciding what to keep, what to push and what to drop from the shelf.