Product Filters

Filtering is one of the most important parts of the feed creation process.
By using filters, you will not export products which have zero price or are out of stock, products without images, disabled products etc.

To create a new product filter follow these steps:

  1. Go to Catalog → Advanced Product Feeds → Manage Filters. Press button Add Filter.
  2. Set filter Name.
  3. Select feeds for which the filter will be applied. Also you can select applied filters on the feed edit page.
  4. At the Rules tab you can specify all required conditions.
  5. Select any attribute from the list and use the filter conditions. The extension allows you to set the conditions combination, using if ALL and if ANY, TRUE or FALSE rules.

Note

Do not set in the filter Visibility conditions: Catalog or Catalog, Search if you have configurable products.
Otherwise, simple Associated Products which have the status Not Visible Individually, will not be included into the feed.

Product Filter Examples

  • Filter example for Simple products

    For example, you want to export only Simple products from the Furniture category with a product Price greater than 50 and products that are available in the Stock:

    • Set Status is Enabled (not necessarily)
    • Set Product Type is Simple Product
    • Add a new Conditions Combination. Set if ANY rule. Add 2 conditions for attribute Visibility:
      • Visibility is Catalog
      • Visibility is Catalog, Search

    This condition allows you to include products which have the Visibility status: Catalog or Catalog, Search.
    If you don't set this condition combination, the feed will be generated also with products which have status: Not Visible Individually.
    Thus, Configurable Associated Products will not be included into the feed.

    Continue setting up main conditions:

    • Set Price greater than 50
    • Set Stock availability is In Stock
    • Select Category attribute and set condition is one of.
      Click the Chooser icon and you will see the store category tree.
      To include products from certain categories, tick the Furniture category and their subcategories from the list.
      Category ID's will be added automatically to the text line.
  • Filter example for Simple and Configurable products

    For example, you want to export Simple and Configurable products which are not from Cell Phones and Cameras categories.
    Product Name contains word ecco and product quantity equals or greater than 10:

    • Set Status is Enabled (not necessarily)
    • Set Name contains ecco
    • Set Stock availability is In Stock
    • Set Quantity equals or greater than 10
    • Select Category attribute and set condition is not one of.
      Click the Chooser icon and you will see the store category tree.
      To exclude products from certain categories, tick the Cell Phones and Cameras categories and subcategories from the list.
      Category ID's will be added to the text line automatically.
  • How to exclude products without Base images

    Add next condition to your filter:

    Base Image is not ...
  • How to exclude children products if their parent configurable product is not active or out of stock

    Add next condition to your filter:

    Is Salable is Yes