How to create filters
Filtering plays a crucial role in creating accurate and optimized product feeds. This ensures your feed contains only relevant and available products.
Creating a filter
Follow these steps to set up a new product filter:
1. Navigate to filters
Go to Catalog -> Advanced Product Feeds -> Manage filters and click Add filter.
2. Name your filter
Enter a clear and descriptive name for your filter.
3. Select feeds
Choose the feeds to which this filter will apply. Alternatively, you can apply filters directly when editing a feed.
4. Set filter rules
In the Rules tab, define the conditions your products must meet to be included in the feed:
- Select an attribute from the list and apply filter conditions.
- Use ALL or ANY rules to combine conditions.
- Choose TRUE or FALSE as needed.
Avoid filtering by Visibility: Catalog or Catalog, Search if you have configurable products. Otherwise, simple associated products (which are "Not Visible Individually") may be excluded from the feed.
Examples of product filters
Filtering simple products for feed export
If you need to export only Simple products from the Furniture category with a price greater than 50 and in stock, follow these steps:
-
Step 1: Set basic filters
- Set Product type to Simple product.
- Set Status to Enabled (optional).
-
Step 2: Set visibility conditions
To exclude associated products of configurable products, add a Conditions combination:
- Set If ANY rule is met.
- Add 2 Visibility conditions:
- Visibility is Catalog
- Visibility is Catalog, Search
Without these conditions, the feed may include products that are Not Visible Individually, such as child products of configurable products.
-
Step 3: Add price and stock conditions
- Set Price greater than 50.
- Set Stock availability is in stock.
-
Step 4: Filter by category
- Select the Category attribute.
- Set the condition to is one of.
- Click the Chooser icon to open the category tree.
- Tick the Furniture category (and subcategories if needed).
- The system will automatically insert the category IDs.
With these conditions, your feed will include only Simple Products from the Furniture category that are in stock and priced above 50, ensuring a refined product export.
Filter for simple and configurable products
If you need to export simple and configurable products while excluding items from the cell phones and cameras categories, follow these steps:
Step 1: Set product type
- Product type -> is one of -> simple product, configurable product
Step 2: Set conditions
- Status -> Enabled (optional)
- Name -> contains -> ecco
- Stock availability -> is in stock
- Quantity -> greater than or equal to 10
Step 3: Exclude categories
- Category -> is not one of
- Click the Chooser icon to open the category tree.
- Tick cell phones and cameras categories (including subcategories).
- The category IDs will be added automatically.
Final result
With these filters, the feed will include only simple and configurable products that:
- Are in stock.
- Have ecco in the name.
- Have 10 or more in quantity.
- Are not from the cell phones or cameras categories.
This setup ensures that only relevant products are exported while filtering out unwanted items.
Additional filtering options
Exclude products without a base image
- Add the condition: Base image is not ...
Exclude child products if their configurable parent is not active or out of stock
- Add the condition: is salable is yes