• Resolved pursang20

    (@pursang20)


    The website is a staging copy of https://www.enotecarivetti.it/
    At this moment, the only plugin active is woocommerce, with 2022 theme active
    On live, Avada themefusion is in use.

    There are two issues (Both of these things used to work normally.):

    1. Under widget one section is loaded as a sidebar in the shop with different “filter product by attribute” filters, but none of them are loading at all. We tried also using yith, those filters load but they don’t “find” any product once any filter is applied. This can’t really be seen without switching theme to Avada as the widget area in use for this is created and loaded through the theme. We can switch it back on if needed.<br/>
      This has started recently.
    2. Pages in the shop archives (any, as far as we can tell) show less than whatever number of items per page we pick. We tried changing number of columns, we tried changing the number of items, we tried adding code to our function.php – the result is always that in certain pages, 1 or 2 items are missing, showing 13 or 14 items instead of 15 (or 7-8 instead of 9), despite the list going on in several pages.
      This we are unsure of how long it has been going on.

    The page I need help with: [log in to see the link]

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Thanks for reaching out!

    Under widget one section is loaded as a sidebar in the shop with different “filter product by attribute” filters, but none of them are loading at all

    WooCommerce 6.3 included a database migration to create a new product attributes lookup table. You can read more about it here: https://developer.woocommerce.com/2022/02/02/new-product-filtering-by-attributes-rolling-out-in-woocommerce-6-3/

    It looks like there was an issue with it. Can you try regenerating the lookup table data, like mentioned there? You can find that option in WooCommerce > Status > Tools.

    Pages in the shop archives (any, as far as we can tell) show less than whatever number of items per page we pick

    Can you please share a screenshot of your Product Catalog settings? You can find it in Appearance > Customize > WooCommerce > Product Catalog. You can use https://snipboard.io/ to share the screenshot.

    For reference, here’s how my Twenty Twenty-Two test site is configured for 16 results per page:


    Link to image: https://snipboard.io/fZJpUS.jpg

    Let us know how it goes!

    • This reply was modified 2 years, 8 months ago by Paulo P - a11n. Reason: formatting
    Thread Starter pursang20

    (@pursang20)

    We already tried without success to regenerate the lookup table.

    Regarding the second question:

    live:
    https://snipboard.io/D7W9UO.jpg

    https://snipboard.io/HxMDc8.jpg

    staging:

    https://snipboard.io/4ib9xm.jpg

    as you can see, it should not be behaving like it is.

    Hi @pursang20

    We already tried without success to regenerate the lookup table.

    Can you also clear transients from WooCommerce > Status > Tools, and check if the attribute filters are loading properly?

    Regarding the second question:

    I can see that the staging site with Twenty Twenty Two theme is also missing 1-2 items on the shop page. To troubleshoot further, could you please share a copy of your staging site’s 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.

    Thread Starter pursang20

    (@pursang20)

    Sorry that it took this long to get back to you.

    Clearing the transients doesn’t seem to fix it

    System status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.staging4.enotecarivetti.it
    Site address (URL): https://www.staging4.enotecarivetti.it
    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: 768 MB
    WP Debug Mode: –
    WP Cron: –
    Language: it_IT
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.28
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.66.0
    OpenSSL/1.1.1l-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.32-35-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: 6.3.1
    WC Database Prefix: wp_
    Dimensione totale database: 37.39MB
    Dimensione dati database: 30.61MB
    Dimensione indice database: 6.78MB
    wp_woocommerce_sessions: Dati: 0.89MB + indice: 0.03MB + motore MyISAM
    wp_woocommerce_api_keys: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_attribute_taxonomies: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_woocommerce_downloadable_product_permissions: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_order_items: Dati: 0.01MB + indice: 0.01MB + motore MyISAM
    wp_woocommerce_order_itemmeta: Dati: 0.11MB + indice: 0.08MB + motore MyISAM
    wp_woocommerce_tax_rates: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_woocommerce_tax_rate_locations: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_shipping_zones: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_shipping_zone_locations: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_woocommerce_shipping_zone_methods: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_payment_tokens: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_payment_tokenmeta: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woocommerce_log: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_actionscheduler_actions: Dati: 0.34MB + indice: 0.16MB + motore MyISAM
    wp_actionscheduler_claims: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_actionscheduler_groups: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_actionscheduler_logs: Dati: 0.24MB + indice: 0.18MB + motore MyISAM
    wp_cmplz_cookiebanners: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_cmplz_cookies: Dati: 0.05MB + indice: 0.00MB + motore InnoDB
    wp_cmplz_services: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_commentmeta: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_comments: Dati: 0.05MB + indice: 0.03MB + motore MyISAM
    wp_fusion_forms: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
    wp_fusion_form_entries: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_fusion_form_fields: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_fusion_form_submissions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_gdbc_attempts: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_huge_it_share_params: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_huge_it_share_params_posts: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_layerslider: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_layerslider_revisions: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_links: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_mailchimp_carts: Dati: 0.09MB + indice: 0.00MB + motore InnoDB
    wp_mailchimp_jobs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_ms_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_options: Dati: 3.06MB + indice: 0.48MB + motore MyISAM
    wp_postmeta: Dati: 9.67MB + indice: 2.69MB + motore MyISAM
    wp_posts: Dati: 11.86MB + indice: 0.34MB + motore MyISAM
    wp_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_termmeta: Dati: 0.12MB + indice: 0.09MB + motore MyISAM
    wp_terms: Dati: 0.08MB + indice: 0.11MB + motore MyISAM
    wp_term_relationships: Dati: 0.18MB + indice: 0.36MB + motore MyISAM
    wp_term_taxonomy: Dati: 0.05MB + indice: 0.08MB + motore MyISAM
    wp_usermeta: Dati: 0.16MB + indice: 0.08MB + motore MyISAM
    wp_users: Dati: 0.01MB + indice: 0.01MB + motore MyISAM
    wp_wcpicfi_sessions: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
    wp_wc_admin_notes: Dati: 0.03MB + indice: 0.00MB + motore MyISAM
    wp_wc_admin_note_actions: Dati: 0.01MB + indice: 0.01MB + motore MyISAM
    wp_wc_category_lookup: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_wc_customer_lookup: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_wc_download_log: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wc_order_coupon_lookup: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wc_order_product_lookup: Dati: 0.02MB + indice: 0.02MB + motore MyISAM
    wp_wc_order_stats: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_wc_order_tax_lookup: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_wc_product_attributes_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
    wp_wc_product_meta_lookup: Dati: 0.08MB + indice: 0.11MB + motore MyISAM
    wp_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wc_tax_rate_classes: Dati: 0.00MB + indice: 0.01MB + motore MyISAM
    wp_wc_webhooks: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_woof_query_cache: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_wpfm_backup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wt_iew_action_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wt_iew_cron: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wt_iew_ftp: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wt_iew_mapping_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_wysija_campaign: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_campaign_list: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_custom_field: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_email: Dati: 0.09MB + indice: 0.00MB + motore MyISAM
    wp_wysija_email_user_stat: Dati: 0.01MB + indice: 0.01MB + motore MyISAM
    wp_wysija_email_user_url: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_form: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_list: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_queue: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_url: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_url_mail: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_user: Dati: 0.04MB + indice: 0.03MB + motore MyISAM
    wp_wysija_user_field: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_user_history: Dati: 0.00MB + indice: 0.00MB + motore MyISAM
    wp_wysija_user_list: Dati: 0.01MB + indice: 0.01MB + motore MyISAM
    wp_yith_wcps_shippings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
    wp_yoast_indexable: Dati: 2.52MB + indice: 1.05MB + motore InnoDB
    wp_yoast_indexable_hierarchy: Dati: 0.16MB + indice: 0.30MB + motore InnoDB
    wp_yoast_migrations: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
    wp_yoast_primary_term: Dati: 0.09MB + indice: 0.11MB + motore InnoDB
    wp_yoast_seo_links: Dati: 0.11MB + indice: 0.04MB + motore MyISAM
    wp_yoast_seo_meta: Dati: 0.03MB + indice: 0.03MB + motore MyISAM
    
    ### Post Type Counts ###
    
    attachment: 1421
    fusion_element: 32
    fusion_tb_section: 1
    fusion_template: 5
    jetpack_migration: 2
    mc4wp-form: 1
    nav_menu_item: 65
    oembed_cache: 4
    page: 21
    post: 18
    product: 710
    product_variation: 584
    revision: 958
    rooms: 11
    shop_coupon: 2
    shop_order: 48
    shop_order_refund: 3
    slide: 26
    soliloquy: 2
    timeline: 10
    tribe_events: 1
    tribe_organizer: 4
    tribe_venue: 3
    wineproducts: 6
    wp_global_styles: 1
    wpcf7_contact_form: 4
    wysijap: 1
    yith_wcan_preset: 2
    ywcm_message: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (1) ###
    
    WooCommerce: by Automattic – 6.3.1
    
    ### Inactive Plugins (51) ###
    
    Age Gate: by Phil Baker – 2.20.2
    Amount Left for Free Shipping for WooCommerce: by WPFactory – 2.1.5
    Autoptimize: by Frank Goossens (futtta) – 2.9.5.1
    Avada Builder: by ThemeFusion – 3.6.1
    Avada Core: by ThemeFusion – 5.6.1
    Code Snippets: by Code Snippets Pro – 2.14.3
    Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 6.1.2
    Contact Form 7: by Takayuki Miyoshi – 5.5.6
    Contact Form 7 Image Captcha: by KC Computing – 3.2.5
    Conversios.io - Google Analytics and Google Shopping plugin for WooCommerce: by Tatvic – 4.6.7
    Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.3
    CTX Feed: by WebAppick – 4.4.53
    Custom Login Page Customizer: by Hardeep Asrani – 2.1.8
    Custom Product Tabs for WooCommerce: by YIKES
    Inc. – 1.7.7
    
    Disable Comments: by WPDeveloper – 2.3.3
    Disable Gutenberg: by Jeff Starr – 2.6
    Envato Market: by Envato – 2.0.7
    Facebook for WooCommerce: by Facebook – 2.6.12
    Hide Shipping Method For WooCommerce Pro: by theDotstore – 1.3.1
    Honeypot for Contact Form 7: by Nocean – 2.1
    Jetpack: by Automattic – 10.7
    Loco Translate: by Tim Whitlock – 2.6.0
    Mailchimp for WooCommerce: by Mailchimp – 2.6.1
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
    No Right Click Images Plugin: by Keith P. Graham – 3.6
    Perfect Brands for WooCommerce: by QuadLayers – 2.0.7
    Product CSV Import Export (BASIC): by WebToffee – 2.1.8
    Product GTIN (EAN, UPC, ISBN) for WooCommerce: by Emanuela Castorina – 1.1.1
    Product Subtitle For WooCommerce: by Varun Sridharan – 4.6.1
    Really Simple SSL: by Really Simple Plugins – 5.3.0
    Show IDs: by DraftPress – 1.1.8
    SiteGround Optimizer: by SiteGround – 7.0.6
    Site Offline: by Chandra Shekhar Sahu – 1.5.0
    Subtitles: by <a href="https://philip.blog/">Philip Arthur Moore</a>
    <a href="https://wecobble.com">We Cobble</a> – 3.0.0
    
    Widget Logic: by WPChef – 5.10.4
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.8
    WooCommerce P.IVA e Codice Fiscale per Italia: by dot4all – 2.1.11
    WooCommerce Stripe Gateway: by WooCommerce – 6.3.0
    Woo Empty Cart Button: by WPCodelibrary – 1.4.0
    WOOF - WooCommerce Products Filter: by realmag777 – 1.2.6.4
    WP Apache Handline: by WordPress – 1.9
    WPBruiser: by Mihai Chelaru – 3.1.43
    WP File Manager: by mndpsingh287 – 7.1.4
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.3
    
    YITH Product Shipping for WooCommerce Premium: by YITH – 1.0.29
    YITH WooCommerce Ajax Product Filter: by YITH – 4.8.0
    YITH WooCommerce Brands Add-on: by YITH – 1.12.0
    YITH WooCommerce Cart Messages Premium: by YITH – 1.7.3
    YITH WooCommerce Catalog Mode: by YITH – 2.8.0
    Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.4
    Yoast SEO: by Team Yoast – 18.3
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left_space
    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)
    outofstock (outofstock-2)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-2 (rated-2-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    rated-5 (rated-5-2)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Shop base: #19647 - /negozio/
    Carrello: #16564 - /carrello/
    Pagamento: #689 - /checkout/
    Il mio account: #351 - /my-account/
    Termini e condizioni: #21338 - /termini-e-condizioni/
    
    ### Theme ###
    
    Name: Twenty Twenty-Two
    Version: 1.1
    Author URL: https://www.ads-software.com/
    Child Theme: ? – Se stai modificando WooCommerce o un tema genitore che non hai costruito personalmente
    ti consigliamo di utilizzare un tema child. Vedi: Come creare un tema child
    
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Completato: 1.218
    Oldest: 2022-02-22 14:12:04 +0100
    Newest: 2022-03-22 11:02:07 +0100
    
    Operazione non riuscita: 9
    Oldest: –
    Newest: –
    
    In attesa: 2
    Oldest: 2022-03-22 11:02:24 +0100
    Newest: 2022-03-23 11:02:07 +0100
    
    ### Status report information ###
    
    Generated at: 2022-03-22 11:02:29 +01:00
    
    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Thanks for writing back!

    We already tried without success to regenerate the lookup table.

    There might be an incompatibility between WooCommerce’s new product attributes lookup table and something else on your site. A conflict test would be needed to pinpoint the issue. As a temporary workaround, please go to WooCommerce > Settings > Products > Advanced and disable the “Use the product attributes lookup table for catalog filtering.” option.

    As for the second question. I see the archive pages in both the live and staging sites are showing 15 items per page. I’m assuming you have resolved this one, right?

    Thread Starter pursang20

    (@pursang20)

    We didn’t do anything, the issue is semi-random and still present:

    https://snipboard.io/NjOlM8.jpg

    The temporary work-around seems to be *somewhat* working, but i’ve noticed filters that claim there being 10 items, where it only shows 9, or others with 1 that shows none.
    Could this specific behaviour be connected to the other issue?

    Thread Starter pursang20

    (@pursang20)

    We proceded to create a new staging, deactivate everything but Avada builder, Avada core and Woocommerce, and there’s still no filters.
    We tried clearing transients and regenerating tables as per instructions, still no result.

    Would you like to have backend access to take a look?

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    It sounds like a caching issue. Can you clear your website’s cache and get in contact with Siteground to clear the server cache as well?

    Once this is done, test after deactivating all plugins except WooCommerce and keep the theme to Twenty Twenty-Two or change it to Storefront.

    Let us know how it goes.

    Thread Starter pursang20

    (@pursang20)

    Hello again,

    Cache on siteground is turned off/was emptied manually
    Storefront installed and a filter widget was moved to sidebar position

    Nothing is shown, issue remains.

    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Cache on siteground is turned off/was emptied manually
    Storefront installed and a filter widget was moved to sidebar position

    Thanks for confirming. Please contact us at WooCommerce.com > My Account > Support.

    You may need to create an account before you can access that page. Please include a link to this forum thread, so that we can keep track of what’s already been done.

    We will be able to help you further there.

    The issue is now being investigated in 5200327-zen.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Filter by attribute widget not working + random number of items per archive page’ is closed to new replies.