Coupon discount still applied to items on sale (SHOULD NOT BE)
-
Hi,
We have a client who has created a % discount coupon, and has ticked the box to ‘should not apply to items on sale.’
However the coupon still gets applied to any items that are on sale in the customer basket, which is frustrating our client.
I have noticed that if the coupon type is ‘fixed price’ then the coupon isn’t applied to sale items. However the checkmark does not specify that it only disables applying the coupon on ‘fixed price coupons’. Surely percentage discount should also restrict applying to sale items?
Please let me know asap. Thanks.
- This topic was modified 3 years, 6 months ago by kristianas.
-
Hello there,
Can you send us a copy of your system status from WooCommerce > Status > System Status?Hi there: its below:
### WordPress Environment ###WordPress address (URL): *****
Site address (URL): *******
WC Version: 5.2.2
REST API Version: ? 5.2.2
WC Blocks Version: ? 4.7.2
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.1.5
Log Directory Writable: ?
WP Version: 5.7.1
WP Multisite: ?
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –### Server Environment ###
Server Info: Apache
PHP Version: 7.4.16
PHP Post Max Size: 100 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1dSUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.28-MariaDB-cll-lve
Max Upload Size: 1 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?### Database ###
WC Database Version: 4.4.1
WC Database Prefix: wp_
Total Database Size: 132.11MB
Database Data Size: 77.93MB
Database Index Size: 54.18MB
wp_woocommerce_sessions: Data: 0.29MB + Index: 0.01MB + Engine MyISAM
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: 1.52MB + Index: 0.19MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_2_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_age_restriction_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_braapf_product_stock_status_parent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_braapf_variation_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2_ewwwio_images: Data: 0.20MB + Index: 0.23MB + Engine InnoDB
wp_2_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_options: Data: 2.11MB + Index: 0.06MB + Engine InnoDB
wp_2_postmeta: Data: 0.48MB + Index: 0.31MB + Engine InnoDB
wp_2_posts: Data: 0.23MB + Index: 0.06MB + Engine InnoDB
wp_2_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_2_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yoast_indexable: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
wp_2_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.21MB + Index: 0.10MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.16MB + Index: 0.10MB + Engine MyISAM
wp_age_restriction_stats: Data: 1.52MB + Index: 1.81MB + Engine MyISAM
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_braapf_product_stock_status_parent: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_braapf_variation_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
wp_ewwwio_images: Data: 7.52MB + Index: 9.13MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_onestock_product_properties: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_onestock_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_onestock_sku_map: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_options: Data: 4.13MB + Index: 0.14MB + Engine InnoDB
wp_postmeta: Data: 22.55MB + Index: 17.89MB + Engine InnoDB
wp_posts: Data: 5.52MB + Index: 1.09MB + Engine InnoDB
wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sitemeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 1.34MB + Index: 0.27MB + Engine InnoDB
wp_term_taxonomy: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 11.52MB + Index: 12.03MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 1.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.11MB + Index: 0.10MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.46MB + Index: 0.41MB + Engine MyISAM
wp_wc_order_stats: Data: 0.13MB + Index: 0.09MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblockediplog: Data: 0.07MB + Index: 0.05MB + Engine MyISAM
wp_wfblocks7: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wfconfig: Data: 1.80MB + Index: 0.02MB + Engine MyISAM
wp_wfcrawlers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilemods: Data: 1.26MB + Index: 0.27MB + Engine MyISAM
wp_wfhits: Data: 0.85MB + Index: 0.19MB + Engine MyISAM
wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfissues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_wfknownfilelist: Data: 0.65MB + Index: 0.08MB + Engine MyISAM
wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflogins: Data: 0.33MB + Index: 0.08MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfstatus: Data: 0.13MB + Index: 0.06MB + Engine MyISAM
wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Data: 3.04MB + Index: 0.66MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.17MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wp_yoast_seo_meta: Data: 0.04MB + Index: 0.04MB + Engine MyISAM### Post Type Counts ###
acf-field: 74
acf-field-group: 21
age_restriction: 1
amn_mi-lite: 3
attachment: 1059
br_filters_group: 1
br_product_filter: 7
ffw_producer: 72
nav_menu_item: 100
oembed_cache: 1
page: 17
post: 38
product: 815
product_variation: 4
revision: 785
shop_coupon: 224
shop_order: 2796
shop_order_refund: 48
wpcf7_contact_form: 1### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?### Active Plugins (51) ###
ManageWP – Worker: by GoDaddy – 4.9.8
Advanced Custom Fields: Contact Form 7: by Taylor Mitchell-St.Joseph – 1.0.1
Advanced Custom Fields PRO: by Elliot Condon – 5.9.5
Premium Age Restriction Plugin for WordPress: by AA-Team – 999.1.2
Category Checklist Tree: by scribu – 1.3.2
Classic Editor: by WordPress Contributors – 1.6
Contact Form 7: by Takayuki Miyoshi – 5.4.1
Disable Comments: by WPDeveloper – 2.1.1
Email Verification for WooCommerce: by WPFactory – 2.0.8
EWWW Image Optimizer: by Exactly WWW – 6.1.3
Heroic Favicon Generator: by HeroThemes – 1.6.1
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.17.0
Mailgun: by Mailgun – 1.7.7
oAuth Twitter Feed for Developers: by Liam Gladdy (Storm Consultancy) – 2.3.0
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Rich Text Tags, Categories, and Taxonomies: by Katz Web Services
Inc. – 1.8Save Contact Form 7: by Nimblechapps – 2.0
Under Construction: by Noah Kagan – 1.18
Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.5.4.2
WP WooCommerce Mailchimp: by Saint Systems – 2.4.1
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.3.2
WooCommerce Waitlist: by Neil Pie – 136.3.6
WooCommerce: by Automattic – 5.2.2
WorldPay Gateway for WooCommerce: by PatSaTECH – 1.7.5
Yoast SEO: by Team Yoast – 16.2
WordPress Force HTTPS: by A. Kai Armstrong – 0.1.4
LESS CSS: by Robert O’Rourke – 2.1
Perfect Images + Retina: by Jordy Meow – 6.1.3
WP User Avatar: by ProfilePress – 2.2.16
Advanced Custom Fields PRO: by Elliot Condon – 5.9.5
Advanced Custom Fields: Contact Form 7: by Taylor Mitchell-St.Joseph – 1.0.1
Category Checklist Tree: by scribu – 1.3.2
Classic Editor: by WordPress Contributors – 1.6
Contact Form 7: by Takayuki Miyoshi – 5.4.1
Disable Comments: by WPDeveloper – 2.1.1
Email Verification for WooCommerce: by WPFactory – 2.0.8
EWWW Image Optimizer: by Exactly WWW – 6.1.3
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.17.0
Heroic Favicon Generator: by HeroThemes – 1.6.1
Mailgun: by Mailgun – 1.7.7
ManageWP – Worker: by GoDaddy – 4.9.8
oAuth Twitter Feed for Developers: by Liam Gladdy (Storm Consultancy) – 2.3.0
Perfect Images + Retina: by Jordy Meow – 6.1.3
Premium Age Restriction Plugin for WordPress: by AA-Team – 999.1.2
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Rich Text Tags, Categories, and Taxonomies: by Katz Web Services
Inc. – 1.8Save Contact Form 7: by Nimblechapps – 2.0
LESS CSS: by Robert O’Rourke – 2.1
OneStock for WooCommerce: by Inpsyde GmbH – 1.1.1
WordPress Sentry: by Alex Bouma – 4.3.0
WooCommerce Smart Coupons: by StoreApps – 4.12.2### Inactive Plugins (2) ###
Wordfence Security: by Wordfence – 7.5.2
WordPress Importer: by wordpressdotorg – 0.7### Dropin Plugins (1) ###
maintenance.php: maintenance.php
### Must Use Plugins (1) ###
ManageWP – Worker Loader: by GoDaddy –
### Settings ###
API Enabled: ?
Force SSL: –
Currency: GBP (£)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)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: –
### WC Pages ###
Shop base: #4 – /shop/
Basket: #5 – /basket/
Checkout: #6 – /checkout/
My account: #7 – /my-account/
Terms and conditions: #988 – /terms-conditions/### Theme ###
Name: Frontier Fine Wines
Version: 1.0.0
Author URL: https://applinskinner.com/
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 themeWooCommerce Support: ?
### Templates ###
Overrides: ffw/woocommerce/archive-product.php
ffw/woocommerce/content-product.php
ffw/woocommerce/content-single-product.php
ffw/woocommerce/emails/customer-completed-order.php version 3.5.0 is out of date. The core version is 3.7.0
ffw/woocommerce/single-product/add-to-cart/simple.php
ffw/woocommerce/single-product/add-to-cart/variable.php
ffw/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
ffw/woocommerce/single-product/add-to-cart/variation.php
ffw/woocommerce/single-product/price.php
ffw/woocommerce/single-product/product-image.php
ffw/woocommerce/single-product/share.php
ffw/woocommerce/single-product/tabs/tabs.php version 2.4.0 is out of date. The core version is 3.8.0
ffw/woocommerce/single-product/title.php
ffw/woocommerce/single-product.phpOutdated Templates: ?
Learn how to update
### Action Scheduler ###
Complete: 422
Oldest: 2021-04-04 19:22:07 +0100
Newest: 2021-05-04 15:34:38 +0100### Status report information ###
Generated at: 2021-05-05 09:22:25 +01:00
`Hi @kristianas,
Thanks for sending that over. So far I haven’t been able to duplicate this. I created a 25% off coupon code and set it to exclude products on sale.
When I add an item on sale to the cart, the system won’t allow me to add the coupon. If I add other products that aren’t on sale, then I can apply the coupon to those products, but it doesn’t discount the sale price.
Just to make sure we’re on the same page, this happens when only sale products are in the cart and the coupon is applied. Is that right? If so, does it happen when only WooCommerce and the Storefront theme are active?
https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4
Let us know.
Thanks
Hi @kristianas,
Since we haven’t heard from you in a while, we’re hoping that means you were able to get this resolved. I’m going to close this thread out now.
If you’re still having trouble, please open up a new topic and we’ll be happy to help out.
Cheers
- The topic ‘Coupon discount still applied to items on sale (SHOULD NOT BE)’ is closed to new replies.