A practical inventory routine for a growing shop

01

Create one source of truth

Every sellable variant needs one record with a stable SKU, on-hand quantity, committed quantity, and availability state. Spreadsheets, marketplaces, and point-of-sale systems become risky when each is treated as the authority. Choose one inventory ledger and make every sales channel update it.

Document what each number means. On hand is physically present. Committed is reserved for open orders. Available is what can still be sold. Incoming stock should remain separate until it has been received and checked.

02

Count a little every week

A full annual count is disruptive and finds mistakes too late. Cycle counting spreads the work across the year. Count fast sellers and high-value items weekly, moderate sellers monthly, and stable low-value items quarterly. Record the expected quantity before counting so discrepancies can be investigated rather than silently overwritten.

Common causes include an unreceived return, a damaged item that was never adjusted, a duplicate SKU, or a manual order entered outside the normal flow. Fixing the process that caused the difference is more valuable than correcting the number alone.

03

Set reorder points from reality

A reorder point should reflect normal demand during supplier lead time plus a deliberate buffer. Review it after promotions, seasonal shifts, and supplier delays. For handmade or constrained products, production capacity can matter more than supplier delivery time.

Alerts should be selective. If every product is marked low stock, the alert becomes background noise. Start with the products whose absence would meaningfully hurt revenue or customer trust, then tune the threshold as order history grows.

• Receive purchase orders against what actually arrived.
• Separate sellable, damaged, sample, and returned inventory.
• Review negative stock immediately; do not treat it as a normal state.
• Keep a short reason with every manual adjustment.

04

Use aging to make calmer decisions

Inventory age reveals cash that has stopped moving. Review units and cost value by age band, then decide whether to improve the product page, bundle the item, move it to another channel, or discontinue it. Discounting is one tool, not the automatic answer.

A useful weekly inventory review can take less than an hour: resolve exceptions, receive incoming stock, count a rotating group, review low-stock alerts, and look at aging. Consistency creates the accuracy that more elaborate systems often promise but cannot create on their own.