• Resolved babrees

    (@babrees)


    I updated woocommerce on 11th March.

    I have products with some variations not available for all attributes, ie colour is not available in all sizes, or paper is not available in all sizes.

    For products created prior to the update, on the front end when you select a colour it will only show the sizes available in that specific colour.

    For products created after the update, when you select a colour it shows ALL sizes, and then creates a message “Sorry, no products matched your selection. Please choose a different combination.” which is of course extremely bad.

    I have spent two days trying different things, including turning off all unnecessary plugins and reverting to default theme, none of which worked.

    Unfortunately this is a development site and therefore unavailable at the moment.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hello @babrees,

    Navigate to WooCommerce > Status > Tools and do the followings to see if that helps.

    1. Delete all Orphaned variations
    2. Regenerate Product lookup tables
    3. Update database

    https://prnt.sc/fwCqV3QzjoMD

    Cheers,
    Naz.`

    Thanks @nazreenexe for chiming in.

    @babrees – If the problem persists even after performing the steps above, then please share with us the following:

    1. System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
    2. Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    Hoping for a quick resolution.

    Thread Starter babrees

    (@babrees)

    @nazreenexe
    Thanks, but that hasn’t worked. I also cleared Woocommerce transients, but that did nothing

    • This reply was modified 4 years, 2 months ago by babrees.

    Are you using plugin like Variation swatches? If yes, go to attributes/colors and just rename and save some attributes to see if that helps. This exact had happened in the past and it was solved by doing the above.

    Naz.

    Thread Starter babrees

    (@babrees)

    @margaretwporg

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://dev.funkthis.com
    Site address (URL): https://dev.funkthis.com
    WC Version: 6.3.1
    REST API Version: ✔ 6.3.1
    WC Blocks Version: ✔ 6.9.0
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.2.1
    Log Directory Writable: ✔
    WP Version: 5.9.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2
    PHP Version: 7.4.28
    PHP Post Max Size: 64 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.37
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.3.1
    WC Database Prefix: wp_
    Total Database Size: 2.66MB
    Database Data Size: 2.17MB
    Database Index Size: 0.49MB
    wp_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + 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_actionscheduler_actions: Data: 0.03MB + Index: 0.03MB + 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.02MB + Index: 0.02MB + Engine MyISAM
    wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_kbp_countdown_entry: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_kbp_form_entry: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_kbp_form_entrymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 1.55MB + Index: 0.05MB + Engine MyISAM
    wp_postmeta: Data: 0.21MB + Index: 0.15MB + Engine MyISAM
    wp_posts: Data: 0.19MB + Index: 0.03MB + Engine MyISAM
    wp_statistics_exclusions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_statistics_historical: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_statistics_pages: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
    wp_statistics_search: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_statistics_useronline: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_statistics_visit: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_statistics_visitor: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
    wp_statistics_visitor_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_toolset_associations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_toolset_connected_elements: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_toolset_post_guid_id: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_toolset_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_toolset_type_sets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_top_ten: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_top_ten_daily: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    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.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_attributes_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_reserved_stock: Data: 0.00MB + 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.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfconfig: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilemods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfknownfilelist: Data: 0.00MB + Index: 0.00MB + 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.00MB + Index: 0.00MB + 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.00MB + Index: 0.00MB + Engine MyISAM
    wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpmelon_advbedit_temp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    attachment: 5
    nav_menu_item: 1
    page: 9
    post: 2
    product: 8
    product_variation: 159
    revision: 8
    wp_global_styles: 1
    wp-types-group: 2
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (18) ###
    
    Contact Form 7: by Takayuki Miyoshi – 5.5.6
    WP Armour - Honeypot Anti Spam: by Dnesscarkey – 1.9.1
    Kadence Blocks - PRO Extension: by Kadence WP – 1.6.1
    Kadence Blocks – Gutenberg Blocks for Page Builder Features: by Kadence WP – 2.3.0
    Kadence Pro - Premium addon for the Kadence Theme: by Kadence WP – 1.0.5
    Side Cart WooCommerce: by XootiX – 2.1
    Toolset Blocks: by OnTheGoSystems – 1.6.2
    Top 10: by Ajay D'Souza – 3.0.0
    Toolset Types: by OnTheGoSystems – 3.4.15
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.11
    
    WebP Converter for Media: by Mateusz Gbiorczyk – 4.2.4
    WooCommerce Advanced Bulk Edit: by George Iron – 5.0.1
    WooCommerce Stripe Gateway: by WooCommerce – 6.3.0
    Toolset WooCommerce Blocks: by OnTheGoSystems – 3.1.2
    WooCommerce: by Automattic – 6.3.1
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.3
    
    WP Statistics: by VeronaLabs – 13.1.6
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.3
    
    ### Inactive Plugins (3) ###
    
    Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.3
    MailPoet 3 (New): by MailPoet – 3.84.1
    Wordfence Security: by Wordfence – 7.5.8
    
    ### 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: #12 - /shop/
    Basket: #13 - /basket/
    Checkout: #14 - /checkout/
    My account: #15 - /my-account/
    Terms and conditions: #36 - /terms-conditions/
    
    ### Theme ###
    
    Name: Kadence Child
    Version: 1.0.0
    Author URL: https://www.kadencewp.com/
    Child Theme: ✔
    Parent Theme Name: Kadence
    Parent Theme Version: 1.1.15
    Parent Theme Author URL: https://www.kadencewp.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 120
    Oldest: 2022-03-16 12:27:05 +0000
    Newest: 2022-03-16 12:29:57 +0000
    
    ### Status report information ###
    
    Generated at: 2022-03-16 12:36:17 +00:00
    

    —END————————————————–
    Nothing in logs.

    I now have made the site available at https://dev.funkthis.com/shop/

    The Posters is the one that works correctly. You can see this as size A2 is available for Matte paper, but not Bamboo.

    Sweatshirt – colour anthracite should not have sizes 4X or 5X available.

    Thread Starter babrees

    (@babrees)

    @nazreenexe – Nope. The only plugin I have installed is Bulk Edit. However, I have created some without using that and it is no different. I have also turned that off with no difference.

    Ah! Got your problem. Add the below code on your themes fuctions.php. Alternatively use plugin like Code Snippet to add the code safely without breaking your site. Let me know if the problem still persist.

    /**
     * Fix for issue where too many variations causes the front end to not pre-load
     * all variations and rely on AJAX.
     */
    
    function custom_wc_ajax_variation_threshold( $qty, $product )
    {
        return 200;
    }
    add_filter( 'woocommerce_ajax_variation_threshold', 'custom_wc_ajax_variation_threshold', 10, 2 );
    • This reply was modified 4 years, 2 months ago by WP Native.
    Thread Starter babrees

    (@babrees)

    @nazreenexe

    Naz, you are a genius!! Thank you so much – that worked.

    Glad that solved your problem 🙌

    Cheers 🍻
    Naz.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Probable bug in Variables’ is closed to new replies.