Inventory Management for Etsy Sellers: A Simple System

When you're starting out on Etsy, you can keep inventory in your head. A few listings, a shelf of supplies — you just know what you have. Then orders pick up, you add products, and one day you sell something you can't actually make because you're out of a key material. That's the moment a real system pays for itself.

Track two kinds of stock, not one

Most maker shops have two separate inventories, and confusing them is where spreadsheets fall apart:

• Materials — the supplies you buy: wax, vinyl, beads, blanks, fabric.
• Finished products — the items you actually sell, made from those materials.

The link between them is your recipe: each product consumes a specific amount of materials. Get that link right and the whole system clicks — make a product, and your materials draw down automatically; sell one, and finished stock drops.

Know what you can make right now

The most useful question in a maker shop isn't "how many do I have?" — it's "how many can I make before I run out of something?" If you know your recipes and your material stock, you can answer that instantly, and decide what to list and when to restock supplies.

Set reorder points so you never sell what you can't ship

For each material, pick a low-stock level that gives you enough runway to reorder before you hit zero — accounting for shipping time from your supplier. When stock drops to that level, you reorder. No more discovering you're out mid-order.

The goal isn't perfect counts. It's never being surprised.

A simple system you can actually keep up with

1. 1List your materials with how much you have and the unit you buy them in.
2. 2Build each product's recipe — the materials and amounts it uses.
3. 3Set a reorder point on every material.
4. 4Update stock as you make and sell — or scan it in and out so it updates itself.

When to graduate from spreadsheets

Spreadsheets work until they don't: they don't link materials to products, they don't draw stock down when you make or sell, and they quietly drift out of date. If you're spending Sunday nights reconciling counts, it's time for a tool built for it.

Hivara is inventory and production software made for handmade shops: track materials and finished products, build recipes, set reorder alerts, and scan stock in and out with your phone. It's free to start — so you can put a real system in place before the next busy season catches you out.