OTIF (On Time In Full) is the percentage of orders that arrived by the committed date and with everything that was ordered, both at once. If 88 out of 100 orders arrived on time and complete, your OTIF is 88%. An order that arrived on time but incomplete counts as a failure, and so does one that arrived complete but late.
It's the metric retailers use most to grade their suppliers, and the most useful one for knowing whether your logistics deliver what you promise.
The formula
OTIF = orders delivered on time and complete ÷ total orders × 100
To apply it, you need to define two things before measuring, in writing:
- What "on time" means. The exact promised day? A two-day window? Does early count?
- What "in full" means. The whole order, each line (each SKU in the order), or each unit? With the same data, the result changes a lot depending on which you choose.
There's no single official definition. That's why a 95% OTIF means nothing unless you know how it was measured.
The most common mistake: multiplying the two percentages
Many spreadsheets take the on-time percentage, the in-full percentage, and multiply them. It looks equivalent, but it's only correct if late orders and incomplete orders are unrelated to each other. That's rarely the case.
An example with 100 orders, 10 late and 10 incomplete:
| Scenario | True OTIF | On time × in full |
|---|---|---|
| The 10 late orders are the same 10 incomplete ones | 90% | 90% × 90% = 81% |
| They're 20 different orders | 80% | 90% × 90% = 81% |
In the first case the multiplication punishes you too much; in the second it gifts you a point. To get it right, count order by order: each one passes or fails. (The example is illustrative.)
Order, line or unit: same warehouse, three numbers
Picture a 5-SKU order missing one unit of one SKU:
- At order level, it fails entirely: 0 of 1.
- At line level, one line in five fails: 80%.
- At unit level, if it was 50 units and one was missing: 98%.
None is wrong; they measure different things. Order level is the strictest and the closest to what your end customer experiences. What matters is that the number your logistics provider reports and the one you calculate use the same basis. That gets fixed in the fulfillment SLA.
OTIF, fill rate and perfect order
Three metrics that get mixed up:
| Metric | What it measures | What it leaves out |
|---|---|---|
| Fill rate | How much of what was ordered was supplied (by unit, line or order) | Time |
| OTIF | Orders on time and complete | Damage, billing or document errors |
| Perfect order | On time, complete, undamaged, correctly billed, correct documents | Nothing; it's the strictest |
Perfect order drops fast because each condition compounds. According to a 2026 KPMG analysis, meeting each of five conditions 95% of the time leaves your perfect order rate around 77%.
What Walmart requires (in the U.S.)
The best-known program is Walmart's in the United States, which began fining suppliers over OTIF in 2017. Since February 2024 it requires 90% on time and 95% in full from suppliers who pay their own freight, according to Logistics Management (Feb 29, 2024). The fine has been 3% of the cost of the goods that missed, per press reports on the supplier memos.
Two honest caveats: the current details are only visible to suppliers in Walmart's portal, so these figures come from trade press, not Walmart. And we found no public OTIF requirement from Walmart de México; if you sell to them, ask your buyer for it in writing.
We also found no reliable public figure for average OTIF in Mexico. We won't make one up.
How to raise your OTIF
Most failures aren't the carrier's; they start in the warehouse:
- Incomplete orders come from inventory the system says exists but isn't on the shelf. Cycle counts and inventory control fix it.
- Picking errors (wrong size or color) are prevented by scanning at every step; we priced them in what a picking error costs.
- Late orders are almost always orders that left after the cutoff time. If the promise is "ships today," the warehouse has to keep it at peak volume, not just on a Tuesday.
And the basics: measure it weekly, with the same definition, and review failures one by one. The percentage tells you how much; the failure list tells you why. Other metrics worth tracking alongside OTIF are in warehouse KPIs: what to measure.
FAQ
What does OTIF mean? On Time In Full. It's the percentage of orders delivered by the committed date with everything that was ordered.
How is OTIF calculated? Divide orders delivered on time and complete by total orders and multiply by 100. Count order by order; don't multiply the on-time percentage by the in-full percentage.
What's the difference between OTIF and fill rate? Fill rate only measures how much of the order was supplied. OTIF also requires it to arrive on time.
If you want your operation measured on order-level OTIF, with a written SLA, see our fulfillment service in Mexico.