Build guide
Aromatherapy & Handmade Candle Atelier OS
Scent recipe catalogs, pouring and curing batch production logs, bulk client order sheets, essential oil material LOT trackers, and supplier directories — built on the Universal Base.
For: Tailors, cobblers, jewellers, furniture makers, restorers, bike builders, potters and custom workshops
- Linked databases
- 9
- Connections
- 8
- Automatic calculations
- 14
- Ready-made views
- 23
What it saves you
- Each commission totals its logged hours and material cost into a real job cost
- Profit per job is calculated from quote minus labour and materials
- Balances still owed after deposits are listed in one view
- Jobs close to their promised date are flagged before they are late
How the parts work together
- Quote: Add the customer → Create a commission with specs, quote and promised date
- Make: Record the deposit → Log hours in the work log → Record materials drawn in material use
- Hand over: Move to Ready to collect → Record the final payment → Check profit in "Job profitability"
Databases inside
Commissions
Every custom job from enquiry to collection, with quote, deposit and promised date. Labour and material costs roll up from the logs.
16 fields · 8 calculated automatically · linked to Customers, Work Log, Material Use, Scent Formula & Recipe Book, Pouring & Batch Production Log, Atelier Client Custom Orders, Material LOT & Safety Tracker
Views: Job board, At risk, Balances owed, Job profitability, Due dates
Customers
Private and trade customers with contact details and lifetime value from their commissions.
7 fields · 2 calculated automatically · linked to Commissions
Views: All customers
Work Log
Hours spent per job and person. Labour value uses the hourly rate so job costing needs no maths.
7 fields · 1 calculated automatically · linked to Commissions
Views: This week, All entries
Materials
Timber, leather, metals, fabric and hardware with stock and cost per unit. Low stock flags itself.
7 fields · 1 calculated automatically · linked to Material Use
Views: Low stock, All materials
Material Use
Materials drawn from stock for each job. Cost = quantity x the material's unit cost, and it rolls up into job costing.
6 fields · 2 calculated automatically · linked to Commissions, Materials
Views: By job
Scent Formula & Recipe Book
A precision catalog for candle makers to lock in wax blends, essential oil percentages, wick configurations, and temperature controls.
9 fields · linked to Commissions
Views: Recipe Catalog, Formulation Table, By Product Type
Pouring & Batch Production Log
A production board to log melting batches, monitor exact temperature measurements, track curing countdowns, and manage workshop shelf inventory.
8 fields · linked to Commissions
Views: Curing Pipeline, Shelf Inventory, By Container Type
Atelier Client Custom Orders
A pipeline database for tracking wedding favors, corporate gifts, private-label branding runs, custom label graphics, and event payment splits.
9 fields · linked to Commissions
Views: Order Pipeline, Bulk Orders Calendar, By Order Status
Material LOT & Safety Tracker
Maintain safety registers for chemical and cosmetic formulation: trace essential oil LOT numbers, wax shipments, organic labels, and Safety Data Sheets (SDS) for trade compliance.
9 fields · linked to Commissions
Views: Audit Batch Log, Raw Materials Expiry, By Status
You get the finished workspace, not homework.
Buy it once for $29 or get it with your membership, then duplicate it into Notion with every field, link, formula, view and example row already set up.
See Aromatherapy & Handmade Candle Atelier OS →