Articles on: Shopify

Incoming Feed Filter

Filter (Step 3) is an optional settings only on Update & Add products feed only. It will help to filter specific products or data on the feed data.


To use this filter, there are a few guidelines:


  1. Column name/index can only be defined once.
  2. Filter multiple keywords with commas as separators.
  3. Must match ALL of the filters below.


Below are a few examples given:



Field Name

Condition

Value

Result Showing

producttype

Equal To

clothes

When column name producttype, and don't update/add clothes

vendor

Not Equal To

Adidas

When the column name vendor, and don't update/add Adidas

producttype

Contain

<blank>

To include blank values for product type, use this method.

5

Not Equal To

shoes

When a column name 5, and don't update/add shoes

4

Not Equal To

Tag A

When a column name 4, and don't update/add Tag A

date

Contain

%Y_%m_%d

When you want to use dynamic dates to update/add the products. Select the condition as Contain

price

Greater Than

50

When you want to update/add products that price greater than 50

date

Contain

2025-05

To include 2025-05 for certain month date, use this method.

description

Start With

comp*

When want to match the starting value "comp" which is from this example comp, complete, and computer. All words that begin with "comp" will be included in the process.

description

End With

*less

When want to match the ending value "less" which is from this example 123less , 234less, and sleeveless. All words that end with "less" will be included in the process.

description

Contain

*un*

When want to match any of the character values "un" which is from this example, sunny, tuned, bunny, and guns. All words that contain "un" will be part of the process.

description

Not Equal To

*

Exclude products that have empty value or blank. This is because of * is for filtering all description in this case need to use Not Equal To condition to filter out the blank value

3

Between

6~12

If the inventory's column mapping relies on an index, and a row has a value of 10 within the range of 6 to 12 , only that specific value will be imported or updated within that range.

description

Not Contain

man

When want to unmatch any of the characters values "man" which is from this example, man, manual, mango, and manager . Any words containing "man" will be excluded from the process.


Another example of multiple values to filter can refer below:


Field Name

Condition

Value

Result Showing

Vendor

Equal To

Adibas, Niqe, Baha

When column name Vendor, and want to update/add Adibas, Niqe, and Baha

Tag

Not Equal To

New-add, Old, ABC

When column name Tag, and don't update/add New-add, Old, and ABC

Product Type

Equal To

Clothes, Shoe, Dress

When column name Product Type, and want to update/add Clothes, Shoe, and Dress


2. Include empty row (✔️ Add)


By enabling this toggle icon, This option is only applicable when the filter is applied. It can be used for the product with an empty column cell for each row, but the image is available in another row. Learn more here



3. Skip product(s) with zero quantity (✔️ Add)


When you activate this toggle icon, products with zero quantity in the feed will be skipped during the process.

However, please ensure that all variants with zero quantity are identified. If even one variant has quantity, the product cannot be skipped being add or export or update.


To enable this feature, please map the Available Quantity on Step 2: Matching Column


Product A - Variant Red : 10 qty, Variant Yellow: 0 qtyIt will still import


Product B - Variant Red : 0 qty, Variant Yellow: 0 qtyIt will NOT import


Updated on: 11/07/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!