Another tool that will give you great flexibility and control over your data is filtering. By using this function, you can easily filter out products you wish to include or exclude in your exports, setup uniqueness filters or split big chunks of data.
To start go to your export overview and select ‘filtering’.
There are three different ways of using filtering:
- Basic product filtering
- Uniqueness filtering
- Subset filtering
Basic product filtering is a way of excluding products that you do not want to include in your export feed. Let’s say there is a certain product or set of products you want to exclude or include based on their IDs. The process is very simple. Add a filter, set the condition and save the filter. This way the feed no longer contains any of the products matching the ID. In the following example we have used the “in list” function – this allows you to exclude more than one product at a time. If you only want to exclude one product, simply use “equal” instead.
Uniqueness filtering is a way of ensuring that all your products in the export are unique, avoiding any duplicates. To do so, simply select uniqueness filtering and choose which field should be unique (typically ID, EAN or similar value).
Subset filtering is our brand-new feature, which allows you to create multiple “copies” of a feed but separated on a given value.
Let’s say you have one import that contains 10.000 products spread out on 200 different manufacturers and you want a product feed for each individual manufacturer. Select Subset filtering and choose which value should “split” the feed. In our example we will use Brand information, but you can choose any other value such as ID, Manufacturer SKU etc.
Select Brand and activate the subset filtering. Define the subset filters. Choose the brand you wish to split and write it in the filter value field. Furthermore, in the comment field write any necessary comments – this will only be visible for you. Lastly, add a value that will differentiate the URL of the products, usually the same brand or another way of identifying each set of products.
Save subset filtering and continue with the next brand.
After activating subfiltering you add the values you want to split on. The URL identifier is what will be visible in the feed URL
As you are saving your different subfilters they will appear in a list, as shown below. By clicking the URL button you open the feed in a new browser tab.
Depending on the complexity of the filtering, this can either be very fast or take a while. Therefore, the cost will depend on what you want to do. Simple filtering will typically take a max. of 30 minutes, while subset filtering is usually more time consuming.