Question: Best practices for testing WooCommerce HPOS compatibility? #67086

Hi @hiSoft1129 , you've got the core concept right already, so most of the groundwork is done. Taking your questions in order.

WooCommerce does the first compatibility pass for you: under WooCommerce > Settings > Advanced > Features, the HPOS section lists any active plugins that declare themselves incompatible, and wp wc hpos compatibility-info gives you the same list from WP-CLI. One thing to keep in mind: this only catches plugins that declare their status, so a plugin that never declares anything still needs a manual look.

In your own code, the usual offenders are direct calls like get_post_meta() or update_post_meta() with an order ID, get_posts() or WP_Query on the shop_order post type, and raw SQL against wp_posts or wp_postmeta. The fix is the CRUD layer: wc_get_order(), wc_get_orders(), and the order object's meta methods work the same on both storage backends. Once your code is clean, declare compatibility with FeaturesUtil::declare_compatibility( 'custom_order_tables', __FILE__, true ) in your main plugin file.

To find stray queries, enable HPOS with compatibility mode (the setting that keeps orders synced to the posts table) on staging. Anything writing to the legacy tables directly shows up as a data mismatch, and wp wc hpos verify_data or wp wc hpos diff <order_id> will point at the exact fields. Query Monitor also helps for spotting direct wp_posts queries on checkout and the order admin screens.

And yes, staging first is the right call. Turn on compatibility mode, let the sync finish, run with both tables for a while, and only make the HPOS tables authoritative on production once verify_data comes back clean and your plugins behave.

The docs cover all of this in more depth: https://developer.woocommerce.com/docs/features/orders/high-performance-order-storage/

Recipe book (includes a regex for auditing your code): https://developer.woocommerce.com/docs/features/orders/high-performance-order-storage/recipe-book/

One note on venue: this repo's issues and discussions are mainly for WooCommerce core development. For setup and store-level questions like this, you'll get more eyes on the community forum: https://wordpress.org/support/plugin/woocommerce/