Magento for B2B Commerce, 2.2.x
Export Criteria

Export filters are used to specify the data that you want to in the export file, based on attributeA characteristic or property of a product; anything that describes a product. Examples of product attributes include color, size, weight, and price. value. In addition, you can specify which attribute data you want to include or exclude from the export.


Export Criteria
Export Filters

You can use filters to determine which SKUs are included in the export file. For example, if you enter a value in the Country of Manufacture filter, the exported CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas. file will incude only products manufactured in that country.

The type of filter corresponds to the data type. For date fields, you can choose the date from the Calendar . To learn more, see: Attribute Input Types. The format of the date is determined by the locale.

To inlcude only records with a specific value, such as a sku, type the value into the Filter field. Some fields such as Price, Weight, and Set Product as New have a from/to range of values.

Exclude Attributes

The checkbox in the first column is used to exclude attributes from the export file. If an attribute is excluded, the associated column in the export data is included, but empty.

  • Export Criteria

    Exclude

    Filter

    Result

    No

    The exported file contains each attribute for all existing records.

    Yes

    The export file contains each attribute with only the records allowed by the filter.

    No

    The export file does not include the column for the excluded attribute, but does include all existing records.

    Yes

    The export file does not include the column for the excluded attribute, and contains only the records allowed by the filter.