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 upper filter has a higher priority than lower filter. To determine which condition is more important, let's consider two scenarios.First Scenario: Two field with different filter


Scenario 2: Single field with "Matches" and "Doesn't matches" 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)


(c) To add vendor with a comma in the name (ABC, Ltd)


(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 matches/doesn't matches the Product type filter from your store. The usage is the same as the Vendor Filter.


4. Product Title Filter


This will matches/doesn't matches 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. Include variants with "Track Quantity".


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



11. Include variants where Available Quantity more than zero


Enabling this toggle includes only variants with a quantity greater than zero in the store when filtering.



12. Include variants where Available quantity less or equal to zero quantity (✔️ Update)


By enabling this toggle icon, when the filtering process begins it will include variants with less or equal to zero quantity in the store.



13. Include variants exist in selected location under Quantity field (✔️ Export)


By enabling this toggle icon, when the filtering process begins it will include variants exist in selected location under Quantity field.



Updated on: 09/10/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!