Notion Tutorial: Build a Personal CRM in 10 Steps

Written by

in

TL;DR: Build a Notion CRM to track porcelain supplier interactions, sample requests, and order histories by linking database entries for seamless inventory management. This system ensures you maintain detailed records of glaze preferences and shipping costs for every ceramic vendor.

Step 1: Create a New Database

Open your Notion workspace and click on “New Page.” Select the “Database” option and choose “Table view.” Name this database “Porcelain Vendor CRM.” This central hub will store all your interactions with suppliers of raw clay bodies, glaze materials, and finished ceramic ware.

If you want to dig deeper, check out our guide on Apple Watch Series 10 Review: Is the Titanium Case Worth It?.

Step 2: Define Core Properties

Click the plus icon to add properties. Start with “Vendor Name” as a text property. Add “Primary Contact” as another text field. Include “Specialty” as a select property with options like “White Clay,” “Stoneware,” or “Glaze Mixes.” This categorization helps you quickly filter vendors based on the specific type of porcelain material you need for your current project.

Step 3: Add Financial Details

Porcelain procurement often involves bulk discounts. Add a “Min. Order Value” number property to track minimum purchase requirements. Include a “Currency” select property if you source internationally. Finally, add a “Payment Terms” select property with options like “Net 30” or “Prepaid.” This ensures you are always aware of cash flow implications when ordering high-quality porcelain materials.

Step 4: Link to Product Database

For a robust CRM, you need to connect vendors to specific products. Create a separate database called “Porcelain Products.” Add a “Relation” property in the Vendor CRM that links to this product database. This allows you to see exactly which vendors supply which specific clay bodies or glaze recipes, creating a comprehensive map of your supply chain.

Step 5: Track Interactions

Add a “Last Contact” date property. Use a “Rollup” property to pull the latest interaction date from a separate “Notes” database if you prefer granular tracking. Alternatively, use a simple “Status” select property with options like “Active,” “Negotiating,” or “Inactive.” This keeps your vendor list clean and prioritizes active relationships.

Step 6: Implement Quality Ratings

Porcelain quality can vary significantly between batches. Add a “Quality Score” number property ranging from 1 to 5. Use this to rate the consistency of the clay body or the color stability of the glaze. This metric helps you identify reliable partners who deliver consistent results for your production needs.

Step 7: Create a Kanban View

Switch the view to “Board” or “Kanban.” Group cards by the “Status” property. This visual layout helps you see which vendors are currently in negotiation stages versus those who are ready for immediate ordering. Dragging cards between columns provides a quick way to update the status of your porcelain supply relationships.

Step 8: Automate Reminders

Use Notion’s “Button” feature to create quick actions. Create a button that adds a new entry to your “Notes” database with a pre-filled template asking about new clay body availability or price changes. This simplifies the process of logging communication and ensures no important details about material specifications are forgotten.

Step 9: Build a Dashboard

Create a parent page titled “Porcelain Sourcing Dashboard.” Embed the Vendor CRM and Product databases here. Add a “Chart” block to visualize spending by vendor or category. This high-level view helps you analyze trends in pricing for raw porcelain materials and identify opportunities for cost savings or better terms.

Step 10: Regular Review Cycle

Set a recurring reminder to review your CRM every month. Check for vendors who have not been contacted in three months and update their status. Verify that all product links are accurate and that quality scores reflect recent experiences. Cons

Related Articles

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *