Why Magento shows the wrong stock: stale indexes explained
Products showing in or out of stock incorrectly? Direct inventory updates can leave stock index tables stale. Here is why it happens and how to fix it properly.
Products showing in or out of stock incorrectly? Direct inventory updates can leave stock index tables stale. Here is why it happens and how to fix it properly.
We saw quantities updated correctly while the stock status index still held old values, so products appeared in or out of stock incorrectly until indexing caught up.
How Magento decides stock status
The storefront relies on indexed stock status (for example cataloginventory_stock_status and inventory index tables). If quantities change without the index being updated, customers see old availability.
RELATED GUIDEGoogle Merchant Center feed optimisation: fix disapprovals and win more Shopping clicks → Need reliable ecommerce support?Patches, upgrades and fixes from certified developers.Get a free store health check →Common causes
- Integrations writing directly to stock tables
- Indexers stuck or invalid
- Cron not running or jobs failing
- Cache not refreshed after updates
- Multi-source inventory configuration issues
How to fix it
Update stock through Magento APIs or services, keep indexers on schedule with healthy cron, and monitor indexer status and backlog.
Common mistakes to avoid
How we help with ecommerce
Frequently asked questions
Why does stock look right in admin but wrong on the site?
Admin often reads raw data while the storefront uses indexed data.
Should I reindex manually?
As a one-off fix yes, but solve the root cause.
Does this affect Google Shopping?
Yes — wrong availability can cause Merchant Center mismatches.