High-Performance Order Storage (HPOS), previously called Custom Order Tables, is a new WooCommerce feature that stores order data in dedicated database tables instead of the default WordPress _posts and _postmeta.
HPOS was introduced in WooCommerce version 8.2. It’s enabled by default for new installations and available as an opt-in feature for existing stores.
This update makes WooCommerce faster, more scalable, and easier to managem especially for stores with lots of orders.
If you’re just starting to build your store, check out our full guide on how to create an online store with WooCommerce.
Why Switch to HPOS?
WooCommerce has historically saved orders as “posts” in the WordPress database, which isn’t ideal for stores with thousands of orders. HPOS solves this by separating order data into optimized tables designed just for WooCommerce. The main benefits include:
- Speed – HPOS improves checkout and admin performance by reducing database load.
- Scalability – Handles more orders without slowing down the site.
- Stability – Less risk of data conflicts and easier backups.
- Cleaner structure – Developers can work with structured data instead of overloaded meta tables.
Who Should Use HPOS?
HPOS is suitable for stores of all sizes. While high-volume stores benefit the most, even small shops can enjoy faster performance. If you run a WooCommerce store and your plugins are compatible, you should consider enabling it.
How to Enable HPOS in WooCommerce
HPOS is enabled by default on new WooCommerce installations (version 8.2 and above). For existing stores, follow these steps:
- In your WordPress dashboard, go to WooCommerce > Settings > Advanced > Features.
- Check the box labeled Enable compatibility mode. This ensures data is synchronized between the old and new systems.
- WooCommerce will automatically begin syncing orders in the background. You can wait, or manually run the sync under WooCommerce > Status > Scheduled Actions.
- Once syncing is complete, return to the Features screen and choose High-performance order storage as your active method.
Important Notes Before Migrating
Before you enable HPOS, make sure all your critical plugins-especially ones that handle orders like Subscriptions or Bookings-are active.
If they’re disabled during migration, WooCommerce may not sync their order data correctly, which could lead to missing or broken order records.
How to Avoid Problems
- Do not disable important plugins before enabling HPOS.
- If you already activated HPOS and noticed issues, switch back to the legacy system, let WooCommerce re-sync the orders, then try again.
- Always back up your site before making structural database changes.
What If a Plugin Isn’t Compatible?
If a plugin you’re using doesn’t support HPOS yet, WooCommerce will block the feature until the plugin is updated. You’ll see a message about incompatible extensions in the settings screen. You can also visit:
https://yourdomain.com/wp-admin/plugins.php?plugin_status=incompatible_with_feature&feature_id=custom_order_tablesIn the meantime, you can continue using legacy order storage. It’s also a good idea to contact the plugin developer and ask them to support HPOS.
Switching Back to Legacy Storage
You can revert to the old system if needed. Go to WooCommerce > Settings > Advanced > Features and choose WordPress posts storage (legacy). If compatibility mode is off, re-enable it to sync the data again.
How Synchronization Works
When compatibility mode is enabled, WooCommerce keeps the legacy and HPOS tables in sync. You can safely test HPOS while keeping a copy of all data in the old structure. After verifying everything works, you can disable compatibility mode and run your store fully on HPOS.
The following tables are used by HPOS:
_wc_orders_wc_order_addresses_wc_order_operational_data_wc_orders_meta
Frequently Asked Questions
Here are some of the most common questions users have about High-Performance Order Storage and what you need to know before switching.
Final Thoughts
HPOS is a major improvement for WooCommerce. It gives your store better performance, cleaner database tables, and more flexibility for growth. If your plugins are compatible and you’ve backed up your site, enabling HPOS is highly recommended.
You can also refer to the official WooCommerce HPOS documentation for more technical details.
