# 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-f71e7f8bfcb19b800b1963a862bd1fe066805f7d%2Ffilters.png?alt=media" alt=""><figcaption><p>Add filter button in the Filters section</p></figcaption></figure>

### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-3d322dbacaa3fd733e6c82867c7ded43f62ad9b3%2Ffeed%20data.png?alt=media" alt=""><figcaption><p>Filtering by feed data</p></figcaption></figure>

**Filtering conditions**

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

* sku
* name
* quantity
* brand

<table data-full-width="false"><thead><tr><th>sku</th><th width="178">name</th><th>quantity</th><th>brand</th></tr></thead><tbody><tr><td>XYZ001</td><td>T-shirt</td><td>25</td><td>SPORTWEAR</td></tr><tr><td>XYZ002</td><td>T-shirt</td><td>0</td><td>SPORTWEAR</td></tr><tr><td>XYZ003</td><td>T-shirt</td><td>25</td><td>FITCLOTHES</td></tr><tr><td>XYZ004</td><td>T-shirt</td><td>25</td><td>FINECLAD</td></tr><tr><td>XYZ005</td><td>Leggings</td><td>25</td><td>SPORTWEAR</td></tr><tr><td>XYZ006</td><td>Leggings</td><td>25</td><td>SPORTWEAR</td></tr><tr><td>XYZ007</td><td>Leggings</td><td>0</td><td>FITCLOTHES</td></tr><tr><td>XYZ008</td><td>Leggings</td><td>25</td><td>FINECLAD</td></tr></tbody></table>

#### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-471f8db16ef45a7c0ddf6ae84c934974948d93cc%2Fiscondition.jpg?alt=media" alt=""><figcaption><p>Setting filter to import only those items where brand equals SPORTWEAR</p></figcaption></figure>

#### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-a9143e1fdeadb1b16f65b5858ca712fe9b6b36ae%2Fisnotcond.png?alt=media" alt=""><figcaption><p>Setting filter to import only those items where brand is not equal to SPORTWEAR</p></figcaption></figure>

#### 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*.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-1febe42f52c67437d87c643a18552fe1b5114746%2Fcontains.png?alt=media" alt=""><figcaption><p>Setting filter to import items where brand is SPORTWEAR or FINECLAD</p></figcaption></figure>

#### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-55d62b252bf37e58c07128eab6bb37ce04951232%2Fdoesnt%20contain.png?alt=media" alt=""><figcaption><p>Setting filter to import items where brand is not SPORTWEAR and FINECLAD</p></figcaption></figure>

#### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-ed5bcff971f014e2fa312c14967482d2e76cc185%2Fgreaterthan.png?alt=media" alt=""><figcaption><p>Setting filter to import items where quantity is greater than 0</p></figcaption></figure>

#### 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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-93e30b40cddd498c7b8f41f43316195a0f25245d%2Fandcondition.jpg?alt=media" alt=""><figcaption><p>Setting filter to import items where brand equals FITCLOTHES and quantity is greater than 0</p></figcaption></figure>

###

### 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.

{% hint style="info" %}
To filter by product tags, items in the store must have specified tags.
{% endhint %}

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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-ddd6b1233ff636b14142ff810d3ca7cd6706452c%2Fproduct%20tags.jpg?alt=media" alt=""><figcaption><p>Filtering by product tag</p></figcaption></figure>

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.

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-d42788910e691f2809eb239bcc00c6770fa20b6e%2Fdontcontain.png?alt=media" alt=""><figcaption><p>Filtering items that don't have the FITCLOTHES tag</p></figcaption></figure>

### 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.

{% hint style="info" %}
To filter by vendor, items in the store must have specified vendors.
{% endhint %}

#### Example

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

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-9e65db3172edb2c4f6a2d202629cf3e2c938816e%2FVENDOR.png?alt=media" alt=""><figcaption><p>Setting filter to match items from FITCLOTHES-VENDOR</p></figcaption></figure>

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

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2Fgit-blob-7baa89d8c1433b29e21ef7bc788e12e7c7fecd19%2Fisnotvendor.png?alt=media" alt=""><figcaption><p>Setting filter to match all items except those from FITCLOTHES-VENDOR</p></figcaption></figure>
