Handmade inventory management means knowing what materials you have, what finished products are ready to sell, and what each product costs to make, so you can decide what to make and buy next. For most makers it comes down to four things: tracking materials, linking them to recipes, recording batches, and watching stock and cost.
Start with your materials
For most handmade businesses, useful inventory starts with the inputs: ingredients, components, packaging, labels, containers, and other materials used to make finished products.
For each material, record at least:
- A specific name, such as "White jar, 200 ml" rather than "jar".
- The unit you use it in (grams, ounces, millilitres, pieces).
- The quantity on hand.
- The current cost per unit.
- A minimum level that tells you when to reorder.
When materials are tracked this way, it becomes easier to see what is available, what is running low, and what needs to be reordered before production is blocked. The guide to tracking raw materials goes deeper on each field.
Connect materials to products and recipes
A recipe or BOM explains what each product needs. For handmade sellers, this can include wax, fragrance oil, jars, wicks, labels, packaging, or any other materials used to make a product. If the term is new, read what a recipe/BOM is.
Connecting materials to recipes keeps costing and production decisions together instead of scattered across separate spreadsheet tabs. It also answers a question a plain stock list cannot: how many of this product can I make with what I have?
Use batches to keep stock updated
When you make a batch, your finished product stock should increase and the materials used should decrease. Recording that in one step, rather than editing two or three sheets, is what keeps the numbers trustworthy.
A connected process should help you:
- Reduce the materials used in a batch.
- Increase the stock of finished products.
- Spot materials that may block the next production run.
See batch tracking for small-batch production for what to record in each batch.
Watch stock and product costs
Clear stock visibility helps you see what needs attention before production is blocked. Product cost visibility helps you understand what each item takes to make.
This is especially important when material prices change, recipes are updated, or packaging costs are added later. A cost calculated once and never revisited slowly drifts away from reality. Use the free product cost calculator to check one product, or read how to calculate product cost.
A simple weekly routine
You do not need a complicated system to stay in control. A routine that works for many small makers:
- Record every delivery, batch and sale as it happens, not at the end of the month.
- Once a week, review materials below their minimum level and decide what to order.
- Count your most important or most expensive materials regularly and correct differences with a reason.
- After a supplier price change, check which products use that material and whether their price still makes sense.
Why makers move beyond spreadsheets
Spreadsheets are flexible at the beginning, but they become harder to trust as a handmade business grows. Materials, recipes, finished stock, batch history, and product costs often end up disconnected, and the data is there while the next action is still unclear. The spreadsheet alternative guide lists the signs it is time to move.
How Loomenio helps
Loomenio keeps materials, recipes, production and sales connected, and its Today screen turns that data into a short list of what to make, what to buy and what to fix, with the numbers behind each item. If you already have a spreadsheet, you can import materials, products and recipes from CSV, and you review every row before it is saved. See the pages for candle, soap and skincare makers, or the plans.