Database not changing when after sale is over. Sales icon and sales price remain

  • I think there is a bug in WooCommerce, preventing the plugin from updating the database after a sales promotion is over.

    When the sales promotion is over, the sales price and schedule clear from the Variations tab, but the sales icon and the sales price remain on the product page and the category pages.

    The work around is simple, just click update on each item and the sales on icon and sales price go away when the database is updated again. Is there a way to get WooCommerce to update the database properly? 

    
### WordPress Environment ###

Home URL: https://www.shopcousinearl.com
Site URL: https://www.shopcousinearl.com
WC Version: 2.6.9
Log Directory Writable: ?
WP Version: 4.7
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache
PHP Version: ? 5.4.19 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
PHP Post Max Size: 64 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.48.0
OpenSSL/1.0.1e

SUHOSIN Installed: –
MySQL Version: ? 5.5.43 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 2.6.9
: 
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?
woocommerce_shipping_zones: ?
woocommerce_shipping_zone_locations: ?
woocommerce_shipping_zone_methods: ?
woocommerce_payment_tokens: ?
woocommerce_payment_tokenmeta: ?

### Active Plugins (30) ###

Advanced Image Styles: by Gregory Cornelius – 0.4
iThemes Security: by iThemes – 5.9.0
Fast Secure Contact Form Newsletter Add-on: by Katz Web Services
Inc. – 2.1.2

Enhanced Text Widget: by Boston Dell-Vandenberg – 1.4.5
WooCommerce - Gift Cards: by WP Ronin – 2.5.5
Google Webfonts For Woo Framework: by Jason Judge – 1.6.3
Jetpack by WordPress.com: by Automattic – 4.4.2
MailMunch - Increase your Email Subscribers by over 500%: by MailMunch – 2.0.4
Meta Slider - Pro Addon Pack: by Matcha Labs – 2.6.6
Meta Slider: by Matcha Labs – 3.3.7
Quick View WooCommerce: by XootiX – 1.5
Server IP & Memory Usage Display: by Apasionados
Apasionados del Marketing – 1.3.3

Fast Secure Contact Form: by Mike Challis
Ken Carlson – 4.0.44

Simple Social Icons: by Nathan Rice – 2.0.1
Page Builder by SiteOrigin: by SiteOrigin – 2.4.20
SiteOrigin CSS: by SiteOrigin – 1.1.2
SiteOrigin Widgets Bundle: by SiteOrigin – 1.7.2
Spacer: by Justin Saad – 3.0.4
Tax Rate Upload: by Adam Bowen – 2.4.5
WooCommerce Authorize.Net AIM Gateway: by WooThemes / SkyVerge – 3.10.0
Booster Plus for WooCommerce: by Algoritmika Ltd – 1.0.5
Booster for WooCommerce: by Algoritmika Ltd – 2.5.8
WooCommerce Sequential Order Numbers: by SkyVerge – 1.7.0
WooCommerce Shipment Tracking: by WooThemes – 1.6.2
WooCommerce Shortcodes: by WooThemes
Claudio Sanches – 1.0.0

WooCommerce: by WooThemes – 2.6.9
WooCommerce Helper: by WooCommerce – 1.7.2
Yoast SEO: by Team Yoast – 3.9
WP Instagram Widget: by Scott Evans – 1.9.8
WP Super Cache: by Automattic – 1.4.8

### Settings ###

Force SSL: ?
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

### API ###

API Enabled: ?

### WC Pages ###

Shop Base: ? Page ID is set
but the page does not exist

Cart: #6 - /cart/
Checkout: #7 - /checkout/
My Account: #8 - /my-account/

### Taxonomies ###

Product Types: external (external)
gift-card (gift-card)
grouped (grouped)
simple (simple)
variable (variable)

### Theme ###

Name: Canvas Child
Version: 1.0.0
Author URL: https://www.theafabgroup.com
Child Theme: ?
Parent Theme Name: Canvas
Parent Theme Version: 5.11.3
Parent Theme Author URL: https://www.woothemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: canvas-child/woocommerce/single-product/related.php

### Authorize.Net AIM ###

Environment: Production
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    If the price is getting removed, but the display of the sale badges aren’t, then it points to caching being involved. Your system status report shows that you’re using WP Super Cache – Are you getting the same thing when deactivating that or clearing the cache?

    And yep, the act of re-saving the product will also clear the cache; Especially when logged in ??

    Thread Starter David LeBlanc

    (@davidtleblanc)

    Riann, thanks for the reply.

    Yes, I cleared the cache. That is the first thing I thought of and did and problem remained.

    I did not deactivate the plugin, if that helps.

    I did notice that both the PHP version and MySQL version GoDaddy uses are below the minimums recommended. From past experience, out of date PHP can cause an issue with WooCommerce. It is possible that one or both those things is the cause of the problem.

    Sadly, GoDaddy does not offer more current versions and seems to have no plans to do so.

    • This reply was modified 7 years, 11 months ago by David LeBlanc.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database not changing when after sale is over. Sales icon and sales price remain’ is closed to new replies.