WooCommerce HPOS Sync Problems
WooCommerce Store Fixes
Orders look wrong because two systems disagree about where they live.
Orders are missing from the admin list, show incorrect details, or appear in reports but not in the order screen. WooCommerce may warn that order data is out of sync.
What it actually means
WooCommerce historically stored orders as WordPress posts, which was never a good fit for a store with real volume. High-Performance Order Storage moves them into dedicated database tables, which is considerably faster.
During the transition WooCommerce can run both systems at once, keeping them synchronized. Sync problems mean the two copies have drifted apart — an order written to one and not the other — so what you see depends on which source the screen you are looking at reads from.
This is a data-integrity problem rather than a display bug, which is why it deserves care rather than a quick toggle.
What usually causes it
Most likely first.
- 1
An interrupted migration
The conversion was started and stopped partway, leaving some orders in one store and some in both.
- 2
A plugin writing orders the old way
Extensions not yet compatible with HPOS write directly to post tables, bypassing the new storage entirely.
- 3
Sync disabled while both stores are in use
Compatibility mode switched off before the migration finished, so writes stop propagating.
- 4
A failed or backed-up scheduled action
Synchronization runs as scheduled actions. If cron is unreliable, sync silently falls behind.
- 5
A restore from a mismatched backup
Restoring only part of the database can put the two stores permanently out of step.
How to fix it
Work through these in order. Take a backup before you change anything.
Step 1 — Check the status page first
WooCommerce, Status shows which order storage is active and whether compatibility mode is on. Know your current state before changing anything.
Step 2 — Back up the database before touching sync
This is order data. Take a full backup and confirm you can restore it before running any migration or resync.
Step 3 — Confirm scheduled actions are running
Sync depends on them. If the queue is backed up, fix cron first — resyncing without working cron simply stalls again.
Step 4 — Run the sync and let it finish
Enable compatibility mode and allow synchronization to complete fully. On a large store this takes time and must not be interrupted.
Step 5 — Audit plugin compatibility
Check each extension declares HPOS compatibility. Anything that does not is a candidate for the drift and should be updated or replaced before you disable the legacy store.
When to stop and call someone
Call someone before running a migration on a live store with order history you cannot afford to lose. This is one of the few faults on this site where a hasty fix can cause permanent damage — mismatched order data is difficult to reconstruct after the fact.
Frequently asked
High-Performance Order Storage moves orders out of WordPress's posts tables into dedicated database tables built for the job. It makes order queries and admin screens substantially faster on stores with real volume, and is now the default for new installations.
Because orders are being written to one storage system and not the other. That happens when a migration is interrupted, when a plugin writes orders the legacy way, or when the scheduled actions that perform synchronization are not running reliably.
Generally yes, but back up the database first and confirm every extension declares HPOS compatibility. Incompatible plugins are the main source of problems, and order data is the last thing on a store you want to reconstruct.
Only once synchronization has fully completed and every plugin is confirmed HPOS-compatible. Disabling it early stops writes propagating between the two stores and is a common way sites end up with orders visible in one place and not the other.
On stores with significant order volume, noticeably — order lists, searches, and reports all get faster because they no longer query a table shared with every post and revision on the site. On a very small store the difference is minor.
If you’d rather not
We do this work every week. These are the services that cover it.
- eCommerce DevelopmentBuild a store that makes buying feel simple. We shape product pages, checkout, payments, tracking, and store workflows so customers can act with confidence.
- Custom Web SolutionsBuild the web system your business actually needs. We design custom web systems around your offer, your team, your data, and the way buyers move from interest to action.
- Fixing WordPress PluginsOne bad plugin can take your whole site down. We fix plugin conflicts, fatal errors, and security holes fast — and build custom plugins when the off-the-shelf ones fall short.
See exactly what’s holding your website back.
Get a free audit of your site — speed, SEO, mobile, and security — with the fixes that matter most, delivered as a PDF to your inbox.