Off-the-shelf spreadsheets and warehouse software both miss the mark for a shop with one location and a few thousand SKUs; here is what actually fits.
The right inventory tool for a small shop is not the same one a warehouse uses. It should track stock by shelf and back room, warn you before a bestseller runs out, and take less time to update than a paper count sheet ever did. A shop with one till, one back room and a few thousand SKUs needs something built for that, not a spreadsheet stretched past its limits and not enterprise software built for ten warehouses.
Most shops do not lose stock to theft first. They lose it to the gap between what the shelf says and what is actually behind the counter. A delivery arrives on a Tuesday morning: twelve boxes, three suppliers, one invoice each. Someone unpacks half of it before the doors open, prices the rest at lunch, and by Friday nobody remembers exactly what went where. The point of sale knows what sold. It has no idea what is sitting in the back room, still in its box.
That gap grows every week it goes unmeasured. A gift shop reorders a candle line still sitting in a box marked with last month's date. A hardware store tells a customer a part is in stock because the shelf tag says so, then spends ten minutes proving it wrong. Neither owner did anything careless; they just never had a system connecting the shelf, the back room and the register in one place.
This is what people in retail call phantom stock: the count on paper or in the system does not match what is physically on the shelf. It happens for the same handful of reasons in almost every shop. A return goes back on the shelf without being scanned in. A supplier short-ships an order and nobody adjusts the count. A staff member sells the last one off a display and the stockroom count never moves because the display was never linked to it in the first place.
It is not just the wasted trip to the back room. It is the customer who wanted the size, color or part that the shelf promised and walked out without it, and the reorder that duplicates stock already sitting somewhere in the shop.
A custom tool fixes this by tying one barcode to one shelf location and one register line, so a sale, a return or a delivery updates the same number everywhere at once. That is the difference between a tool built for a shop and a spreadsheet someone updates when they remember to.
None of that needs to be complicated software. It needs to match how the shop actually runs: one owner, one or two staff, a rhythm of deliveries and a Saturday rush that a generic warehouse system was never built to handle. Picking the right one is the same three-question filter behind any small business tech decision: what it actually saves, what it costs to run, and what breaks if it goes wrong, covered in our guide to picking AI and software priorities.
A spreadsheet is free, and it is where most shops start, which is fine for a stockroom of a few dozen items counted once a month. Past a few hundred SKUs and a daily delivery rhythm, it stops being free: it costs the owner an hour a week reconciling numbers a barcode scan would have kept accurate automatically. A generic inventory app closes some of that gap but usually assumes a warehouse and staff logins a one-location shop will never touch, priced for a scale it never reaches.
A tool built around the shop sits between the two: only the screens the shop needs, tied to how that shop actually receives stock and rings up a sale. Starting prices and what drives them (barcode hardware, supplier integrations, a second location) are on our pricing page, confirmed properly in a free consultation rather than guessed at here. The same logic applies to what a small business website actually costs: the sticker price matters less than what the tool saves against what it replaces.
Do not try to count every SKU on day one. Most shops find that a fifth of their products drive most of their sales; start the new system with those, on paper if needed, before touching software.
Shelf A, back room row 3, window display: whatever the shop actually calls them. A tool is only as accurate as the location names someone will actually use every day.
The single habit that fixes phantom stock fastest: nothing goes on display until it has been scanned into the system, even if pricing happens later that day.
Set a low-stock alert for the handful of products that would actually hurt to run out of. Everything else can stay a monthly manual check for now.
A shop that follows that order usually has the habit in place within a couple of weeks, well before the tool is fully built out. Compare that to an automated reorder workflow: the habit above is what makes that automation trustworthy instead of a false alarm machine.
A spreadsheet is enough for a small, slow-moving stockroom counted by hand once a month. Once deliveries arrive weekly, staff numbers grow past one, or a bestseller keeps selling out without warning, the hour spent reconciling the sheet each week usually costs more than a tool built for the job.
It depends mostly on locations, staff logins and supplier integrations, which is why we quote it after a short conversation rather than guessing here. Current starting prices are on our pricing page.
Yes. A single-location shop is the simplest case: one barcode, one shelf location, one till feed. The complexity most inventory software adds is for multiple locations or warehouses, which a one-till shop can skip entirely.
Most of the delay is not the software, it is counting the existing stock. A shop that starts with its top-selling fifth of products, as above, can usually be running the core of it within a couple of weeks rather than waiting for a full count first.
Phantom stock is when the system says an item is available but it is not actually on the shelf, usually from an unscanned return, a short-shipped delivery or a sale that never updated the count. Scanning every delivery in before it reaches the shelf removes most of it on its own.
When a customer searches nearby and books the competitor with a faster site and instant replies, it isn't because they were better. It's because they were easier to find and faster to answer. That's fixable, and it starts with a 15-minute chat that costs nothing.