What belongs in a vendor and trade directory?
Everything you would otherwise search your inbox for: who to call, what account number you have, what terms apply, how long things take, and what went wrong last time. Suppliers (who sell products) and trades (who do work on site) have different fields, so keep two databases.
Which properties does a Vendors database need?
| Property | Type | Notes |
|---|---|---|
| Vendor | Title | Company name |
| Category | Multi-select | Furniture, lighting, fabric, tile, stone, rugs, hardware |
| Contact | Text, email, phone | Rep name and direct line |
| Trade account | Text | Account number or login hint (never store passwords here) |
| Trade discount | Number | As agreed with the vendor |
| Payment terms | Select | Deposit up front, 50/50, on delivery, account |
| Typical lead time (weeks) | Number | Average, with notes |
| Minimum order | Text | If any |
| Showroom or sample policy | Text | How to request samples |
| Items | Relation | Everything you specified from them |
| Reliability | Select | Great, OK, Watch |
Never store passwords or card details in a shared directory. Use a password manager.
Which properties does a Trades database need?
| Property | Type | Notes |
|---|---|---|
| Name or firm | Title | Individual or company |
| Trade | Select | Carpenter, electrician, plumber, painter, upholsterer, installer |
| Contact | Text, email, phone | |
| Rate basis | Select | Day rate, hourly, quoted |
| Availability | Text or date | Next free window |
| Licence and insurance checked | Date | Check what your jurisdiction requires |
| Projects | Relation | Jobs they worked on |
| Rating and notes | Select, text | Quality, tidiness, timing |
Licensing and insurance requirements differ by place. Record the date you checked, not a claim that someone is compliant.
How do you keep reliability ratings honest?
Ratings drift into gut feel unless tied to events. After each delivered PO or finished job, set Reliability and add a one-line note: delivered on time, short by one chair, damaged crate. Then use rollups to show the number of orders and how many arrived late.
- On Purchase Orders, add a formula: late if actual delivery is after expected delivery.
- On Vendors, roll up orders count and late count.
- Add a formula: late percentage.
- Review vendors with a high late rate before the next specification.
Which views make the directory useful?
- By category: gallery or table grouped by Category, for sourcing.
- Open orders: Vendors with open POs, for chase calls.
- Needs review: Reliability = Watch.
- Account setup: vendors where Trade account is empty but you have ordered, to fix gaps.
- On-site contacts: Trades filtered to the active project, shareable with the contractor.
How do you seed the directory quickly?
- 1
Start with your last three projects
Add every vendor and trade you used.
- 2
Import from a spreadsheet
Notion can import CSV into a database.
- 3
Fill in only the five essentials
Contact, category, terms, lead time, account.
- 4
Add the rest as you order
Details appear when you need them.
Where InteriorDesignOS fits
InteriorDesignOS includes a Vendors section next to Selections, and its projects table records a contractor per project. Reliability scoring and a separate on-site trades database are additions you can build with the properties above.
Frequently asked questions
- How do I organise suppliers in Notion?
- Use a Vendors database with category, contact, trade account, terms and lead time, and relate it to items and purchase orders so order history appears on each vendor.
- Should vendors and contractors be in the same database?
- Separate them. Suppliers sell products and need terms and lead times; trades do site work and need rates, availability and insurance checks.
- Can I store trade account logins in Notion?
- Avoid it. Store the account number if needed, and keep passwords in a password manager.
- How do I import my existing supplier list?
- Export it as CSV from your spreadsheet and import it into a Notion database, then change property types as needed.
- Can I share the directory with my team?
- Yes, by sharing the page or workspace with team members. Limit guest access to pages that contain only what they need.
Sources
Keep reading
- Studio workflowsPurchase orders and procurement tracking for interior designers in NotionTrack purchase orders from approval to delivery in Notion: PO fields, deposit and balance, delivery checks, damage claims and a chase list for late orders.4 min read · 27 October 2026
- Interior designTracking vendor lead times in interior design projects with NotionStop late deliveries: track vendor lead times in Notion with order-by dates, supplier-confirmed dates, delay flags and views that show what to chase today.3 min read · 17 October 2026
- Studio workflowsFF&E budget tracking in Notion: columns, status flow and roll-upsThe exact FF&E schedule columns, a status flow from proposed to installed, and the roll-up formulas that show budget versus committed spend in Notion.4 min read · 27 October 2026
- Running a practiceNotion for interior designers: the complete guide to running your studioHow interior designers use Notion: projects and rooms, selections and FF&E, mood boards, client approvals, procurement, budgets and a weekly studio routine.4 min read · 17 October 2026