An item can still be listed for sale even when the last one has already been packed for a customer. Or you might order more supplies because a box is out of sight, then discover you already had enough. A useful inventory record helps you answer two questions: what is here, and how much of it can you actually sell?
For a small product business, you can start with a spreadsheet and a physical count. The important part is agreeing on what each number means and updating it whenever stock changes.
Give each product variant its own row
If you sell a mug in blue and cream, track those colours separately. A total of 18 mugs is not helpful when a customer wants blue and all 18 are cream. Size, scent, finish, and other options may need separate rows too.
Use a short, consistent item code, such as MUG-BLU and MUG-CRM. Keep the same code on the storage label and in your records. Add a location that someone else could find, such as “Shelf B, bin 2,” rather than “back room.”
Choose a unit for supplies and stick to it. If ribbon is measured in metres, record incoming ribbon and ribbon used in metres. Mixing rolls and metres in the same quantity column makes the total unreliable.
Start with a count you can trust
Count what is physically present. Separate damaged items, samples, and stock already promised to customers so they are not mistaken for available items. If you track these separately, label the figures clearly.
For example, you have 24 blue mugs on the shelf. Six are reserved for paid orders and two are chipped. That leaves 16 available to sell: 24 − 6 − 2 = 16. Recording only “24 in stock” could lead you to promise more than you can supply.
A basic tracker may have only one quantity field. Decide whether you will enter physical stock or saleable, unreserved stock, and document that choice. Keep any reserved or damaged quantities in a separate note or record so you can reconcile the count.
Update stock when something happens
Record new deliveries after checking the quantity received. Reduce the relevant quantity when items sell or are set aside for orders, using the convention you chose above. Record damaged stock and samples too. Otherwise, the spreadsheet gradually becomes a record of what you used to have.
If you sell through several channels, choose one inventory record to maintain and update each sales channel from it. A manual spreadsheet does not keep Etsy, a market stall, and your website in sync.
Connect reservations to your customer-order records, using an order number where possible. When a reservation becomes a dispatched order, avoid subtracting the same items a second time.
Set reorder levels around how you work
A reorder level is the point at which you review whether to buy or make more. It should reflect how quickly an item sells and how long replenishment takes, rather than being the same number for every product.
Suppose you usually sell five units a week and a supplier takes two weeks to deliver. You would expect to use about ten units while waiting. A reorder level of 13 adds a three-unit buffer. That is a starting estimate, not a guarantee, so review it if demand or delivery times change.
Before ordering, check for stock already on its way and upcoming orders that may use more than usual. A low-stock label alone cannot account for either.
Check the record against the shelf
Count fast-moving items regularly and investigate differences instead of silently replacing the number. A missing update, an unrecorded sample, or an item stored in the wrong bin needs a different fix. Leave a dated note explaining any adjustment.
If you want a ready-made record, the NeatLittleTools Small Business Inventory Tracker includes product details, storage locations, reorder levels, and calculated inventory value and stock status. You enter and maintain the quantities yourself; it does not sync with shops, deduct sales automatically, or send reorder alerts.