Build guide
Bespoke Perfumer Studio OS
Olfactory pyramid formulation books, raw essential oils stock, sensory client nose files, IFRA allergen audits, and maceration calendars — built on the Universal Base.
For: Tailors, cobblers, jewellers, furniture makers, restorers, bike builders, potters and custom workshops
- Linked databases
- 10
- Connections
- 9
- Automatic calculations
- 14
- Ready-made views
- 25
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, Fragrance Formulation Ledger, Raw Aromatics & Solvents Inventory, Client Nose & Sensory Profiling, IFRA Safety & Allergen Compliance, Maceration & Aging Logs
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
Fragrance Formulation Ledger
A precision laboratory book for fragrance formulation. Catalog complete olfactory pyramids, track ingredient drop counts and weights in grams, calculate compound concentrations, and monitor batch maceration progress.
7 fields · linked to Commissions
Views: Olfactory Family Board, Maturation Tracker Table, By Concentration Tier
Raw Aromatics & Solvents Inventory
A micro-inventory database for delicate perfumery raw materials. Catalog essential oils, absolutes, synthetic aroma chemicals, and solvents, tracking extraction methods and cold storage requirements.
7 fields · linked to Commissions
Views: Cold Storage Inventory, Supplier & Botanical Sourcing, By Compound Category
Client Nose & Sensory Profiling
A luxury customer relationship database for bespoke fragrance services. Profile customer olfactory memories, preferred scent notes, rejected notes, and track skin patch test safety warnings.
7 fields · linked to Commissions
Views: Allergy Warning Dashboard, Sensory Profile Master List
IFRA Safety & Allergen Compliance
A regulatory compliance catalog to monitor restricted aromatics according to International Fragrance Association (IFRA) limits, calculate maximum allergen ratios, and ensure safe skin exposure.
7 fields · linked to Commissions
Views: Allergen Hazard List, Reformulation Alerts, By Compliance Status
Maceration & Aging Logs
A laboratory calendar and record book for fragrance aging. Track maceration weeks of fragrance oil in alcohol base, monitor vault temperature, log clarification checks, and schedule final filtration dates.
7 fields · linked to Commissions
Views: Ready for Filtration Queue, Vault Temperature Log, By Clarification Check
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 Bespoke Perfumer Studio OS →