How to Set Up Notion Database for Inventory Management With Stock Alerts

Managing inventory manually in spreadsheets often leads to missed stockouts and delayed reorders. Notion databases can track product quantities, set minimum stock thresholds, and send alerts when inventory runs low. This article explains how to build a Notion inventory system with automated stock alerts using database formulas and views. You will learn to configure the database structure, create a stock alert formula, and set up a notification workflow.

What the Notion Inventory Database Does and What You Need

A Notion inventory database stores product information and calculates whether stock is low. The system uses three core properties: a Number property for current stock, a Number property for the minimum stock threshold, and a Formula property that compares the two. When current stock is at or below the threshold, the formula displays a status like “Reorder” or “Low Stock.” You can then filter a database view to show only those items. No third-party integrations or paid Notion plans are required. The alert is visual within the database; Notion does not send email or push notifications natively. For external alerts, you will need to connect Notion to a service like Zapier or Make, which is covered in the limitations section.

Before building the database, gather your product list and decide the minimum stock level for each item. A minimum stock level is the quantity at which you want to reorder. For example, a product with a minimum stock of 10 triggers an alert when the current stock reaches 10 or fewer. You will also need a Notion workspace where you have edit permissions. No special account type is required.

Steps to Build the Inventory Database and Stock Alert Formula

1. Create a new Notion database
   Open Notion and navigate to the page where you want the inventory. Type / and select “Table – Inline” or “Table – Full page.” Name the database “Inventory.”
2. Add the product name property
   Click the “+” button in the header row. Select “Text” and name it “Product Name.” Enter each product name in a new row.
3. Add the current stock property
   Click the “+” button again. Select “Number” and name it “Current Stock.” In each row, enter the quantity you currently have on hand.
4. Add the minimum stock property
   Click “+” and select “Number.” Name it “Min Stock.” Enter the threshold quantity for each product. For example, 10 means you want to reorder when stock drops to 10 or fewer.
5. Create the stock alert formula
   Click “+” and select “Formula.” Name it “Stock Alert.” Click inside the formula editor and paste the following formula:
   if(prop("Current Stock") <= prop("Min Stock"), "Reorder", "OK")
   This formula checks if Current Stock is less than or equal to Min Stock. If true, it returns “Reorder.” If false, it returns “OK.” Click “Done” to save.
6. Add a unit property (optional)
   If you track units like “boxes” or “pounds,” click “+” and select “Select.” Name it “Unit.” Add options such as “Units,” “Boxes,” “Pounds,” or “Cases.” This property is informational and does not affect the alert.
7. Create a filtered view for low stock
   Click the “+” tab next to the current view name at the top of the database. Select “Table View.” Name the view “Low Stock.” Click “Filter” in the top-right corner. Add a filter: “Stock Alert” “is” “Reorder.” Now this view shows only products that need reordering.
8. Add a sort order to the low stock view
   Click “Sort” in the top-right corner. Add a sort by “Current Stock” ascending. The lowest stock items appear first.
9. Test the alert system
   Change the Current Stock value of any product to a number at or below its Min Stock value. The Stock Alert column should display “Reorder.” Switch to the “Low Stock” view to confirm the product appears there.

If the Stock Alert Formula Does Not Work or Other Common Issues

Formula returns an error or shows “NaN”

The formula requires both Current Stock and Min Stock properties to be Number type. If you used Text or another type, the formula cannot compare values. Check each property’s type by clicking the property name and selecting “Edit property.” Ensure both are set to “Number.” Also verify that the property names in the formula exactly match the property names in your database, including capitalization and spaces.

Filtered view shows no results when it should

The filter condition may be set incorrectly. Open the filter menu and confirm the condition is “Stock Alert” “is” “Reorder.” The word “Reorder” must match the formula output exactly, including capitalization. If the formula returns “reorder” (lowercase), the filter will not match. Edit the formula to use “Reorder” or adjust the filter value to match.

Stock alert does not update when I change a number

Notion formulas recalculate automatically when any related property changes. If the formula does not update, try refreshing the page by pressing F5 or closing and reopening Notion. If the problem persists, delete the Formula property and recreate it with the same formula.

I need email or push notifications for low stock

Notion does not send email or push alerts natively. To get external notifications, connect your Notion database to an automation service like Zapier or Make. Set up a trigger that checks the database periodically or watches for changes. For example, in Zapier, use the “New Database Item” or “Updated Database Item” trigger, then add a filter to check if the Stock Alert property equals “Reorder.” Finally, add an action to send an email via Gmail, a Slack message, or a push notification via Pushbullet. This requires a paid Zapier or Make account.

Notion Inventory Database vs Spreadsheet vs Dedicated Inventory Software

Feature	Notion Database	Spreadsheet (Excel/Google Sheets)	Dedicated Inventory Software
Stock alert formula	Built-in formula property	Requires conditional formatting or separate column	Automatic with configurable thresholds
Filtered low-stock view	One-click filter on formula column	Requires filter or pivot table	Built-in dashboard
External notifications	Requires Zapier/Make integration	Requires scripting or add-on	Built-in email or SMS alerts
Collaboration	Real-time with comments and mentions	Real-time in Google Sheets, limited in Excel	Real-time with user roles
Cost	Free for up to 1000 rows	Free (Google Sheets) or part of Office	Monthly subscription per user
Ease of setup	10 minutes with basic formula	15-20 minutes with conditional formatting	1-2 hours with onboarding

Notion is a middle ground between a simple spreadsheet and expensive inventory software. It works best for small to medium inventories where real-time collaboration and visual alerts are sufficient. For large warehouses or multi-location stock, dedicated software provides barcode scanning, purchase orders, and automated reordering.

You now have a working Notion inventory database that highlights low stock items using a formula and a filtered view. To improve the system, add a “Last Updated” Date property to track when stock counts were last modified. You can also create a Rollup property that sums inventory across multiple databases if you manage stock in different locations. After testing the alerts, consider automating external notifications with Zapier or Make if your team needs email or mobile alerts for critical stockouts.