🕯 Candle Order Form & Business Tracker — 5 Sheets. One Complete Order Management System.
Stop managing candle orders in WhatsApp and notebooks.
Track every order, every customer, and every dollar —
all in one spreadsheet built specifically for candle makers.
─────────────────────────────
📦 WHAT’S INCLUDED — 5 SHEETS
─────────────────────────────
🕯️ Sheet 1 — Candle Order Form
Take custom orders professionally.
– Candle name, scent, wax type & wick type
– Size, qty, unit price, discount & line total auto
– Customer details — name, email, phone & Instagram
– Delivery method — Shipping / Local Pickup / Digital
– Custom & personalisation details:
Label personalisation, scent strength, vessel preference,
lid, ribbon, colour & gifting message
– Terms & seller notes — production time, payment,
deposit, cancellation & allergy disclaimer
– Customer & seller signature fields
– Thank-You message footer
📋 Sheet 2 — Order Tracker
Every order status in one place.
– Order #, date, due date & customer name
– Candle name, size, qty & unit price
– Auto invoice total & balance due
– Deposit paid field
– Payment status color-coded
– Fulfillment & delivery tracking
– Order status — New, Curing, In Production,
Shipped, Completed, Cancelled
– Notes per order
– Totals row auto-summed
📊 Sheet 3 — Revenue & Sales Dashboard
See your business at a glance.
– Total orders, revenue & outstanding balance
– Completed orders & in production count
– Order status breakdown with total value
– Monthly sales tracker — 12 months
– Net revenue, refunds & avg order value
👥 Sheet 4 — Customer Directory
Build your loyal customer base.
– Customer name, email, phone & Instagram
– City / State
– Total orders & total spent — auto
– First & last order date
– Favourite scent
– VIP / Repeat / New status
– Notes per customer
💰 Sheet 5 — Candle Price List
Share with wholesale buyers or display at craft markets.
– Product name, scent & container
– COGS per product
– Retail price — set your own
– Wholesale price — auto at 60% of retail
– Stock availability notes
– Wholesale terms included:
MOQ, payment terms, lead time, shipping,
returns & custom label info
─────────────────────────────
✅ WHY CANDLE MAKERS LOVE THIS
─────────────────────────────
✔ Built specifically for candle makers
✔ Custom order form with personalisation fields
✔ Auto line totals, invoice total & balance due
✔ Color-coded order & payment status
✔ VIP & repeat buyer tracking
✔ Retail + wholesale price list included
✔ Revenue dashboard auto-pulls from order tracker
✔ Zero manual math — everything calculated
✔ Works on Excel & Google Sheets (free)
✔ Pre-filled with sample data
✔ Unlimited use — one purchase, forever
─────────────────────────────
📥 HOW TO GET STARTED
─────────────────────────────
1. Purchase & download the file instantly
2. Open in Google Sheets (free) or Excel
3. Add your business name & payment details
4. Fill in Order Form for each new customer
5. Track everything in Order Tracker & Dashboard
⚠️ Download via web browser only.
Not supported through the Etsy app.
Go to etsy.com/your/purchases to access your file.
─────────────────────────────
📌 FILE DETAILS
─────────────────────────────
– Format: .xlsx (Excel + Google Sheets compatible)
– Delivery: Instant Digital Download
– Use: Personal & commercial use for your own business
– Support: Message me anytime if you need help!
─────────────────────────────
💡 ALSO IN MY SHOP
─────────────────────────────
Need to price your candles profitably too?
Check out my Candle Pricing & COGS Calculator —
know your exact cost and price with confidence.
https://bizmindstudio.etsy.com/listing/4504850202/candle-pricing-cogs-calculator-6-sheets
Also available: Candle Business Invoice System —
send professional invoices to every customer.
https://bizmindstudio.etsy.com/listing/4504156508/candle-business-invoice-template-excel
─────────────────────────────
© BizMind Studio
For personal & commercial use within your own candle business.
Please do not resell or redistribute this file.
