Hi @fernandocctech, thank you for sharing the System Status Report and for testing this on a staging site with plugins disabled. I can see the effort you have already put into narrowing this down.
Looking through the report, WooCommerce itself is up to date and only WooCommerce and WP Crontrol are active on the staging environment, which helps rule out plugin conflicts. WP-Cron also appears to be running normally, which is what WooCommerce relies on to start and end scheduled sales.
One thing that stands out is the very large number of failed Action Scheduler jobs, over 13,000 failed actions recorded. Since WooCommerce scheduled sales rely on scheduled actions to update product prices, a backlog or repeated failures in Action Scheduler could prevent those updates from completing correctly.
To investigate this further, please check the scheduled actions responsible for ending sales:
- Go to WooCommerce → Status → Scheduled Actions.
- Search for actions related to sales, such as
woocommerce_scheduled_sales.
- Check if they appear as failed or pending, and try running one manually.
You can learn more about scheduled actions here:
https://woocommerce.com/document/understanding-the-woocommerce-system-status-report/scheduled-actions/
If those actions are failing, please share a screenshot of what you see in the Scheduled Actions screen using https://snipboard.io and also check the error message shown in the action log. That will help identify why the sales prices are not being cleared automatically.
Once we can see how those woocommerce_scheduled_sales actions are behaving, we should have a clearer path to resolving the issue without needing to update each variable product individually.
Most of the failed actions were coming from a different plugins that has been deleted. Only two failed actions were related to scheduled sales but dont give a specific error message nor is it appearing in our php error logs: https://snipboard.io/twcf6j.jpg
Every other scheduled sale cron job appears as completed on our logs and manually running the scheduled sale cron also shows a completed message but our sale products with expired dates still aren’t returning to regular price.
Hi @fernandocctech,
Thank you for sharing the screenshot, that helps clarify what is happening.
From what I can see, the woocommerce_scheduled_sales action is starting but then failing after 300 seconds, which usually indicates a timeout while WooCommerce is processing the scheduled sales update. Since this task is responsible for ending expired sale prices, the timeout would explain why the products are not returning to their regular price.
At this point, it would be helpful to check the WooCommerce logs under WooCommerce → Status → Logs around the same time as the failed action to see if a more specific error appears there.
You can also try running the action again manually from WooCommerce → Status → Scheduled Actions and check if the same failure occurs.
If you find any related error in the logs, feel free to share it using https://pastebin.com so we can take a closer look.
Running the action manually keeps saying the action was completed succesfully. The only error message in the logs is this https://pastebin.com/CQ9RGGkj. No other errors are ocurring when I try to run the scheduled action.
Hi there!
Thanks for sharing the error log that’s very helpful.
I can see the following critical error in the logs:
Attempt to get an instance of class 'Automattic\WooCommerce\Internal\FraudProtection\AdminSettingsHandler', which doesn't exist.
This usually indicates that some WooCommerce files may be missing or not loaded correctly, which can sometimes happen if an update was interrupted or if files were partially overwritten. When this happens, certain background processes (like scheduled sale updates) may not run as expected.
For testing purposes, could you please reinstall WooCommerce and check whether the error disappears? You can perform this on a staging site so that your live site remains unaffected. Please make sure to take a full site backup before reinstalling. You may use the following plugin to create a staging site: https://wordpress.org/plugins/wp-staging/
I’ve also checked the sale price issue, and I can confirm that it has already been reported on GitHub here:
https://github.com/woocommerce/woocommerce/issues/42971
Our developers are actively working on this issue; however, there is currently no estimated timeframe (ETA) for when a fix will be released. I would recommend adding a comment to that thread so you can receive updates as progress is made.
Reinstalling woocommerce didn’t help and the github thread is a couple years old with no updates. Since every solution so far fails is there any way we can manually remove the sales prices of all the products without having to use the cron job? There are way too many variations on sale to remove them manually.
Hi there!
Sorry for sharing the incorrect link earlier. Here is the latest GitHub issue where our developers are actively tracking and working on this:
https://github.com/woocommerce/woocommerce/issues/63061
Regarding updating the sale data in bulk, yes, this is possible. It can be done either by using a WooCommerce bulk editing plugin or by exporting the products as a CSV file, editing the sale price fields in the file, and then importing the CSV again to update the products. This allows you to update or remove the sale prices for many products and variations at once without needing to edit them individually.
I hope this helps.
Thanks for reaching out and for your patience while we looked into this! I really appreciate you taking the time to report this — it genuinely helps us improve.
I’ll go ahead and mark this thread as resolved for now. If anything changes on your end or you need further assistance down the road, feel free to start a new thread anytime — we’re always happy to help!
