Inventory Says It’s in Stock—but the Shelf Is Empty: 6 Causes and How to Fix Them
By Ty Fisher, founder of Fisher Software
Few inventory problems are more frustrating than seeing six units in the system while the shelf is empty. The record looks healthy, but the product is not available when a customer wants it. This is often called phantom inventory: stock that exists in the records but cannot actually be sold. The fix starts by finding where the quantity stopped matching reality.
1. Receiving was recorded differently from what actually arrived
A purchase order may say 24 units, but a short shipment, damaged carton, substitution, or counting mistake can mean fewer units physically arrive. If the full order is received into the system anyway, the discrepancy begins before the product ever reaches the shelf. Count what arrives, record shortages, and keep partial deliveries open until they are resolved.
2. A sale, transfer, or adjustment was never recorded
Inventory stays accurate only when every movement is captured. A product moved to another location, used internally, given to a customer, or manually removed without a matching transaction can leave the system showing inventory that is no longer there. Review recent activity before simply changing the quantity.
3. The product is in the building—but not where employees expect it
Sometimes the count is right and the location is wrong. Overstock may be placed on another shelf, returns may be waiting for processing, or a transfer may have been physically moved before the system location was updated. Clear location labels and consistent transfer procedures make these problems much easier to find.
4. Case packs and individual units are being mixed up
Unit-of-measure mistakes can create large quantity errors very quickly. If one case contains 12 sellable units, receiving one case as one unit understates inventory; receiving 12 cases as 12 individual units can do the opposite. Make sure each SKU clearly defines what one inventory unit represents.
5. Damage, returns, or shrinkage were handled outside the normal process
Damaged products, customer returns, expired goods, and missing items all affect available inventory. If they are set aside or discarded without an inventory adjustment, the system continues to count them as sellable. Require a clear reason whenever stock is removed or corrected so recurring causes become visible.
6. Two systems are not updating at the same time
When inventory is shared between a point-of-sale system, ecommerce store, spreadsheet, or another app, timing and mapping matter. Duplicate SKUs, delayed imports, and mismatched variants can create temporary or repeated differences. Keep product identifiers consistent and verify that the same SKU and location are being updated everywhere.
A practical way to fix the mismatch
- Physically count the affected SKU before making an adjustment.
- Review receiving, sales, returns, transfers, damage, and manual adjustments since the last known-good count.
- Confirm the SKU, barcode, unit of measure, and location are correct.
- Correct the quantity only after identifying the most likely cause.
- Record the reason for the correction so repeated patterns can be fixed at the process level.
- Cycle-count products with repeated discrepancies more often.
Prevent phantom inventory from becoming a routine problem
The goal is not perfect inventory once a year. It is a process that catches small differences before they become customer-facing stockouts. Barcode scanning, clear locations, regular cycle counts, low-stock visibility, and consistent receiving and adjustment rules all make the system quantity more trustworthy day to day.