Sale prices are not updating

Hi @mattiabf,

I have a problem with my website: if I plan a discount price (setting the date of end), when the offer expires, the product keeps being shown with discount price in the store page and won’t go back to full price. To revert it to its full price, I have to open the product page and close it. By doing this, it reverts to correct price.

From what I understand, you’re having trouble with sale prices not updating correctly on your website. Despite setting an end date for the discount, the product still shows the discounted price after the offer ends. You’ve also shared that you need to open and close the product page to get it back to its original price.

I commend your efforts in trying to fix this issue by checking the cache, deactivating other plugins, and making sure WooCommerce is up-to-date.

Here are a few potential solutions you can try:

1. Use a different browser or device: This issue might be specific to certain browsers or devices. Try visiting your store from a different browser or device to see if the problem continues.
2. Verify the server’s timezone: Ensure that your server’s timezone matches the timezone in your WordPress settings. A mismatch can sometimes cause scheduling problems.
3. Review your Scheduled Actions: Go to WooCommerce > Status > Scheduled Actions. Look for any pending actions related to the sale price. If you find any, run them manually to see if this solves the problem.
4. Check WP Cron Jobs: WooCommerce uses WordPress Cron Jobs to schedule events like updating sale prices. There might be an issue with the Cron Jobs not running correctly. You can use a plugin like  ?? WP Crontrol to check if the Cron Jobs are functioning properly.
5. Look into a Database Issue: There could be a problem with your WooCommerce database. Consider using a plugin like ?? WP-Optimize to clean and optimize your database.

If you’re still facing the issue after trying these steps, could you please share more information? We would need to understand the exact steps you take when setting the sale price and its end date. Also, please tell us if you’ve made any recent changes to your website before this problem started.

We would also find it helpful to see your site’s System Status report. This can give us a better idea of your site’s setup and help us pinpoint the problem. You can find the report under WooCommerce > Status. Choose Get system report and then Copy for support.

If there are any fatal error logs, please share those too. You can find them under WooCommerce > Status > Logs.

Once you’ve gathered this information, please paste it inside a Code block in your reply, or use https://pastebin.com to paste it and share the link with us.

Thanks for your patience and cooperation in this matter! We’re here to help you get this sorted.

Hi,

I tried everything but did not find the problem. Setting the offer creates a schedule action with the hook woocommerce_run_product_attribute_lookup_update_callback, which seem to work correctly.

Let me be clear, when the offer expires:
– the price displayed IN THE SHOP PAGE is the discounted one, but the badge “on sale” disappears, and I do not see the “sale price” cancelled and then the discount price: I only see one price tag, with the amount I used for discount.
– when I click on the product, I see the correct price
– then, after viewing the product page, the price fixes itself also in the shop page

To set up the sale price, I go to the edit product page, and in the “General” tab I set up a discount price and an end date.

https://pastebin.com/NtzWmZ4n here is the log

Hey @mattiabf,

Thanks for providing clarity and for sharing the SSR.

To turn those sales on and off, WooCommerce uses a system called WP-CRON that runs automated actions inside WordPress. There may be times when it doesn’t work as expected which could cause sale prices to not end.

WP-CRON?requires site visitors to trigger these actions, and if for some reason, your site has had no visits nearing the end of the sale, then the sale price could remain in effect. This would explain why the issue resolves after visiting the product page and closing it.

Operazione non riuscita: 69

As per your SSR, I am able to see that you have a lot of?Pending?actions, with the most recent being 2023-11-06.

Have you managed to install the?WP Control?plugin to see if there are any errors causing?WP Cron?to not run as expected, keeping actions stuck in a Pending state? If not, please can you do this and share the outcome with us here.

WC Version: 7.6.0

I can also see that WooCommerce is not yet updated to its latest available version [8.2.2]. Can you please do this to ensure optimal functionality?

We always recommend ensuring that you have a good backup of your full site and database before performing any updates or making any changes to your live site, so that, should something go wrong, you are able to easily restore your site to a functioning state.

Additionally, please could you share any fatal errors you may see when navigating to?WooCommerce?→?Status?→?Logs?

Cheers!

Now I checked carefully. When I make an offer, I do not see any new WP Cron events.

Total number of events stays the same, and no new event appears

Not seeing any errors in the logs. Last one is from a few days ago

Hey @mattiabf,

Based on what you have described, there may be problem with WP Cron on the site.

Please follow the support guide below and see if the troubleshooting steps outlined there help resolve the issue:

• Debugging WP Cron

Not seeing any errors in the logs. Last one is from a few days ago

If the issue is still unresolved, although the last errors were logged a few days ago, please can you share these with us here so that we can take a closer look.

Cheers!

Please I need some further help because I am not going anywhere with this.

For WP Cron: I see 77 actions, and all of them are running. If I check how often they are supposed to run, and when is their next run, they are all working correctly from what I see.

Of course I have no idea of which one is the one related to updating this specific field.

Regarding woocommerce action: the only action I see created when I set up an expiring offer is: woocommerce_run_product_attribute_lookup_update_callback which is completed correctly as soon as the offer ends.

Again I have no idea if this is the right action related to the refresh of the price, but even when the action is completed, price remains the same.

Just to be clear: price keeps being wrong in the store page, while if I open the product page the price gets displayed correctly.

Then after visiting the product page, price updates also in the store page.

I have 14 pending actions, all related to external plugins live CartBounty, WP Forms, Stripe. They are pending, but still running on correct schedule.

When I set up the offer, woocommerce_run_product_attribute_lookup_update_callback goes pending but then is completed correctly.

Log does not help, only existing logs are from an external plugin, and nothing related/nothing to worry about. They are all like this:

2023-11-02T02:02:43+00:00 NOTICE GetResponse: 409 – Contact already added There is another resource with the same value of unique property ([]). Email: XXX. 2023-11-02T14:33:55+00:00 INFO Not saving abandoned cart: Bot detected. User Agent string – Mozilla/5.0 (compatible; Googlebot/2.1; +https://www.google.com/bot.html) 2023-11-02T23:08:59+00:00 NOTICE GetResponse: 409 – Contact already added There is another resource with the same value of unique property ([]). Email: XXX.

Updating plugins, updating woocommerce, even disabling all plugins and using a basic theme does not help.

Hello @mattiabf,

You mentioned that you have 14 pending actions from external plugins like CartBounty, WP Forms, and Stripe. Although these are running on the correct schedule, they might still be interfering with the WooCommerce cron job.

Given that you’ve already tried disabling all plugins and switching to a basic theme, I suggest you try to temporarily disable these external plugins and see if the issue persists.

If the problem still occurs, it would be beneficial to investigate the WP Cron events further. You can use the WP Crontrol plugin to manage and debug the WP Cron system. This will allow you to see all cron events and their arguments, as well as add, edit, and remove cron events.

Also, may I know which WordPress and PHP version you are using? Could you please share a copy of your site’s System Status Report with us? You’ll find it at the top of the page under WooCommerce > Status > Select Get System Report and then Download for Support. This will download a TXT file containing the SSR’s contents to share with us share via Mozilla Community Pastebin and send the link here.

I understand how frustrating this issue can be and appreciate your cooperation as we work together to find a solution. Please let us know how these steps work for you and if you have any other questions.

Hello guys,

I also have this issue, and I notice that when I add Variations, the LIST price and SALE price are turning up BLANK, and you cannot save THE PRICE once you add Variations options. The price appears on the shop or products pages but appears blank once you add the Variations. When you return and look at the Pricing section, the LIST price and SALE price files are empty.

How can this issue be fix or what can cause such to happen.

Hi @webfaithmedia,

I also have this issue, and I notice that when I add Variations, the LIST price and SALE price are turning up BLANK, and you cannot save THE PRICE once you add Variations options.

From what I understand, you’re encountering a similar issue where the List price and Sale price fields are turning up blank when you add Variation options. It seems that the prices are visible on the shop or product pages, but they appear blank once you add the Variations. When you revisit the Pricing section, both the List price and Sale price fields are empty.

Given that each site setup is unique, and to ensure we adhere to our ?? forum’s best practices, could you kindly initiate a ?? new topic in our support forum? This approach helps us zero in on your specific issue and allows other users facing a similar problem to easily find and benefit from the discussion.

In your new topic, could you please provide as much detail as possible? This might include screenshots, error messages, payment gateways you’re using and the checkout method you’ve set up, the steps you’ve already taken to try to resolve the issue, and any other information you think might be relevant.

You can use https://snipboard.io to share screenshots. Just follow the instructions on the page and paste the URL in your reply.

Thank you for your understanding and cooperation. We look forward to assisting you further on the new topic.

I already tried to deactivate all the plugins except woocommerce as I mentioned multiple times before. Unfortunately it didn’t change anything

I already installed WP Cron and tried to debug, but did not find problems.

Here is the status:

https://prod.pastebin.prod.webservices.mozgcp.net/sUrrudSu

Hello @mattiabf,

According to your system status, you’re using a very outdated version of WooCommerce that we no longer support, please make sure to update to the latest version as previously mentioned.

You can follow this guide for step-by-step instructions: https://woo.com/document/how-to-update-woocommerce/

Let us know how it goes! :?)