How do I add a filter on a product attribute to Magento Advanced Export Profiles?

How do I add a filter on a product attribute to Magento Advanced Export Profiles?

August 16, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How do I add a filter on a product attribute to Magento Advanced Export Profiles?

Filtering Magento Products for Export: A Comprehensive Guide

Exporting your Magento product data is an essential part of managing your inventory. However, sometimes you might need to filter this data based on specific attributes before saving it as a CSV file. In this guide, we’ll walk you through the process of adding a filter to your export profile for a custom attribute like “Manufacturer”.

Understanding the Current Approach

Let’s first analyze the provided code snippet:

<action type="catalog/convert_adapter_product" method="load">
    <var name="store"><![CDATA[0]]></var>
    <var name="filter/manufacturer"><![CDATA[898]]></var>
</action>

At first glance, it seems like the right approach. The catalog/convert_adapter_product action is used to load products based on a filter. However, the issue lies in how the filter is applied.

The Problem with the Current Filter Syntax

The current syntax for applying a filter (<var name="filter/manufacturer">) isn’t recognized by Magento’s default filters. Magento expects a specific format for attribute filtering during data exports.

The Correct Way to Apply Filters

To correctly apply a filter to your product export, you need to use the dataflow/convert_filter action in conjunction with the catalog/convert_adapter_product action:

<action type="catalog/convert_adapter_product" method="load">
    <var name="store"><![CDATA[0]]></var>
</action>

<action type="dataflow/convert_filter" method="addFilter">
    <filter name="manufacturer_id" condition="eq" value="898"/>
</action>

In this corrected version:

  • We first load all products from the specified store.
  • Then, we add a filter for the “Manufacturer ID”. Note that Magento uses the ID of the manufacturer attribute during filtering.

Applying Multiple Filters

You can apply multiple filters by adding more <filter> nodes:

<action type="dataflow/convert_filter" method="addFilter">
    <filter name="manufacturer_id" condition="eq" value="898"/>
    <filter name="visibility" condition="in" value="2,3"/>
</action>

In this example, we’re filtering for products with a manufacturer ID of 898 and visibility set to either “Catalog Only” or “Search Results Only”.

Conclusion

Adding filters to your Magento product exports is a powerful way to manage your data. However, it requires understanding the specific syntax that Magento expects.

Remember:

  • Use the catalog/convert_adapter_product action to load products.
  • Use the dataflow/convert_filter action to add filters based on the attribute’s ID or name.
  • You can apply multiple filters by adding more <filter> nodes with the desired conditions and values.

For a more in-depth look at Magento data exports and customizations, I recommend checking out our series on Magento Data Management. It provides detailed guides on handling product data, including advanced export profiles and custom attribute filtering.

Catalog Pricing Import/Export Errors

Our network