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.

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 conditions

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

  • sku

  • name

  • quantity

  • brand

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Last updated