Filter by attribute widget not working + random number of items per archive page
-
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.):
- 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. - 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]
- 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/>
-
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.jpgLet us know how it goes!
- This reply was modified 2 years, 8 months ago by Paulo P - a11n. Reason: formatting
We already tried without success to regenerate the lookup table.
Regarding the second question:
live:
https://snipboard.io/D7W9UO.jpghttps://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.
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
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?
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?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?
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.
Hello again,
Cache on siteground is turned off/was emptied manually
Storefront installed and a filter widget was moved to sidebar positionNothing is shown, issue remains.
Hello,
Cache on siteground is turned off/was emptied manually
Storefront installed and a filter widget was moved to sidebar positionThanks 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.
- The topic ‘Filter by attribute widget not working + random number of items per archive page’ is closed to new replies.