I am seeing around 90,000 completed wc-admin_import_orders in 30 mins.
Can someone help please!
Hi there!
I understand that you’re seeing a large number of pending scheduled actions on your site. To assist you further, I suggest installing the Action Scheduler plugin, which allows you to manage and monitor the status of your scheduled actions. This can help identify why these actions are repeating so frequently.
Also, In the meantime, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
- System Status Report which you can find via WooCommerce > Status
- Fatal error logs (if any) under WooCommerce > Status > Logs.
Please use https://pastebin.com/ or https://gist.github.com/ and share a link to that paste in reply here. Once we have more information, we’ll be able to assist you further.
Fatal Error Logs
https://pastebin.com/uVZuDfju
System Status Report
https://pastebin.com/QHXEjuZ2
I think I might have narrowed things down to Analytics in WooCommerce. Under settings tab, the Import historical data is running indefinitely. Even when I uncheck the “skip previously imported customers and orders” and stop importing it just keeps restarting.
Hi @meatface888
Thank you for sharing both the logs and your system status report. From the error message, it looks like there’s a delay in your MySQL database that’s affecting how Rank Math and WooCommerce interact—specifically when running scheduled tasks.
This type of issue can be triggered by several factors, such as high database load, slow queries, long-running processes locking up the database, limited server resources, or even a plugin conflict during scheduled actions.
Since you mentioned that WooCommerce Analytics seems to be running continuously, that could be part of the problem—and it’s worth investigating what’s causing that behavior.
To help resolve this:
- Install the WP Crontrol plugin
Use it to check and manually run any pending or failed scheduled actions. It can also help you monitor for ongoing errors or scheduling issues.
- Use WP-Optimize
Run a database optimization (but please back up your site first). This can help reduce unnecessary overhead and clean up bloat.
- Clear WooCommerce caches
Go to WooCommerce > Status > Tools and:
- Clear transients (both regular and expired)
- Recount terms
- Clear template cache
- Clear analytics cache
- Temporarily deactivate Rank Math
This will help you confirm whether the issue is directly tied to that plugin.
If the issue still persists, I recommend reaching out to your hosting provider. Share the exact error with them and ask them to review your server and database performance, as they can check if it’s hitting resource limits or timeouts.
Let me know how it goes or if you need help with any of the steps.
Hi I have tried most of the solutions you provided
I installed WP Crontrol plugin but was not able to activate it. The site has recently been having problems with activating and deactivating plugins. Siteground is looking into the CPU usage now. The size of the DB was over which alerted me to this issue. It has been reduced but I think it will fill very fast again if this continues.
I’ve done the clear cache, wp-optimize, deactivated Rank Math
Hi @meatface888,
Thank you for the update. This appears to be a resource-related issue. Let’s wait to hear back from SiteGround about it. Once you’re able to install the WP Control plugin, we’ll have better visibility into any other notices and be able to run any pending actions more easily.
You can respond when you have an update from Siteground.
Well they disabled my WooCommerce Analytics because it’s generating a ton of Action Scheduler tasks but he says it’s still making lots of “Self referencing requests.” I’m not sure what that is. These were causing CPU usage to be very high.
I have also installed WP-Crontrol plugin as well and activated it but I am not sure what I am looking for.
Hi @meatface888 ,
I’m really sorry to hear about the trouble you’re having with the wc-admin_import_orders actions — especially with the high CPU usage and database growth. I can imagine how stressful that must be, and I’m here to help however I can.
When you get a chance, could you go to WooCommerce > Settings > Advanced > Features, and try unchecking the option for WooCommerce Analytics? After saving the changes, keep an eye on whether the action is still being scheduled repeatedly for new order.
We’re actually investigating a known issue that sounds closely related to what you’re seeing. You can take a look here for more details: GitHub issue #54791 and Related pull request
As for the self-referencing requests, it’s very likely they’re being triggered by those repeated wc-admin_import_orders actions. Some hosts have flagged these as coming from the server’s own IP address, which can definitely contribute to the load.
If you’re using the Action Scheduler plugin, try heading to WooCommerce > Status > Scheduled Actions in your dashboard. From there, look for any entries with the wc-admin_import_orders hook. You can use the options there to cancel or delete those actions, and check the log for anything unusual. Just a heads-up — this action might get rescheduled if a new order comes in, so it’s okay to see it return in that case.
One more thing — it’s worth double-checking that no other plugins are triggering this behavior. The easiest way to test is by temporarily disabling all plugins except WooCommerce, and then checking to see if the issue still happens.
Let me know how it goes!
WooCommerce Analytics was disabled by Siteground and this did stop the wc-admin_import_orders actions and they did not return. The CPU usage has dropped as well.
Siteground said the self-referencing requests are still occurring, though even after Analytics was turned off.
In the bug 54791 its says wc-admin_import_orders is automatically scheduled and fails, but I don’t think mine are failing when Analytics was turned on. I see these are complete. There are only a few failed actions of wc-admin_import_orders but this was when the CPU usage was very high yesterday. There were 43 fails. I see thousands of completed wc-admin_import_orders.
Related Pull request – I created a test order and see wc-admin_import_orders in scheduled actions under Pending. Now I checked again and went into Failed. This is with Analytics still turned off.
When Analytics is running the ” Import historical data” never completes and is running indefinitely. I am not sure if this is also part of the cause to these issues.
I am looking at the CPU usage chart and see the problem started around April 29. The CPU usage spiked up a lot from 32,000 to 328,000 CPU seconds/Day. Were there any WooCommerce updates around then?
Looking at WooCommerce update 9.8.2 on 2025-04-22 and 9.8.3 on 2025-04-22. These are the closest updates to the time period before I had issues. Would any of the changes here cause the issues I am having?
= 9.8.3 2025-04-30 =
**WooCommerce** * Fix – Add static cache and queue search to prevent duplicate scheduling of the wc_delete_related_product_transients_async action in wc_delete_product_transients(). [#57592](https://github.com/woocommerce/woocommerce/pull/57592) * Fix – Don’t run postcode validation for hidden postcodes. [#57594](https://github.com/woocommerce/woocommerce/pull/57594)
= 9.8.2 2025-04-22 =
**WooCommerce** * Fix – Fix coming soon breaks other page [#57216](https://github.com/woocommerce/woocommerce/pull/57216) * Fix – Fix deprecated function WCAdminHelper::is_store_page() used [#57169](https://github.com/woocommerce/woocommerce/pull/57169) * Fix – Fix implicitly nullable parameters deprecation warnings in PluginsHelper and CheckoutSchema [#57212](https://github.com/woocommerce/woocommerce/pull/57212) * Fix – Fix issue in which client side validation in checkout didn’t work. [#57278](https://github.com/woocommerce/woocommerce/pull/57278) * Fix – Fix undefined variable warning when saving billing address. [#57189](https://github.com/woocommerce/woocommerce/pull/57189) * Fix – Fix wc admin scripts loading on unrelated WP admin pages [#57186](https://github.com/woocommerce/woocommerce/pull/57186) * Fix – Store API – Move cart init and validation back within checkout route to avoid loading early. [#57255](https://github.com/woocommerce/woocommerce/pull/57255) * Update – Merge legacy cart and block based cart shipping calculation methods to ensure shipping calculations happen only when a full address has been provided. [#57176](https://github.com/woocommerce/woocommerce/pull/57176) * Fix – Restore default margin in Product Collection block navigation links. [#57275](https://github.com/woocommerce/woocommerce/pull/57275)
Zee
(@doublezed2)
Hello meatface888,
Thank you for your reply.
I understand you’re seeing a spike in CPU usage and a large number of pending “wc-admin_import_orders” scheduled actions, which started around April 29. You’re wondering if a WooCommerce update caused this.
It’s unlikely that a WooCommerce update would lead to such a CPU spike. Please clone your site to staging, disable all plugins except WooCommerce, and switch to a default theme. Enable an offline payment method to test orders.
This helps isolate the cause by comparing the staging and live sites. You can use the Query Monitor plugin to track performance and spot any issues.
Let me know about your findings and I will be happy to help further. 🙂
I created a staging site and Installed Query Monitor. I don’t see the high number of pending “wc-admin_import_orders” so I went and started the “Import historical data” in Analytics > Settings.
Now there are lots of “wc-admin_import_batch_orders” A bit different than what I am seeing on the production site.
It doesn’t look like the same issues is replicated on the staging site. Could there be something different when staging site is created? I had to start the Import historical data where in the production site it just starts automatically and keeps running indefinitely and never stops.
Zee
(@doublezed2)
Hello meatface888,
Thank you for your reply and I appreciate the troubleshooting steps you have taken so far.
Could you share screenshots of the Scheduled Actions page? You may use https://snipboard.io to upload images and share links here.
Also, it would be helpful if you could share the System Status Report from your staging site. You can paste the report at https://pastebin.com and share the link here.
My goal is to find any difference or pattern that might help determine the cause of the problem.
Best regards.
