Never Sold Out by Surprise: Stock Tracking for Small Shops

It is Saturday morning at the market. A customer picks up the last jar on your table, smiles, and asks if you have two more. You do not. Or you think you do. Your phone buzzes with an online order for the same item, and your stomach drops.

That small, hot feeling is not about one jar. It is the feeling of not quite knowing what is on your shelf. You sold something you could not deliver. Now you write the apologetic email, issue the refund, and wonder what else is quietly running low.

Most small shops do not run out because they are careless. They run out because the numbers live in too many places: a notebook, a spreadsheet that stopped keeping up, a memory of what you ordered last month. Stock moves faster than the notes do.

When this is handled, the shelf stops surprising you. You know roughly how many days of an item are left. You know the point at which it is time to reorder, with a little buffer for slow suppliers. You stop holding money in stock that barely moves, and you stop apologising to people who wanted to buy from you.

Nothing about this needs to be complicated. It needs one clear place to look and a few simple numbers you trust. The pieces below start with stories you may recognise, then move to free calculators you can use in your browser, and finally to a tracker if you want it all in one file.

Take whichever step fits where you are today. Even one honest look at your fastest-selling item is a good beginning. Calm stock is not about perfection. It is about no longer being caught off guard.

• 📖 Customer Ordered, Item Out of Stock Again: The Saturday Market Buzz
  A Saturday market moment when the item is gone again, and what it feels like to be caught out in front of a customer.
• 📖 The Order You Had to Cancel: Running Out of Stock Unnoticed
  The order you had to cancel because the stock ran out unnoticed, and how to see it coming next time.
• 📖 Out of Stock Again: Tracking Inventory and Reorder Points in Excel
  A calm walk through tracking stock and reorder points in Excel so the shelf stops surprising you.
• 📖 Spreadsheets Everywhere? The Monday You Couldn't Find the Number
  For the Monday when the number you need is hiding in one of too many spreadsheets.
• 🧮 Days of Stock Left & Reorder Date Calculator
  Enter what you have and how fast it sells to see how many days are left and when to reorder.
• 🧮 Reorder Point & Safety Stock Calculator (Free)
  Work out your reorder point and a safety stock buffer so slow suppliers do not catch you out.
• 🧰 Never Sold Out by Surprise – Inventory & Reorder Tracker (Excel)
  One Excel tracker for stock levels and reorder points, with a 30-day money-back promise if it does not help.