{"id":14250,"date":"2025-09-29T16:25:12","date_gmt":"2025-09-29T13:25:12","guid":{"rendered":"https:\/\/creativethemes.com\/blocksy\/?post_type=documentation&p=14250"},"modified":"2025-09-30T17:55:26","modified_gmt":"2025-09-30T14:55:26","slug":"regenerating-product-lookup-tables","status":"publish","type":"documentation","link":"https:\/\/creativethemes.com\/blocksy\/docs\/troubleshooting\/regenerating-product-lookup-tables\/","title":{"rendered":"Regenerating Product Lookup Tables"},"content":{"rendered":"\n
\"\"
“Please wait until the Woo Commerce product taxonomies lookup table is regenerated” message.<\/figcaption><\/figure>\n\n\n\n

WooCommerce product lookup tables are designed to speed up how product data is queried and displayed. They store product details in a special structure that\u2019s optimised for filtering and searching, reducing the load on your database whenever a product query is performed.<\/p>\n\n\n\n

Our Product Taxonomy Lookup Tables<\/strong> extend this functionality in Blocksy by improving how taxonomy-based queries work – for example, when using our Product Filters module<\/a><\/strong>. These tables make filtering operations almost instant, creating a smooth browsing experience for your visitors.<\/p>\n\n\n\n

Sometimes, however, the taxonomy lookup tables might not be generated correctly, or may fail to generate at all. When this happens, you may encounter messages like \u201cPlease wait until the WooCommerce table is regenerated.\u201d<\/em><\/p>\n\n\n\n

Common Symptoms<\/h2>\n\n\n\n

You may need to regenerate your lookup tables if you notice issues such as:<\/p>\n\n\n\n

    \n
  • Filters not returning the expected results.<\/li>\n\n\n\n
  • Products missing from filtered views.<\/li>\n\n\n\n
  • The \u201cRegenerating Taxonomies Data\u201d notice appearing in place of product filters.<\/li>\n<\/ul>\n\n\n\n

    If you\u2019re experiencing any of these, regenerating the lookup tables is the first thing to try.<\/p>\n\n\n\n

    Regenerating Product Lookup Tables<\/h2>\n\n\n\n

    The good news is that regenerating these tables is straightforward. WooCommerce provides a set of tools that make this process quick and easy:<\/p>\n\n\n\n

      \n
    1. Go to your WordPress Dashboard<\/strong>.<\/li>\n\n\n\n
    2. Navigate to WooCommerce \u2192 Status \u2192 Tools<\/strong>.<\/li>\n\n\n\n
    3. Scroll down until you see Regenerate the product taxonomies lookup table<\/strong>.<\/li>\n\n\n\n
    4. Click the Regenerate<\/strong> button.<\/li>\n<\/ol>\n\n\n\n

      That\u2019s it – the process will begin automatically.<\/p>\n\n\n\n

      \u26a0\ufe0f Important:<\/strong> Do not refresh the page while regeneration is running. The process is triggered by a URL parameter, and refreshing will restart it from the beginning. If you need to refresh, click the Tools<\/strong> tab again instead.<\/p>\n\n\n\n

      Checking for Errors<\/h2>\n\n\n\n

      If you suspect an issue with the taxonomies lookup table<\/strong>, head to the Logs<\/strong> tab in the same area. Look for the taxonomies_lookup_table<\/code> log – it will show whether any errors occurred. This information can be very useful if you need to contact our support team.<\/p>\n","protected":false},"excerpt":{"rendered":"

      WooCommerce product lookup tables are designed to speed up how product data is queried and displayed. They store product details in a special structure that\u2019s optimised for filtering and searching, reducing the load on your database whenever a product query is performed. Our Product Taxonomy Lookup Tables extend this functionality in Blocksy by improving how taxonomy-based queries […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_categories":[119],"class_list":["post-14250","documentation","type-documentation","status-publish","hentry","doc_categories-troubleshooting"],"blocksy_meta":{"header_scripts":"","styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"acf":[],"_links":{"self":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/documentation\/14250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/types\/documentation"}],"author":[{"embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/comments?post=14250"}],"version-history":[{"count":15,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/documentation\/14250\/revisions"}],"predecessor-version":[{"id":14268,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/documentation\/14250\/revisions\/14268"}],"wp:attachment":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/media?parent=14250"}],"wp:term":[{"taxonomy":"doc_categories","embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/doc_categories?post=14250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}