Skip to content
STORE STANDARDS
STORE STANDARDS

Choose a language and region

English

Other languages

Blog

Why your Shopify stock count drifts, and six ways to stop it

The six places Shopify inventory goes wrong in a real store, how to work out which one is costing you, and the fixes that hold without adding a daily count.

Nia Chambers

4 min read

Stock accuracy Receiving Operations

Every store we work with says a version of the same thing: “the numbers are about right, but we do not trust them.” Usually they are right not to.

Stock drift is not one mistake. It is six small ones, none of which look serious on the day. Over a quarter they add up, until the number on screen and the number on the shelf have nothing to do with each other.

Here is where it comes from, in the order it usually costs the most.

1. Receiving

The biggest single source, and the easiest to fix.

Stock booked in from a delivery note instead of a count. Stock booked in two days late. Part deliveries closed early. Every one of these puts a number into Shopify that was never actually verified against the boxes.

The fix. Count into the purchase order while unpacking, book in the same day, and record every short or over line. We wrote up the full method in how to receive a purchase order in Shopify.

2. Returns that never come back

A customer returns a jacket. The refund goes through, so the money is right. The jacket sits in a pile behind the counter for two weeks before anyone puts it back on the shelf, or nobody ever does.

Shopify has an option to restock on return, and it is easy to tick when the item is not actually back in sellable condition.

The fix. Two piles, and one rule: nothing goes back into stock until someone has looked at it. Restock at the moment it goes back on the shelf, not at the moment the refund is issued.

3. Damage nobody wrote down

A box gets dropped. Two items are unsellable. They go in the bin, and Shopify still thinks you have them.

This one is quiet because there is no transaction attached to it. Nothing prompts anyone to record it.

The fix. Make a damage adjustment as easy as throwing the item away. If recording it takes longer than binning it, it will not get recorded.

4. Multi-location confusion

Stock received into the warehouse when it went to the shop. Stock transferred in Shopify but not physically moved, or moved but not transferred.

The symptom is distinctive: the total across locations is right, but each individual location is wrong. If your totals look fine and your shop floor keeps running out, this is your problem.

The fix. Receive into the location the boxes are physically standing in, and make transfers a two-step confirmation: sent, then received.

5. Theft and loss

Real, and usually smaller than people expect in a store that has the other five under control. Around one to two percent of stock in a typical small retailer, depending on what you sell.

It matters that this is last on the list, not first. Blaming shrinkage is comfortable because it is nobody’s process. Most of the time the process is where the stock went.

The fix. Get the other five right first. Whatever is left after that is your real shrinkage figure, and now you can act on it.

6. The annual stocktake

Counting everything once a year, badly, in one long day, is worse than not counting at all. You correct twelve months of drift in a single adjustment, learn nothing about what caused it, and start the same drift again the next morning.

The fix. Cycle counting. Count a small number of lines often instead of everything rarely.

What cycle counting looks like in a small store

You do not need software or a shutdown.

  1. Pull your twenty fastest-selling variants.
  2. Count those twenty every Monday morning, before opening. It takes about fifteen minutes.
  3. Write down the difference, not just the correction.
  4. Once a month, look at the differences together.

That last step is the one that pays. A single line being out by three is noise. The same line being out by three every week is a process telling you something: a mis-picked variant, a barcode on the wrong shelf, a supplier sending inners as outers.

Fix the cause before the number

The tempting move when you find a discrepancy is to correct Shopify and move on. Do that and you will be back next month.

For every correction, write one line saying what you think caused it. Receiving, return, damage, transfer, unknown. After a month you will have a tally, and it will point straight at the process to change. In almost every store we have done this with, the top row is receiving.

If most of your corrections trace back to goods-in, the fix is to make the new stock countable the day it lands: every unit labelled, with a barcode that scans. StandardLabel prints those labels straight from the delivery, and there is a free plan if you want to try it on one location first.

And if the reason you are not scanning yet is that half your products have no barcode, start with barcode types every Shopify store should know.

To put a number on where you are today, run your last count through the stock accuracy scorecard. If you would rather start counting properly first, print the cycle count sheet.

Questions people ask

What stock accuracy should I be aiming for?

Ninety eight percent or better, measured in units rather than in lines that matched. Below ninety five percent you will place orders that are wrong often enough to notice.

How do I measure my accuracy?

Count a section, then compare it to what Shopify said you had. Divide the units you are out by the units the system claimed, and take that off a hundred.

Is shrinkage the same thing as drift?

No. Shrinkage is stock that has genuinely gone. Drift is the gap between your records and reality, and most of it is recording errors rather than missing goods.

How often should I count?

Your twenty fastest sellers weekly, high value lines monthly, everything else across the year. One big count in January tells you how wrong you were, not how wrong you are.

Will a barcode scanner fix this on its own?

It fixes the typing and the counting, which is a large part of it. It does not decide what to do about six damaged units, and that judgement is where a lot of the rest comes from.

Nia Chambers

Product

I pick what we build next by watching people take stock off a pallet. Not by counting feature requests. I say no to nine ideas in ten.

Related reading

Receiving Operations

What Stocky did that Shopify's admin still does not

Shopify moved purchase orders and receiving into the admin. Four jobs did not move. Here is what each gap costs you in time and in money, and what covers it.

Nia Chambers

4 min read

Stop typing label quantities

Install the app, open a delivery and print the labels for it. Setup takes about four minutes.