How to Track Candle Inventory Without Spreadsheets

The Spreadsheet Problem

Let's be honest: every candle maker starts with a spreadsheet. You create columns for wax weight, fragrance oil, wicks, jars, labels. It works great — for about two weeks.

Then reality hits:

• Multiple tabs for supplies, products, orders, and costs — none of them talk to each other
• Manual math every time you pour a batch ("OK, I used 5 lbs of 464, so subtract that from... which cell was it?")
• Version chaos — you edited the sheet on your phone but your laptop has the old version
• No alerts — you discover you're out of 6oz jars when you're halfway through a batch
• Cost tracking nightmare — wax prices change, you buy from different vendors, and suddenly your COGS numbers are fiction

Spreadsheets are great for simple lists. They're terrible for managing a growing candle business with dozens of supplies, multiple products, and real money on the line.

What You Actually Need to Track

Before choosing a system, know what matters. Candle inventory breaks down into three layers:

1. Raw Materials (Supplies)

Everything you buy to make candles:

• Wax — soy, coconut, paraffin, blends (tracked by weight)
• Fragrance oils — dozens of scents, each with a cost per oz
• Wicks — different sizes for different containers
• Containers — jars, tins, vessels
• Labels, lids, warning stickers
• Packaging — boxes, tissue paper, bubble wrap

2. Work in Progress (Batches)

Candles that are poured but not yet ready to sell:

• Freshly poured (cooling)
• Curing (most soy candles need 1-2 weeks)
• Quality check / wick trimming

3. Finished Goods (Products)

Candles ready for sale — sitting on your shelf, at a craft fair table, or listed on Shopify. Each one has a cost (your COGS) and a sell price.

Supply Tracking: Wax, Fragrance, Wicks & More

This is where most candle makers struggle. You're juggling 30-50 different supplies from multiple vendors, each with different units, prices, and reorder points.

A good supply tracking system should:

• Show current stock at a glance — how many pounds of 464 do I have?
• Track cost per unit — not just what you paid, but the per-ounce or per-unit cost
• Log vendor info — who you buy from and at what price
• Auto-deduct when you pour — make a batch of 12 candles, supplies adjust automatically
• Alert you when stock is low — before you're mid-batch and out of wicks

With spreadsheets, you'd need formulas linking your batch log to your supply sheet, and you'd still have to manually trigger the deduction. With a purpose-built tool, it happens automatically.

Finished Goods: Products Ready to Sell

Once a batch finishes curing, those candles become inventory — sellable products. You need to know:

• How many of each product do you have? (e.g., 24 Lavender 8oz, 12 Vanilla 4oz)
• What did each one cost to make? (your per-unit COGS)
• Where are they? (home shelf, storage, at a market, shipped to a customer)
• What's your total inventory value? (critical for taxes and insurance)

If you sell at craft fairs, you also need to track what you bring vs. what you sell — so you know your conversion rate and which products move.

Low Stock Alerts (Never Run Out Mid-Batch)

The most expensive inventory problem isn't ordering too much — it's running out at the worst time.

Imagine: you've got a craft fair in 5 days. You planned to pour 48 candles this weekend. You heat up the wax, prep the jars... and realize you only have 8 wicks left. Now you're panic-ordering from Amazon at 2x the price, or worse — showing up to the market with half your inventory.

Low stock alerts fix this. Set a minimum threshold for each supply:

• Soy wax 464: alert when below 25 lbs
• CD-8 wicks: alert when below 100
• 8oz jars: alert when below 24
• Lavender FO: alert when below 8 oz

A good system checks these automatically and tells you what needs reordering — before you're in crisis mode.

Batch Tracking: From Pour to Cure to Sale

Batch tracking is the bridge between your supplies and your finished products. Every time you pour, you should record:

• Date poured
• Recipe used (wax type, fragrance, wick, container)
• Quantity made
• Supplies consumed (auto-deducted from inventory)
• Cure date (when they'll be ready)
• Status (pouring → curing → completed → sold)

This gives you a production history. You can see exactly when each candle was made, what went into it, and what it cost. If a customer complains about a scent throw problem, you can trace it back to the specific batch.

In a spreadsheet, you'd need a separate "Batches" tab with formulas pulling from your recipe tab and deducting from your supplies tab. In practice, people stop updating it after the third batch.

Connecting to Shopify (or Your Sales Channel)

If you sell online, your inventory lives in two places: your production system and your sales platform. When someone buys a candle on Shopify, your stock count should update everywhere — not just on the website.

The dream workflow:

1. You pour a batch of 24 Lavender candles
2. After curing, you mark them complete — stock goes from 12 to 36
3. That count syncs to Shopify automatically
4. Customer buys 2 on your website — stock drops to 34 everywhere
5. You sell 5 at a craft fair — update once, syncs back to Shopify

Without sync, you're manually updating Shopify every time you pour or sell at a market. That's where overselling happens — your site says "in stock" but you actually sold the last one at Saturday's market.

Building a Real Inventory System

You have three options, ranked from worst to best:

Option 1: Spreadsheets (Free, Fragile)

Google Sheets or Excel. Free, familiar, and functional — until you have more than 20 products or forget to update it for a week. No automation, no alerts, no sync. You'll outgrow it fast.

Option 2: Generic Inventory Software ($30-100/mo)

Tools like Craftybase, inFlow, or Sortly. They handle inventory well, but they're not designed for candle makers specifically. You'll spend time configuring categories, custom fields, and workarounds for things like cure times and fragrance loads.

Option 3: Purpose-Built for Candle Makers

This is what WickSuite was built for. Instead of adapting generic software to your workflow, everything is designed around how candle businesses actually operate:

• Supplies tracked with candle-specific units (lbs of wax, oz of fragrance)
• Recipes with automatic COGS calculation
• Batches that deduct supplies and track cure times
• Products linked to recipes so costs stay accurate
• Low stock alerts based on your reorder points
• Shopify sync for online sellers
• Pricing tools built right in

The Bottom Line

Inventory management isn't glamorous. Nobody starts a candle business because they love tracking wax weights. But the candle makers who grow beyond the craft fair table into a real business? They all have one thing in common: they know exactly what they have, what it costs, and when to reorder.

You can do that with spreadsheets — for a while. Or you can use a tool that does it automatically, so you can spend your time making candles instead of managing cells.