Soap Maker Inventory: Ditch the Spreadsheet

Soap making runs on a long list of oils, butters, lye, fragrance, colorants and packaging — most of it measured by weight, some of it hazardous, and all of it easy to run out of mid-batch. A spreadsheet can't keep up. Here's a better system.

Why soapmakers outgrow spreadsheets fast

A single cold-process recipe can pull from a dozen ingredients, each in grams or ounces, each bought in different pack sizes. Track a few recipes across batches and you're maintaining a fragile web of formulas. One typo and your numbers quietly drift from reality.

Track every ingredient in its real unit

Olive oil by the pound, lye by the gram, fragrance by the ounce, micas by the gram. Record each ingredient in the unit you actually measure with, and how much is in a pack or jug, so partial use and restocking both just work.

Turn each soap into a recipe

Enter what one batch (or one bar) consumes and let the software handle the rest: it shows how many batches you can make from current stock, and making a batch deducts every oil, the lye and the fragrance automatically. No more manual subtraction across ten ingredients.

Bonus: a recipe is also a built-in cost sheet. Add ingredient costs and you instantly see what a bar costs to make and your margin at your selling price.

Set reorder points on the essentials

Lye, your base oils, and packaging are the things you can't make without. Put a reorder point on each so they flag themselves and drop onto a shopping list — grouped by supplier — before you're caught short the week before a market.

Keep batch records (because soap is regulated)

For cosmetics like soap, keeping clear records of what went into each batch and when isn't just good practice — it matters for safety and compliance. Logging every batch as you make it builds that history automatically, instead of reconstructing it later.

From spreadsheet to system

StockSpace replaces the soap maker's spreadsheet with something purpose-built: ingredients in real units, recipes that calculate batches and cost, low-stock alerts and a shopping list, and a running record of everything you've made. It travels with you to the workbench, and you can import your existing materials list from a CSV to get started in minutes. Curious about the cost side? Read how to calculate cost and margin on handmade products.