Product Filters

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

To create a new product filter, take the following steps:

  1. Go to Catalog → Advanced Product Feeds → Manage Filters. Press the button Add Filter.
  2. Set the filter Name.
  3. Select the 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 conditions you require.
  5. Select an 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 the Visibility conditions: Catalog or Catalog, Search if you have configurable products.
Otherwise, simple Associated Products, which contain the status Not Visible Individually, will not be included in the feed.

Product Filter Examples

  • Filter example for Simple products

    For example, you seek to export only Simple products from the Furniture category with a product Price that is 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 the if ANY rule. Add 2 conditions for the attribute Visibility:
      • Visibility is Catalog
      • Visibility is Catalog, Search

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

    Continue setting up the main conditions:

    • Set Price greater than 50
    • Set Stock availability is In Stock
    • Select Category attribute and set the condition to 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 the Cell Phones and Cameras categories.
    The product Name contains the word ecco and the product quantity is equal to 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 the condition to 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 the following condition to your filter:

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

    Add the following condition to your filter:

    Is Salable is Yes