Rebuild the supporting tables (wp ssf rebuild)
Super Speedy Filters keeps an optimised “object ancestors” table that powers all the filtering and counts. It maintains itself automatically, but it can drift out of sync – and it needs rebuilding on purpose in these cases:
- You renamed term slugs (product categories, brands, colours, etc.).
- You renamed a taxonomy qualifier (e.g. the
/brand/in/brand/adidas/). - You ran an import with do_action calls switched off.
- You bulk-updated products via SQL, duplicated products, or migrated the site.
- Counts are wrong, or a new term/product isn’t appearing.
The best way is the WP-CLI command (run it anywhere inside your WordPress folder):
wp ssf rebuild
Use the CLI rather than the Advanced-tab button wherever you can – many hosts kill the long-running build query when it’s triggered from wp-admin, whereas the CLI runs it cleanly. The command returns quickly and finishes in the background. If a build is already stuck, wp ssf rebuild cancels and restarts it; add --force to make it wait for the stuck query to roll back first. To clear the fragment cache from the command line (version 6.18+) use wp ssf clear-cache. Always flush your object cache afterwards, especially if the “building object ancestors table” notice persists. On a local copy where wp-cron is disabled the build may never run on its own – use the CLI.
Still stuck? Post a screenshot on our Discord.
Comments