• Resolved joshlfcox

    (@joshlfcox)


    Hi there,

    On a few orders our fixed basket discount coupon is applying random discounts to individual products, which may cause issues if/when refunds are given.

    Please see screenshot here:
    https://snipboard.io/S1Vv7q.jpg

    The coupon provides a fixed discount of £35 when a minimum spend of £85 is met and certain products are in the basket. The majority of the time it works, but on a few occasions it throws the above error.

    Wondering if I’ve missed a setting or something?

    Many Thanks,

    Josh

    WC status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://whitecoco.co.uk
    Site address (URL): https://whitecoco.co.uk
    WC Version: 5.9.0
    REST API Version: ? 5.9.0
    WC Blocks Version: ? 6.1.0
    Action Scheduler Version: ? 3.3.0
    WC Admin Version: ? 2.8.0
    Log Directory Writable: ?
    WP Version: 5.8.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.24
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 2500
    cURL Version: 7.65.0
    OpenSSL/1.0.2k-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.4.22-MariaDB-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.9.0
    WC Database Prefix: 40_
    Total Database Size: 328.36MB
    Database Data Size: 208.66MB
    Database Index Size: 119.70MB
    40_woocommerce_sessions: Data: 2.02MB + Index: 0.02MB + Engine InnoDB
    40_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    40_woocommerce_order_items: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    40_woocommerce_order_itemmeta: Data: 24.55MB + Index: 19.06MB + Engine InnoDB
    40_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    40_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_actionscheduler_actions: Data: 5.52MB + Index: 5.25MB + Engine InnoDB
    40_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_actionscheduler_logs: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
    40_ajaxsearchpro: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    40_ajaxsearchpro_priorities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_ajaxsearchpro_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_asp_index: Data: 7.52MB + Index: 7.03MB + Engine InnoDB
    40_asp_synonyms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_cmplz_cookies: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    40_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_commentmeta: Data: 0.27MB + Index: 0.27MB + Engine InnoDB
    40_comments: Data: 11.52MB + Index: 9.09MB + Engine InnoDB
    40_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    40_mailchimp_jobs: Data: 0.52MB + Index: 0.00MB + Engine InnoDB
    40_options: Data: 9.09MB + Index: 1.45MB + Engine InnoDB
    40_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_pimwick_gift_card_activity: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    40_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_postmeta: Data: 82.61MB + Index: 46.13MB + Engine InnoDB
    40_posts: Data: 21.52MB + Index: 6.06MB + Engine InnoDB
    40_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    40_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_redirection_items: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    40_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    40_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_sbi_instagram_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    40_stock_log: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
    40_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    40_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    40_term_relationships: Data: 0.19MB + Index: 0.11MB + Engine InnoDB
    40_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    40_usermeta: Data: 8.52MB + Index: 6.03MB + Engine InnoDB
    40_users: Data: 0.44MB + Index: 0.36MB + Engine InnoDB
    40_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    40_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wc_customer_lookup: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
    40_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    40_wc_order_product_lookup: Data: 4.52MB + Index: 6.06MB + Engine InnoDB
    40_wc_order_stats: Data: 2.52MB + Index: 1.17MB + Engine InnoDB
    40_wc_order_tax_lookup: Data: 0.27MB + Index: 0.20MB + Engine InnoDB
    40_wc_product_meta_lookup: Data: 0.33MB + Index: 0.50MB + Engine InnoDB
    40_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    40_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    40_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    40_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
    40_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wffilemods: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    40_wfhits: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    40_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    40_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    40_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    40_wfpklist_template_data: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    40_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    40_wfstatus: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
    40_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_woo_shippment_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    40_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    40_wpmailsmtp_tasks_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    40_yith_wcwl: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    40_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    40_yoast_indexable: Data: 6.52MB + Index: 3.44MB + Engine InnoDB
    40_yoast_indexable_hierarchy: Data: 0.45MB + Index: 0.52MB + Engine InnoDB
    40_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    40_yoast_primary_term: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    40_yoast_seo_links: Data: 0.22MB + Index: 0.13MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 7424
    custom_css: 1
    custom_order_status: 1
    customize_changeset: 5
    elementor_library: 1
    nav_menu_item: 38
    oembed_cache: 7
    page: 32
    popup: 2
    popup_theme: 8
    post: 5
    postman_sent_mail: 4
    product: 787
    product_variation: 1372
    revision: 1401
    seedprod: 2
    shop_coupon: 28
    shop_order: 15395
    shop_order_refund: 2780
    stores: 2
    wc_whsm: 1
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (37) ###
    
    Advanced Woocommerce Product Gallery Slider: by UnikInfotech – 1.0.0
    Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 5.5.2
    Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.52
    Contact Form 7: by Takayuki Miyoshi – 5.5.3
    Custom Order Status for WooCommerce: by Tyche Softwares – 2.0.3
    Elementor: by Elementor.com – 3.4.8
    Essential Addons for Elementor: by WPDeveloper – 4.9.6
    Facebook for WooCommerce: by Facebook – 2.6.7
    Imsanity: by Exactly WWW – 2.7.2
    Smash Balloon Instagram Feed: by Smash Balloon – 2.9.7
    Jetpack: by Automattic – 10.3
    Mailchimp for WooCommerce: by Mailchimp – 2.5.4
    MainWP Child: by MainWP – 4.1.8
    Max Mega Menu: by megamenu.com – 2.9.5
    Popup Maker: by Popup Maker – 1.16.3
    PW WooCommerce Gift Cards Pro: by Pimwick
    LLC – 1.330
    
    Rearrange Woocommerce Products: by Aslam Doctor – 3.0.4
    Redirection: by John Godley – 5.1.3
    Storefront Product Sharing: by WooCommerce – 1.0.6
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.65
    
    WC Secondary Product Thumbnail: by Hendy Tarnando – 1.3.2
    Advanced Shipment Tracking for WooCommerce: by zorem – 3.3.1
    WooCommerce Admin: by WooCommerce – 2.8.0
    Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.4
    WooCommerce Stripe Gateway: by WooCommerce – 5.8.1
    Woocommerce Gift Wrapper: by Little Package – 4.5.1
    WooCommerce POS Pro: by kilbot – 0.4.19
    WooCommerce POS: by kilbot – 0.4.26
    WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.20
    WooCommerce Product Stock Alert: by WC Marketplace – 2.7.1
    WooCommerce Sequential Order Numbers: by SkyVerge – 1.9.5
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
    Stock Manager for WooCommerce: by StoreApps – 2.8.1
    WooCommerce: by Automattic – 5.9.0
    Yoast SEO: by Team Yoast – 17.6
    WP Mail SMTP: by WPForms – 3.2.1
    YITH WooCommerce Wishlist: by YITH – 3.3.0
    
    ### Inactive Plugins (6) ###
    
    Advanced Coupons for WooCommerce Free: by Rymera Web Co – 3.0.1
    Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 3.3.2
    Advanced Shipping Validation for WooCommerce: by Jeroen Sormani – 1.1.5
    Checkout Countdown for WooCommerce: by Puri.io – 3.1.3
    Wordfence Security: by Wordfence – 7.5.7
    WP Crontrol: by John Blackbourn & crontributors – 1.12.0
    
    ### Must Use Plugins (2) ###
    
    Elementor Safe Mode: by Elementor.com – 1.0.0
    StackCache: by Stack CP –
    
    ### 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)
    pw gift card (pw-gift-card)
    simple (simple)
    variable (variable)
    yith-composite (yith-composite)
    
    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: #10 - /
    Basket: #11 - /basket/
    Checkout: #12 - /checkout/
    My account: #13 - /my-account/
    Terms and conditions: #65 - /returns/
    
    ### Theme ###
    
    Name: Storefront Child Theme
    Version: 1.0.0
    Author URL: https://prystine.co.uk
    Child Theme: ?
    Parent Theme Name: Storefront
    Parent Theme Version: 3.9.1
    Parent Theme Author URL: https://woocommerce.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: storefront-child-theme-master/woocommerce/emails/customer-completed-order.php
    storefront-child-theme-master/woocommerce/emails/customer-invoice.php
    storefront-child-theme-master/woocommerce/global/quantity-input.php
    storefront-child-theme-master/woocommerce/myaccount/orders.php
    storefront-child-theme-master/woocommerce/single-product/product-image.php
    storefront-child-theme-master/woocommerce/single-product.php
    
    ### Action Scheduler ###
    
    Canceled: 4
    Oldest: 2021-11-08 10:50:05 +0000
    Newest: 2021-11-18 11:00:44 +0000
    
    Complete: 16,031
    Oldest: 2021-10-29 15:41:20 +0100
    Newest: 2021-11-29 13:40:06 +0000
    
    Failed: 6
    Oldest: 2020-12-07 16:31:29 +0000
    Newest: 2020-12-07 16:31:29 +0000
    
    Pending: 1
    Oldest: 2021-11-30 11:25:51 +0000
    Newest: 2021-11-30 11:25:51 +0000
    
    ### Status report information ###
    
    Generated at: 2021-11-29 13:40:09 +00:00
    
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Fixed basket coupon adding random discounts to products’ is closed to new replies.