In some cases, after importing products using third-party import tools (such as WP All Import, Product Import Export for WooCommerce, or custom API-based sync plugins), WooCommerce product filters and sorting may stop working correctly.
This issue can affect
- Sorting options such as Sort by popularity, Sort by average rating, Sort by latest, Sort by price: low to high, Sort by price: high to low
- Product filters such as Price filters, Category filters, Attribute filters (color, size, brand, etc.), Layered navigation widgets
Why This Happens
WooCommerce uses an internal database table called the product lookup table
wc_product_meta_lookup
to power product sorting, filtering, and layered navigation.
When products are imported via
- Third-party import plugins
- External APIs
- Custom synchronization scripts
This lookup table is not always regenerated automatically. As a result, WooCommerce continues to use outdated or incomplete lookup data, which causes filters and sorting options to behave incorrectly or return empty results.
How to Fix the Issue
All required actions can be completed from the same WooCommerce tools page.
Step 1: Regenerate Lookup Tables and Clear Transients
- Go to WooCommerce → Status
- Open the Tools tab
-
Perform the following actions in order
- Click Regenerate next to Product lookup tables
- Click Clear transients
- Click Clear expired transients
This process rebuilds WooCommerce’s internal indexing data and removes cached values that may contain outdated product information.
For stores with a large number of products, regeneration may take several minutes.
Step 2: Clear Cache and Verify
After completing the steps above:
- Clear any active caching plugin cache
- Clear server-side or CDN cache (if applicable)
- Clear your browser cache
Then reload your shop or category pages and verify that filters and sorting now work correctly.
Additional Notes
- This process does not modify or delete product data
- It is safe to run on live sites, though testing on staging is recommended for large catalogs
- If products are imported regularly via API or scheduled imports, this issue may reoccur and require periodic regeneration
