In-Stock Rate: How to Measure and Improve It

In-stock rate is the share of the time, or the share of item and location combinations, that a product is available for the customer to buy, and it is the service measure that shoppers feel most directly. This guide is part of demand planning and inventory optimization, follows the cost of stockouts and excess and obsolete inventory, and leads to inventory optimization and inventory turnover. A shopper does not care about your warehouse fill rate. They care whether the product is on the shelf or can be added to the cart. A company can show a high order fill rate to its retail customers and still have a poor in-stock rate on the shelf, if the goods are in the back room, misallocated between stores or delivered late. This guide defines in-stock rate and compares it with related measures, shows how to measure it, works through an example with checked arithmetic that includes a lost-sales estimate, lists the root causes of low in-stock performance and gives a practical improvement plan. Availability and cash trade off, as covered in cash flow management.

Definition

In-stock rate = the number of item-location-days (or item-location checks) on which the product was available, divided by the total number of item-location-days (or checks) in the period.

It can be measured at the shelf in a store, at a distribution center, or online as the share of listings that can be purchased. Availability can be defined as having at least one unit, or at least a minimum presentation quantity. The measurement unit should match the customer's experience.

How it differs from related measures

Order fill rate measures the share of ordered units or lines that were shipped complete. It reflects your service to a customer's order, not what is on a shelf. Cycle service level is the probability of not stocking out during a replenishment cycle, a planning parameter. On-time-in-full (OTIF) measures delivery against the promised date and quantity. Perfect order rate combines several delivery quality measures. Out-of-stock rate is the complement of in-stock rate. A supplier can score well on fill rate and OTIF while a retailer's shelf availability is poor, because of store-level execution, forecasting at the retailer or phantom inventory. Both views matter, and they should be reconciled in conversations with key accounts.

How to measure it

For your own warehouses or ecommerce, extract daily stock status by item and location from your inventory system. For retail partners, use shelf availability data from point-of-sale systems, which can flag items with zero sales in a period that normally has sales, or from store audits and third-party providers. Online, crawl or track your own listings for out-of-stock status. Weight the measure by importance: a sales-weighted or margin-weighted in-stock rate focuses on what matters, since a stockout on a best seller costs more than one on a slow item. Report by class, by customer and by region.

A worked example

A brand audits 50 items across 10 stores for 30 days (illustrative). That is 50 × 10 × 30 = 15,000 item-store-days. The audit finds 750 item-store-days with no stock available.

• In-stock rate: (15,000 - 750) / 15,000 = 14,250 / 15,000 = 95.0 percent
• Out-of-stock rate: 750 / 15,000 = 5.0 percent

Suppose the average item sells 3 units per store per day when in stock, at a margin of $4 a unit. Lost sales while out of stock, assuming that 60 percent of shoppers do not buy a substitute, are 750 × 3 × 0.60 = 1,350 units, worth 1,350 × 4 = $5,400 of margin for the month. Check: 750 × 3 = 2,250; × 0.6 = 1,350; × 4 = 5,400. If the brand could raise the in-stock rate to 97 percent, out-of-stock days would fall to 0.03 × 15,000 = 450, a reduction of 300 item-store-days. The margin recovered would be 300 × 3 × 0.6 × 4 = $2,160 a month, or about $25,900 a year (2,160 × 12 = 25,920). This is for a small sample of items and stores, so scale it to the whole range, and compare it with the cost of the stock and service improvements that would be required.

Root causes of low in-stock

1. Forecast error and bias, leading to under-ordering.
2. Replenishment parameters out of date, with reorder points and safety stock that no longer match demand.
3. Supply problems: late deliveries, short shipments, quality holds.
4. Allocation and distribution: stock in the wrong location, or a lack of rebalancing.
5. Promotional surprises: demand spikes that were not planned.
6. Store or channel execution: goods in the back room, missed shelf fill, delays in receiving, and phantom inventory (the system shows stock that is not there).
7. Data errors: wrong item master data, pack sizes or lead times.
8. Ordering rules: minimum orders and case packs that prevent replenishing small quantities in time.
9. Lack of visibility: no daily view of availability, so problems last for days.

An improvement plan

Measure at the right level first. Without item-location-day data, you cannot find patterns. Build a daily out-of-stock report, ranked by sales value.

Classify the cause of each major stockout. Use a simple root cause list, as in forecast error root cause analysis. Many companies find that a few causes explain most of the problem.

Fix parameters for the top items. Recalculate reorder points and safety stock from current demand and measured lead times. See safety stock formula and reorder point formula.

Improve the forecast for promoted and seasonal items. Plan events explicitly, with supply response.

Work with suppliers on reliability. Measure OTIF, share data and agree on corrective actions.

Rebalance inventory. Move stock from locations with surplus to locations with shortage, using rules based on days of supply.

Reduce phantom inventory with cycle counts and system accuracy checks, especially in stores.

Set service targets by class and monitor them weekly. Investigate misses quickly.

Align with customers. Share forecasts and promotion plans with retail buyers, and ask for their availability data.

What a good routine looks like

Each day, an exception report lists items at or near zero stock, sorted by sales value, with the days of supply and the next incoming shipment. Planners act on the top of the list. Each week, the team reviews in-stock rate by class and customer, with the root causes of the biggest stockouts and the actions taken. Each month, the report goes to leadership with the trend and the cost estimate. Each quarter, the team reviews targets and parameters.

Balancing availability and inventory

Raising in-stock rate costs inventory, and the increments get costlier as you approach 100 percent. Aim for high availability on the items that matter most and accept lower availability on slow, low-margin items. Check the effect of any improvement on turnover, and look for ways to raise availability without raising inventory proportionally, such as better forecasts, faster replenishment and smarter allocation. See inventory turnover.

Common mistakes

1. Relying on order fill rate as a proxy for shelf availability.
2. Measuring averages that hide chronic stockouts on key items.
3. Treating all items equally.
4. Ignoring phantom inventory.
5. Fixing symptoms, such as expediting, without addressing causes.
6. Not sharing data with customers.

Weighting the measure

A simple average of in-stock rates can mislead because it treats all items alike. Suppose a brand has three item groups with different sales shares and in-stock rates: group A has 40 percent of sales and a 98 percent in-stock rate, group B has 35 percent and 94 percent, and group C has 25 percent and 90 percent (illustrative). The simple average is (98 + 94 + 90) / 3 = 94.0 percent. The sales-weighted rate is 0.40 × 98 + 0.35 × 94 + 0.25 × 90 = 39.2 + 32.9 + 22.5 = 94.6 percent. Here the weighted figure is slightly higher because the best-performing group is also the biggest. If the pattern were reversed, with the best sellers performing worst, the weighted figure would be well below the simple average, and that is the dangerous case. Always report both, and examine the in-stock rate of the top sellers on their own.

Phantom inventory

Phantom inventory is stock that the system shows but that is not physically available to sell. It is a major hidden cause of low in-stock rates in stores and warehouses, because the replenishment system believes that a unit is on the shelf and does not reorder. Suppose a cycle count of 200 items finds that the system quantity matches the physical count for 164 of them. Inventory record accuracy is 164 / 200 = 82 percent, and the 36 mismatches are potential sources of phantom stock. If one in three of those mismatches is a phantom, about 12 items are being hidden from replenishment. Improve accuracy with regular cycle counts focused on fast-moving and high-value items, with scanning at receiving and sale, and with rules that flag items showing zero sales for longer than expected for further investigation. For retailers, shared data on inventory record accuracy can transform the conversation about shelf availability.

Online in-stock

For ecommerce, the equivalent measure is the share of listing-days on which an item can be purchased, weighted by traffic. Out-of-stock listings waste advertising spend, reduce conversion and may lose search rank on marketplaces. Set up alerts for items nearing zero stock, so that advertising can be paused and replenishment expedited. Consider allowing backorders for items with a short wait and reliable restock dates, with honest delivery estimates, as an alternative to showing "unavailable". Track the effect on conversion and returns before and after.

Working with retail partners

Many retailers share in-stock or on-shelf availability scorecards with their suppliers. Ask for them, agree on the definition and compare with your own data. Where there are gaps, such as a good order fill rate and a poor shelf in-stock rate, investigate together: the cause may be store receiving, shelf replenishment, forecasting at the retailer or phantom inventory. Propose joint actions, such as a collaborative forecast for key promotions, vendor-managed replenishment for selected items or a change in delivery frequency. Suppliers who bring data and a plan are valued by buyers.

FAQs

What is in-stock rate?

The share of item-location-days on which a product is available to buy, measured at the shelf, warehouse or online listing.

How is in-stock rate different from fill rate?

Fill rate measures how completely orders are shipped. In-stock rate measures whether the product is available where the customer buys it.

What is a good in-stock rate?

It depends on the channel and item class. Set higher targets for important items and compare with your own trend and customer scorecards.

How do I improve in-stock rate?

Measure daily, fix reorder parameters, improve forecasts for promoted items, work with suppliers on reliability, rebalance stock and reduce phantom inventory.

Does a higher in-stock rate always mean more inventory?

Not necessarily. Better forecasts, faster replenishment and better allocation can raise availability without proportional increases in stock.