WooCommerce HPOS Migration Checklist: Test, Break, Roll Back
A working checklist for moving a live WooCommerce store to HPOS: what breaks, the queries to grep for, how to test on staging, and how to roll back.
Writing
HPOS: what we have had to fix
14 write-ups from production, newest first. Each one is a problem hit on a real project and how it was diagnosed and fixed.
WooCommerce Analytics Empty After HPOS Migration: The Fix
WooCommerce Analytics dashboard showing zero orders after enabling HPOS? Here is why the lookup tables never rebuilt and the WP-CLI fix that restores it.
WooCommerce Custom Order Status Emails Not Sending
WooCommerce custom order status emails silently stopped after HPOS migration? Why the transition hook misses, and the fix that restores notifications.
WooCommerce Stock Not Reducing After Order: The Real Fix
WooCommerce orders complete but stock levels never drop? Here is why HPOS plus page caching hides the bug and the exact hook order that fixes it today.
WooCommerce 10.8 Stock Not Deducting After Order Status
WooCommerce 10.8 manual orders not reducing stock after a status switch to processing? Here is the hook rename and the one-line fix that restores it cleanly.
WooCommerce Refund Button Disabled on HPOS Order Screen
WooCommerce refund button greyed out on HPOS order edit screen after 10.8? Here is why the capability check fails and the action filter fix that works again.
WooCommerce Custom Order Status Missing in HPOS Admin
Custom order status registered with register_post_status disappears after WooCommerce HPOS migration. Here is why and the exact filter that brings it back.
WooCommerce HPOS Bulk Order Status Update Failing Silently
WooCommerce HPOS bulk action shows 'Updated' but order status never changes? Here is why the legacy hook fires on the wrong table and the action fix that holds.
WooCommerce Filter by Attribute Block Not Working with HPOS
WooCommerce Filter by Attribute block returning empty results on HPOS stores? Here is the index rebuild and lookup table fix that gets filters working again.
WooCommerce 10.7 Short Description Editor Missing in Admin
WooCommerce 10.7 short description editor missing from product admin? HPOS shifts the meta box registration timing. Restore it with one filter and a hook.
WooCommerce HPOS Order Search by Email Not Working Fix
WooCommerce HPOS order search by customer email returning empty? The legacy postmeta query is bypassed. Add a custom filter against the orders table.
WooCommerce Subscriptions 8.6.1 Renewal Mode Bug: Fix
WooCommerce Subscriptions 8.6.1 fixes renewal mode bugs on HPOS stores after plan and gateway switches. Here is the safe audit and repair path today.
WooCommerce 10.7 HPOS Sync on Read Fix
WooCommerce 10.7 disables HPOS sync on read by default. If your plugins still write to posts tables, here is the fix path before order data drifts safely.
WooCommerce HPOS Custom Queries Breaking: The Fix
WooCommerce HPOS breaks custom order queries using WP_Query or postmeta. Here's the exact fix with working code for WooCommerce 8.7+ stores.
We take HPOS work on subcontract and direct.
Fixed price for a defined scope, on live sites, with a rollback path. Agencies and in-house teams welcome.
Hire me for HPOS