Articles on: Shopify

Store Product Filter

Filter (Step 3) is an optional setting on the Update products feed only. It filters specific products or data on the store products. This does not support wildcard.

For the Store Product filter, the field name is provided. There are a few types of setup lists. Below are the examples:

To use a single value containing commas, like "Animal - Dog, Cat, Cow", enclose it in double quotes. See the image below

When there are two conditions, the phrase "is in" has a higher priority than "is not in". To determine which condition is more important, let's consider two scenarios.First Scenario: Two field with different filter

Scenario 2: Single field with "Is in" and "Is not in" filters

1. Vendor Filter

To include the filter, you need to select Is in. Basically, this will include the vendor filter from your store. This will optimize your search in your Shopify store.

For example:

(a) To add a single vendor (Vendora)

(b) To add multiple vendors (Vendora, Colo)

(d) To add combination vendor (Colo, ABC, Ltd) - Colo, "ABC, Ltd"

To exclude the filter, you need to select Not Equal to. In other words, it is the reverse of the include.

For example: If you have 10 vendors and you want to include 9 vendors. Instead of doing that, you could easily exclude just 1 of them which is much simpler. The way to use it is similar to include as well.

2. Tags Filer

This will include/exclude the tags for certain products containing these keywords or tags from your store. It also supports multiple comma-separated values.

For example: If you want to include the contain of the ABC tag, any other tags containing this keyword will also be included.

3. Product Type Filter

This will include/exclude the Product type filter from your store. The usage is the same as the Vendor Filter.

4. Product Title Filter

This will include/exclude the Product title filter from your store.

5. Collection Filter

This will enable the Collection filter from your store. It is a drop-down field, these options are retrieved from the current Collection that exists in your Shopify store.

6. Published Filter

This will enable the Published filter from your store. It is a drop-down field, this option is available as Any( ALL), Published or Unpublished.

7. SKU Filter

This is a more specific filter that includes or excludes any SKU that you input in the field. Separated by a comma supports multiple values.

For example:

To include the SKU with starting letter ABC. For example, ABC-123, ABC134, ABC145, ABC-765 can use as ABC*

To include the SKU contain with ABC. For example, ABC123, 456ABC, 123ABC456 can use as *ABC*It will take any SKUs that contain ABC letter.

To include blank SKU from the store, use <blank>. This applies to any SKU field that is blank. If the product identifier is mapped as "barcode" or any other identifier instead of SKU, you can filter the blank SKUs.

8. Product Category Filter

This will enable the Product Category filter from your store. It is a drop-down field, these options are retrieved from the Shopify Category.

9. Available Quantity Filter

This includes or excludes products with a specific quantity from your store, based on the location ID set in Step 2: Matching Column > Available Quantity > Smart Settings > Location.

10. Enable Track Inventory in filter

When the filtering process begins you can enable this option to ignore variants in store with Track Inventory.

11. Enable Inventory Quantity

By enabling this toggle icon, when the filtering process begins it will ignore variants with zero quantity in the store.

12. Enable Ignore variants with quantity (✔️ Update)

By enabling this toggle icon, when the filtering process begins it will update variants with zero quantity in the store.

Updated on: 01/07/2025

Was this article helpful?

Thank you!