WiseGuy's Guide to Advanced Filtering

So you’ve created a few basic filters like SKUs with more than 2 competitors or SKUs with low margin and competition. This post will arm you with all the hacks you need to take your filters to the next level in our new Wiseboard.

 

Price position filters

These filters let you compare two different price points (current price, min price, max price, lowest and highest competitor price). Use this filter to identify SKUs that may be out of sync with your overall pricing strategy.

 

Pro tip: When you enable this quick filter, it will automatically return SKUs where your min price is greater than the lowest competitor price. These SKUs are typically uncompetitive since you have competitors selling under your floor. Take these SKUs back to finance or your vendors for better costs!

 

Other great use cases include:

  • Current price < min price (you’re currently priced under your floor)
  • Current price > max price (you’re currently price above your max)
  • Current price > highest competitor price (you’re the highest market price)



Price variance filters

These gems are hidden in your custom filter logic. They let you filter for SKUs based on the price variance to the lowest competitor price.

 

 **Note: Mapper stores have these set as quick filters called violation price variance**

 

Positive percents indicate you’re cheaper than the lowest competitor

Ex: price variance greater than 10% will return SKUs where your price is at least 10% cheaper than the market

 

Negative percents indicate you’re more expensive than the lowest competitor

Ex: price variance less or equals -20% will return SKUs where your price is at least 20% more expensive than the lowest competitor price

 

 

Leveraging the operators ‘IN’ and ‘CONTAINS ANY’

In the custom filter logic, use the ‘IN’ logic to return a list of potential results (this is the same as using a long series of OR operators with IN in a filter)

 

Not sure what the exact name was? Use ‘CONTAINS ANY’ to return a list of results that contain your text (same as using a long series of OR operators with CONTAINS in a filter)

 

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