Shopify Metric
Product
Stock Out Frequency = Number of Stock Out Events in Period / Total Active Variants x 100
Stock Out Frequency measures how often products in your Shopify catalogue reach zero available inventory across a defined period. Using Shopify inventory level and variant data, it counts the number of distinct stock out events, where a sellable variant drops to zero available units, against the size of your active catalogue. It tells you how frequently customers land on an out of stock product rather than a buyable one.
Full guide: definition, formula, and benchmarksShopifyProductStock Out Frequency
Stock Out Frequency measures how often products in your Shopify catalogue reach zero available inventory across a defined period. Using Shopify inventory level and variant data, it counts the number of distinct stock out events, where a sellable variant drops to zero available units, against the size of your active catalogue. It tells you how frequently customers land on an out of stock product rather than a buyable one.
How to calculate stock out frequency
Why stock out frequency matters for Shopify users
Every stock out in Shopify is a moment where a ready buyer cannot complete a purchase, so it directly suppresses conversion and pushes shoppers towards competitors. A high Stock Out Frequency also distorts your other store metrics, because traffic to dead product pages drags down cart and checkout rates without revealing the real cause.
Tracking this metric over time turns reactive firefighting into planned replenishment. It shows which variants run dry most often, how seasonality and promotions deplete stock, and where your reorder points are set too low, so the team can protect revenue before sales are lost rather than after.
Understand and act on stock out frequency with KPI Tree
Sync your Shopify inventory levels, variants and order data into your warehouse and compute Stock Out Frequency in KPI Tree. Place it in a metric tree alongside [Cart Conversion Rate](/glossary/product/cart-conversion-rate) and [Average Order Value](/glossary/revenue/average-order-value) so you can see how out of stock events ripple through to revenue and pinpoint the variants worth prioritising for reorder.
Assign RACI ownership in KPI Tree, with inventory or operations accountable and merchandising consulted, then set a weekly review cadence during steady trading and a daily check around promotions and peak seasons. This keeps replenishment decisions tied to real demand signals rather than guesswork.
Get started with your Shopify data
MCPPull metrics from Shopify directly through the Model Context Protocol.
Connect your existing warehouse where Shopify data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Related Shopify metrics
Cart Conversion Rate
E-commerceMetric Definition
Cart Conversion Rate = (Completed Orders / Sessions with Add-to-Cart) × 100
Cart conversion rate is the percentage of visitors who add items to their cart and subsequently complete a purchase. It isolates the effectiveness of the post-browse, pre-checkout stage of the buying journey.
Average Order Value
E-commerceMetric Definition
AOV = Total Revenue / Number of Orders
Average order value (AOV) is the mean monetary value of each completed order. It captures the combined effect of pricing, bundling, upselling, and promotional strategies on basket size.
Cart Abandonment Rate
E-commerceMetric Definition
Cart Abandonment Rate = ((Carts Created - Completed Orders) / Carts Created) × 100
Cart abandonment rate is the percentage of shopping carts created that are not converted into completed orders. It measures friction and hesitation between add-to-cart and purchase completion.
Checkout Conversion Rate
E-commerceMetric Definition
Checkout Conversion Rate = (Completed Orders / Checkout Starts) × 100
Checkout conversion rate is the percentage of visitors who begin the checkout process and successfully complete a purchase. It isolates conversion performance at the critical final stage of the buying journey.
Explore stock out frequency across integrations
All Shopify metrics
Average Order ValueCart Abandonment RateCheckout Conversion RateCustomer Acquisition CostCustomer Lifetime ValueCustomer Repeat RateDiscount Usage AnalysisFulfilment SpeedGross Merchandise VolumeInventory TurnoverMarketing Channel AttributionNew vs Returning CustomersOrder FrequencyOrders Per CustomerProduct Performance AnalysisProduct Return RateProfit Margin by ProductRevenue by ChannelRevenue by GeographyRevenue Per VisitorSessions to Purchase RatioShipping Cost AnalysisStore Conversion RateTop Selling Products AnalysisTraffic Source PerformanceAbandoned Cart Recovery RateAverage Product RatingCart Conversion RateCheckout Abandonment RateCollection Performance AnalysisCustomer Cohort AnalysisCustomer Segmentation AnalysisPayment Method DistributionRevenue Growth RateSeasonal Trend AnalysisCohort AnalysisConversion RateCross Sell AnalysisCustomer Churn RateDiscount EffectivenessDraft Order Conversion RateFulfillment Time AnalysisGift Card Utilization RateInventory Turnover RateLocation Based Sales AnalysisPurchase Funnel AnalysisRefund RateRepeat Purchase RateRevenue Per CustomerRFM SegmentationTransaction Success RateVariant Performance AnalysisEmpower your team to understand and act on Shopify data
Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.
