How can I filter PIM products I want to import?

#Filter scope

The filter configuration described below is valid for all your Websites and Store Views.

Unfortunately, with the current version of the Akeneo Connector for Magento 2, there are currently no possibilities to configure multiple filters at the same time according to your Websites or Store Views.

#Filter products: 2 modes

In the connector configuration page, in Filter products, you can choose between a Standard or an Advanced filter to retrieve your PIM products:

Connector parameter Connector information
Mode "Standard" or "Advanced"

#"Standard" mode

With this Standard mode, you can filter on:

  • Channel
  • Completeness
  • Product status (enabled or disabled)

You will also be able to:

  • Import only updated products
  • Select PIM families you don't want to retrieve products from.

If you want to have more filter possibilities, you will need to switch to Advanced mode.

#How to filter products on a specific PIM channel?

In the connector configuration page, in Filter products, you can filter your PIM products on a specific PIM channel:

Connector parameter PIM information
Channel PIM Channel ID

#How to filter on PIM completeness?

In the connector configuration page, in Filter products, you can filter your PIM products on completeness:

First, select the condition:

Connector parameter PIM information
Completeness type No condition
Lower than
Lower or equals than
Greater than
Greater or equals than
Equals
Differ
Greater than all locales
Greater or equals than all locales
Lower than all locales
Lower or equals than all locales

Then, fill the required percentage of completeness:

Connector parameter PIM information
Completeness value Percentage of completeness
Has to be a value between 0 and 100

#How to filter on PIM product status?

In the connector configuration page, in Filter products, you can filter on your PIM products status:

Connector parameter PIM information
Status No condition or Enable or Disable

#How to import only updated products?

In the connector configuration page, in Filter products, you can import only updated PIM products since last X days, between two dates, before a date or after a specific date:

First, select what you need:

Connector parameter PIM information
Updated mode Lower than
Greater than
Between
Since last X days

By selecting an "Updated mode", you will have to fill in the corresponding parameter above:

Lower than

Connector parameter PIM information
Updated before Desired date

Greater than

Connector parameter PIM information
Updated after Desired date

Between

Connector parameter PIM information
Updated before Desired date
Connector parameter PIM information
Updated after Desired date

Since last **X** days

Connector parameter PIM information
Updated Number of days

#How to select PIM families you don't want to retrieve products from?

In the connector configuration page, in Filter products, you can select PIM families you don't want to retrieve products from:

Connector parameter PIM information
Families Select PIM families you don't want to retrieve products from.

#"Advanced" mode

Please note any setting previously defined with the standard filtering mode will be overwritten if you switch to the advanced configuration.

In the connector configuration page, in Filter products, you can define your own filter with the following parameter:

Connector parameter PIM information
Advanced filter PIM API JSON filter

This field must be written in JSON format.

To know all the filtering possibilities and the JSON syntax, please refer to our API documentation on filtering possibilities.

For example, the below filter enables to import only products with Enable status, with a SKU which starts with A letter and only retrieve ecommerce scopable attribute content and on fr_FR/de_DE locales:


        {
            "search": {
                "enabled": [{
                    "operator": "=",
                    "value": true
                }],
                "sku": [{
                    "operator": "STARTS WITH",
                    "value": "A"
                }]
            },
            "scope": "ecommerce",
            "locales": "fr_FR,de_DE"
        }