Filters

Setting filters allows filtering data based on whether it meets particular condition. You can add and configure new filters by clicking on the Add filter button in the Filters section. Available filtering options are filtering by vendor, feed data or product tag.

Add filter button in the Filters section

Feed Data

Filtering by feed data allows extracting only that data from the feed, where a feed field matches given condition.

To filter by feed data you need to select Feed Data in the Field dropdown.

Filtering by feed data

Filtering conditions

To showcase different filtering conditions, assume you're importing a CSV file with the following columns:

• sku

• name

• quantity

• brand

sku	name	quantity	brand
XYZ001	T-shirt	25	SPORTWEAR
XYZ002	T-shirt	0	SPORTWEAR
XYZ003	T-shirt	25	FITCLOTHES
XYZ004	T-shirt	25	FINECLAD
XYZ005	Leggings	25	SPORTWEAR
XYZ006	Leggings	25	SPORTWEAR
XYZ007	Leggings	0	FITCLOTHES
XYZ008	Leggings	25	FINECLAD

IS condition

Assume you want to import only those items where brand equals SPORTWEAR. To do that you need to specify column name of which data will be checked and choose the condition that the data must meet to be imported. In this case the according filtering condition is the is condition.

Setting filter to import only those items where brand equals SPORTWEAR

IS NOT condition

Now assume you want to import only those items where brand is not SPORTWEAR. To do that, you need to use the is not condition.

Setting filter to import only those items where brand is not equal to SPORTWEAR

CONTAINS condition

Another filtering condition is the contains condition. Assume you want to import all those items where brand is equal to either SPORTWEAR or FINECLAD. To set that filter, you need to choose the contains condition, and set the Value field to concrete column data values you accept, separated by commas. In this case the Value field is set to SPORTWEAR, FINECLAD.

Setting filter to import items where brand is SPORTWEAR or FINECLAD

DOESN'T CONTAIN condition

Now assume you want to import the items of all brands except SPORTWEAR and FINECLAD. To do that you need to choose the doesn't contain condition.

Setting filter to import items where brand is not SPORTWEAR and FINECLAD

GREATER THAN condition

Assume you want to import items where quantity is greater than 0. In that case you need to use the greater than condition.

Setting filter to import items where quantity is greater than 0

Joining conditions

If you want to filter by multiple conditions you can do that by adding multiple filters. Assume you want to import those items where brand is equal to FITCLOTHES and quantity is greater than 0.

Setting filter to import items where brand equals FITCLOTHES and quantity is greater than 0

Product Tag

Filtering by product tags is a solution for situations where products from different suppliers might have the same SKUs. Marking the items with a tag, and setting a filter by product tag secures the automation to modify correct items.

Filtering by product tags also allows for faster automation runs. When Stockeo runs the automation, it scans existing variants in the store. Adding filtering by product tag allows minimazing the amount of scanned items to those with a given tag, therefore shortening the duration of the automation.

To filter by product tags, items in the store must have specified tags.

When filtering by product tag, there are two filtering conditions available: contain and don't contain.

Example

Assume you want to update items marked with FITCLOTHES tag. To do that you need to choose the contain condition.

Filtering by product tag

If you want to filter by multiple tags, the contain condition is also applicable. You can set the Value field to multiple tags separated by commas. Automation will then scan only those variants that have either tag that was set in the Value field.

Using the don't contain condition will cause the automation to scan those variants that aren't marked with a given tag.

Filtering items that don't have the FITCLOTHES tag

Vendor

Filtering by vendor has a similar purpose as filtering by product tags, in a case when products from different vendors might have the same SKUs, setting the vendor for each item and then filtering by vendor secures the automation to modify correct items.

When filtering by vendor, available filtering options are is and is not conditions.

To filter by vendor, items in the store must have specified vendors.

Example

Assume you want to update those items where vendor is FITCLOTHES-VENDOR.

Setting filter to match items from FITCLOTHES-VENDOR

If you want to modify items for every vendor except FITCLOTHES-VENDOR you can use the is not condition.

Setting filter to match all items except those from FITCLOTHES-VENDOR