Zee
(@doublezed2)
Hello rapidsuccess,
Thank you for contacting WooCommerce support.
I understand you’re trying to enable HPOS but are stuck with 30,142 orders pending in the sync process, even after disabling plugins and following all forum suggestions.
There isn’t a dedicated logging system built into WooCommerce HPOS for order syncing, but you can check WooCommerce logs under WooCommerce > Status > Logs. Check for anything related to HPOS or Order.
With 178,000+ orders, your database performance may be slowing down the process. Check your database server resources (CPU, RAM, disk I/O).
Also, check the Action Scheduler queue at Tools > Scheduled Actions. Filter for “Pending” actions related to HPOS migration and see if any are stuck.
Lastly, please share your site’s System Status Report with me. You can paste it into https://pastebin.com and share the link here. This will help me understand the site configuration.
Looking forward to your response. 🙂
We have cleared and restarted jobs I mean everything but no way to override.
https://pastebin.com/LDcMZppE
We are on a large dedicated server with 128gb ram so no issues just ran down to 30k and has been stuck there for weeks. We copied the database and setup a test server with nothing but woocommerce and it would not clear as well..
Hi @rapidsuccess,
Thanks for sharing the report and the additional details. While WooCommerce doesn’t log HPOS sync activity by default, you can enable debug logging to help track background processes and identify potential issues. To do this, add or update the following lines in your wp-config.php file:
define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);
Once enabled, repeat the sync process and then check the /wp-content/debug.log file for any errors. Also, navigate to WooCommerce > Status > Logs and review logs related to Action Scheduler, fatal-errors, hpos, or order sync. Please share any relevant logs via Pastebin.
Additionally, have you tried manually running any failed or pending scheduled actions through the dashboard or WP-CLI?
We haven’t heard back from you in a while, so I’m going to mark this as resolved.
If you have a few minutes, we’d love if you could leave us a review: https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/
This is not respoved we have tried eveything we can think of but still stuck at 30000 orders
Currently syncing orders… 30,850 pending
Hi @rapidsuccess ,
I’m sorry to hear you’re still having trouble syncing your orders with High-Performance Order Storage (HPOS) in WooCommerce. I know this kind of issue can be frustrating, especially with a large number of orders already involved. Let’s try some more advanced troubleshooting together to see if we can get this sorted.
One option I’d recommend is using WP-CLI to run the synchronization. This tool gives you more detailed control and feedback on what’s happening behind the scenes. Here are some commands that can help:
wp wc hpos sync — This starts the synchronization process.wp wc hpos status — This shows the current sync status, including how many orders haven’t synced yet.wp wc hpos verify_data — This checks for any mismatches between your legacy order data and the HPOS data.
Running these commands can sometimes highlight if certain orders are causing the sync to get stuck or fail.
If syncing still doesn’t work, there might be some leftover data conflicts causing trouble. In that case, you can try cleaning up with:
This command removes outdated or conflicting data that might be blocking the sync. After running cleanup, try syncing again with wp wc hpos sync.
You can find more detailed information about the commands here: https://developer.woocommerce.com/docs/hpos-cli-tools
Just a quick heads-up — please make sure you have a full backup of your site before running cleanup, just to be safe.
Give this a shot when you can, and please let me know how it goes!
