Notion Inventory Template for Small E-commerce Businesses

If you’re running a small e-commerce business, you know the pain of losing track of stock levels in a spreadsheet jungle. You need something more flexible than Excel but less complicated (and expensive) than dedicated inventory software.

A Notion inventory template gives you real-time stock tracking, automatic low-stock alerts, and the ability to link products to suppliers and orders—all without a monthly subscription. In this guide, you’ll learn how to build one from scratch and customise it for your business.

Why Use Notion for Inventory Management?

Notion isn’t purpose-built inventory software, but for small e-commerce businesses selling 50–500 SKUs, it hits a sweet spot. You get databases with custom properties, formulas, and relations—enough power to track stock without the bloat of enterprise systems.

Here’s what makes Notion work for inventory:

• No per-user fees: Unlike dedicated inventory tools, Notion charges per workspace, not per team member
• Flexible structure: Add custom fields for anything—batch numbers, expiry dates, warehouse locations
• Relations and rollups: Link inventory to suppliers, purchase orders, and sales in one workspace
• Mobile access: Check stock levels and update counts from your phone or tablet

If you’re already using Notion for other parts of your business, adding inventory management keeps everything in one place. Check out our Notion dashboard ideas to see how inventory fits into a broader business workspace.

What to Include in Your Notion Inventory Template

Before you start building, decide which data points matter for your business. A basic inventory database needs at least six core properties, but you’ll likely add more as you grow.

Essential Properties for Every Inventory Template

SKU (Text): Your unique product identifier. Keep it short and consistent—use a format like CAT-SHIRT-BLU-M for category, product, colour, size.

Product Name (Title): The main field visitors see. Make it descriptive but concise.

Current Stock (Number): How many units you have right now. Update this after every sale and delivery.

Reorder Point (Number): The stock level that triggers a reorder. Set this based on lead time and sales velocity.

Unit Cost (Number): What you pay per item. Use this to calculate total inventory value.

Supplier (Relation): Link to a separate Suppliers database so you can see all products from one vendor.

Useful Optional Properties

• Category (Select): Group products by type—Apparel, Accessories, Electronics
• Location (Select): Track which warehouse or shelf holds each item
• Selling Price (Number): Your retail price, useful for profit margin calculations
• Last Restocked (Date): When you last received stock, helpful for spotting slow movers
• Status (Select): Options like In Stock, Low Stock, Out of Stock, Discontinued
• Image (Files & Media): Upload a product photo for quick visual reference

If you’re tracking multiple projects or teams in Notion, understanding relations and rollups will help you link inventory data to sales orders, customer records, and supplier information.

How to Build a Notion Inventory Template Step-by-Step

You can build a working inventory system in Notion in under 30 minutes. Follow these steps to create the database and add the logic that keeps your stock counts accurate.

Step 1: Create the Inventory Database

Open Notion and create a new page. Give it a name like “Inventory Management” or “Stock Tracker.”

Type /table and select “Table – Inline”. This creates a database that lives on the current page. Rename the default “Name” column to “Product Name.”

Add your core properties: Click the + icon in the table header to add new columns. Set up SKU (Text), Current Stock (Number), Reorder Point (Number), Unit Cost (Number), and any optional fields you need.

Step 2: Add a Low Stock Formula

Create a new property called “Stock Status” and set the type to Formula. This will automatically flag items that need reordering.

Enter this formula:

if(prop("Current Stock") <= prop("Reorder Point"), "🔴 Low Stock", if(prop("Current Stock") == 0, "⚠️ Out of Stock", "✅ In Stock"))

Now every row shows a visual indicator. Sort your table by Stock Status to see urgent items at the top.

Step 3: Calculate Total Inventory Value

Add another Formula property called "Total Value". This multiplies current stock by unit cost.

Use this formula:

prop("Current Stock") * prop("Unit Cost")

Format the result as a number with two decimal places. At the bottom of the column, Notion can show the sum of all values—your total inventory worth.

Step 4: Create a Suppliers Database and Link It

Create a new database page called "Suppliers". Add columns for Supplier Name, Contact Email, Lead Time (days), and Payment Terms.

Go back to your Inventory database and add a Relation property. Select "Suppliers" as the target database. Now you can link each product to its supplier.

Optional: Add a Rollup to see supplier lead time in your inventory table. This helps you set smarter reorder points. If you're new to this feature, our guide on Notion relations and rollups explains it in detail.

Step 5: Build Filtered Views for Quick Access

Create a view that shows only low-stock items. Click "Add a view" at the top of your database, choose Table, and name it "Low Stock." Add a filter: Stock Status contains "Low Stock."

Create category views if you sell different product types. Add filters like Category is Apparel or Location is Warehouse A. This makes it faster to count stock during physical audits.

Set up a "Recently Restocked" view. Filter by Last Restocked is within the past 7 days. This helps you spot delivery errors early.

How to Keep Your Notion Inventory Updated

A template is only useful if the data stays current. Here's how to build habits that keep your stock counts accurate without constant manual entry.

Update Stock After Every Sale

Subtract units from Current Stock immediately after an order ships. If you use Shopify, WooCommerce, or another platform, export daily sales reports and update Notion in a batch at the end of each day.

For higher volumes, consider using automation tools like Zapier or Make to sync sales data into Notion automatically. Note that Notion's API limits may apply if you're processing hundreds of transactions daily.

Log Incoming Deliveries

Add a "Stock Adjustments" database to track deliveries and corrections. Include fields for Date, Product (Relation), Quantity Added, and Reason (Delivery, Return, Damage, etc.).

When stock arrives, create an entry in Stock Adjustments, then update the Current Stock field in your main inventory. This audit trail helps you spot discrepancies during physical counts.

Schedule Weekly Stock Reviews

Set a recurring task to review your Low Stock view every Monday. Place purchase orders for items below the reorder point, and adjust reorder points if you're consistently running out or overstocking.

If you're managing recurring tasks in Notion, our guide to recurring tasks and SOPs shows you how to automate reminders.

Advanced Features for Growing E-commerce Businesses

Once your basic inventory system is running, these additions help you scale without switching to enterprise software.

Track Inventory Across Multiple Locations

Add a Location property (Select) with options like Warehouse, Retail Store, Consignment. Create separate views for each location so staff can see only relevant stock.

If you have multiple warehouses, consider duplicating your inventory database and using relations to show total stock across all locations. This gets complex—evaluate whether you've outgrown Notion before building elaborate workarounds.

Link Inventory to Sales and Purchase Orders

Create a Sales Orders database with fields for Order Number, Customer, Date, and Status. Add a Relation to your Inventory database so each order links to the products sold.

Use a Rollup to calculate order totals automatically. This connects your inventory management to sales tracking without duplicate data entry.

For purchase orders, create a similar database that links to Suppliers and Inventory. When a PO arrives, update your Current Stock and mark the order complete.

Set Up Low-Stock Notifications

Notion doesn't have built-in alerts, but you can use its reminders feature as a workaround. In your Low Stock view, add a Date property called "Reorder By" and set reminders manually.

Alternatively, use Zapier to send you a weekly email or Slack message listing all low-stock items. This requires a paid Zapier plan and some setup time, but it's more reliable than checking Notion daily.

Calculate Inventory Turnover Rate

Track units sold per product in a separate field or database. Calculate turnover with a formula: Units Sold (period) ÷ Average Inventory.

High turnover means you're selling through stock quickly (good), while low turnover suggests overstocking or slow-moving products. If you're tracking other business metrics, see our list of top KPIs for small businesses to add context.

When to Customise or Replace Your Notion Inventory Template

Notion's flexibility is a strength, but it's not infinite. Here's when to customise further—or consider dedicated inventory software.

Customise When...

• You add new product lines: Duplicate your existing structure and adjust properties for each category
• You hire team members: Use Notion's permissions to control who can edit stock counts vs view-only access
• You expand to multiple sales channels: Add a Channel property (Select) to track inventory by platform—Website, Amazon, Etsy

Our guide on how to customise a Notion template in 15 minutes walks you through quick adjustments without breaking your setup.

Consider Dedicated Software When...

• You're managing 500+ SKUs: Notion databases slow down with thousands of entries
• You need barcode scanning: Notion's mobile app doesn't integrate with scanners
• You require real-time multi-channel syncing: Tools like Cin7 or Unleashed handle this natively
• You're doing complex manufacturing: Bill of materials, work orders, and production tracking need specialised features

For businesses between 50–500 SKUs with straightforward inventory needs, Notion usually offers enough functionality without the monthly cost of dedicated platforms.

Combining Inventory with Other Notion Workspaces

The real power of a Notion inventory template comes when you connect it to other parts of your business. Here's how to integrate inventory into a larger workspace.

Link to a CRM for Customer Orders

If you're using a Notion CRM template, add a relation from your Deals or Orders database to Inventory. When a customer places an order, link the products sold and Notion can automatically show stock availability.

This is especially useful for B2B e-commerce where customers ask about stock before ordering.

Connect to a Product Roadmap

For businesses launching new products, link your Inventory database to a product roadmap template. Track when new SKUs launch, initial stock quantities, and marketing timelines in one place.

This prevents the common mistake of announcing a product launch before inventory arrives.

Integrate with Project Management

If you're using Notion for agile project management, add inventory tasks to your sprint board. For example, "Audit warehouse stock" or "Place Q1 bulk order" can live alongside development tasks.

For teams running sprints, tools like Scrum Board PRO offer a complete agile system in Notion with sprint planning, backlogs, and meeting notes—useful if you're coordinating product development with inventory decisions.

Free vs Paid Notion Inventory Templates

You can build a functional inventory template from scratch in Notion for free. However, pre-built templates save setup time and often include features you might not think to add yourself.

What You Get with Free Templates

Most free Notion inventory templates available online include a basic database with SKU, stock levels, and reorder points. They're a good starting point if you're new to Notion or have simple needs.

Limitations: Free templates rarely include supplier relations, purchase order tracking, or advanced formulas. You'll need to customise them yourself, which takes time if you're not familiar with Notion's features.

When Paid Templates Are Worth It

Paid templates (typically $10–$50) usually offer more complete systems: linked suppliers, stock adjustment logs, automated alerts, and instructions for customisation. They're worth the cost if setup time matters more than budget.

Before buying, check if the template includes documentation and whether the seller offers support. Some creators provide lifetime updates, while others sell one-time downloads with no follow-up.

Common Mistakes to Avoid with Notion Inventory Templates

Even with a solid template, these errors can break your system or make it frustrating to use.

Not Updating Stock in Real Time

The biggest mistake is treating Notion like a static report. If you only update stock levels weekly, you'll make decisions based on outdated data—leading to overselling or emergency reorders.

Set a rule: update Current Stock within 24 hours of every sale or delivery. If that's not realistic for your volume, Notion might not be the right tool.

Overcomplicating Your Properties

Don't add fields "just in case." Every extra column makes your database slower to load and harder to scan. Start minimal and add properties only when you actually need them.

If you're debating whether a field is necessary, skip it for now. You can always add it later when the need becomes clear.

Ignoring Mobile Access

Test your template on a phone or tablet before relying on it. Some Notion formulas and views work fine on desktop but are clunky on mobile. If you're doing stocktakes in a warehouse, mobile usability matters.

Forgetting to Back Up Your Data

Export your Notion workspace monthly as HTML or Markdown. While Notion is reliable, having a local backup protects you if your account is compromised or if Notion experiences downtime during a critical reorder period.

Alternatives to Notion for Inventory Management

Notion is flexible and affordable, but it's not the only option. Here's when you might choose something else.

Google Sheets

Best for: Tiny businesses with under 50 SKUs who need real-time collaboration and don't want to learn a new tool.

Drawbacks: No relations between tables (without complex VLOOKUP formulas), limited mobile experience, and harder to build a unified workspace with CRM and project management.

Airtable

Best for: Businesses that need more database power than Notion but less complexity than enterprise software. Airtable has better automation, more formula functions, and faster performance with large datasets.

Drawbacks: More expensive than Notion (starts at $20/user/month), steeper learning curve, and less intuitive for non-technical users.

Dedicated Inventory Software

Best for: High-volume e-commerce (500+ SKUs), multi-channel selling, barcode scanning, or manufacturing workflows.

Options: Zoho Inventory (free for small volumes), inFlow, or Cin7. These tools offer features Notion can't match but cost $50–$200+ per month.

If you're comparing Notion to other project management tools for your broader business needs, check out our comparisons: Notion vs ClickUp for kanban boards and Notion vs Jira for small teams.

Final Tips for Running Inventory in Notion

Start simple and iterate. Build a basic database first, use it for a week, then add complexity based on what you actually need. Trying to design the perfect system upfront usually leads to over-engineering.

Document your process. Write a quick guide—even just bullet points—on how to update stock, when to reorder, and what each property means. This helps when you onboard team members or forget your own system six months later.

Review and clean your data monthly. Archive discontinued products, delete duplicate entries, and check that your reorder points still make sense. A cluttered database slows you down and hides important information.

If you're managing multiple Notion systems across your business, visit our Notion templates hub for more practical guides and ready-to-use setups.

Frequently asked questions

Can Notion handle inventory for a growing e-commerce business?

Notion works well for small e-commerce businesses managing up to 500 SKUs with straightforward inventory needs. Beyond that, you may experience slower database performance and will likely need dedicated inventory software with features like barcode scanning and real-time multi-channel syncing. Check Notion's performance with your data volume before committing.

How do I prevent overselling when using Notion for inventory?

Update your Current Stock field immediately after each sale—ideally within 24 hours. Create a Low Stock view with filters to flag items at or below reorder points, and review it daily. For higher volumes, consider using Zapier or Make to sync sales data from your e-commerce platform into Notion automatically, though this requires a paid automation plan.

Can I track inventory across multiple warehouse locations in Notion?

Yes. Add a Location property (Select type) to your inventory database with options for each warehouse or storage area. Create filtered views for each location so staff can see only relevant stock. For businesses with complex multi-location needs, you may need to create separate databases for each location and use relations to calculate total stock across all sites.

Does Notion integrate with Shopify or WooCommerce for automatic inventory updates?

Notion doesn't have native integrations with e-commerce platforms. You can use third-party automation tools like Zapier or Make to connect Shopify, WooCommerce, or other platforms to Notion and sync inventory data automatically. This requires a paid plan on the automation platform and some setup time. For high-volume stores, manual or batch updates may be more practical.

What's the difference between a free and paid Notion inventory template?

Free Notion inventory templates typically include basic databases with SKU, stock levels, and reorder points but require customisation to add supplier relations, formulas, and purchase order tracking. Paid templates (usually $10–$50) offer more complete systems with documentation, advanced formulas, and linked databases for suppliers and orders, saving you setup time if you're new to Notion.

How do I back up my Notion inventory data?

Go to Settings & Members in your Notion workspace, then Export All Workspace Content. Choose HTML or Markdown format and download the file to your computer. Do this monthly to protect your inventory data in case of account issues or service downtime. Store backups in a separate location like Google Drive or Dropbox.