Skip to main content

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.
Note

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
note

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