Incoming Feed Filter

Modified on Thu, 27 Apr 2023 at 04:40 PM


Filter (Step 3) is an optional settings only on Update & Add products feed only. It is to filter the 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. Support wildcard. eg, PRE*, *DO, *MIDDLE*
  4. 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


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 want to use dynamic dates to update/add the products. Select the condition as Contain


price

Greater Than

50


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

description

Start With

comp


When want to match the starting value "comp" which is from this example "comp", "complete", and "computer"

description

End With

less


When want to match the ending value "less" which is from this example "123less", "234less", and "sleeveless"

description

Contain

un


When want to match any of the character values "un" which is from this example "sunny", "tuned", "bunny", and "guns" 

description

Contain

*


When one of the cells has an empty value, the incoming feed filter does not allow it to exclude. When want to exclude it, you can select the condition contain and put value *



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






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article