Creating and Applying Filters

 

Filters are tools to segment your catalog. Filters are built from conditions and they group all SKUs that are included under the conditions. 

For example:

If you’d like to group all items that are: made by ‘Brand A’, being sold by more than three competitors, and costs above $100. You will need three conditions:

  • Every item that Brand = Brand A
  • And Price is above $100
  • And It is being sold by more than 3 competitors

For example, if we create this filter for all Casio watches above $100, it will look as follows:

 You can create and access your saved filters from the ‘Filters’ menu on your WiseBoard.

You can always apply rules or perform actions to a specific group of items. All by using filters.

First you will need to click on the filter, to see only the filtered items.

  • Click on the ‘Actions’ menu
  • Select ‘Apply on Filtered Items’

 

- All actions will now be applied only to the filter in view.

Same logic applies to the ‘Reprice’ menu. When selecting ‘Reprice filtered items’ it will only reprice the items under the filter in view.

Important Note: All segmentations in WisePricer are designed to be treated as filters. For example, when you click on ‘Items eligible for Price Increase/Reduction’ you can use ‘Apply on Filtered items’ and every action you take will only apply to that group.

Another option is to create a filter that will group a predefined label. For example, you can group all 'Top Sellers Accessories.'

You can do that by using the Label field. Please follow this tutorial to understand how to segment by label.  

Here is a list of all the fields you can filter by:

Filter By Available Operators 
SKU Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Name Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Min. Price <, <=, >, >=, ≠, =
Stock <, <=, >, >=, ≠, =
NewPrice <, <=, >, >=, ≠, =
Brand Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Model Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
MPN Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
ASIN Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
UPC Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Cost <, <=, >, >=, ≠, =
Shipping Cost <, <=, >, >=, ≠, =
Label Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
# Comp. <, <=, >, >=, ≠, =
Current Margin % <, <=, >, >=, ≠, =
Current Margin Currency <, <=, >, >=, ≠, =
New Margin % <, <=, >, >=, ≠, =
New Margin Currency <, <=, >, >=, ≠, =
Import Date <, <=, >, >=, ≠, = (a selected calendar date)
Rule Name Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Competitor Name Equal, Does Not Equal, Contains, Does Not Contain, Begins With,
Does Not Begin With, Ends With, Does Not End With
Price <, <=, >, >=, ≠, =

 

 

 

First you need to select the segment you’d like to apply changes to by creating a filter. You can use this tutorial for a quick explanation on how to do so.

After you have a filter created, you can apply a specific rule to that filter:

Click on the ‘Filters’ menu and select the filter you would like to use

Once Selected, click on the ‘Actions’ menu

 

Select ‘Apply on Filtered Items’ 



Go the ‘Assign a Rule’ drop-down and select the rule you’d like to apply to that filter.
The rule will be applied to that filter only. 

You can also repeat this process if you’d like to export only that specific filter:

  • Click on the ‘Filters’ menu and select the filter you would like to use
  • Once Selected, click on the ‘Actions’ menu
  • Select ‘Apply on Filtered Items’
  • Click on ‘Export as File’

 

 

Help Us Get Better

Was this article helpful?

0 out of 0 found this helpful

Your problem isn't listed here?

Ask a Question
Have more questions? Submit a request

Comments