Handmade inventory is deceptively complex. A retailer buys a finished mug and sells a finished mug. A ceramic studio buys clay, glaze, decals, boxes, and labor, then turns them into mugs through several stages with breakage along the way. The useful inventory question is not only “How many products are left?” It is also “What can we make, what is already committed, and what will prevent the next run?”
That is why inventory software for handmade brands should be judged by the production work it can represent, not by the length of its feature list. A simple, disciplined system that matches the studio usually produces better information than a sophisticated system people avoid using.
Map your inventory before comparing tools
Create an inventory map with four groups. Raw materials are transformed, such as wax, oils, clay, fabric, or pigments. Components remain recognizable in the product, such as clasps, wicks, pumps, or hardware. Packaging includes jars, labels, boxes, and inserts. Finished goods are ready for sale.
Include work in progress if it matters financially or operationally. Soap on a curing rack is not available to ship, but it has consumed materials and occupies capacity. Bisque-fired pottery is neither raw clay nor a finished mug. A system that treats every item as either raw or finished can hide these constraints.
For each group, identify:
- how the item is purchased and used;
- whether supplier lots or expiration dates matter;
- whether color, size, or style variations need separate counts;
- where the item is stored;
- what event should increase or decrease its quantity.
This map becomes a requirements list grounded in real work.
Capabilities that matter to handmade production
Reliable units and conversions
Makers routinely buy in one unit and produce in another. Fragrance may arrive by the pound and be used by the gram. Ribbon may be purchased by the roll and consumed by the inch. The software should convert units without repeated manual arithmetic and should define rounding clearly.
Test a difficult case before committing. If a 25-pound bag costs $82 and a formula uses 375 grams, can the tool calculate that usage correctly? Unit errors can distort both availability and product cost.
Formulas or bills of materials
A bill of materials links a product to what it consumes. For handmade work, it should support quantities, packaging, expected yield, and versions. If a candle formula produces twelve units, completing a batch should reduce wax, fragrance, wicks, vessels, and labels while increasing finished candles.
Look for flexibility around actual yield. Handmade production rarely lands on the theoretical number every time. The system should record eleven good units and one rejected unit without pretending all twelve are sellable.
Variants without confusion
A product offered in six scents and three sizes can create eighteen variants. Decide which differences affect materials, price, stock, or labeling. Each operationally meaningful variant needs a clear identifier, but unnecessary variants create maintenance work.
A consistent naming pattern helps: product, size, scent, and packaging version in the same order. Human-readable names matter on shelves as much as in reports.
Production and traceability
A useful small batch production record identifies what was planned, what was used, what was produced, and what was rejected or held. Lot tracking is particularly important for businesses making cosmetics, food, supplements, pet products, and other goods where an ingredient issue may require targeted action.
Not every craft brand needs regulated traceability. Even so, production records help explain color variation, breakage, rework, and customer complaints.
Sales-channel coordination
If products sell through a website, markets, wholesale orders, and a studio shop, inventory can be promised twice. Ask how the tool handles reservations, bundles, delayed synchronization, returns, and offline sales. “Integration available” is not enough; test the exact events your business experiences.
A scorecard for evaluating options
Score each candidate from one to five in six areas: workflow fit, inventory accuracy, production support, cost visibility, integrations, and ease of correction. Weight workflow fit and accuracy more heavily than attractive dashboards.
Run a scenario using one actual product:
- Receive two materials in their purchase units.
- Make a partial batch with an unusual yield.
- Reject one finished unit.
- sell units through two channels.
- return one damaged product.
- increase a supplier cost and review the next batch estimate.
Watch how many workarounds are needed. Export the data to confirm that the business can retain access to its records. Ask whether activity history shows who changed a quantity and why.
Clean data is part of the implementation
Software cannot resolve duplicate names, unknown units, and old counts by itself. Before migration, combine duplicate items, retire obsolete products, standardize naming, verify unit conversions, and perform a physical count. Choose a cutoff date so transactions are not entered in both old and new systems.
Assign ownership as well. One person should approve new item names and unit changes. Everyone who receives, makes, packs, or adjusts stock needs a short procedure for recording the event. Accuracy comes from routine, not from an annual cleanup.
Know which numbers mean what
On-hand quantity is physically present. Available quantity subtracts committed orders or held stock. Reorder quantity considers demand, lead time, and safety stock. Potential production calculates what existing materials could make, often limited by one scarce component.
These figures should not be treated as interchangeable. A studio may have 80 jars on hand, 30 committed to wholesale orders, and enough labels for only 24 more units. The useful answer depends on the decision being made.
Avoid common buying mistakes
Do not choose solely on the lowest monthly price. Add setup time, data cleanup, training, barcode equipment, paid integrations, and the cost of inaccurate decisions. Conversely, do not buy enterprise complexity for imagined future needs. A system that fits the next two years and exports clean data can be a better choice.
Also avoid automating a broken process. If finished goods sit uncounted for three days, instant sales synchronization will not fix the gap. Define when goods become available and make that checkpoint easy to follow.
Kerno is one option designed around the connected material, formula, batch, cost, and quality needs of product creators. The same evaluation standard applies to it: test the system with a real product and real exception before trusting it with the catalog.
Choose for daily reality
The best craft business inventory system makes routine truth easier to record. Start with your inventory map, test conversions and imperfect batches, and involve the people who touch stock. The winning tool is the one that helps the studio make and fulfill confidently on an ordinary busy day.
