Running your orders
Simple Inventory Tracking for Small Sellers: Why Your Stock Sheet Keeps Going Wrong
Why small sellers' stock counts go wrong within a week, when stock should really go down, and the smallest inventory setup that stays accurate.
8 min read
Short answer: a stock count is only useful if it changes by itself when you take an order. Most small sellers’ counts go wrong because updating them is a second job, done after the real one, and a second job gets skipped on a busy day. The smallest setup that stays accurate is one count per finished product, kept on the same item your orders use. It goes down when you take the order and comes back when an order is cancelled. It warns you when it gets low and never refuses a sale.
If you make things in batches (candles, pickles, soap, cupcakes by the dozen, printed tees), you probably already have a stock list somewhere. A spreadsheet, a notes app, a page at the back of the order book. And you probably don’t fully trust it.
That is normal, and it is not a discipline problem. It is a design problem, and it is fixable.
Why stock sheets drift
Walk through a normal week.
An order comes in on WhatsApp for three jars. You write it in your order book, or your order app. The stock sheet is somewhere else, so you mean to update it tonight. Tonight, two more orders arrive and one customer changes three jars to five. On Thursday someone cancels. On Saturday you count the shelf, find eleven where the sheet says fourteen, and can’t say which of the week’s changes you missed.
Every one of those events was recorded, in the orders. The stock sheet drifted because it was a second copy of information that already existed, and it had to be kept in step by hand.
So the fix is not more discipline. It is to have one record instead of two. The count should live on the product your orders point at, so taking an order is updating the stock.
When does stock actually leave?
This is the question most stock setups get quietly wrong, so it is worth being deliberate about.
There are three moments you could pick:
| Stock goes down when… | What goes wrong |
|---|---|
| The order is taken | Nothing structural. If the order is cancelled or returned, the stock comes back. |
| The order ships or is handed over | Items promised to customers still look available, so you can sell the same jar twice. |
| The order is marked complete | It depends on you marking every order done, and most small sellers don’t. |
The last one is the trap. If your count only moves when an order is marked complete, every order you forget to close leaves stock that doesn’t exist. And plenty of orders never get closed. Customers get their jars, the chat goes quiet, and the order sits at “new” forever.
So take stock off when you take the order. From that moment the item is promised, whether or not it has left the shelf. Then make sure the reverse happens as well: a cancellation, a return or a deleted order puts it back. An edit should follow the order too. If three jars become five, two more come off, not five.
Never refuse an order on a count
Checkout software can stop a customer from buying something that reads zero. That makes sense when the count is exact and the buyer is a stranger clicking a button.
Neither is true for most small sellers. Your count is an estimate that is right most days. The customer is someone you are talking to, and you might be making another batch on Sunday. If an app refuses the order, you will take it anyway, just not in the app. Then your order records are wrong as well as your stock.
The better rule is warn, don’t block. When an order asks for more than you have, say so, let it through, and show the item as oversold by two. That tells you something useful, “make or buy two more”, instead of starting an argument with your own tools.
Even Shopify, which exists to run a checkout, has a setting to keep selling a product after it runs out, for pre-orders and for stock that is on its way. For a business built on conversations, that should be the default.
A low-stock warning is one message, not a nag
The point of a low-stock number is to find out before you run out, while there is still time to make more. That needs two things.
A threshold per product. Five might be plenty for one candle scent and far too few for your bestseller. Pick the number at which you would start the next batch.
One alert per dip. You want to hear about it once when stock crosses the line, not after every order that follows. Once you restock above the line, the next dip should alert you again.
It also helps to have a list you can check at any time: everything that is low, out or oversold. That way the answer to “what do I need to make this weekend?” doesn’t depend on remembering the alerts.
Finished goods are not materials
Here is the distinction that decides which kind of tool you need.
Finished goods are the things you sell: twelve jars of lime pickle, eight lavender candles, four medium tote bags. You count them, sell them and restock them.
Materials are what you make them from: flour, wax, wicks, jars, fabric, beads. They get used up by making, in amounts that depend on a recipe, often in units like grams or metres.
Tracking finished goods is small and fits on a phone. Tracking materials properly means recipes, units, batches and cost per unit, and that is a different category of software. If your real question is “how much wax do I have, and what does one candle actually cost me?”, you want a materials and costing tool like Stocksmith, formerly Craftybase, not a simple stock count.
Plenty of batch makers only need the first. If you make a batch, sell it down, and make another when it runs low, a count per product and a low-stock warning are most of the value.
Sizes and colours sit in between. If you sell a kurta in S, M and L, the simplest setup that works is one product per size, “Kurta (M)” and so on, each with its own count and warning. It is a little more typing when you set it up, and nothing to think about after that.
Which setup fits you
| You… | Use |
|---|---|
| Sell a handful of things, rarely run out, and restock by eye | A glance at the shelf. Don’t track what doesn’t hurt. |
| Sell a few dozen finished products, take orders by message, and sometimes oversell | A count per product that moves with your orders, with a low-stock warning |
| Need to know materials on hand and true cost per unit | A materials and costing tool such as Stocksmith |
| Want customers to buy without talking to you, with stock enforced at checkout | An online shop such as Shopify (here’s when that’s the right call) |
| Already live in a spreadsheet and your counts are right | Keep it. The problem this article is about is drift; if you don’t have it, you don’t need a fix. |
How this works in WISMO, specifically
WISMO added stock tracking to its catalogue in September 2026. It covers the second row of that table and deliberately nothing more.
It is on the catalogue item, not in a separate list. Open a product, turn on Track stock, and enter how many you have. You can set Warn me at to the level where you would start the next batch, or leave it blank for no alert. Services, like a portrait sitting or an alteration, can’t track stock, because there is nothing to count.
It moves with your orders. When you create an order with that item, or accept an enquiry from your store page, the count goes down. Editing the quantity adjusts it by the difference. Cancelling, returning or deleting the order puts it back, and un-cancelling takes it off again. Orders you took before you turned tracking on don’t touch the count, since the number you typed in already allowed for them.
It never blocks an order. The order form shows “5 left” beside a tracked item. If you order more than that, you get a warning (“Only 5 left”), and the order still goes through. The item then shows as Oversold by 2 until you restock.
Every change is written down. Each item has a stock history: which order took it, which cancellation gave it back, when you added stock, and when you corrected the count after counting the shelf. When the number looks wrong, you can see why. There are two ways to change it by hand: Add stock for a new batch, and a set-to-a-count option for after a physical count.
Low stock tells you once. When an item drops to its warning level, you get one push notification. You won’t get another until you’ve restocked above the line. The evening Daily Digest also says how many items are running low. You can turn the alert off in notification settings.
The Catalogue tab has three views: All, Stock (only the items you track) and Running low (anything low, out or oversold). The last one is your “what do I make this weekend” list.
Customers never see the count. If you publish a store page, a tracked item with nothing left shows as Sold out and can’t be added to an enquiry. The number itself, and anything above zero, stays in your app.
Stock tracking is free on every plan, like the catalogue it lives on. The catalogue already fills in your order form as you type, so filling it in pays off before you track a single item.
What it doesn’t do, stated plainly: materials or recipes, sizes and colours as variants of one product, more than one location, barcode scanning, stock value reports, or syncing with Shopify or Etsy. We built the smallest useful version on purpose. Materials and recipes are the obvious next step, and we will only build them if sellers use this and ask for more. We would rather not ship a small ERP that nobody asked for.
The honest summary
Stock sheets don’t go wrong because sellers are careless. They go wrong because they are a second copy of your orders, updated by hand after the fact.
Keep one record. Put the count on the product your orders use, take stock off when you take the order, put it back when an order falls through, warn instead of refusing, and get told once when something runs low. That is the whole method, and a notebook can do most of it if you are strict enough.
If you would rather it happened by itself, that is what the catalogue in WISMO now does. It is free, and you can turn it on for just the three products you always run out of.
Common questions
What is the easiest way to track inventory for a small business?
Keep the count on the same thing your orders use, so it moves when you take an order rather than when you remember to update a sheet. For a seller with a few dozen products and orders arriving by message, that means one count per finished product, a number that warns you when it is low, and a history showing what changed it. Anything that needs a second step after each sale will drift, however disciplined you are.
Should stock go down when an order is placed or when it ships?
When you take the order. From that moment the item is promised to someone, even if it is still on your shelf, so counting it as available lets you sell it twice. If the order is later cancelled or returned, the stock should come back. Deducting only on shipping or completion looks tidier, but it depends on every order being marked done, and plenty of small sellers never mark orders done.
Should I stop taking orders when something is out of stock?
Usually not, if your orders come in by message. Your count can be wrong, you might be making more this weekend, and a customer on the phone is not waiting for software to agree. A better rule is to warn rather than block: show that the order goes over what you have, let it through, and show the item as oversold so you know to make or buy more. Even Shopify, which is built around a checkout, has a setting to keep selling when a product is out of stock.
Can WISMO track raw materials or ingredients?
Not yet. WISMO counts finished products, the things you sell, with a low-stock warning and a history of every change. It does not track materials, recipes or batches, and it does not calculate true cost of goods. If flour, wax or beads are the numbers you need to watch, a materials tool such as Stocksmith (formerly Craftybase) is the right category.
Is stock tracking free in WISMO?
Yes. Stock tracking is part of the catalogue, and the catalogue and the public store page are both free on every plan. On the store page, a tracked item with nothing left shows as Sold out.
Can my customers see how many I have left?
No. Counts stay in the app. On a published WISMO store page, a tracked item with nothing left shows as Sold out and cannot be added to an enquiry, but the number itself is never shown, and neither is anything above zero.
Sources
About the author
Ashish Vijay is the founder of WISMO, an order management app for small sellers and independent makers. He builds the product, talks to the sellers who use it, and writes these guides from what that work turns up.
