Rebrand 2023 Learn more 

  • Products/
    Products in Commerce Manager/
    Filtering Products

    Filtering Products

    You can filter your products. The filter options that are available depend on the attribute you have chosen to filter your products on.

    Filter Characteristics

    Filters in Commerce Manager have the following characteristics.

    • You can configure more than one filter at a time. For example, you may want to find all products whose name start with T-Shirt and whose SKU is like 287. A chain of filters must not exceed 10 filters.

    • Filters must not exceed 8KB. This is equal to approximately, for example, 200 IDs when using a list filter.

      filter restriction

    • Filtering in Commerce Manager is case-sensitive.

    • Filters do not work with attributes that contain commas. For example, filtering on this product name does not return any products:

      attribute with comma

    List Filter Characteristics

    The list filter has the following characteristics.

    • You cannot apply other filters with a list filter. The following error message is displayed:

      list filter error

    • When providing a list, you can separate the items in the list.

      • (default) Spaces
      • Line breaks
      • Comma separated
      • View as tags

      The separator you choose depends on your requirements. For example, when using the list filter for product name in the following scenario:

      • Product names contain spaces.
      • There is more than one product with the same name.

      you should use Comma separated instead of Spaces.

      list filter separator example

    Filter query parameters are available in the URL. Bookmark your filter URL to automatically activate that filter without having to reapply the filter each time.

    Supported Characters

    The following table describes the supported characters that can be used in filters.

    CharactersCan be used in filter?
    A-Z (upper & lower case)Yes
    0-9Yes
    $ - _ * .Yes
    " " (space)Yes (a+ is also treated as a space).

    Supported Date Formats

    If you need to specify a date, specify the date in YYYY-MM-DD format, for example 2022-04-27. You can also specify the date as an integer number of milliseconds since 1970-01-01 00:00:00. This is also known as UNIX time. For example, 640912546584.

    Filter Options

    The following table describes the filter options available for each attribute.

    AttributeFilterDescription
    ID
    • is
    • list
    • For is, type the value you want. You can use supported characters.
    • For list, specify a list of IDs. Only the products whose IDs you have specified are shown.
    Name
    • starts with
    • is
    • is like
    • ends with
    • list
    • For starts with, is, is like, and ends with, type the value you want. You can use supported characters.
    • For list, specify a list of names. Only the products whose names you have specified are shown.
    SKU
    • starts with
    • is
    • is like
    • ends with
    • list
    • For starts with, is, is like, and ends with, type the value you want. You can use supported characters.
    • For list, specify a list of SKUs. Only the products whose SKUs you have specified are shown.
    Description
    • starts with
    • is
    • is like
    • ends with
    Type the value that you want. You can use supported characters.
    Slug
    • starts with
    • is
    • is like
    • ends with
    • list
    • For starts with, is, is like, and ends with, type the value you want. You can use supported characters.
    • For list, specify a list of slug. Only the products whose slugs you have specified are shown.
    Commodity Type
    • Physical
    • Digital
    Select Physical or Digital to display a list of physical or digital products.
    UPC/EAN
    • starts with
    • is
    • is like
    • ends with
    • list
    • For starts with, is, is like, and ends with, type the value you want. You can use supported characters.
    • For list, specify a list of UPC/EANs. Only the products whose UPC/EANs you have specified are shown.
    MPN
    • starts with
    • is
    • is like
    • ends with
    • list
    • For starts with, is, is like, and ends with, type the value you want. You can use supported characters.
    • For list, specify a list of MPNs. Only the products whose MPNs you have specified are shown.
    Status
    • Live
    • Draft
    Select Live or Draft to display a list of live or draft products.

    Templates

    • is
    • list

    Use this filter to filter template attributes.

    1. Select a template from the list.
    2. In Attributes, select an attribute from the list. (Attributes with a date type are not displayed because Commerce Manager does not support filtering on template attributes with a date type.) The filter operators are displayed.
    3. Select is or list. The list filter option does not support integer, float, or boolean attributes, hence no filter operators are displayed for attributes of these types.
    4. Enter the values you want to search for.

    You can chain filters to search for more than one template attribute at a time.

    Owner
    • Organization
    • Store
    Select Organization or Store to display a list of organization or store products.
    Has Node AssignmentFalseUse this filter to find orphaned products. Products must be assigned to nodes to be included in a catalog.

    You cannot use this filter to show products that are assigned to nodes.

    Creating Filters

    The following steps describe how to create a filter.

    1. Click Products.

    2. Click Filters.

    3. From the list, select the attributes you want to filter your products on. The filter options are displayed. The options that display depend on the attributes you have selected.

    4. Configure your filter. See Filter Options.

    5. Once you have configured your filter, either:

      • Press Enter to automatically apply your filter.
      • Click Apply Filters.

      Commerce Manager displays the number of products that match your filter.

      Product Filtering

    6. Your filters are retained even when you navigate away from the filter results. You can remove your filters at any time by, either, removing an individual filter or, clicking Clear All.

    Was this helpful?

    Previous
    Searching for Products