notion

How to run your entire ecommerce store from Notion — product management, supplier tracking, orders, and finances in one workspace.

# build your store in notion

Notion works well as an ecommerce operations hub because everything links together. A supplier record links to purchase orders; a product links to its supplier, variants, and pricing history. You get a relational database without the complexity of a full ERP.

what you need

A Notion account on any plan works. The free plan supports unlimited pages and databases for a single user. If you're working with a team, the Plus plan ($10/month) is worth it for collaborative editing and permission controls.

the core databases

// database 01 products

SKU, name, category, status, cost price, sell price, margin %, supplier (relation), images, notes

// database 02 suppliers

name, contact, lead time, MOQ, payment terms, country, active products (rollup), notes

// database 03 orders

order ID, platform, date, status, customer, line items (relation), total, tracking, fulfilment date

// database 04 purchase orders

PO number, supplier (relation), products (relation), quantity, cost, status, expected delivery

// database 05 marketing calendar

campaign name, platform, start/end dates, budget, status, linked products (relation), notes

// database 06 finances

month, revenue, COGS, ad spend, platform fees, shipping costs, net profit, margin %

how they connect

Products → Suppliers (relation + rollup for active count). Orders → Products (relation + rollup for revenue per product). Purchase Orders → Suppliers + Products. Once linked, Notion formulas handle margin calculations and rollup properties aggregate totals automatically.

# setup checklist

Follow this order to avoid re-linking databases after the fact.

create a new workspace or pageKeep the store hub separate from personal notes. One top-level page named "store operations".

create the suppliers database firstBuild this before products so you can immediately add the supplier relation when creating products.

create the products databaseAdd a relation to Suppliers. Add a formula property for margin: (Sell Price - Cost) / Sell Price * 100.

add a rollup to suppliersGo back to Suppliers → add rollup property → relation: Products → count all → rename "Active Products".

create purchase orders databaseAdd relations to both Suppliers and Products. Add a Select property for status: Draft / Sent / Confirmed / Received / Cancelled.

create the orders databaseAdd platform (Select: Shopify / Etsy / Amazon / Direct), status (Select: New / Packed / Shipped / Delivered / Returned), relation to Products.

create the finances databaseOne entry per month. Add formula properties for gross margin % and net margin %. Link to orders via rollup for revenue.

create the marketing calendarUse a calendar view as the default. Add a Timeline view for campaign overlap visibility. Link campaigns to products.

build a home dashboard pageEmbed linked views from each database (filtered to show only active/open items). Add a finance summary table at the top.

add your first real dataImport 5–10 real products, 2–3 suppliers, and last month's orders. Dummy data reveals gaps in the structure before you commit to it.

set up templates for recurring entriesCreate a Purchase Order template with pre-filled status = Draft, and an Orders template with status = New.

invite your team (if applicable)Notion Plus required for full collaboration. Set page permissions to "can edit" for operations team, "can view" for read-only access.

// etsy ecommerce operations hub — notion template Pre-built with all 8 databases, formulas, linked views, dashboard, and sample data. Duplicate and start using in 5 minutes.

$19 buy on etsy →