Product attributes lookup table
-
Hello there,
I hope you are doing well.
I am a little bit confused with the Product attributes lookup table. Although I have regenerated the attributes lookup table and cleaned all transients from woo tools, I still cannot see the attributes’ filters on the shop archive when the option “Use the product attributes lookup table for catalog filtering.” is enabled from the woo products advanced settings.
I can only see the filters if the above setting is disabled.
Any ideas why this is happening? It’s the first time I come across with this behavior; I own many WooCommerce websites and all work great with the “Use the product attributes lookup table for catalog filtering.” option enabled.
Thanks in advance,
George.
-
Hello,
For better assistance, can you please share a copy of your site’s System Status Report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?
And please share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any error is visible).
This will permit us to get a better idea, thanks.
Hello @ihereira,
Thanks for your quick response.
Please find below my system status report:
` ### WordPress Environment ### WordPress address (URL): https://home-electric.gr Site address (URL): https://home-electric.gr WC Version: 7.3.0 REST API Version: ? 7.3.0 WC Blocks Version: ? 9.1.5 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: ? Language: el External object cache: ? ### Server Environment ### Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 256 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.85.0 OpenSSL/3.0.8 SUHOSIN Installed: – MySQL Version: 5.7.39-42-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: 7.3.0 WC Database Prefix: z1tPi_ Συνολικ? μ?γεθο? β?ση? δεδομ?νων: 29.21MB Μ?γεθο? β?ση? δεδομ?νων: 21.29MB Μ?γεθο? ευρετηρ?ου β?ση? δεδομ?νων: 7.92MB z1tPi_woocommerce_sessions: Δεδομ?να: 2.19MB + Ευρετ?ρια: 0.08MB + Μηχαν? InnoDB. z1tPi_woocommerce_api_keys: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_woocommerce_attribute_taxonomies: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_woocommerce_downloadable_product_permissions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_woocommerce_order_items: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_woocommerce_order_itemmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_woocommerce_tax_rates: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_woocommerce_tax_rate_locations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_woocommerce_shipping_zones: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_woocommerce_shipping_zone_locations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_woocommerce_shipping_zone_methods: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_woocommerce_payment_tokens: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_woocommerce_payment_tokenmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_woocommerce_log: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_actionscheduler_actions: Δεδομ?να: 0.14MB + Ευρετ?ρια: 0.16MB + Μηχαν? InnoDB. z1tPi_actionscheduler_claims: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_actionscheduler_groups: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_actionscheduler_logs: Δεδομ?να: 0.17MB + Ευρετ?ρια: 0.16MB + Μηχαν? InnoDB. z1tPi_aioseo_cache: Δεδομ?να: 0.33MB + Ευρετ?ρια: 0.09MB + Μηχαν? InnoDB. z1tPi_aioseo_notifications: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_aioseo_posts: Δεδομ?να: 0.34MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_commentmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_comments: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.09MB + Μηχαν? InnoDB. z1tPi_links: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_options: Δεδομ?να: 1.52MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_piraeusbank_transactions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_postmeta: Δεδομ?να: 8.52MB + Ευρετ?ρια: 4.84MB + Μηχαν? InnoDB. z1tPi_posts: Δεδομ?να: 2.52MB + Ευρετ?ρια: 0.56MB + Μηχαν? InnoDB. z1tPi_revslider_css: Δεδομ?να: 0.13MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_css_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_layer_animations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_revslider_layer_animations_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_revslider_navigations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_revslider_navigations_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_revslider_sliders: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_sliders_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_slides: Δεδομ?να: 0.05MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_slides_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_static_slides: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_revslider_static_slides_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_sgs_log_events: Δεδομ?να: 3.52MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_sgs_log_visitors: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_termmeta: Δεδομ?να: 0.19MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB. z1tPi_terms: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_term_relationships: Δεδομ?να: 0.23MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB. z1tPi_term_taxonomy: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_ultimate_post_entries: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_usermeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_users: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.05MB + Μηχαν? InnoDB. z1tPi_wc_admin_notes: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_wc_admin_note_actions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_wc_category_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_wc_customer_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_wc_download_log: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_wc_order_coupon_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_wc_order_product_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB. z1tPi_wc_order_stats: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.05MB + Μηχαν? InnoDB. z1tPi_wc_order_tax_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB. z1tPi_wc_product_attributes_lookup: Δεδομ?να: 0.11MB + Ευρετ?ρια: 0.14MB + Μηχαν? InnoDB. z1tPi_wc_product_download_directories: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_wc_product_meta_lookup: Δεδομ?να: 0.13MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB. z1tPi_wc_rate_limits: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_wc_reserved_stock: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_wc_tax_rate_classes: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_wc_webhooks: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_woodmart_wishlists: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_woodmart_wishlist_products: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB. z1tPi_wpmailsmtp_debug_events: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. z1tPi_wpmailsmtp_tasks_meta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB. ### Post Type Counts ### attachment: 1206 cms_block: 7 custom_css: 2 ml-slide: 3 ml-slider: 1 nav_menu_item: 277 oembed_cache: 9 page: 15 post: 1 product: 549 product_variation: 143 revision: 3 shop_coupon: 1 wpcf7_contact_form: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (18) ### All in One SEO: απ? τον/την All in One SEO Team – 4.3.1.1 Classic Widgets: απ? τον/την Συντελεστ?? WordPress – 0.3 Contact Form 7: απ? τον/την Takayuki Miyoshi – 5.7.3 Google Analytics for WordPress by MonsterInsights: απ? τον/την MonsterInsights – 8.12.1 WPBakery Page Builder: απ? τον/την Michael M - WPBakery.com – 6.10.0 Loco Translate: απ? τον/την Tim Whitlock – 2.6.3 Longer Permalinks: απ? τον/την Giannis Economou – 1.25 Regenerate Thumbnails: απ? τον/την Alex Mills (Viper007Bond) – 3.1.5 Slider Revolution: απ? τον/την ThemePunch – 6.6.10 Safe SVG: απ? τον/την 10up – 2.0.3 SiteGround Optimizer: απ? τον/την SiteGround – 7.3.1 SiteGround Security: απ? τον/την SiteGround – 1.4.1 Piraeus Bank WooCommerce Payment Gateway: απ? τον/την Papaki – 1.6.5.1 WooCommerce: απ? τον/την Automattic – 7.3.0 (ενημ?ρωση στην ?κδοση 7.4.0 ε?ναι διαθ?σιμη) Woodmart Core: απ? τον/την – 1.0.35 WP Crontrol: απ? τον/την John Blackbourn & crontributors – 1.15.1 WP Mail SMTP: απ? τον/την WPForms – 3.7.0 Smart Image Resize PRO: απ? τον/την Nabil Lemsieh – 1.7.8 ### Inactive Plugins (2) ### Advanced Database Cleaner PRO: απ? τον/την Younes JFR. – 3.2.2 Under Construction: απ? τον/την WebFactory Ltd – 3.97 ### Dropin Plugins (1) ### object-cache.php: Memcached ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) 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: – Enforce Approved Product Download Directories: – Order datastore: WC_Order_Data_Store_CPT ### WC Pages ### Β?ση καταστ?ματο?: #6 - /shop/ Καλ?θι: #7 - /cart/ Ταμε?ο: #8 - /checkout/ Ο λογαριασμ?? μου: #9 - /my-account/ ?ροι και Προ?ποθ?σει?: #2128 - /terms-of-use/ ### Theme ### Name: Woodmart Child Version: 1.0.0 Author URL: https://xtemos.com Child Theme: ? Parent Theme Name: Woodmart Parent Theme Version: 7.0.4 Parent Theme Author URL: https://themeforest.net/user/xtemos WooCommerce Support: ? ### Templates ### Overrides: woodmart/woocommerce/archive-product.php woodmart/woocommerce/cart/cart-item-data.php woodmart/woocommerce/cart/cart.php woodmart/woocommerce/cart/cross-sells.php woodmart/woocommerce/cart/mini-cart.php woodmart/woocommerce/checkout/form-checkout.php woodmart/woocommerce/checkout/thankyou.php woodmart/woocommerce/content-product-cat.php woodmart/woocommerce/content-product.php woodmart/woocommerce/content-single-product.php woodmart/woocommerce/content-widget-product.php woodmart/woocommerce/global/breadcrumb.php woodmart/woocommerce/global/form-login.php woodmart/woocommerce/global/quantity-input.php ?κδοση 4.0.0 ε?ναι ληγμ?νο. Η βασικ? ?κδοση ε?ναι η 7.2.0 woodmart/woocommerce/loop/add-to-cart.php woodmart/woocommerce/loop/loop-end.php woodmart/woocommerce/loop/loop-start.php woodmart/woocommerce/loop/no-products-found.php woodmart/woocommerce/loop/orderby.php woodmart/woocommerce/loop/pagination.php woodmart/woocommerce/loop/sale-flash.php woodmart/woocommerce/myaccount/form-login.php woodmart/woocommerce/product-searchform.php woodmart/woocommerce/single-product/add-to-cart/grouped.php woodmart/woocommerce/single-product/add-to-cart/variable.php woodmart/woocommerce/single-product/meta.php woodmart/woocommerce/single-product/product-attributes.php woodmart/woocommerce/single-product/product-image.php woodmart/woocommerce/single-product/product-thumbnails.php woodmart/woocommerce/single-product/rating.php woodmart/woocommerce/single-product/related.php woodmart/woocommerce/single-product/sale-flash.php woodmart/woocommerce/single-product/tabs/description.php woodmart/woocommerce/single-product/tabs/tabs.php woodmart/woocommerce/single-product/title.php woodmart/woocommerce/single-product/up-sells.php woodmart/woocommerce/single-product.php Outdated Templates: ? Μ?θετε πω? να κ?νετε ενημ?ρωση ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ? Next scheduled: 2023-02-28 09:48:56 +02:00 Options: ? Notes: 23 Onboarding: completed ### Action Scheduler ### Canceled: 1 Oldest: 2023-02-24 13:16:01 +0200 Newest: 2023-02-24 13:16:01 +0200 Complete: 334 Oldest: 2023-01-30 20:40:16 +0200 Newest: 2023-02-28 09:57:09 +0200 Pending: 4 Oldest: 2023-02-28 10:12:09 +0200 Newest: 2023-03-10 05:00:44 +0200 ### Status report information ### Generated at: 2023-02-28 10:09:29 +02:00 `
For the errors, I am leaving you one I can see below:
2023-02-28T08:04:04+00:00 CRITICAL Uncaught Error: Call to a member function get() on null in /home/customer/www/home-electric.gr/public_html/wp-content/themes/woodmart-child/functions.php:118 Stack trace: #0 /home/customer/www/home-electric.gr/public_html/wp-includes/class-wp-hook.php(308): enable_offline_payment_gateway_for_local_pickups(Array) #1 /home/customer/www/home-electric.gr/public_html/wp-includes/plugin.php(205): WP_Hook->apply_filters(Array, Array) #2 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/includes/class-wc-payment-gateways.php(163): apply_filters('woocommerce_ava...', Array) #3 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/src/Admin/Features/OnboardingTasks/Tasks/Payments.php(93): WC_Payment_Gateways->get_available_payment_gateways() #4 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/src/Admin/Features/OnboardingTasks/Tasks/Payments.php(71): Automattic\WooCommerce\Admin\Features\OnboardingTasks\Tasks\Payments::has_gateways() #5 μ?σα στο /home/customer/www/home-electric.gr/public_html/wp-content/themes/woodmart-child/functions.php στην γραμμ? 118
I do not believe that the issue is being occurred from the above error. I have tried to remove those lines from my functions.php file to see if the issue will go away but with no luck.
Thanks in advance,
George.
Hello @ihereira,
Any updates on my issue? It’s been a while since I left you my system report here.
Please let me know.
Thanks in advance,
George.
Hi @toulip
Sorry for the delayed reply and thanks for sharing the requested information above.
I still cannot see the attributes’ filters on the shop archive when the option “Use the product attributes lookup table for catalog filtering.” is enabled from the woo products advanced settings.
Going back to your original inquiry here, I would be happy to assist you, but I am not quite sure I understand your inquiry. Could you please provide additional details or clarify your question, so I can better assist you?
If a screenshot would be helpful, I’d recommend using https://snipboard.io or https://skitch.com/. You can share the direct link to the image as a response to this topic.
Hi George
We haven’t heard back from you in a while, so I’m going to mark this as resolved – feel free to create a new topic should you need any further help.
Cheers!
- The topic ‘Product attributes lookup table’ is closed to new replies.