Separate materials from products
Keep wax, fragrance, vessels, wicks, labels, and packaging as materials; keep finished candles as products.
Candle inventory spreadsheet
Candle inventory spreadsheet structure for wax, fragrance, vessels, and finished goods
Use this structure to clean up a candle inventory spreadsheet before importing the pieces into Mavenory.
What Mavenory tracks
- Wax by weight
- Fragrance by volume or weight
- Wicks and vessels by piece
- Labels and boxes
- Finished candle stock
- Recipe yield
Make recipes explicit
Each candle recipe should list exact material quantities, batch yield, labor, overhead, and expected waste.
Track reorder signals
Add reorder levels and supplier lead time so low stock becomes a buying decision, not a surprise.
FAQ
Common questions
Should finished candles and wax be on the same tab?+
They can be in one workbook, but keeping products and materials as separate tables makes import and COGS cleaner.
Can Mavenory choose an Excel sheet during import?+
Yes. The importer lets you choose which sheet to load from an Excel workbook.