Sale prices not being removed

Hi @nikkise

I had a sale going on in my store, but the sale has ended and the prices have not reverted. I checked in the woo commerce section of my wordpress, and the scheduled dates for the sale have definitely passed/gone, but the prices are still reflecting those of the sale. How do I reset it/force Woo commerce/Wordpress to update these prices?

From what I understand, you’re having trouble with your store’s sale prices. They haven’t switched back to the original prices after the sale period ended, even though the scheduled dates for the sale are over. You’re trying to find a way to update these prices on WooCommerce/WordPress, right?

Here’s how you can tackle this issue:

1. Clear WooCommerce Transients: Navigate to WooCommerce > Status > Tools. There, click on the ‘Clear Transients‘ button under ‘WooCommerce transients‘. This action will clear the product/shop transients cache.
2. Clear Expired Transients: While you’re still on the same page, hit the ‘Clear Transients‘ button under ‘Clear Expired Transients‘. This will clear ALL expired transients from WordPress.
3. Regenerate Product Lookup Tables: Click on the ‘Regenerate‘ button under ‘Regenerate Product Lookup Tables‘ on the same page. This will regenerate product lookup table data. Keep in mind, that this process might take some time.
4. Disable Plugins: Try turning off all plugins except WooCommerce to see if there’s a conflict between any of your plugins and WooCommerce.
5. Switch Themes: Try switching to a default WordPress theme like Storefront temporarily. If the issue is resolved, your current theme might be the problem. Here’s a handy guide on how to test for conflicts: ?? How to Test for Plugin and Theme Conflicts.

Image Link: https://snipboard.io/f14UTH.jpg

Once you’ve done these steps, check to see if the prices have been updated.

If you’re still facing the issue, could you give us more details? We’re interested in knowing if this happened with specific products or all products that were on sale. A screenshot of the product data from your WooCommerce section would be great for further troubleshooting.

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

Sharing your site’s System Status report will also give us a better understanding of your site’s setup and help us identify the problem. You can find this under WooCommerce > Status. Simply select Get system report and then Copy for support.

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

Once you have this information, please paste it inside a Code block in your response, 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,
Unfortunately, that hasn’t worked. I’ve followed the steps as you outlined on a test server (copied from the main site this evening so it should be exactly the same – https://woocommerce.fractalrpg.com/), but the sale prices have remained.

All of my products are showing the sale issue. https://snipboard.io/0vue7L.jpg. There are no fatal logs from today, nothing since October 3rd.

` WordPress Environment

WordPress address (URL): https://woocommerce.fractalrpg.com<br>Site address (URL): https://woocommerce.fractalrpg.com<br>WC Version: 8.1.1<br>REST API Version: ? 8.1.1<br>WC Blocks Version: ? 10.9.3<br>Action Scheduler Version: ? 3.6.2<br>Log Directory Writable: ?<br>WP Version: 6.3.1<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_AU<br>External object cache: – Server Environment

Server Info: LiteSpeed<br>PHP Version: 8.0.28<br>PHP Post Max Size: 2 GB<br>PHP Time Limit: 360<br>PHP Max Input Vars: 5000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1p

SUHOSIN Installed: –<br>MySQL Version: 10.6.14-MariaDB-cll-lve<br>Max Upload Size: 2 GB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.1.1<br>WC Database Prefix: wp_<br>Total Database Size: 15.12MB<br>Database Data Size: 10.94MB<br>Database Index Size: 4.18MB<br>wp_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_cache: Data: 0.14MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_aioseo_posts: Data: 0.14MB + Index: 0.02MB + Engine InnoDB<br>wp_bv_activities_store: Data: 0.28MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_ip_store: Data: 0.22MB + Index: 0.16MB + Engine InnoDB<br>wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_banners: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookie_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_ctf_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ctf_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ctf_feed_caches: Data: 0.03MB + Index: 0.02MB + Engine InnoDB<br>wp_ctf_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ctf_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_edd_adjustmentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_adjustments: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_edd_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_customers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_edd_customer_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_edd_customer_email_addresses: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_edd_logmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_logs: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_edd_logs_api_requestmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_logs_api_requests: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_logs_file_downloadmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_logs_file_downloads: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_edd_notemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_notes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_edd_notifications: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_edd_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_edd_order_addresses: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_edd_order_adjustmentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_order_adjustments: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_edd_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_edd_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_edd_order_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_mo2f_network_blocked_ips: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_network_email_sent_audit: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_network_transactions: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_network_whitelisted_ips: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_user_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_user_login_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 2.47MB + Index: 0.13MB + Engine InnoDB<br>wp_postmeta: Data: 1.52MB + Index: 0.22MB + Engine InnoDB<br>wp_posts: Data: 3.52MB + Index: 0.13MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_socialsnap_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_userfeedback_surveys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_userfeedback_survey_responses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaas_activity_log: Data: 0.16MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpns_attack_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts

attachment: 60<br>custom_css: 2<br>customize_changeset: 3<br>mc4wp-form: 1<br>monsterinsights_note: 1<br>nav_menu_item: 9<br>page: 20<br>post: 16<br>product: 3<br>revision: 428<br>shop_order: 20<br>wp_block: 1<br>wp_global_styles: 3<br>wp_navigation: 3<br>wp_template: 9<br>wp_template_part: 3<br>wpforms: 1 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (1)

WooCommerce: by Automattic – 8.1.1 Inactive Plugins (25)

All-in-One WP Migration: by ServMask – 7.78<br>All in One SEO: by All in One SEO Team – 4.4.7.1<br>Anti-Spam by CleanTalk: by СleanTalk <a href="mailto:[email protected]">[email protected]</a> – 6.19<br>B Accordion: by bPlugins LLC – 1.0.3<br>B Blocks: by bPlugins LLC – 1.7.8<br>Classic Editor: by WordPress Contributors – 1.6.3<br>CookieYes | GDPR Cookie Consent: by CookieYes – 3.1.4<br>Disable Comments: by WPDeveloper – 2.4.5<br>Duplicate Page: by mndpsingh287 – 4.5.3<br>Hostinger: by Hostinger – 1.6.2<br>Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.25.25<br>LiteSpeed Cache: by LiteSpeed Technologies – 5.6<br>MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall: by MalCare Security – 5.25<br>MC4WP: Mailchimp for WordPress: by ibericode – 4.9.9<br>miniOrange 2 Factor Authentication: by miniOrange – 5.7.4<br>OptinMonster: by OptinMonster Popup Builder Team – 2.14.0<br>Pre-Orders for WooCommerce: by Bright Plugins – 1.2.14<br>Site Kit by Google: by Google – 1.110.0<br>Stop User Enumeration: by Fullworks – 1.4.8<br>Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.39<br>Use Any Font: by Dnesscarkey – 6.3.01<br>UserFeedback Lite: by UserFeedback Team – 1.0.9<br>WooCommerce PayPal Payments: by WooCommerce – 2.3.1<br>WPForms Lite: by WPForms – 1.8.4<br>WPS Hide Login: by WPServeur<br>NicolasKulka<br>wpformation – 1.9.9 Must Use Plugins (1)

Object Cache Pro (MU): by Rhubarb Group – 1.18.2 Settings

API Enabled: –<br>Force SSL: –<br>Currency: AUD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)

Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop base: #797 - /shop/<br>Cart: #96 - /cart/<br>Checkout: #97 - /checkout-2/<br>My account: #98 - /my-account/<br>Terms and conditions: #99 - /termsandconditions/ Theme

Name: Storefront<br>Version: 4.5.3<br>Author URL: https://woocommerce.com/<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ? Templates

Overrides: – Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-variation-management<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-10-10 00:40:13 +11:00<br>Options: ?<br>Notes: 16<br>Onboarding: completed Action Scheduler

Complete: 174<br>Oldest: 2023-09-09 19:56:10 +1000<br>Newest: 2023-10-10 01:46:11 +1100

Failed: 17<br>Oldest: 2023-08-30 13:17:48 +1000<br>Newest: 2023-10-10 01:47:28 +1100

Pending: 3<br>Oldest: 2023-10-10 17:28:31 +1100<br>Newest: 2023-10-15 14:52:32 +1100 Status report information

Generated at: 2023-10-10 01:48:44 +11:00<br>`

Hello @nikkise,

Thank you for sharing the logs!

Just to confirm, you’re adding a scheduled sale price for each product one by one from the product settings, but the price is not removed once the sale period expires, correct?

Link to image: https://d.pr/i/lrFsXp

A cron event named woocommerce_scheduled_sales is responsible for handling this functionality. Please ensure that it’s working correctly or check if its interval has been modified. It’s typically set to run daily.

To view and edit WP cron events, you can use a plugin like WP Crontrol: https://www.ads-software.com/plugins/wp-crontrol/

Look forward to hearing back from you.