• Resolved meatface888

    (@meatface888)


    I am having problems with my Scheduled actions. I see there are lots of “wc-admin_import_orders” pending. These are running every few seconds and I think it’s filling up the logs in my DB. My “wlv_actionscheduler_actions” is about 590 MB now in size, and there are probably a few thousand logs from “wc-admin_import_orders” .

    The page I need help with: [log in to see the link]

Viewing 15 replies - 16 through 30 (of 54 total)
  • Thread Starter meatface888

    (@meatface888)

    System Status report
    https://pastebin.com/5wnhYzrb

    Actions Page on fresh created staging site
    https://snipboard.io/GsZaXz.jpg

    Import historical data not running
    https://snipboard.io/JQ9axc.jpg

    After starting Import historical data I check back to Action scheduler
    https://snipboard.io/i1dRcE.jpg

    If I stop Import historical data, all the Pending “wc-admin_import_batch_orders” disappear. Production site I can not stop it and it never completes.

    On the production site, I have WooCommerce Analytics turned off now, but CPU usage still seems very high so I think there is something else that is causing these problems, not just the Analytics.
    By the hour
    https://snipboard.io/TdbV4G.jpg
    By the day as well so you can see a baseline what it use to be before April 30 when it spiked.
    https://snipboard.io/1F0pBm.jpg

    Thread Starter meatface888

    (@meatface888)

    Siteground also said “CPU usage issue continues and it seems that this is caused by some plugin which is making self-referencing requests from the server’s IP address 35.206.84.21”

    “wp_1_wc_privacy_cleanup”, it appears to be related to WooCommerce

    https://pastebin.com/pS6yLMH3

    Hello meatface888,

    Thank you for your reply.

    I reviewed the system status report and noticed that there are currently 26 active plugins on your staging site. To help us narrow down the issue, please deactivate all plugins except WooCommerce and switch to a default theme such as Twenty Twenty-Five.

    This will allow me to rule out any conflicts with other plugins or the theme and better isolate the cause of the problem. Let me know once you’ve done that, and we can continue troubleshooting from there.

    Looking forward to your response. 🙂

    Thread Starter meatface888

    (@meatface888)

    Ok I disabled everything except WooCommerce and changed theme to twenty five

    Here is a copy of the recent Status Report

    https://pastebin.com/maSMBY6a

    Also I’d like to thank you very much for your help it is greatly appreciated 🙂

    Hello meatface888,

    Thank you for taking the time to troubleshoot this issue. Your efforts are appreciated.

    Now that all plugins except WooCommerce are disabled, I recommend monitoring the site for any self-referencing requests and unexpected CPU usage spikes. To simulate live conditions, please place a few test orders and run the “Import Historical Data” process.

    This will help identify whether the issue can be reproduced. If anything unusual comes up, feel free to share the details.

    Best regards.

    Thread Starter meatface888

    (@meatface888)

    Siteground has also indicated other issues as well.

    “Regrettably, I am currently unable to determine the cause of these frequent requests, as the task wp_1_wc_privacy_cleanup_cron is scheduled to run every 5 minutes, yet requests are being generated approximately every 20 seconds.”

    It appears some jobs are running more often than they should.

    Hello meatface888,

    Thank you for your reply.

    I understand you’re concerned about certain jobs running more frequently than expected, as SiteGround mentioned the wp_1_wc_privacy_cleanup_cron task is scheduled for every 5 minutes, but is triggering every 20 seconds.

    To confirm, is this happening on your live site or staging site? I’m asking because the wp_1_ prefix typically indicates the production site. Have you noticed anything similar on the staging site?

    Looking forward to your response. 🙂

    Thread Starter meatface888

    (@meatface888)

    This is what Siteground sent back:

    https://pastebin.com/BCJw7fHz

    I don’t know why but the Staging Site does not show the same issues we are seeing from Production site. After creating the Staging site even with all plugins still running the CPU usage is very low. Also I don’t see “Import historical data” running indefinitely.

    Plugin Support LovingBro (woo-hc)

    (@lovingbro)

    Hi @meatface888,

    Thanks so much for all the detailed information you’ve shared and for the thorough troubleshooting you’ve done. I know how frustrating it can be when these scheduled actions pile up and start to affect performance.

    I saw that your staging site isn’t experiencing the same issue, which is very interesting. Could you help us understand what the key differences are between your live site and staging environment? For instance, are there any plugins deactivated, any admin notes dismissed, or has the staging site skipped any onboarding or import steps? This could help narrow down what’s triggering the constant wc-admin_import_orders tasks.

    Since WooCommerce Analytics and the historical data import are known to schedule those tasks, and given the context from similar threads, you might consider disabling the analytics import entirely if you’re not actively using it. You can do that with this snippet:

    add_filter( 'woocommerce_analytics_import_orders', '__return_false' );

    If the task queue is still growing even after turning off Analytics, you could also disable the asynchronous request runner by adding:

    add_filter( 'action_scheduler_allow_async_request_runner', '__return_false' );

    This will prevent the async queue from constantly firing and rely only on WP-Cron, which can help reduce server load.

    Let me know what you uncover in terms of differences between the two environments. That insight might be the missing piece in solving this puzzle once and for all. Happy to keep working with you on this!

    Let me know if you’d like this version to be more concise or if it needs tailoring to a different tone.

    Thread Starter meatface888

    (@meatface888)

    Siteground says they have Cron jobs turned off by default on the staging site. I do use WooCommerce Analytics to track my sales.

    The Import historical data never stops running when it is activated. In a 30min time frame I see 90,000 completed actions. I have only had about 5000 sales since I opened. I am not sure what it is importing. I thought it was older sales orders.

    Thread Starter meatface888

    (@meatface888)

    I am also getting notifications that my CPU second limit is being reached, and they have already extended this once already. I am worried I will run out before the end of the month and they shut the site down until next month for overutilization of the CPU.

    Thread Starter meatface888

    (@meatface888)

    There is also a new Woocommerce plugin update. Should I do the update and will it fix the issues I am having, or will it complicate the resolution of the problem?

    Thread Starter meatface888

    (@meatface888)

    Sorry I missed this:
    “To confirm, is this happening on your live site or staging site? I’m asking because the wp_1_ prefix typically indicates the production site. Have you noticed anything similar on the staging site?”

    Yes this is running on the production site.

    Thread Starter meatface888

    (@meatface888)

    I Started Woocommerce Analytics again to see if issues are still there and it is showing “wc-admin_import_batch_orders” instead of “wc-admin_import_orders” in the pending. What is the difference between these and why did it change?

    Plugin Support Moses M. (woo-hc)

    (@mosesmedh)

    Hi @meatface888,

    Thank you for the clear explanation. I understand this situation can be frustrating and might raise some questions. I’ll start by addressing your concerns and then continue with the troubleshooting steps.

    There is also a new Woocommerce plugin update. Should I do the update and will it fix the issues I am having, or will it complicate the resolution of the problem?

    Yes, I recommend updating all your plugins that have available updates. However, before doing so, it’s best to first deactivate and delete any plugins you’re not using or that are no longer necessary.

    As for the difference: wc-admin_import_orders is used to trigger the full import of orders into WooCommerce Analytics, while wc-admin_import_batch_orders is responsible for processing those orders in smaller chunks. Seeing wc-admin_import_batch_orders simply means WooCommerce is handling the import in batches, which is expected behavior and helps improve performance on larger sites.

    Yes this is running on the production site.

    Thank you for the clarification. I suggest we focus on the staging site for now to help isolate the issue.

    You mentioned that your host support said cron is disabled on the staging site. Please enable it and monitor the site to see if the issue can be reproduced. When you do, ensure all plugins remain deactivated and the Twenty Twenty-Five theme is active. Monitor it for a few days, then start activating your plugins gradually—about one or two per day—until the issue reappears. Take note of the last plugin activated before the problem returns.

Viewing 15 replies - 16 through 30 (of 54 total)
  • You must be logged in to reply to this topic.