If your rule builder filter returns zero results, it usually means that the conditions are too strict, conflicting, or don’t match the actual data in Magento.
1. Check attribute values in Magento
Make sure the attribute you’re filtering on actually has matching values in Magento.
Example: If you filter “Brand = Nike” but in Magento the brand is stored as “NIKE” or “Nike®”, the filter will not match unless it’s an exact match (case-insensitive, but spelling and symbols matter).
2. Verify condition type
Using the wrong condition type can exclude results.
Example: “Equals” requires an exact match, while “Contains” searches for partial matches.
For multiple values, use IN rather than multiple equals filters to avoid conflicts.
3. Avoid conflicting filters
If you combine multiple filters with AND, all must be true for an item to appear.
Example:
Status = Enabled AND Status = Disabled → This will always return zero results.
4. Check category and visibility logic
Filtering by category requires exact matches to Magento’s assigned categories.
Visibility filters must match how the product is set (e.g., “Catalog, Search” is not the same as “Search only”).
5. Review store scope
If you are targeting a specific store view, make sure the attribute values exist in that store view.
Sometimes values are only set at the global level or in another store view.
6. Use the real-time preview
The rule builder preview updates instantly. If you see “0 results,” loosen your filters and gradually add conditions until you isolate the cause.
Tip: If you’re still stuck, try building the rule in reverse — start broad (one filter) and add more filters one by one until the results disappear. That tells you which filter is the problem.