Pixlio← All Posts
E-CommerceApril 8, 2026

WooCommerce HPOS: What It Is and Whether You Should Enable It

High Performance Order Storage is one of WooCommerce's biggest architectural changes in years. Here's what it does and how to migrate your store safely.

WooCommerce HPOSOrder storageDatabase performanceWooCommerce migrationStore optimisation

What HPOS Actually Is

High Performance Order Storage (HPOS) replaces WooCommerce's legacy order storage system, which was built on WordPress's custom post types (CPT) table — a structure never designed for transactional data. HPOS moves orders into dedicated database tables built specifically for e-commerce. The result is faster order queries, better database performance under load, and a cleaner architecture that will support WooCommerce's development for the next decade. It has been available since WooCommerce 7.1 and is now the default for new installations.

Why the Old System Was a Problem

The original CPT-based order storage stores order data across multiple tables (wp_posts, wp_postmeta) in a structure that requires complex joins for every query. On stores with thousands of orders, this becomes a significant performance bottleneck — slow order admin screens, delayed reporting, and increased database load affecting the whole site. HPOS uses a single, purpose-built table (wp_wc_orders) that handles these queries far more efficiently.

Should You Enable It?

For most stores, yes — but timing matters. If you're running a new WooCommerce installation, HPOS is already the default and you should leave it enabled. For existing stores, the decision depends on your plugins. Any plugin that directly queries the wp_posts or wp_postmeta tables for order data — rather than using WooCommerce's official API — will break with HPOS enabled. Before migrating, check that your theme and all active plugins are marked as HPOS-compatible in their documentation or changelogs.

How to Migrate Safely

Enable synchronisation first: in WooCommerce → Settings → Advanced → Features, turn on 'Order data synchronisation' before enabling HPOS. This keeps both the old and new tables in sync during the transition, giving you a fallback. Run the migration on a staging site first. Check every plugin's compatibility. Test order creation, editing, refunds, and reporting thoroughly. Only then migrate production. The sync mode means you can roll back if something breaks — don't skip it.

Performance Impact

In practice, stores migrated to HPOS typically see 30–60% improvement in order query times and noticeably faster WooCommerce admin screens on larger catalogues. Reporting dashboards that previously timed out on stores with 10,000+ orders load reliably post-migration. For high-volume UK stores in particular, the database efficiency gains compound meaningfully over time.

Ready to start your project?

Get a free, no-obligation quote from our team in Manchester.

Get a Free Quote