Candle Business Inventory Template
For candle makers tracking wax, fragrance oils, wicks and vessels alongside finished candles. See exactly which raw materials limit your next pour.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| CN-WAX-SOY-464 | Soy Container Wax, 10 lb | Wax | Pour Room Shelf 1 | bag | 6 | 3 | 24 | auto | auto | Golden Hive Candle Supply |
| CN-FO-CEDAR-16 | Cedar & Sage Fragrance Oil, 16 oz | Fragrance | Fragrance Rack | bottle | 4 | 2 | 21.5 | auto | auto | Aroma Works Supply |
| CN-VSL-AMB-8 | Amber Glass Jar 8 oz with Lid | Vessels | Back Shelf C | case of 12 | 9 | 4 | 14.4 | auto | auto | Clearwater Glass Containers |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Track fragrance oil in ounces and note your load percentage per scent so you can see how many candles each bottle still covers.
- Let finished candles cure before counting them as sellable; keep a cure-start date in the location or notes.
- Match wick size to vessel diameter in the SKU (e.g. WICK-CD12) so a vessel change never leads to the wrong wick.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template