WooCommerce · Guide
WooCommerce HPOS: What It Is and How to Switch
Short answer
HPOS, or High-Performance Order Storage, stores WooCommerce orders in four dedicated database tables instead of the WordPress posts tables. New stores have used it by default since WooCommerce 8.2, released in October 2023. Older stores can switch under WooCommerce, then Settings, then Advanced, then Features, after turning on compatibility mode and letting orders sync.
Key takeaways
- HPOS stores orders in four dedicated tables instead of the WordPress posts tables.
- New stores have used HPOS by default since WooCommerce 8.2, released in October 2023.
- Existing stores are never moved on their own: the switch is opt-in.
- Turn on compatibility mode first and wait for orders to sync 25 at a time before switching.
- All extensions on WooCommerce.com are HPOS-compatible; outside extensions may block the switch.
What is HPOS in WooCommerce?
HPOS is WooCommerce's order storage system, which keeps orders in four dedicated tables instead of the WordPress posts tables.
WooCommerce says HPOS, previously called Custom Order Tables, is built for ecommerce needs and stores order data in custom tables made for WooCommerce queries. See High-Performance Order Storage.
Before version 8.2, WooCommerce stored order data in the _posts and _postmeta tables. HPOS moves it to _wc_orders, _wc_order_addresses, _wc_order_operational_data, and _wc_orders_meta.
WooCommerce says the dedicated tables and indexes mean fewer read and write operations and fewer busy tables, which helps stores scale as orders grow. The same HPOS doc lists scalability, reliability, and simplicity as the three gains.
HPOS is the default for new installations from WooCommerce 8.2 onward, and WooCommerce 8.2 was released in October 2023. Existing stores are not moved over on their own.
A slow orders page is often the first sign the old storage is struggling. See How to Fix A Slow WooCommerce Orders Page
What do you need before you switch to HPOS?
You need a full backup, a staging copy to test on, and a list of the plugins that touch orders.
Back up the database and files first. HPOS moves order data between tables, so a backup is the only way back if something goes wrong.
WooCommerce says to keep extensions that use custom post types, such as Woo Subscriptions or WooCommerce Bookings, active while you switch. Turning one off first can leave its order data behind. See High-Performance Order Storage.
All extensions on WooCommerce.com are HPOS-compatible, and WooCommerce checks that on each version update, while extensions from outside the Marketplace may not be. The same HPOS doc states this.
WooCommerce says there are no hosting restrictions for HPOS: any host that can run WordPress and WooCommerce can run it. The same doc also notes the switch is opt-in, so you can do it any time.
If you only need the background, read What Is HPOS in WooCommerce? A Plain Explanation
| Check | Where to find it | Pass means |
|---|---|---|
| Backup done | Your backup plugin or host panel | Database and files saved |
| Staging copy | Your host staging tool | Same plugins and theme as live |
| Plugins checked | WooCommerce, Settings, Advanced, Features | No incompatible plugin named |
| Extensions active | Plugins screen | Subscriptions and Bookings still on |
How do you check whether your store already uses HPOS?
Open WooCommerce, then Settings, then Advanced, then Features, and read the Order data storage setting.
If it says “High-performance order storage (recommended)”, your store already uses HPOS and you have nothing to switch.
If it says “WordPress posts storage (legacy)”, your store still uses the old tables. That is normal for a store set up before WooCommerce 8.2.
The current version is WooCommerce 11.3.0, listed on WordPress.org as tested up to WordPress 7.1.5 as of November 2026. Older versions may show different labels on the Features page, so check the WooCommerce plugin page before you start.
You can also check from the command line. WooCommerce's developer docs list the wc hpos commands for managing HPOS. See the wc hpos command reference.
How do you enable HPOS step by step?
Enable compatibility mode first, wait for orders to sync, then switch the storage setting to HPOS.
- Back up the store, then test the same steps on a staging copy first.
- In WordPress, go to WooCommerce, then Settings, then Advanced, then Features.
- Tick "Enable compatibility mode (synchronizes orders to the posts table)" and click Save changes.
- Wait for the background sync to finish. WooCommerce copies orders 25 at a time, and you can watch the actions under WooCommerce, then Status, then Scheduled Actions.
- When the sync is done, pick “High-performance order storage (recommended)” as the Order data storage and click Save changes.
- Leave compatibility mode on for a while, then turn it off once orders, refunds, and reports all look right.
WooCommerce says to keep compatibility mode on for some time after the switch, since going back to the posts table is then instant. See High-Performance Order Storage.
If the HPOS option is greyed out, an active plugin is marked incompatible. Click “View and manage” on the Features page to see which ones. The same HPOS doc explains this block.
Large stores can sync from the command line instead: WooCommerce's HPOS doc gives the command wp wc cot sync to copy orders to the HPOS tables. The same doc notes the older wc cot names are still in use.
WooCommerce's server recommendations ask for PHP 8.3 or newer and a WordPress memory limit of 256 MB or greater. Meet that floor before you switch. See WooCommerce Server Recommendations.
How long does the switch take?
The switch itself takes minutes, but the sync time depends on how many orders your store holds.
WooCommerce copies 25 orders at a time in the background, so a store with a few hundred orders syncs in minutes, while a store with tens of thousands may take hours.
Do the switch during a quiet period, so new orders do not land while the tables are syncing.
Keep compatibility mode on for at least a few days of normal trading before you turn it off.
If the sync stalls, check the server: WooCommerce asks for a WordPress memory limit of 256 MB or greater, while PHP's own default memory limit is 128M. The PHP manual lists the 128M default in Description of core php.ini directives.
How do you check HPOS worked?
Check three things after the switch: orders open, new orders save, and reports match the old totals.
- Open WooCommerce, then Orders, and open a few old orders. Each should show its items, totals, and customer details.
- Place a test order and confirm it appears in the order list with the right status.
- Open WooCommerce, then Analytics, then Revenue, and compare the totals with the week before the switch.
- Check refunds, subscriptions, and any plugin that reads orders, such as shipping or invoicing tools.
WooCommerce says HPOS makes targeted backup and restore simpler, since orders live in their own tables. See High-Performance Order Storage.
The Status report also shows your storage setup. See How Do You Read the WooCommerce Status Report?
Also confirm scheduled actions finish: open WooCommerce, then Status, then Scheduled Actions, and check that no HPOS sync action is stuck as failed.
If anything looks wrong, switch back while compatibility mode is still on. WooCommerce's HPOS doc gives the rollback steps on the same Features page: turn compatibility mode on, wait for the sync, then pick WordPress posts storage.
What if a plugin blocks the switch?
WooCommerce blocks the switch while an active plugin is marked incompatible with HPOS, and names the plugin on the Features page.
Click “View and manage” to see the list. WooCommerce's HPOS doc also gives a plugins page link filtered to incompatible plugins, using your own domain. See High-Performance Order Storage.
Ask the plugin's developer to add HPOS support. WooCommerce says it is up to each extension developer to add support, and points to its developer resources for help. The same HPOS doc states this.
Developers declare support with a short call in the plugin's main file, using FeaturesUtil::declare_compatibility for the custom_order_tables feature. WooCommerce's recipe book shows the exact code. See the HPOS extension recipe book.
Do not switch with an incompatible plugin active. A plugin that reads orders from the posts tables can miss orders once HPOS is the only store.
Custom code needs the same audit. WooCommerce's recipe book says to check the code for direct database access and WordPress APIs that should not be used with orders any more. See the HPOS extension recipe book.
If the plugin is one you can replace, switch to an HPOS-compatible one first, then run the HPOS steps again.
Update WooCommerce and the plugin first, since a newer release may already declare support. See How to Update WooCommerce Safely
What mistakes should you avoid?
The most common mistake is switching without a backup or a staging check, which turns a small problem into a lost-orders problem.
- Switch on the live store first. Test the same steps on staging, with the same plugins.
- Turn off compatibility mode at once. Leave it on until orders, refunds, and reports all check out.
- Deactivate Subscriptions or Bookings before the switch. Keep them active so their order data moves too.
- Ignore the incompatible-plugin warning. Fix or replace the plugin before you switch, not after.
- Forget to save the Features page between changes. WooCommerce's HPOS doc warns to save the page between changes.
HPOS is opt-in for existing stores, and WooCommerce says you can switch any time. There is no deadline forcing the move, so take the safe route.
Frequently asked questions
Can I switch back from HPOS to the old storage?
Yes, if compatibility mode is still on. Go to WooCommerce, then Settings, then Advanced, then Features, make sure compatibility mode is on, wait for the sync to finish, then pick WordPress posts storage (legacy) and save. WooCommerce's HPOS doc gives these rollback steps. If you already turned compatibility mode off, turn it on first and wait for the sync.
Will WooCommerce switch my store to HPOS on its own?
No. Existing stores are not moved to HPOS on their own, and WooCommerce says the switch is opt-in. New installations have used HPOS by default since WooCommerce 8.2, released in October 2023. An older store keeps the posts storage until you switch it by hand under WooCommerce, then Settings, then Advanced, then Features.
Does HPOS change how products are stored?
HPOS only changes where orders are stored. Products, customers, coupons, and settings stay where they are. The four new tables hold orders, order addresses, operational data, and order meta. Product data still lives in the WordPress posts tables, so HPOS does not change how products are stored.
Are all WooCommerce extensions compatible with HPOS?
No. All extensions on WooCommerce.com are HPOS-compatible, and WooCommerce checks that on each version update. Extensions from outside the Marketplace may not be, and WooCommerce blocks the switch while one is active. Click View and manage on the Features page to see the list, then ask the developer to add support.
Will HPOS make my store faster on any hosting?
No. HPOS changes the storage engine, not the hosting plan, so a slow host stays slow. What changes is how order queries run: dedicated tables and indexes mean fewer read and write operations on large order lists. Pair the switch with hosting that meets the WooCommerce server recommendations for the full gain.
Sources
- High-Performance Order Storage WooCommerce
- HPOS extension recipe book WooCommerce Developer Docs
- wc hpos command reference WooCommerce Developer Docs
- WooCommerce Server Recommendations WooCommerce
- WooCommerce plugin page WordPress.org
Is your product missing, or something out of date?
Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.
Thanks — we review requests within 3 business days.
