Incoming Feed Filter

Modified on Tue, 10 Oct, 2023 at 12:38 PM

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

To use this filter, there are a few guidelines:

Column name/index can only be defined once.
Filter multiple keywords with commas as separators.
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 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
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	Contain	*	To exclude the rows with empty values, you can select the condition contain and put 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