How to Track Inventory for a Small Business

A simple inventory system for small shops: SKUs, stock in and out, reorder points, stock value and margin per product.

If you sell handmade goods, resell items or do markets, a simple inventory record tells you what you have, what sells and when to restock, without expensive software.

1. Give every product a SKU

A short code (for example CND-LAV-8) keeps similar items apart and makes logging quick.

2. Record cost and price

Cost per unit (materials or purchase price) and selling price let you see margin per item. Products with thin margins may need a price check.

3. Log stock in and stock out

Each time you make or buy stock, log it in. Each sale, giveaway or damaged item goes out, with the channel (online, market, wholesale).

4. Set reorder points

Pick the quantity at which you restock or make more, so best sellers don't run out before a busy weekend.

5. Count before big events

Do a quick count before a craft fair and at year end, and fix any differences in your log.

Checklist

This is record-keeping, not accounting or tax advice. Doing a year-end look back? See the small business year-end review.

Free download: Restock & Reorder Checklist, a printable checklist for what to restock and reorder. Free on Payhip.
Bundle: the Small Business & Freelancer Bundle ($30) has the Freelance Client Onboarding Kit, Small Business Inventory Tracker, Project Planner, Recipe Cost Calculator and Craft Fair Vendor Kit. Bought separately they are $45. Made with AI assistance.
Spreadsheet: the Small Business Inventory Tracker ($9, Excel or Google Sheets) handles up to 300 products with stock in/out logs, on-hand counts, stock value, margin, OK/Reorder/Out status and a dashboard by channel. Sample and blank files. Made with AI assistance.

Questions

What is a reorder point?

The stock level at which you restock or make more, set so you don't run out.

Do I need inventory software for a small shop?

Not necessarily. A spreadsheet with stock in and out logs works for many small sellers.