March 18, 2026 · Alertr Team

The Complete Guide to Shopify Inventory Management (2026)

Everything Shopify merchants need to know about inventory management: formulas, metrics, app comparisons, and systems that prevent stockouts.

If you run a Shopify store and you have ever discovered a stockout by noticing a best-seller sitting at zero units on a Tuesday afternoon, this guide is for you. It covers everything a DTC brand needs to know about inventory management — from the metrics that actually matter, to the formulas that drive reorder decisions, to the tools that automate the whole process once your catalog outgrows a spreadsheet.

This is not a surface-level overview. It is a working reference for merchants managing anywhere from 50 to 2,000 SKUs who want to stop guessing and start making inventory decisions backed by data. Bookmark it. You will come back to it.

Why Inventory Management Matters More Than Most DTC Brands Realize

Inventory management sounds like back-office busywork until it costs you real money. And it will, in one of two ways.

Stockouts bleed revenue silently. When a customer lands on your product page and sees "Out of Stock," they do not wait. They buy from a competitor — often a brand they will stick with permanently. The direct cost is the lost sale. The hidden costs are worse: reduced customer lifetime value, lower search rankings as Google notices unavailable products, and the operational scramble of expedited shipping once you finally realize you ran out.

Overstock ties up cash that could be working elsewhere. Every unit sitting in your warehouse is money that is not being spent on ads, product development, or hiring. For products with seasonal relevance or short shelf life, overstock becomes dead stock — inventory you end up discounting at 40% off or writing off entirely. A Shopify store carrying $50,000 in excess inventory is effectively giving its warehouse a $50,000 interest-free loan.

For a DTC brand doing between $100K and $5M in annual revenue, the sweet spot is lean inventory that turns over quickly without running dry. Getting there requires understanding a handful of core concepts, applying some straightforward math, and having a system that monitors your stock levels daily instead of relying on weekly gut-check sessions in the Shopify admin.

The rest of this guide teaches you exactly how to build that system.

What Shopify Gives You Out of the Box (And Where It Falls Short)

Shopify includes basic inventory management tools on every plan. Here is what you actually get:

Stock tracking per variant. Enable tracking on any product variant and Shopify decrements inventory automatically with each sale, refund, and fulfillment.
Multi-location support. Assign inventory to up to 1,000 locations — retail stores, warehouses, 3PLs — and route fulfillment accordingly.
Purchase orders and transfers. Create POs to receive new stock and transfers to move inventory between locations.
Inventory adjustments. Manually correct counts with reason codes (damaged, returned, shrinkage) for a basic audit trail.
Reporting. On higher-tier plans, you get inventory value reports, sell-through rates, and ABC analysis.

For a store with fewer than 50 SKUs moving at a predictable pace, this is often enough. You can eyeball stock levels in the admin once a week, mentally flag anything that looks low, and place reorders based on past experience. It works — until it does not.

Where Shopify falls short is anything predictive or proactive. There is no native reorder point calculation. There is no alert system that emails or Slacks you when a product crosses a threshold. There is no demand forecasting. There is no sell-rate visibility at the SKU level. There is no "days of stock remaining" metric anywhere in the admin.

In practice, this means Shopify will tell you that a product is at zero. It will not tell you that a product is heading toward zero in 6 days and you should have reordered last week. That is the gap every growing DTC brand hits, usually somewhere between 100 and 300 SKUs.

For a deeper dive into how Shopify's native tracking stacks up against third-party tools, read our breakdown of Shopify's built-in inventory tracking vs apps.

The Six Metrics Every Shopify Merchant Should Track

You do not need a degree in supply chain management. You need six numbers per SKU, and you need them to stay current. Here is what they are and why they matter.

1. Sell Rate (Sales Velocity)

Sell rate is the number of units you sell per day (or per week) for a given product. It is the single most important input in every inventory formula that follows.

Formula: Units Sold / Number of Days = Sell Rate

If you sold 90 units of a product over the last 30 days, your sell rate is 3 units per day. That number drives every smart reorder decision you will make.

The catch: sell rate changes. A product selling 3 units per day in March might sell 8 per day in November. Using a static sell rate is one of the most common mistakes merchants make. You need to recalculate regularly — ideally weekly, at minimum monthly.

Learn how to calculate and apply sell rate in our guide to sell rate for Shopify products.

2. Reorder Point (ROP)

The reorder point is the inventory level at which you should place a new purchase order. When your stock drops to this number, it is time to buy more — not when you hit zero.

Formula: Reorder Point = (Average Daily Sales x Lead Time in Days) + Safety Stock

For example: if you sell 10 units per day, your supplier takes 14 days to deliver, and you keep 5 days of safety stock:

ROP = (10 x 14) + (10 x 5) = 140 + 50 = 190 units

When your inventory hits 190 units, place the order. By the time it arrives 14 days later, you will have roughly 50 units left — your buffer against demand spikes or shipping delays.

Use our free reorder point calculator to run the numbers for your own SKUs, or read the full explanation of how to set reorder points for Shopify.

3. Safety Stock

Safety stock is the extra inventory you keep on hand beyond what you expect to sell during your lead time. It is your insurance policy against two types of uncertainty: demand variability (customers buying more than expected) and supply variability (your supplier delivering late).

Formula: Safety Stock = Z-score x Standard Deviation of Daily Demand x Square Root of Lead Time

The Z-score depends on your desired service level. A 95% service level (meaning you want to avoid stockouts 95% of the time) uses a Z-score of 1.65. For most Shopify merchants, 95% is a reasonable target.

If your standard deviation of daily demand is 4 units and your lead time is 14 days:

Safety Stock = 1.65 x 4 x sqrt(14) = 1.65 x 4 x 3.74 = 24.7 units (round up to 25)

Do not know your standard deviation? A quick starting estimate is 20-30% of your average daily sales. Run the precise calculation with our safety stock calculator, or read the full breakdown in our post on what safety stock is and when you need it.

4. Lead Time

Lead time is the total elapsed time from when you place a purchase order to when that inventory is on your shelves and available to sell. This is not just shipping time. It includes supplier processing, manufacturing (if applicable), transit, customs clearance for international orders, receiving at your warehouse, and quality checks.

Most merchants underestimate lead time by 3-7 days because they forget the last-mile steps: the time between a package arriving at their warehouse and those units actually being counted, shelved, and marked as available in Shopify.

If your supplier quotes 10 days but your actual order-to-available time is consistently 16 days, use 16. Better yet, track your last 5 orders and use the worst-case figure for safety.

For a full breakdown of lead time types and how to measure them, see our guide to lead time in inventory management.

5. Days of Supply

Days of supply tells you how many days your current stock will last at your current sell rate. It is the most intuitive metric for daily inventory monitoring.

Formula: Days of Supply = Current Inventory / Average Daily Sales

If you have 300 units on hand and sell 10 per day, you have 30 days of supply. Simple.

The power of this metric is in comparison. When your days of supply drops below your lead time, you are in trouble — even if you reorder immediately, you will run out before the shipment arrives. When it drops below your lead time plus your safety stock buffer, you should have already reordered.

This is the metric that Alertr calculates automatically for every SKU in your catalog, every day.

Full explanation: What is days of supply and how to use it.

6. Inventory Turnover Ratio

Inventory turnover ratio measures how many times you sell and replace your entire inventory in a given period.

Formula: Inventory Turnover = Cost of Goods Sold / Average Inventory Value

A higher ratio means you are selling efficiently and not sitting on excess stock. A lower ratio suggests overbuying or slow-moving products eating up warehouse space and cash.

For most DTC ecommerce brands, a healthy inventory turnover ratio falls between 4 and 8 — meaning you turn over your full inventory every 6 to 12 weeks. Below 4, you are probably carrying too much. Above 10, you might be cutting it too close and risking stockouts.

Read our full guide to inventory turnover ratio: what it means and how to improve it.

Bonus Metrics Worth Knowing

Two additional concepts round out the inventory management toolkit:

Economic Order Quantity (EOQ) — the mathematically optimal number of units to order at one time, balancing ordering costs against holding costs. Useful for high-volume, stable-demand SKUs. Less practical for products with volatile or seasonal demand. Full explanation here.
Sell-through rate — the percentage of available inventory you sold during a given period. A sell-through rate of 80% or higher is generally healthy for ecommerce. Below 50% and you are likely overstocked.

How to Calculate Reorder Points and Safety Stock in Practice

The formulas above are straightforward. The hard part is gathering accurate inputs. Here is how to do it for a real Shopify store.

Step 1: Pull Your Sales Data

Go to Shopify Analytics and export your sales data for the last 90 days. You want units sold per product per day. If you cannot get daily granularity from Shopify's reports, export order data and calculate it yourself: total units sold divided by 90 gives you a daily average.

For seasonal products, use a shorter lookback window (30 days) during peak seasons and a longer one (90 days) during stable periods. The goal is a sell rate that reflects current demand, not last quarter's demand.

Step 2: Measure Your Actual Lead Times

Pull your last 5 purchase orders for each supplier. For each one, record the date you placed the order and the date the inventory was available to sell in Shopify. The difference is your actual lead time.

Calculate the average and the maximum. Use the maximum as your planning lead time — or at minimum, use the average plus a few days of buffer. Lead time surprises are the number one cause of unexpected stockouts.

Step 3: Calculate Standard Deviation of Demand

If you have daily sales data, calculate the standard deviation across your measurement period. If that sounds like too much work for hundreds of SKUs, use the shortcut: multiply your average daily sales by 0.25. This gives you a rough estimate that works for products with moderate demand variability.

For products with highly variable demand — anything that spikes during promotions, viral moments, or seasonal peaks — use a higher multiplier (0.4-0.5) or calculate the real standard deviation.

Step 4: Run the Formulas

With your sell rate, lead time, and demand variability in hand:

Calculate safety stock: Z-score (1.65 for 95% service level) x standard deviation x square root of lead time
Calculate reorder point: (daily sell rate x lead time) + safety stock

Do this for your top 20 SKUs first. These are the products where stockouts hurt the most and where getting the math right delivers the highest ROI.

A Worked Example

Say you sell a moisturizer that moves 12 units per day. Your supplier takes 18 days to deliver. Your standard deviation of daily demand is 3 units.

Safety stock = 1.65 x 3 x sqrt(18) = 1.65 x 3 x 4.24 = 21 units
Reorder point = (12 x 18) + 21 = 216 + 21 = 237 units
Days of supply check: If you have 300 units on hand, that is 300 / 12 = 25 days. Your lead time is 18 days, so you have a 7-day buffer — comfortable but not excessive.

When your stock drops to 237 units, place the next order. By the time it arrives, you will have about 21 units left — enough to cover normal demand variability without running out.

When Spreadsheets Stop Working: The 50-100 SKU Threshold

A well-built Google Sheet can handle inventory management for a small catalog. You can track stock levels, calculate reorder points using formulas, and flag items that need reordering. If you are disciplined about updating it, a spreadsheet works fine for 30-50 SKUs.

The problem is that spreadsheets require manual upkeep, and that upkeep scales linearly with your catalog size.

At 50 SKUs, updating your spreadsheet takes maybe 30 minutes per week. At 100 SKUs, it is an hour. At 300 SKUs, it is a part-time job. And the failure mode is silent: you miss an update, your sell rates go stale, and a reorder point that was correct two months ago no longer reflects reality. You discover the problem when a best-seller hits zero.

The specific signals that you have outgrown a spreadsheet:

You have had 2 or more preventable stockouts in the last quarter. Each one represents revenue you will never recover.
Your weekly inventory review takes more than 30 minutes. That time is better spent on growth.
You are manually copying data from Shopify into a spreadsheet. This is the bottleneck that breaks first — one missed export and your data is stale.
Your sell rates change faster than you update them. If you recalculate monthly but your demand shifts weekly, your reorder points are always lagging.
You manage more than one person's worth of institutional knowledge. If only one person on your team knows how the spreadsheet works, that is a single point of failure.

For a detailed comparison of both approaches and exactly when to make the switch, read Spreadsheet vs App: when to switch for Shopify inventory management.

What to Look for in a Shopify Inventory Management App

The Shopify App Store has dozens of inventory management apps, ranging from free low-stock alert widgets to full enterprise resource planning platforms. Most Shopify merchants do not need the expensive end of that spectrum. Here is how to evaluate what you actually need.

Define Your Core Problem First

Before you install anything, write down the 3-5 things your current process fails at. For most DTC brands in the 100-2,000 SKU range, the list looks something like:

I do not know which products are about to run out until it is too late
I do not have a systematic way to decide when and how much to reorder
I waste time manually checking stock levels in the Shopify admin
My team does not get notified about low-stock situations proactively
I cannot see how fast each product is selling at a glance

If that matches your situation, you need an app that does three things well: tracks sell rates, calculates days of stock remaining, and sends automated alerts when products hit their reorder point. You do not need purchase order management, manufacturing planning, or multi-channel sync.

The Price-to-Complexity Spectrum

Inventory apps on Shopify fall into roughly four tiers:

Tier 1: Basic alerts ($0-$6/mo). Apps like iAlert ($2.99/mo) and LSA Low Stock Alert ($5.99/mo) send notifications when inventory drops below a threshold. Simple, cheap, but limited — most use static thresholds that do not account for sell rate or lead time.

Tier 2: Intelligent alerts and forecasting ($5-$40/mo). Bee Low Stock Alert ($5.99-$39.99/mo) offers dynamic thresholds and demand forecasting on its Enterprise plan. Alertr ($19/mo beta pricing) tracks sell rates, calculates days of stock remaining, and sends alerts to email or Slack with configurable thresholds. This is the sweet spot for most DTC brands.

Tier 3: Planning and purchase orders ($49-$200/mo). Prediko ($49-$199/mo, 4.9 stars from 190 reviews) adds AI forecasting and automated purchase order generation. Fabrikator ($79+/mo) does similar with strong warehouse integration. Good for brands that have outgrown basic alerts and need to streamline purchasing.

Tier 4: Enterprise and manufacturing ($250+/mo). Katana ($299/mo) and Inventory Planner by Sage handle multi-location, manufacturing, raw materials, and full supply chain complexity. Powerful, but expensive and time-intensive to set up. Only worth it if you genuinely need those capabilities.

Key Features to Prioritize

For the typical Shopify merchant reading this guide, prioritize these features in this order:

Automated sell rate tracking — The app should calculate how fast each SKU moves without manual input
Days of stock estimate — How many days until you run out at the current sell rate
Configurable alert thresholds — Per-SKU thresholds based on lead time and safety stock, not a flat "alert me below 10 units" across all products
Email and/or Slack alerts — Notifications that land where your team already works
CSV export — For purchase order workflows and sharing data with your team

Features you probably do not need (yet): purchase order generation, multi-location sync, barcode scanning, raw materials management, demand planning models.

For side-by-side feature and pricing comparisons across every major app, visit our comparison hub. If you are evaluating specific alternatives to your current app, check our alternatives guides.

The Stocky Shutdown and What It Means for Shopify Merchants

Stocky — the free inventory tool that Shopify bundled for years — hits end-of-life on August 31, 2026. New installs have been blocked since February 2, 2026, when Shopify pulled it from the App Store. Merchants who still depend on Stocky for purchase orders, demand forecasting, or reorder suggestions have roughly five months to find and test a replacement before the app goes dark completely.

What Stocky Actually Did

Stocky was a surprisingly capable free tool. It offered demand forecasting based on historical sales, suggested reorder quantities, generated purchase orders, and provided basic inventory analytics. For a free app, it covered a lot of ground.

The problem: Shopify decided to fold some of Stocky's features into the core Shopify admin (inventory reports, ABC analysis) while quietly dropping the features merchants relied on most — automated reorder suggestions and proactive stock alerts. The result is a gap that third-party apps need to fill.

What to Do Before August 31

Export your data now. Download all purchase orders, supplier information, and historical reports from Stocky before the shutdown date. After August 31, the app and all its APIs stop working.
Install a replacement and run both in parallel. Give yourself at least 4-6 weeks of overlap to compare the outputs and verify the new tool is working correctly.
Document your current Stocky workflows. Write down which reports you pull, how often you generate POs, and which alerts you rely on. This becomes your requirements list for evaluating replacements.

For a step-by-step migration plan, read our guide to migrating from Stocky. For a full rundown of the shutdown timeline and implications, see The Stocky shutdown: what Shopify merchants need to know.

If you used Stocky primarily for stock tracking and alerts (rather than purchase orders), Alertr fills that gap directly — sell rate tracking, days of stock estimates, and automated reorder alerts via email or Slack, starting at $19/mo. Check our Stocky alternatives guide for a full comparison of replacement options.

Setting Up Alerts and Automation That Actually Work

The difference between a merchant who prevents stockouts and one who discovers them after the fact is not intelligence or effort. It is automation. Specifically, it is having a system that monitors inventory levels against calculated thresholds every single day and sends actionable notifications when something needs attention.

Why "Check the Admin" Is Not a System

Manually checking stock levels in Shopify works when you have 20 products. At 200 products, it takes 30-60 minutes to scan through everything, and you will still miss things. At 500 products, it is impossible to do thoroughly. The human brain is not designed to compare 500 numbers against 500 different thresholds and flag the ones that crossed.

This is the core argument for low-stock alert software. It is not about fancy features or AI — it is about a computer doing a comparison check across your entire catalog every day, which takes it 2 seconds and would take you 2 hours.

What Good Alert Configuration Looks Like

Bad alerts: "Notify me when any product drops below 10 units." This generates noise for slow-moving products (who cares if a niche accessory dropped to 9 units?) and silence for fast-moving ones (a product selling 20 units per day at 10 units means you are 12 hours from a stockout).

Good alerts: Per-SKU thresholds set at each product's reorder point, which accounts for that specific product's sell rate and lead time. A fast-selling product with a 14-day lead time might have a threshold of 200 units. A slow-moving product with a 7-day lead time might have a threshold of 15 units. The alert fires when it matters for that specific product.

Channel Matters

Email alerts work for solo operators who check email regularly. For teams, Slack is significantly better — the alert lands in a channel where someone will see it and act on it within minutes, not hours. The best setup is a dedicated Slack channel (something like #inventory-alerts) that the operations person monitors.

For a detailed walkthrough on setting up alerts, thresholds, and notification workflows, see How to set up low stock alerts on Shopify.

Building a Complete Shopify Inventory Management System: A Step-by-Step Guide

Knowing the metrics and formulas is step one. Applying them consistently across your entire catalog is step two. Here is the system that works for most single-location DTC brands doing $100K-$5M in annual revenue.

The Weekly Inventory Review (20 Minutes, Not 2 Hours)

Every Monday morning, pull a report sorted by days of stock remaining. If you are using an inventory app, this should be a dashboard view or automated export. If you are using a spreadsheet, update your sell rates and recalculate.

Focus on three categories:

Critical (under 7 days of supply): These products need immediate reorder attention. If lead time is longer than 7 days, you are already late.
Warning (7-21 days of supply): These are approaching reorder territory. Confirm that orders are already placed or need to be.
Healthy (21+ days of supply): No action needed. Scan for outliers — anything with 90+ days of supply might be overstocked.

This review should take 15-20 minutes with a good tool. If it takes longer, your system needs better automation.

The Monthly Inventory Audit

Once per month, spot-check physical counts against Shopify's records for your top 20 SKUs. Inventory shrinkage, receiving errors, return discrepancies, and breakage add up quietly. A 2-3% discrepancy is normal. Above 5%, you have a process problem to investigate.

The Quarterly Strategy Review

Every quarter, zoom out and look at bigger patterns:

Which products had the highest turnover? Double down on these — they are your cash generators.
Which products had stockouts? Why? Was it a forecasting miss, a lead time surprise, or a process failure?
Which products are sitting? Anything with more than 60 days of supply needs a plan — promote it, bundle it, discount it, or stop reordering it.
Have your lead times changed? Suppliers shift. Shipping routes change. Update your assumptions.

The Tech Stack

For the system above, you need three things:

Shopify's native inventory tracking — The foundation. Make sure it is enabled on every product.
An inventory alert app — Something that calculates sell rates, estimates days of stock, and sends reorder alerts automatically. This is the automation layer that makes the weekly review possible in 20 minutes instead of 2 hours.
A supplier contacts sheet — A simple document listing each supplier, their contact info, payment terms, minimum order quantities, and average/worst-case lead times. Sounds basic, but most merchants do not have this centralized.

You do not need an ERP. You do not need demand planning AI. You do not need a $300/mo tool. Those become relevant at much higher volumes and complexity. For most DTC brands, the combination above handles 95% of inventory management needs.

How Alertr Fits Into Your Inventory Management Shopify Stack

Full disclosure: we built Alertr, so take this section with appropriate context. We will keep it factual.

Alertr connects to your Shopify store, syncs inventory data daily, calculates sell rates for every SKU, estimates how many days of stock you have left, and sends automated reorder alerts when products approach their threshold. Alerts go to email, Slack, or both.

What it does:

Sell rate tracking per SKU (updated daily)
Days of stock remaining estimates
Configurable per-SKU reorder thresholds
Low stock alerts via email and Slack
CSV export for purchase order workflows
Dashboard with inventory health overview

What it does not do:

Purchase order generation
Multi-location inventory sync
Manufacturing or raw materials management
Barcode scanning
Demand planning models

This is intentional. Alertr is built for single-location DTC brands managing 100-2,000 SKUs whose primary pain point is knowing what to reorder and when. If you need purchase orders or multi-location, check Prediko (from $49/mo) or Katana ($299/mo). If you need the cheapest possible alert tool and are fine with static thresholds, Bee starts at $5.99/mo.

Pricing: Free tier for up to 50 SKUs. Pro at $19/mo during beta (normally $29/mo) — that price is locked in permanently for early adopters. 14-day free trial on Pro, no credit card required.

If the problems described in this guide sound like your problems, the free tier is a zero-risk way to see whether the data matches your expectations.

Frequently Asked Questions About Shopify Inventory Management

Do I need inventory management software?

Not every store does. If you have fewer than 50 SKUs, predictable demand, and short lead times, a spreadsheet and Shopify's native tools can get the job done. The inflection point comes when you regularly experience preventable stockouts, spend more than 30 minutes per week on manual inventory checks, or manage more than 100 active SKUs. At that point, even a basic app pays for itself by preventing one significant stockout per month. Read our full analysis: Do you actually need inventory management software?

How do I forecast inventory for seasonal products?

Standard formulas assume relatively stable demand. For seasonal products, you need to layer in seasonal uplift multipliers based on historical data. Look at last year's sales by month, calculate the ratio between your peak month and your average month, and apply that multiplier to your current sell rate as you approach the peak period. Start reordering for seasonal surges at least one full lead time cycle early. Our inventory forecasting guide covers this in detail.

What is a good inventory turnover ratio for ecommerce?

Most healthy DTC brands fall between 4 and 8 turns per year. Below 4 suggests overbuying or slow-moving products consuming too much capital. Above 10 may indicate you are running too lean and risking stockouts. The right number depends on your margins, lead times, and how seasonal your products are. Higher-margin products can tolerate lower turnover because the holding cost is justified by the profit per unit.

Should I use Shopify's built-in tools or a third-party app?

Use both. Shopify's native inventory tracking is the foundation — reliable, automatic, and included in every plan. Layer a third-party app on top for the intelligence layer: sell rate tracking, reorder point monitoring, and automated alerts. Shopify tells you where your inventory is. A good app tells you when it is going to run out and what to do about it. Read our comparison: Shopify native tools vs third-party apps.

How do I avoid stockouts without overstocking?

Calculate reorder points and safety stock for each SKU using the formulas in this guide. The reorder point triggers a new order at exactly the right time, and safety stock provides a buffer against demand spikes and supply delays. Together, they keep inventory lean but safe. The biggest mistake is using the same threshold for every product — a flat "reorder at 50 units" approach overstocks slow movers and understocks fast movers simultaneously. Our guide to avoiding stockouts goes deeper.

Stop Guessing, Start Tracking

Alertr monitors sell rates, forecasts stockouts, and sends reorder alerts automatically. Inventory forecasting and reorder alerts. Free tier available, no credit card required.

Join Waitlist