New

The new HostCloud is live. Web Hosting for ₹1 for your first month.

Web Hosting for ₹1 · first month

Claim offerClaim
WordPress

WooCommerce HPOS: how to enable High-Performance Order Storage and check plugin compatibility

HPOS moves WooCommerce orders out of the WordPress posts table into dedicated tables. Here is what that changes, how to switch an existing store over safely, how compatibility mode works and what to do when a plugin is not compatible.

5 November 2026 · 9 min read
WooCommerce HPOS: how to enable High-Performance Order Storage and check plugin compatibility

WooCommerce HPOS: how to enable High-Performance Order Storage and check plugin compatibility

TL;DR: High-Performance Order Storage (HPOS) stores WooCommerce orders in dedicated database tables instead of mixing them into the WordPress posts and post meta tables. New stores have used it by default since WooCommerce 8.2, released in October 2023. Existing stores can switch in WooCommerce, Settings, Advanced, Features. The safe route is: back up, check plugin compatibility, turn on compatibility mode so orders sync both ways, wait for the background sync to finish, then switch to HPOS and keep sync on for a while so you can revert instantly if something breaks. Plugins and custom code that read orders directly from the posts table can break, so test on a staging copy first.

What HPOS is

By default, older WooCommerce versions stored every order as a "post" of a special type, with each piece of order data (billing address, totals, payment method and so on) in the post meta table. That design reused WordPress's tables but meant orders competed with every other kind of content in the same tables.

HPOS uses purpose-built tables for orders. The main ones are:

  • wc_orders for the core order record,
  • wc_order_addresses for billing and shipping addresses,
  • wc_order_operational_data for payment, shipping and other operational fields,
  • wc_orders_meta for custom order metadata.

Table names carry your database prefix, so they usually appear as wp_wc_orders and so on.

Diagram comparing the old order storage in the WordPress posts and post meta tables with HPOS, which stores orders in four dedicated tables, with a compatibility-mode sync between them

Why it exists

WooCommerce built HPOS for scale and reliability:

  • Faster order queries. Dedicated, indexed tables are quicker for searching, filtering and reporting on orders than scanning a shared posts and meta table. The gains matter most on stores with many orders.
  • Less contention. Order writes no longer compete with blog posts, pages and other content in the same tables.
  • Cleaner structure. Orders have their own schema, which makes them easier to maintain and extend.
  • Better scaling. Large stores can handle more orders per second.

How much faster your store gets depends on its size and setup. A small store with a few hundred orders will notice little difference, while a store with hundreds of thousands of orders can benefit much more. HPOS also does not replace page caching, a good database and enough server resources. See how much RAM WordPress and WooCommerce need and managed WooCommerce hosting in India.

Is it already on in your store?

  • New installations of WooCommerce 8.2 and later enable HPOS by default.
  • Older stores that were upgraded keep using the posts table until you switch.

To check, go to WooCommerce, Settings, Advanced, Features and look at the Order data storage section. It shows which storage is the authoritative one: "WordPress posts storage (legacy)" or "High-performance order storage". You can also see whether compatibility mode is on.

Before you switch

  1. Take a full backup of the files and the database. See how to back up a WordPress site and test the restore.
  2. Update WooCommerce, WordPress and all plugins to current versions.
  3. Check PHP and database versions against current requirements. See PHP 8.2 end of life and how to upgrade.
  4. Plan for a quiet period. Do the switch when order volume is low, for example overnight.
  5. List what touches orders. Payment gateways, shipping plugins, invoice and GST plugins, CRM and marketing integrations, inventory sync, analytics and any custom code.
  6. Avoid doing this during a sale.

Step 1: check plugin compatibility

WooCommerce shows a compatibility list for installed plugins.

  1. Go to WooCommerce, Settings, Advanced, Features.
  2. Find the section about order data storage, and look for the plugin compatibility notice. WooCommerce lists plugins that have declared themselves incompatible with HPOS, and may hide the option to switch until you review them.
  3. For each plugin that is not marked compatible, check the plugin's changelog or support page for "HPOS" or "custom order tables" support.
  4. Update any plugin that has a newer, compatible release.
  5. For plugins with no compatibility information, ask the developer, or test carefully on staging.

A plugin that has not declared compatibility is not always broken. Some simply have not updated their declaration. But a plugin that reads or writes orders directly in the posts table is likely to misbehave, so test it before you switch.

Common plugin types worth checking in an Indian store:

Step 2: test on staging

Copy your live store to a staging site and do the whole migration there first. See our WordPress staging guide.

On staging:

  1. Enable compatibility mode and let the sync finish.
  2. Switch to HPOS.
  3. Place several test orders with each payment method.
  4. Refund an order and change an order's status.
  5. Check emails, invoices, shipping labels and any integrations.
  6. View reports and exports.
  7. Review your error log.

If anything fails, find out which plugin or code is responsible. Fix, replace or update it, and only then move to the live site.

Step 3: enable compatibility mode and sync

Compatibility mode keeps the old posts table and the new HPOS tables in sync, so orders are written to both. It protects you while you switch and lets you go back if you need to.

  1. Go to WooCommerce, Settings, Advanced, Features.
  2. Turn on "Enable compatibility mode (synchronizes orders to the posts table)" and save.
  3. WooCommerce now starts background actions that copy your existing orders. According to the WooCommerce developer documentation, one action checks whether orders need syncing and schedules batches, and each batch processes 25 orders at a time until all orders are synchronised.
  4. You can let these run on their own, or run them manually from WooCommerce, Status, Scheduled Actions.
  5. Wait until the sync is complete. On a large store this can take a while.

If the sync seems stuck, the cause is usually a scheduled-actions or cron problem. See the next section.

Step 4: switch to HPOS

Once both tables are in sync, the option to choose HPOS as the authoritative storage becomes available.

  1. In the same Features page, select High-performance order storage as the order data storage.
  2. Save changes.
  3. Leave compatibility mode on.

WooCommerce's documentation recommends keeping compatibility mode enabled for a while after the switch, and notes that you can revert to the posts table if problems occur. Because both tables stay in sync, going back is quick.

Step 5: verify and keep sync on for a while

  • Place a real test order and confirm it shows in the orders list.
  • Check recent real orders for correct totals, addresses and statuses.
  • Test every payment and shipping method.
  • Check order emails and invoices.
  • Watch your error log and your store's performance.
  • Check integrations such as accounting, CRM and courier tools.

Keep compatibility mode on for at least a few weeks, or until you are confident that every plugin and custom script works. Then you can turn it off to reduce database writes. Note that compatibility mode writes orders twice, so it adds some overhead, which is the price of the safety net.

Hosting and cron requirements

HPOS migration depends on background processing.

  • Action Scheduler is the queue WooCommerce uses for batches. It needs WordPress cron, or a real server cron, to run. If cron is broken, the sync can stall. See WordPress cron jobs and scheduled posts.
  • Database permissions. The database user needs permission to create tables. Most hosts allow this.
  • Resources. The sync reads and writes many rows. On shared hosting, a big store may hit limits. Run it at a quiet time. See hosting resource limits explained.
  • Disk space. Compatibility mode stores order data in both places, so expect the database to grow.
  • Backups. Make sure your backup includes the new tables. Most full database backups do.

For developers: making custom code compatible

Custom code and plugins should stop reading order data directly from the posts and post meta tables.

  • Use WooCommerce's order functions and CRUD methods, such as wc_get_order() and the WC_Order getters and setters, rather than get_post_meta() or direct SQL on order posts.
  • Use wc_get_orders() or the order query API instead of WP_Query with the shop_order post type.
  • Save changes through the order object, for example $order->update_meta_data() followed by $order->save().
  • Declare compatibility so WooCommerce knows your plugin is safe:
add_action( 'before_woocommerce_init', function () {
    if ( class_exists( \Automattic\WooCommerce\Utilities\FeaturesUtil::class ) ) {
        \Automattic\WooCommerce\Utilities\FeaturesUtil::declare_compatibility(
            'custom_order_tables',
            __FILE__,
            true
        );
    }
} );

Only declare compatibility after you have tested your code with HPOS on.

Troubleshooting

Problem Likely cause What to try
Option to switch to HPOS is greyed out Sync is not finished, or incompatible plugins are active Wait for or run the sync, then review the compatibility list
Sync never finishes Action Scheduler is stuck, cron is failing or resources are limited Check Scheduled Actions for failed items, fix cron and run it at a quiet time
Orders missing in a plugin's report The plugin reads from the posts table Update the plugin, ask the developer or replace it
Duplicate or out-of-sync orders Compatibility mode off while a plugin writes to the posts table Turn compatibility mode on and re-sync
Errors after switching An incompatible plugin or custom code Switch back to posts storage, then find and fix the cause on staging
Slow orders page Large store, missing indexes or limited resources Check database health and server resources. See shared hosting capacity

If you need to revert, go back to the Features page, select the legacy posts storage and save, while compatibility mode is still on so both tables hold current data.

FAQs

What is HPOS in WooCommerce?

High-Performance Order Storage, a system that stores orders in dedicated database tables instead of the WordPress posts and post meta tables.

Is HPOS enabled by default?

For new installations since WooCommerce 8.2, released in October 2023. Existing stores keep the old storage until you switch.

How do I enable HPOS?

Go to WooCommerce, Settings, Advanced, Features, turn on compatibility mode, wait for orders to sync, then select high-performance order storage.

Will HPOS break my plugins?

It can break plugins that read orders directly from the posts table. Check the compatibility list, update plugins and test on staging first.

What is compatibility mode?

A setting that keeps the old posts table and the new HPOS tables in sync, so you can switch back if needed.

Can I go back to the old storage?

Yes, if you have kept compatibility mode on so both tables are current. You can select the legacy posts storage again in the Features settings.

Does HPOS make my store faster?

It can speed up order queries, especially on large stores. Small stores may see little difference, and HPOS does not replace caching or good hosting.

Should I switch my store now?

Most stores should, because it is the default direction for WooCommerce. Do it carefully: backup, check plugins, test on staging and keep compatibility mode on for a while.

Conclusion

HPOS is where WooCommerce is heading, and switching an existing store is straightforward if you prepare. Back up, check plugin compatibility, rehearse on staging, turn on compatibility mode, let the sync finish, switch and keep the safety net on until you are sure. Make sure cron works and your hosting has the resources for the sync.

HostCloud's WooCommerce-ready hosting gives your store room for background jobs and growth. See the plans at https://hostcloud.in.

Sources:

Related posts