How Do You Measure Order Fill Rate? A Guide to Line, Order and Unit Fill Rates, Causes of Missing Lines, the Value of Lost Sales, Count Discrepancies, Channel Inventory Delays and the Path to Your Target
How do you measure the order fill rate? Line, order and unit-based rates, reasons for missing lines and the value of lost sales: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: How is the order fill rate defined?
- Lesson 2: How do you calculate the fill rate for a sample month?
- Lesson 3: What are the reasons for missing lines?
- Lesson 4: How do you calculate the value of lost sales?
- Lesson 5: How do you close the gap between system stock and shelf stock?
- Lesson 6: How do you prevent stock delays on sales channels?
- Lesson 7: How do you raise the fill rate to 98%?
- Lesson 8: How do you monitor the fill rate?
- What are the most common mistakes in measuring order fill?
- How does NetKasam make tracking order fill easier?
- Mini quiz: Test what you have learned
- Conclusion: Record the reason for every incomplete order
- Frequently Asked Questions About the Order Fill Rate
When customers place an order, they trust that the product is on the shelf. The warehouse, however, sometimes can't find one item of the order, sometimes runs into a product that shows as in stock but isn't on the shelf, and sometimes the same product has been sold twice because the system updated stock late. Each of these situations looks like a small problem; but added up, they mean a significant share of orders go out incomplete, late or canceled. The order fill rate makes this loss visible in a single number.
This article is not a narrative but an 8-lesson practical course. We will answer the question how to measure the order fill rate through a sample business that receives 5,000 orders a month: three different fill measures (line, order, unit), the calculation for a sample month, the reasons for missing lines, the value of lost sales, the gap between system stock and shelf stock, stock matching across sales channels, the path to the target and monitoring indicators. At the end there is a mini quiz and an answer key. All figures are sample values chosen to illustrate the method; follow the same steps with your own data.
What will you be able to do by the end of this training?
In short: You will calculate the fill rate on a line, order and unit basis, separate the reasons for shortfalls, find the value of lost sales and set the sequence of actions that brings the rate to 98%.
- 01DefineWrite down the three measures: line, order and unit-based.
- 02CalculateWork out the period's rates from the orders.
- 03Find reasonsBreak missing lines down by reason.
- 04ValueFind the revenue and contribution of lost sales.
- 05FixStart with the largest reason and set a sequence of actions.
- 06MonitorTrack the rate weekly.
The 8 lessons of the course: (1) how the fill rate is defined, (2) the calculation for a sample month, (3) reasons for missing lines, (4) the value of lost sales, (5) the gap between system stock and shelf stock, (6) stock delays across channels, (7) the path to the 98% target, (8) monitoring indicators.
Lesson 1: How is the order fill rate defined?
In short: The fill rate is measured in three ways: on a line basis (how many items were fulfilled), on an order basis (how many orders went out complete) and on a unit basis (how many units were shipped).
- Line fill rate = Fully fulfilled order lines ÷ Total order lines
- Order fill rate = Orders fulfilled complete ÷ Total orders
- Unit fill rate = Units shipped ÷ Units ordered
Each tells you something different. The line rate shows how many products were found in the warehouse; it is a measure of inventory health. The order rate shows how often the customer receives a complete delivery; it is a measure of customer experience. The unit rate shows how much was fulfilled in bulk orders or multi-unit items. For the same business, the line rate can be 95% while the order rate is 94%, because even if a single item is missing from an order, the whole order counts as incomplete. As the number of items per order increases, the order rate falls faster than the line rate.
The definition of "fulfilled" must also be written down: a product is fulfilled if it was shipped in the ordered quantity, within the promised time and intact. Partial shipments, shipments completed later and canceled lines count as unfulfilled. An order turning out incomplete later triggers the cancellation process; for the rules of that process, see the article how to cancel an order.
Lesson 2: How do you calculate the fill rate for a sample month?
In short: In the sample month there are 6,800 lines and 9,500 units across 5,000 orders. The line rate comes to 95.0%, the order rate to 94.0% and the unit rate to 96.0%.
| Measure | Total | Fulfilled | Rate |
|---|---|---|---|
| Line | 6.800 | 6.460 | %95,0 |
| Order | 5.000 | 4.700 | %94,0 |
| Count | 9.500 | 9.120 | %96,0 |
Of the 5,000 orders, 4,700 went out complete. The remaining 300 orders fall into two groups: 260 orders were partially fulfilled (one or more items missing, the rest shipped), and 40 orders were canceled entirely because of missing products. In other words, 5.2% of orders are partial and 0.8% are canceled.
| Order outcome | Number of orders | Share |
|---|---|---|
| Fulfilled complete | 4.700 | %94,0 |
| Partially fulfilled | 260 | %5,2 |
| Canceled entirely | 40 | %0,8 |
| Total | 5.000 | %100 |
- Fulfilled complete₺4,70094%
- Partially fulfilled₺2605.2%
- Canceled entirely₺400.8%
Prepared with sample values. The total equals 5,000 orders.
Note one detail in the calculation: 6,800 − 6,460 = 340 lines are missing, and these missing lines are spread across 300 incomplete orders. So each incomplete order contains an average of 340 ÷ 300 ≈ 1.13 missing lines; most are missing a single item, a few more than one. To measure the total time to ship separately, see the article how to measure and shorten time to ship.
Lesson 3: What are the reasons for missing lines?
In short: Link each missing line to one of four reasons: out of stock, in the system but not on the shelf, defective product and channel stock delay. Whichever reason dominates is where the solution starts.
The sample month's 340 missing lines break down as follows by the reason code entered at the time of the order:
| Reason | Missing lines | Share | Meaning |
|---|---|---|---|
| Out of stock | 170 | %50,0 | No stock in the system or in reality |
| In the system, not on the shelf | 85 | %25,0 | Count discrepancy; recorded stock exceeds physical stock |
| Defective or damaged | 51 | %15,0 | Product found defective during picking |
| Channel stock delay | 34 | %10,0 | Stock ran out, still open for sale on the channel |
| Total | 340 | %100 |
- Out of stock170 lines
- In the system, not on the shelf85 lines
- Defective or damaged51 lines
- Channel stock delay34 lines
Prepared with sample values. Total 170 + 85 + 51 + 34 = 340 missing lines.
An important conclusion follows from this breakdown: only 50% of missing lines are genuine stockouts; the remaining 170 lines, the other half, come from inaccurate stock information or process errors. These are solved not with new purchases but with proper record-keeping. For the 85 lines caused by count discrepancies, use the article how to find and close stock discrepancies, and for defective products, the article how to measure supplier performance.
Lesson 4: How do you calculate the value of lost sales?
In short: Multiplying the number of missing lines by the average line value gives lost revenue; deducting product cost and selling expenses gives the lost contribution.
In the sample business, the average line value is ₺450. The revenue of the 340 missing lines is 340 × 450 = ₺153,000. If the product cost of this revenue is taken as 60% and selling expenses (commission, shipping, packaging) as 15%, the contribution ratio is 25%.
- Lost sales revenue (340 lines × ₺450)₺153,000
- Product cost (60%)−₺91,800
- Selling expenses (15%)−₺22,950
- Lost contribution₺38,250
Prepared with sample values. Total: 153,000 − 91,800 − 22,950 = ₺38,250.
In this calculation, lost contribution includes only the missing lines themselves: not the whole of the 40 orders canceled because of missing products, but the missing line in those orders. However, in an order canceled because one line is missing, the customer also gives up the other items; if this "basket loss" is measured separately, the damage is higher. To calculate the stockout side of lost sales in detail, you can use the article how to calculate the cost of stockouts. We explained how the product cost and contribution calculation is built in the article how to calculate profit margin.
Lesson 5: How do you close the gap between system stock and shelf stock?
In short: The "in the system, not on the shelf" problem is a count discrepancy. If products with the most orders are counted more often with cycle counting, most of this 85-line shortfall is closed.
Stock shown in the system can be missing from the shelf for three reasons: a different product going out after a wrong pick, damage and shrinkage not recorded in counts, and receipts or issues being recorded late. The solution is not a single annual count but frequent counts of risky products. A simple rule: count the 30 products with the most missing lines in the last 90 days weekly and the rest monthly. Suppose in the example 60% of the 85 missing lines come from these 30 products; counting them weekly reduces missing lines from 85 to about 34 (85 × 40%) in the first month.
| Count frequency | Number of products | Missing lines (example) |
|---|---|---|
| Single annual count | All products | 85 |
| 30 risky products weekly, the rest monthly | 30 + others | ≈ 34 |
Calculation: 60% of 85 lines is 51 lines, and assuming all 51 of these lines are fixed, 85 − 51 = 34 lines remain. We explained how to plan counts and how to reconcile records with physical stock in the article how to do a stock count. To prevent the wrong product from going out during picking, apply the control steps in the article how to do order picking and packing. Barcode scanning, shelf location labels and product code verification catch most of these errors; you can start setting them up with the article how to set up a barcode system.
Lesson 6: How do you prevent stock delays on sales channels?
In short: Products that stay open for sale on a channel after stock runs out are the source of 34 missing lines. To keep stock updates from lagging, manage from a single center and set a lower limit.
If the same stock is used across multiple sales channels, when a sale happens on one channel, stock must drop immediately on the others. If the update lags, the same last unit can be sold on two channels. That is why two measures are applied together. The first is to keep stock in a single center and push changes to the channels from there; for details, see the articles how to sync marketplace inventory and how to manage store and e-commerce stock from a single center. The second is to reserve part of the stock shown to channels as a safety buffer: if actual stock is 5 units but 3 are shown on the channel, update delays are absorbed.
A safety buffer is used for low-stock products; it is not needed for products with plenty of stock. The size of the buffer is determined by order frequency; for fast-selling products, a buffer of 2-3 units is enough. To set a lower limit for fast-moving products, use the method in the article how to calculate safety stock.
Lesson 7: How do you raise the fill rate to 98%?
In short: First reach 96.75% by eliminating record and process errors (count discrepancies, channel delays), then reach 98% by closing half of the genuine stockouts with safety stock.
Let's set the target at 98%: 2% of 6,800 lines, or 136 lines, can be missing. There are currently 340 missing lines; an improvement of 204 lines is needed. The sequence of actions is as follows:
- Eliminate record and process errors. Count discrepancies (85) and channel stock delays (34) total 119 lines. Assuming all of these are eliminated (the weekly count in lesson 5 is the first step; full correction takes a few months), missing lines drop to 340 − 119 = 221 and the rate becomes (6,800 − 221) ÷ 6,800 = 6,579 ÷ 6,800 = 96.75%.
- Prevent half of the out-of-stock lines. If half of the 170 lines (85) are prevented with safety stock and critical stock alerts, missing lines drop to 221 − 85 = 136; the rate is 6,664 ÷ 6,800 = 98.0%.
- Reduce defective product lines. The 51 lines fall over time with supplier feedback and receiving inspection; this action delivers extra gains beyond the target.
- Starting point95.00%
- Once count and channel errors are eliminated96.75%
- Once half of stockouts are prevented98.00%
Prepared with sample values. Rate: (6,800 − missing lines) ÷ 6,800.
When 98% is reached, lost contribution also falls: 136 missing lines remain instead of 340; the 204 recovered lines mean 204 × 450 = ₺91,800 in revenue and 91,800 × 25% = ₺22,950 in contribution. In other words, raising the fill rate by three points means roughly 23 thousand ₺ of extra profit per month. To set the critical stock threshold per product, use the article how to calculate safety stock; to keep the rate from falling in busy periods, also see the article how to prepare for a busy campaign period.
Recommended ReadingHow to Calculate the Cost of StockoutsLesson 8: How do you monitor the fill rate?
In short: In a weekly table, track the line fill rate, the order fill rate, the breakdown of missing lines by reason and lost contribution.
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Line fill rate | Fulfilled lines ÷ Total lines | %95,0 |
| Order fill rate | Complete orders ÷ Total orders | %94,0 |
| Genuine stockout share | Out-of-stock lines ÷ Missing lines | %50,0 |
| Record and process share | Count + channel delay ÷ Missing lines | %35,0 |
| Lost contribution | Missing lines × Line value × Contribution ratio | 38.250 ₺ |
- 95%line fill rate
- 94%share of orders fulfilled complete
- ₺38,250monthly contribution lost from missing lines
- ₺22,950monthly contribution recovered when the rate reaches 98%
Weekly monitoring is more sensitive than monthly monitoring; in the week a product runs out of stock, missing lines spike, but they disappear into an ordinary average at the end of the month. To add the indicator table to your weekly report, use the layout in the article how to prepare a weekly management report. As an alarm threshold, we can suggest notifying the warehouse manager when the line fill rate drops below 96%; the threshold should be set from your own historical data.
Recommended ReadingHow to Allocate Overhead to Products: Fixed Costs, Allocation Keys, Allocation by Revenue and Orders, Activity-Based Allocation and True Product Profit GuideWhat are the most common mistakes in measuring order fill?
- Looking only at the line rate. The line rate looks like 95%, yet 6% of orders go out incomplete.
- Not recording the reason for shortfalls. The problem is known but its source isn't, so the solution is aimed at the wrong place.
- Counting every shortfall as a stockout. Half are record and process errors; new purchases don't solve that part.
- Counting a partial shipment as fulfilled. For the customer the order is incomplete, and it should be recorded that way in the calculation too.
- Seeing lost sales only as revenue. The real loss is contribution; basket loss and customer trust come on top.
- Measuring the rate once a year. The problem becomes permanent; weekly tracking is needed.
- Updating channel stock with a delay. The same last unit is sold twice, leading to cancellations and customer complaints.
How does NetKasam make tracking order fill easier?
- One-screen order management. You see orders from different channels together and separate incomplete and canceled orders (order management).
- Stock movements. You track a product's receipt, issue and sales history and find the cause of count discrepancies (inventory management).
- Critical stock report. You set a critical stock level for your products and are notified when they drop to the lower limit.
- Stock from a single source. As marketplace and e-commerce orders come in, stock drops and channel stock doesn't lag.
- Status by branch and warehouse. You see stock separately for each location (branch and warehouse management).
- Saved reports. You save the weekly report and export it to Excel (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If 6,460 of 6,800 lines were fulfilled, what is the line fill rate as a percentage?
- If 4,700 of 5,000 orders went out complete, what is the order fill rate?
- If the average line value of 340 missing lines is ₺450, how many ₺ of revenue is lost?
- If revenue is ₺153,000, product cost is 60% and selling expenses are 15%, how many ₺ of contribution is lost?
- If missing lines drop to 136 (out of 6,800 lines in total), what is the line fill rate as a percentage?
Answer key:
- 6.460 ÷ 6.800 = %95.
- 4.700 ÷ 5.000 = %94.
- 340 × 450 = 153.000 ₺.
- 153.000 × (1 − 0,60 − 0,15) = 153.000 × 0,25 = 38.250 ₺.
- (6.800 − 136) ÷ 6.800 = 6.664 ÷ 6.800 = %98.
Frequently Asked Questions About the Order Fill Rate
What is the order fill rate?
It is the rate that shows how much of the items the customer wanted were fulfilled in the requested quantity and within the promised time. It is calculated on a line, order and unit basis.
What is the difference between line and order fill rate?
The line rate counts items; the order rate counts an order with even one missing item as incomplete. That is why the order rate is usually lower than the line rate.
What should a good fill rate be?
It depends on your product structure; however, it is sensible to set a target comparable with your own historical data. In the example, the target is a 98% line rate.
What are the reasons for missing lines?
They usually fall into four groups: out of stock, in the system but not on the shelf, defective product and channel stock delay.
How do you calculate the value of lost sales?
Multiply the number of missing lines by the average line value; deducting product cost and selling expenses gives the lost contribution.
Does a partial shipment count as fulfilled?
No. Since the customer received the order incomplete, the order counts as incomplete and the missing lines count as unfulfilled.
What is the first step to increase the fill rate?
Recording the reason for a missing line at the time of the order. Once the reasons are visible, separate actions are chosen for count discrepancies, channel delays and genuine stockouts.
How often should the fill rate be monitored?
Weekly. A monthly average hides the sudden drop in the week a product runs out of stock.
Conclusion: Record the reason for every incomplete order
The most useful thing you can do today is to calculate the line and order fill rates from the last month's orders and split the missing lines into the four reasons. The next step is to make sure a reason code is entered in the warehouse for every shortfall. The first month's breakdown tells you whether to spend your money on new stock or on counting and channel discipline.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.