Raw material tracking gives handmade makers a reliable picture of what is available before production starts. Instead of discovering an empty fragrance bottle, missing clasp, or short stack of labels halfway through an order, you can plan from quantities that reflect the real shelf.
What counts as raw material inventory
Raw materials are all the items consumed while making a product. The exact list depends on your craft. A candle maker tracks wax, fragrance, wicks, jars, and labels. A jeweler may track chain, clasps, findings, stones, cards, and pouches. A ceramic maker may track clay, glaze, underglaze, decals, and packaging.
Include small components and packaging, not only the main ingredient. These items are easy to overlook because they cost less individually, but production still stops when they run out. A complete handmade material inventory often includes:
- Core ingredients or making materials
- Components, findings, and attachments
- Color, scent, decoration, or finishing supplies
- Labels, containers, closures, and inserts
- Product boxes, wraps, and other unit packaging
General workshop supplies such as gloves or cleaning materials can be tracked too, but do not let them delay the essentials. Start with items directly consumed by saleable products, then add operating supplies where the visibility is genuinely useful.
Track quantities and units clearly
Every material needs a quantity and a unit. The unit should match how you use the item during production. Count jars and clasps as pieces; measure wax or clay by weight; record ribbon by length. Avoid vague entries such as “one bag” unless every bag is identical and you always consume whole bags.
Purchasing and usage units may differ. You might buy wax in a 20-kilogram case but use it in grams. Convert the delivery into the working unit when receiving it, or use a system that handles the relationship consistently. This makes recipe quantities easier to compare with current stock.
Use specific names for similar materials. “White jar, 200 ml” is more useful than “jar,” especially when another size is stored nearby. Add supplier or item references when they prevent purchasing mistakes, but keep the everyday name readable for everyone who makes or packs products.
Accuracy comes from a repeatable routine. Update stock when deliveries arrive, when materials are consumed in production, when damaged supplies are discarded, and when a count reveals a correction. Small regular updates are easier than reconstructing several months of activity.
Set low stock levels before production is blocked
A low-stock level is the quantity that deserves attention, not necessarily zero. Waiting until a material is gone means the warning arrives too late. Set the level high enough to cover normal use while a replacement order is placed and delivered.
Think about supplier lead time, minimum order quantity, typical batch size, and upcoming demand. If a fragrance takes three weeks to arrive and one batch uses 500 grams, a 200-gram alert is not useful. If standard labels arrive in two days, their threshold can be lower.
Prioritize materials that can block several products. One universal box, base oil, or standard finding may affect most of your range. Give those shared items extra attention because a shortage has a wider impact. Seasonal and imported materials may also need earlier warnings.
Low-stock levels are starting points, not permanent rules. Review them after a busy market season, a wholesale order, or a supplier change. The best threshold reflects the way your business is operating now.
Track material costs, not just material names
A material list shows what you use, but material cost records show what those choices mean financially. Record the total purchase cost and usable quantity so you can calculate a cost per gram, milliliter, meter, or piece.
Include costs that are directly required to obtain the material when appropriate, such as supplier shipping allocated across an order. Be consistent rather than chasing false precision. The purpose is to create useful, comparable product estimates.
Costs change. Updating the current cost when new stock arrives keeps recipe estimates closer to replacement reality. It also makes changes visible. If a jar rises from $1.10 to $1.45, every product using that jar may need a cost review even if the formula is unchanged.
This information supports purchasing as well as pricing. A cheaper pack is not always better if it creates waste, takes too much storage space, or locks cash into a slow-moving material.
Connect raw materials to recipes and products
The biggest improvement in small batch material tracking comes from connecting materials to the products they become. A recipe or bill of materials lists the quantity required for one product or a standard batch.
When you plan production, that connection shows expected demand. When you record production, it provides the basis for reducing the materials used and increasing finished stock. Without recipes, a stock list still depends on someone remembering every ingredient and component after every batch.
Include packaging in the recipe when it is required to create a saleable unit. For example, a soap recipe may cover the batch ingredients, while the finished product recipe also accounts for one band and one label per bar. Choose a structure that mirrors your real workflow and remains easy to update.
Loomenio is built around this materials-to-recipes connection. You can learn more in the features overview or begin organizing your information with the maker templates.
Keep material history visible
Current quantity answers “what do I have?” History helps answer “what happened?” Keep records of deliveries, production use, waste, corrections, and other stock changes. You do not need long notes for every movement, but each adjustment should have a clear reason.
History is especially helpful when a count is unexpectedly low. You can check whether a large batch consumed the material, a delivery was recorded incorrectly, or damaged stock was removed. It also reveals usage patterns that support better reorder decisions.
Schedule physical counts for important materials. No digital record can see an unrecorded spill, an incorrect delivery, or a box used for another purpose. Count high-value and production-critical items more often, then reconcile differences while the context is still fresh.
When to move beyond a spreadsheet
A spreadsheet may be enough when the product range is small and one person makes occasional batches. It becomes harder to trust when recipes, variants, production runs, packaging, and changing costs all need coordinated updates.
Common signs include duplicate material names, formulas that use different units, stock totals that are regularly corrected, and uncertainty about whether an order can be produced. Another sign is spending more time maintaining formulas across tabs than using the information to make decisions.
Moving beyond a spreadsheet does not mean adopting a generic inventory tracker. Handmade businesses benefit from a system that follows materials → recipes → production → stock visibility → cost visibility. That is the workflow Loomenio is designed to support. Browse the Loomenio blog for related practical guides, or review pricing when you are ready for a more connected approach.