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
- List your materials with how much you have and the unit you buy them in.
- Build each product's recipe: the materials and amounts it uses.
- Set a reorder point on every material.
- Update 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.
Keepsel is made for handmade shops: your materials, finished products and recipes in one workspace, and from the Maker plan, low-stock alerts, a reorder list, and scanning stock in and out with your phone. Starter is free for 30 days, so you can put a real system in place before the next busy season catches you out.