Running an ecommerce business generates an operational complexity that most sellers underestimate until they are inside it. Orders need to be tracked from purchase through fulfilment through delivery. Inventory needs to be monitored across multiple suppliers and product variants. Customers need to be managed — returns, refunds, loyalty, repeat purchase rates. Financial performance needs to be visible across multiple platforms and marketplaces simultaneously. And all of this is typically managed in a combination of the platform’s native dashboard, a spreadsheet, a Gmail inbox, and an increasingly unreliable memory.
The Ecommerce Business Management System template consolidates that operational layer into one connected Notion workspace. This is a full review of what it contains.
The Ecommerce Business Management System template is available at createdigitaltools.com. You need a free Notion account to duplicate it. The template is built for product-based businesses selling on any combination of platforms — Shopify, Amazon, Etsy, WooCommerce, TikTok Shop, or direct-to-consumer.
The Ecommerce Operations Problem
Every ecommerce seller reaches a point where the platform’s native dashboard is no longer enough. Shopify tells you what sold today. It does not tell you which products are approaching reorder point, which suppliers have the longest lead times, which customer segments have the highest repeat purchase rate, or how your margins compare across product lines when fulfilment costs are factored in. Answering those questions requires exporting data, building spreadsheets, and spending time on analysis that should be automatic.
A Notion ecommerce management system does not replace Shopify or Amazon. It sits alongside them — providing the strategic and operational layer that platform dashboards do not offer: connected databases where supplier lead times connect to inventory reorder decisions, where customer purchase history connects to segmentation, and where product-level profitability is calculated automatically without a monthly spreadsheet exercise.
The Architecture: Seven Connected Databases
Seven databases: Products, Inventory and Suppliers, Orders, Customers, Returns and Refunds, Marketing Campaigns, and Financial Performance. The Products database is the primary hub — every other database connects back to it through Relation properties, so opening any product record reveals its complete operational picture: current stock levels, linked supplier, recent orders, customer purchase history, and margin data.
The Products Database
One row per product or SKU. Properties: Product Name, SKU (text), Category (Select), Platform (Multi-Select — where this product is sold), Status (Select: Active, Paused, Discontinued, Coming Soon), Cost Price, Sale Price, Profit Margin (formula: Sale Price minus Cost Price divided by Sale Price multiplied by 100), Supplier (Relation), Stock Level (Rollup from Inventory database), Reorder Point (number), and Reorder Alert (formula: true when Stock Level is less than or equal to Reorder Point).
The Reorder Alert formula is the property that makes the Products database operationally useful rather than just a catalog. The Needs Reorder view — filtered to Reorder Alert equals true — shows every product below its reorder threshold in one place. Checking this view three times a week eliminates stockouts caused by oversight. The same view filtered further by Supplier groups reorder needs by supplier — enabling consolidated purchase orders rather than separate orders per product.
The Products database in the Ecommerce Business Management System uses the same Rollup and Formula architecture described in Post 2 of this series — Notion Databases Explained. If the reorder alert formula or the margin calculation are not immediately clear, that post covers the mechanics in detail. The template implements them in a production context; the post explains how they work from first principles.
The Inventory and Suppliers Database
Two linked databases: Inventory (one row per stock movement — purchase, adjustment, return) and Suppliers (one row per supplier). The Inventory database tracks every stock change with Date, Type (Purchase, Adjustment, Return, Write-Off), Quantity, Unit Cost, and a Relation to the Product it affects. The current stock level for any product is a Rollup summing all positive inventory entries minus all negative entries — always accurate because it is calculated from the actual history rather than manually updated.
The Suppliers database has Supplier Name, Lead Time (number, in days), Minimum Order Quantity, Payment Terms, and a Rollup showing all products sourced from each supplier. The Lead Time property connects to the Reorder Point calculation in the Products database — a product sourced from a supplier with a thirty-day lead time needs a higher reorder point than one with a five-day lead time. The data to make that calculation correctly is in the system rather than in someone’s memory.
The Orders Database
One row per order. Properties: Order ID, Customer (Relation), Products Ordered (Relation — multi-item orders link to multiple product records), Platform (Select), Order Date, Status (Select: Processing, Fulfilled, Shipped, Delivered, Cancelled, Refunded), Shipping Method, Revenue, and Fulfilment Date. The In Progress view — filtered to Status equals Processing or Fulfilled — shows the current fulfilment queue. The By Platform view groups orders by selling platform with Sum calculations showing revenue per channel — the data that informs which platforms are worth maintaining and which are generating insufficient volume to justify the management overhead.
The Customers Database
One row per customer. Properties: Name, Email, Platform (where they originally purchased), Total Orders (Rollup from Orders database), Total Spent (Rollup), Average Order Value (formula: Total Spent divided by Total Orders), First Purchase Date, Last Purchase Date, Days Since Last Purchase (formula), Customer Segment (Select: New, Returning, VIP, At Risk, Lapsed), and Notes.
The Customer Segment property powers the marketing segmentation views. The At Risk view — filtered to Segment equals At Risk, which is typically defined by Days Since Last Purchase between sixty and one-hundred-and-twenty — shows customers who purchased once and have not returned, the group most likely to be reactivated with a well-timed offer. The VIP view shows the top-tier customers by Total Spent — the relationships worth managing personally rather than through automated sequences.
Returns, Marketing, and Financial Performance
The Returns database tracks every return and refund with Reason (Select: Defective, Wrong Item, Changed Mind, Damaged in Transit, Not as Described), Resolution (Refund, Exchange, Store Credit), and Cost. Rollup properties on the Products database sum total returns and total return cost per product — the return rate view sorts products by return percentage descending, immediately surfacing products with quality or description problems before they become review or platform penalty issues.
The Marketing Campaigns database tracks each campaign with Platform, Type, Budget, Spend, Revenue Attributed, ROAS (formula: Revenue Attributed divided by Spend), and Status. The Financial Performance database provides a monthly P and L view: Revenue (Rollup from Orders), Cost of Goods Sold (Rollup from Inventory purchases), Gross Profit, Operating Expenses (manual entry), and Net Profit (formula). All automatically calculated. No monthly spreadsheet required.
Ecommerce sellers who also manage freelance or consulting work alongside their product business will find that the Ecommerce Business Management System connects naturally to the Freelance Management System template in the same Notion workspace — the Financial Performance database from ecommerce and the income tracking from freelance work combine into a consolidated business income view without maintaining two separate financial dashboards.
Setting Up for Your Store
After duplicating the template, begin with the Suppliers database — add every current supplier with their lead times and payment terms. Then add your products to the Products database linked to their suppliers. Then add a representative sample of recent orders and customers. The dashboard begins reflecting your real business within the first hour of setup. Add inventory movements and marketing campaign data as they happen going forward — the historical picture builds automatically.
The Ecommerce Business Management System template is available at createdigitaltools.com. Start with a free Notion account and have a connected ecommerce operations system running from day one — rather than piecing one together from spreadsheets six months into running your store.
Disclosure: This post contains affiliate links. If you sign up for Notion through the links in this post, we may earn a small commission at no extra cost to you. The Ecommerce Business Management System is our own product.
0 Comments