search

woocommerce / woocommerce

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine.
https://woocommerce.com
9.39k stars 10.77k forks source link

Scheduled Sale Price not working uniformly across site - Simple Products don't reflect Sale Price / Variable Products do #41710

Closed richTMNT closed 11 months ago

richTMNT commented 11 months ago

Prerequisites

Describe the bug

Scheduled Sale Price for Simple Products show as "Sale" but the price shown doesn't reflect the price entered in the "Sale Price" field. The price shown is still the Regular Price WooCommerce-01 WooCommerce-02

Expected behavior

Sales price should show next to the Regular Price. WooCommerce-03 WooCommerce-04

Actual behavior

Both Regular Price and Sales Price are shown as the same values on the listing, even though the Sales price entered is different than the Regular Price. This is occurring for Simple Product items that were "Scheduled" to go on sale but is working properly for any Variable Product items scheduled to go on sale. WooCommerce-01 WooCommerce-02 WooCommerce-03 WooCommerce-04

Steps to reproduce

  1. Go to a Simple Product - https://tmnt-ninjaturtles.com/product/tmnt-vol-v-100-retailer-exclusives-re-tmnt-a-collection-a-b-set-idw/
  2. See that the listing shows as "Sale" but both the Regular price and Sale price are identical, even though the item has a different price set for Sale than for Regular. WooCommerce-01 WooCommerce-02

WordPress Environment

`

WordPress Environment

WordPress address (URL): https://tmnt-ninjaturtles.com Site address (URL): https://tmnt-ninjaturtles.com WC Version: 8.3.1 REST API Version: ✔ 8.3.1 WC Blocks Version: ✔ 11.4.9 Action Scheduler Version: ✔ 3.6.4 Log Directory Writable: ✔ WP Version: 6.4.1 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: –

Server Environment

Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 256 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.85.0 OpenSSL/3.0.9

SUHOSIN Installed: – MySQL Version: 5.7.39-42-log Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 8.3.1 WC Database Prefix: wp_ Total Database Size: 226.95MB Database Data Size: 152.17MB Database Index Size: 74.78MB wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.91MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 8.02MB + Index: 5.53MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 0.31MB + Index: 0.23MB + Engine InnoDB wp_auction_direct_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_album_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_file_paths: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_image: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_image_comment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_image_rate: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_image_tag: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_shortcode: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_bwg_theme: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp_commentmeta: Data: 0.49MB + Index: 0.17MB + Engine MyISAM wp_comments: Data: 1.02MB + Index: 0.26MB + Engine MyISAM wp_duplicator_pro_entities: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_duplicator_pro_packages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_itsec_opaque_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletters: Data: 0.13MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_scheduled_tasks: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_scheduled_task_subscribers: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_sending_queues: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_newsletters: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscribers: Data: 0.06MB + Index: 0.23MB + Engine InnoDB wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ngg_pictures: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 8.45MB + Index: 0.44MB + Engine MyISAM wp_pmxe_exports: Data: 0.24MB + Index: 0.00MB + Engine MyISAM wp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM wp_pmxe_posts: Data: 0.47MB + Index: 0.21MB + Engine MyISAM wp_pmxe_templates: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wp_postmeta: Data: 49.99MB + Index: 6.50MB + Engine MyISAM wp_posts: Data: 22.96MB + Index: 3.42MB + Engine MyISAM wp_relevanssi: Data: 30.58MB + Index: 35.66MB + Engine InnoDB wp_relevanssi_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_search_filter_cache: Data: 3.09MB + Index: 2.70MB + Engine MyISAM wp_search_filter_term_results: Data: 0.48MB + Index: 0.26MB + Engine MyISAM wp_shortpixel_folders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_shortpixel_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_shortpixel_postmeta: Data: 12.52MB + Index: 9.58MB + Engine InnoDB wp_shortpixel_queue: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wp_terms: Data: 0.22MB + Index: 0.36MB + Engine MyISAM wp_term_relationships: Data: 0.96MB + Index: 2.16MB + Engine MyISAM wp_term_taxonomy: Data: 0.17MB + Index: 0.16MB + Engine MyISAM wp_usermeta: Data: 0.23MB + Index: 0.10MB + Engine MyISAM wp_users: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.08MB + Index: 0.13MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woo_ua_auction_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_WP_SEO_404_links: Data: 2.41MB + Index: 1.76MB + Engine MyISAM wp_WP_SEO_Cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_WP_SEO_Redirection: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_WP_SEO_Redirection_LOG: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_yoast_seo_links: Data: 0.32MB + Index: 0.06MB + Engine MyISAM wp_yoast_seo_meta: Data: 0.05MB + Index: 0.05MB + Engine MyISAM

Post Type Counts

acf: 3 acf-field: 10 acf-field-group: 4 attachment: 15079 comics: 4903 customize_changeset: 2 feedback: 1 figures: 244 jetpack_migration: 2 mailpoet_page: 1 memorabilia: 269 nav_menu_item: 189 page: 34 post: 1048 product: 174 product_variation: 345 revision: 4905 search-filter-widget: 4 shop_coupon: 9 shop_order: 232 shop_order_refund: 4 sp_post_carousel: 1 wp_global_styles: 1 wp_navigation: 1 wp_template: 2 wpape_gallery_theme: 2 wpape_gallery_type: 2 wplp-news-widget: 1

Security

Secure connection (HTTPS): ✔ Hide errors from visitors: ✔

Active Plugins (35)

Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0 Advanced Custom Fields: by WP Engine – 6.2.3 Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3 Archive Control: by SwitchWP – 1.3.4 Auto Post Title: by ThoughtLab – 1.2.2 CB Contact Form: by CodeBuzz (Samuel Todosiciuc) – 1.1 Child Pages Shortcode: by Takayuki Miyauchi – 1.9.3 Classic Widgets: by WordPress Contributors – 0.3 Custom Post Type UI: by WebDevStudios – 1.15.1 Display PHP Version: by David Gwyer – 1.8 Easy Add Thumbnail: by Samuel Aguilera – 1.1.3 Evermore: by Bennett McElwee – 2.4 GA Google Analytics: by Jeff Starr – 20231101 Jetpack: by Automattic – 12.8.1 MailPoet: by MailPoet – 4.37.0 Photospace Responsive: by Dean Oakley – 2.2.0 Recent Posts Widget Extended: by Ga Satrya – 2.0.2 Relevanssi: by Mikko Saari – 4.21.1 Search & Filter Pro: by Code Amp – 2.5.16 SEO Redirection: by wp-buy – 9.5 ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 5.5.2 Smart Post Show Pro: by ShapedPlugin LLC – 2.5.6

Template Tag Shortcodes: by Justin Tadlock – 0.1.1 Ultimate WooCommerce Auction Pro - Business: by Nitesh Singh – 2.3.7 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.23.13

WooPayments: by Automattic – 6.8.0 WooCommerce PayPal Payments: by WooCommerce – 2.4.1 WooCommerce Shipping & Tax: by WooCommerce – 2.4.0 WooCommerce: by Automattic – 8.3.1 WP All Export: by Soflyy – 1.4.1 WP Crontrol: by John Blackbourn & crontributors – 1.16.1 WP External Links: by WebFactory Ltd – 2.59 WP-PageNavi: by Lester 'GaMerZ' Chan – 2.94.1 WP All Export - ACF Export Add-On Pro: by Soflyy – 1.0.5 WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.9

Inactive Plugins (11)

All-in-One WP Migration: by ServMask – 7.79 All-in-One WP Migration Unlimited Extension: by ServMask – 2.46 Duplicator Pro: by Snap Creek – 4.0.2 Export to Text: by Hyped Text – 2.4 Latest Tweets Widget: by Tim Whitlock – 1.1.4 Preview E-mails for WooCommerce: by Digamber Pradhan – 2.1.6 Regenerate Thumbnails Advanced: by ShortPixel – 2.4.1 SiteGround Migrator: by SiteGround – 2.0.9 Temporary Login Without Password: by StoreApps – 1.8.2 Watermark RELOADED Pro: by Sandi Verdev – 2.4.3 WordPress Importer: by wordpressdotorg – 0.8.1

Must Use Plugins (2)

Endurance Page Cache: by Mike Hansen – 2.2 SSO: by Garth Mortensen Mike Hansen – 0.3

Settings

API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: auction (auction) external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription)

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

Connected to WooCommerce.com: – Enforce Approved Product Download Directories: ✔ HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: –

WC Pages

Shop base: #34418 - /shop/ Cart: #34419 - /shop/cart/ Checkout: #34420 - /shop/checkout/ My account: #34421 - /shop/my-account/ Terms and conditions: ❌ Page not set

Theme

Name: TMNT Version: (update to version 0 is available) Author URL: Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ❌ Not declared

Templates

Overrides: –

WooPayments

Version: 6.8.0 Connected to WPCOM: Yes WPCOM Blog ID: 67856569 Account ID: acct_1LPVPx2EaFWZ4kZU Payment Gateway: Enabled Test Mode: Disabled UPE: Enabled (deferred_intent) UPE Enabled APMs: card WooPay: Disabled WooPay Incompatible Extensions: No Apple Pay / Google Pay: Enabled (cart,checkout) Fraud Protection Level: basic Multi-currency: Enabled Public Key Encryption: Disabled Auth and Capture: Enabled Documents: Disabled Logging: Disabled

WooCommerce PayPal Payments

Onboarded: ✔ Shop country code: US WooCommerce currency supported: ✔ Advanced Card Processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: ✔ PayPal Vault enabled: – ACDC Vault enabled: – Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – Subscriptions Mode: Disabled

Admin

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

Disabled Features: customize-store minified-js new-product-management-experience product-virtual-downloadable product-external-affiliate settings async-product-editor-category-field

Daily Cron: ✔ Next scheduled: 2023-11-27 17:18:30 -07:00 Options: ✔ Notes: 148 Onboarding: completed

MailPoet

Sending Method: MailPoet Send all site's emails with: Default WordPress sending method Task Scheduler method: Action Scheduler Cron ping URL: https://tmnt-ninjaturtles.com?mailpoet_router&endpoint=cron_daemon&action=ping

Action Scheduler

Canceled: 2 Oldest: 2023-11-19 18:33:10 -0700 Newest: 2023-11-22 13:53:03 -0700

Complete: 18,057 Oldest: 2023-10-27 10:47:01 -0600 Newest: 2023-11-27 09:44:29 -0700

Failed: 15 Oldest: 2022-08-29 13:58:00 -0600 Newest: 2023-11-13 13:15:17 -0700

Pending: 2 Oldest: 2023-11-27 09:46:29 -0700 Newest: 2023-11-27 14:23:52 -0700

Status report information

Generated at: 2023-11-27 09:44:36 -07:00 `

Isolating the problem

github-actions[bot] commented 11 months ago

Hi @richTMNT,

While our goal is to address all the issues reported in this repository, GitHub should be treated as a place to report confirmed bugs only.

The type of issue you submitted looks like a support request which may or may not reveal a bug once proper troubleshooting is done. In order to confirm the bug, please follow one of the steps below: