What a Weekly Candle Making Planner Actually Looks Like in Practice
A candle making weekly planner is just a calendar that tracks what needs to melt, pour, cure, label, and ship each week. People make it way more complicated than it needs to be. The problem isn't the tool. The problem is that candle making has real physical timelines you can't shortcut, and most free templates ignore that entirely. I've been doing this for years, and honestly the simplest version that actually works is a spreadsheet with columns for wax batch size, fragrance load, curing status, and a hard stop date that factors in the actual wait time. Not the ideal textbook wait time. The real one. Different waxes behave differently. Soy takes longer than paraffin, and if you don't account for that on paper, you end up shipping jars that haven't properly bound the scent yet.
Planner For Candle Making Weekly Structure That Doesn't Waste Time
Here is the setup I actually use. Rows are grouped by project or product line. Columns track the physical stages in order: melting day, pour day, add fragrance day (if it goes in at different temps), cure start, cure end, label day, packaging day, and inventory count. That last one is critical because you need to know exactly how many finished units sit on the shelf versus how many you actually sold that week. I keep a separate column for wax type. This looks trivial until you are juggling coconut soy blends that need 48 hours of curing and regular paraffin that only needs 24. One batch of mine sat too long once and the throw was incredible but the jar looked frosted from the over-cure. I lost half that run to cosmetic rejects. Now my planner has a hard rule: after cure end, the next cell turns orange in my conditional formatting, and I physically move those jars to the finish bin instead of letting them linger.
How to Set Up a Working Weekly Planner From Scratch
Open Google Sheets or Excel and create these column headers in this exact order: Project Name, Wax Type, Fragrance % , Batch Weight Oz, Melt Date, Pour Date, Fragrance Add Date, Cure Start, Cure End (Auto-Formula), Label Date, Pack Date, Units Started, Units Sold This Week, Pending Ship Date, Notes. The auto-formula for Cure End is just a simple IF statement. For soy wax it returns the Melt Date plus 14 days. For paraffin it adds 7. For blends it adds 10. Change those numbers if your local humidity or container size throws them off, but those are the starting points that actually match what happens in a home studio. Not a factory. Home studio conditions matter because your room temperature swings more and your jars cool at different rates depending on thickness. Conditional formatting makes this thing usable without any apps. Set the fill to yellow from Melt Date through Pour Date so you know which batches are actively happening. Orange from Pour through Cure End so you know what is sitting and waiting. Green after Label Date so you can see finished goods at a glance. Red on any Pending Ship Date that is within 2 days and still shows zero Units Sold this week. That red flag saved me from a bad review once where a customer got a candle that had barely cured.
Get the Full Details
What Most People Miss About Weekly Scheduling
Most candle makers plan their pours but forget that fragrance binding actually happens during the cure window, not when you first mix it in. If you pour a batch on Monday and label it Wednesday thinking it is ready, the scent throw will be weak for the first few uses. Customers notice. They come back saying the candle smells fine but not strong, and they are right. The binder hasn't fully integrated yet. Another thing nobody puts in their planner is the rework column. You will have rejected candles. Bad pours. Frosting issues. Cracking from cooling too fast. Every rejected unit eats into your materials for the next week, and if your planner doesn't account for a 10 to 15 percent waste buffer, you will run out of wax or fragrance mid-run and have to scramble. I add a Rework Estimate column that pulls 12 percent of the Batch Weight automatically. It is not exact, but it stops the unexpected shortages.
When a Weekly Planner Falls Apart
A fixed weekly layout breaks down if you are making custom orders that arrive at random times. A bride might want 50 lavender candles for a Saturday wedding and email you on Tuesday. Your planner assumes a steady cadence. Custom work shatters that. The workaround is to keep a rolling Projects tab where one-off orders go, separate from your core product schedule. Track them in the same columns but tag them as Custom, and when they ship, move the row to an Archive sheet at the bottom of the file. Never delete custom rows. You need the data for reorders and material cost analysis later. Also, the planner method assumes you are working alone or with one other person. If you have a small team, you need a shared column for Assignee so you know who is responsible for melting versus packaging. Two people pouring from the same schedule without a name assignment leads to duplicate batches or missed ones. It happens more often than you would think.
The Downside No One Talks About
Maintenance drag is real. A spreadsheet like this needs to be updated daily or it becomes useless within a month. I stopped using one because my phone battery died and I lost access to my main Google Sheet for three days during a run. Every pour date became guesswork. Now I keep a mirrored offline version on my laptop with local auto-save, and I print a single weekly view every Sunday night. The print takes two minutes. It shows only the current week. I clip it to a corkboard in my studio. Physical and digital backups together cover the failure modes that pure cloud or pure paper systems miss. If you want a downloadable template, search for a blank Google Sheets candle planner and import it, then strip it down to the columns above. Most available templates include useless fields like color theory notes or seasonal theme tags that you never update. Cut those. Keep only what drives the schedule. The fewer cells you fill, the more likely you are to actually fill them every week.
