Filters
Last updated
Last updated
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.
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 conditions
To showcase different filtering conditions, assume you're importing a CSV file with the following columns:
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
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.
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.
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.
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.
Assume you want to import items where quantity is greater than 0. In that case you need to use the greater than condition.
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.
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.
Assume you want to update items marked with FITCLOTHES tag. To do that you need to choose the contain condition.
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 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.
Assume you want to update those items where vendor is FITCLOTHES-VENDOR.
If you want to modify items for every vendor except FITCLOTHES-VENDOR you can use the is not condition.
