How Shopify merchants use Stockout-adjusted Sell Velocity
For Shopify merchants, this matters because a SKU that was out of stock for part of the month may look slower than it really is. Adjusting sell velocity helps replenishment planning reflect demand opportunity, not only fulfilled sales.
Formula
Stockout-adjusted sell velocity = Units sold / Days available to sell
Exclude days when the product was unavailable or effectively unsellable, then divide units sold by the remaining available days.
What matters in practice
- Out-of-stock days can make demand look artificially weak.
- Stockout-adjusted velocity is most useful for bestsellers and SKUs with recurring availability gaps.
- The metric should be reviewed with lead time, open purchase orders, and upcoming promotion plans.
Why it matters
Common merchant pain points
- • Forecasts based only on shipped units can under-order products that were unavailable for part of the period.
- • Stockouts can create a feedback loop where a product looks slow, receives a smaller reorder, and then stocks out again.
Native Shopify limitations
- • Shopify reports show sales and inventory history, but merchants often need to adjust for stockout days before using sell velocity for demand planning.
- • Native low-stock workflows do not automatically turn stockout-adjusted velocity into reorder quantities.
How to apply this in practice
Step 1
Find units sold
Export or review units sold for the SKU during the planning period.
Step 2
Count available days
Remove days when the SKU was out of stock or unavailable to sell.
Step 3
Use adjusted velocity
Divide units sold by available days, then use that velocity when estimating lead-time demand.
Examples
Bestseller out of stock for 10 days
A SKU sells 200 units over 20 available days in a 30-day period. Its adjusted velocity is 10 units per available day, not 6.7 units per calendar day.
Frequently asked questions
Related resources
Related guides
- Stockout Prevention on Shopify: Practical Playbook for Growing Brands
Learn how Shopify merchants can prevent stockouts using demand signals, safety stock, and automated reorder points. Includes formulas, real examples, and a step-by-step checklist – plus where native Shopify tools run out of road.
- Shopify Inventory Forecasting Guide: From Gut Feel to Systematic Planning
A practical guide for Shopify brands to forecast inventory demand, combine lead times with sales velocity, and tie forecasts to real purchase orders and cash budgets. Includes formulas, Shopify report tips, and scaling advice.
Related calculators
- Sell-Through Rate Calculator for Shopify | Formula + Benchmarks
Calculate your sell-through rate by SKU or collection. Use the free Synplex sell-through rate calculator with industry benchmarks, worked examples, and Shopify tips.
Related glossary terms
- Reorder Point (ROP)
Reorder point is the inventory level at which a new purchase order should be placed so that replenishment arrives before existing stock is depleted.
- Safety Stock
Safety stock is the extra inventory held above expected demand to reduce the risk of stockouts caused by variability in demand or lead times.
- Inventory Turnover
Inventory turnover measures how many times a company sells and replaces its inventory over a given period, typically a year.