Do I need inventory software for a handmade business?

Not until you outgrow a spreadsheet — usually around 50+ SKUs or multi-channel selling. Start with Google Sheets and switch only when you actually feel the pain.

How much safety stock should I keep?

Enough to cover 1–2 weeks of average sales on top of your reorder point. Higher for materials with long lead times or seasonal spikes.

What's a reasonable inventory turnover for handmade?

Aim to turn finished-goods inventory 4–8 times per year. Slower than that means cash is sleeping on your shelves.

How do I handle made-to-order inventory?

Track materials only — finished-goods quantity is always zero. Reorder points on materials become even more important because you can't pre-build a buffer.

Inventory Management For Handmade Business

Inventory is silent in a handmade business until it bites — out of clasps mid-rush, $400 of fabric you forgot you owned. A simple system fixes both.

Track two things separately: materials and finished goods

Materials are the inputs (wax, fabric, beads, blanks). Finished goods are the listed products. Mixing them in one list hides problems — you can have plenty of finished candles but be one wick away from making zero more.

Use two simple sheets (or two tabs): one row per material with current quantity and reorder point, one row per SKU with quantity on hand.

Set a reorder point for every material

Reorder point = average weekly usage × lead time in weeks + a small safety buffer. If you use 200 wicks per week and your supplier takes 2 weeks, reorder when you hit ~500. Reorder points turn 'I think we're getting low' into a clear trigger.

Count on a schedule, not when you panic

Do a quick count of fast-moving materials weekly and a full count monthly. Counts that only happen during a stockout are the most expensive counts you'll ever do.

Batch production around inventory, not orders

Decide a target stock level for each SKU (e.g. always keep 12 of each candle scent on hand). Produce in batches to refill to target. Batching is faster per unit, cheaper in materials, and keeps you from making single items reactively under pressure.

Know your dead stock and act on it

Anything that hasn't sold in 90 days is tying up cash and shelf space. Bundle it, discount it, donate it, or harvest it for materials — but stop letting it sit. Track 'days since last sale' so dead stock can't hide.

Connect inventory to the calendar

Build a simple calendar of buying peaks (Mother's Day, back-to-school, Q4) and order materials at least one lead-time before each one. Most stockout disasters are scheduling failures, not demand surprises.

Frequently asked questions

Do I need inventory software for a handmade business?: Not until you outgrow a spreadsheet — usually around 50+ SKUs or multi-channel selling. Start with Google Sheets and switch only when you actually feel the pain.
How much safety stock should I keep?: Enough to cover 1–2 weeks of average sales on top of your reorder point. Higher for materials with long lead times or seasonal spikes.
What's a reasonable inventory turnover for handmade?: Aim to turn finished-goods inventory 4–8 times per year. Slower than that means cash is sleeping on your shelves.
How do I handle made-to-order inventory?: Track materials only — finished-goods quantity is always zero. Reorder points on materials become even more important because you can't pre-build a buffer.

Paired calculator

Handmade Pricing Calculator

Put this guide into practice with the matching free calculator.

Try the Handmade Pricing Calculator →

← All guides