All Collections
Wholesale Search
Wholesale Search: Remove Filter
Wholesale Search: Remove Filter

Getting down to the nitty gritty on the Wholesale Search portal.

Julie Steiner avatar
Written by Julie Steiner
Updated over a week ago

Introduction

This article describes the tools available in the Wholesale Search Remove panel.  

The Remove panel contains filters that omit items from search results based on the criteria you enter into a field. In that sense, filters can be a powerful, time-saving tool.

Based on our experience, you shouldn't activate too many Remove filters on a search. If heavily filtered, you could miss out on some worthwhile items.
​

For the majority of product searches, use two of three filters on a regular basis. Your searches will probably include some or all of these:

  • Remove Over Rank

  • Remove if Number of Reviews is less than

  • Remove if Rating is lower than

 

Organisation

The Remove panel has 15 filters. Each filter is described briefly below.

 

1.  Using Remove Ranks Over

Skip products that rank poorly on Amazon.

There are three ways to enter a threshold.

  1. Click the box beside Remove. A drop-down menu displays. Select a time period: Current, Average 30 day, or Average 90 day.

  2. With the toggle switched to the left side, enter a figure in the Ranks over box. Rank measures product sales compared to other items in the same Amazon category.

  3. Toggle the switch to the right side and then click the AS PER SETTINGS button . The Set Sales Rank Filter Values page displays. This page has default threshold values for a wide range of products. 

  • Note: If you select the AS PER SETTINGS option, no number appears in the data field.

1.1  Set Sales Rank Filter Values

You can customize the values on the Set Sales Rank Filter Values page. Once set, use these values for every search.

  1. Open the Set Sales Rank Filter Values page.

  2. Select your base country by clicking a flag.

  3. Click the box beside Country Product Count - Top. A drop-down menu displays. Select 4, 7, or 10%. Choose 4% if you want a high threshold that targets top ranked products (and generates fewer search results) or 10% if you want a low threshold that includes less popular items (but generates more search results). Or, choose 7% because you like the middle of the road.

  4. Inspect individual line items that interest you and make sure the auto-generated threshold figures make sense to you. 

  5. Click SAVE.

 

2.  Using Remove if Estimated Sales is less than

Here's a tool to remove products with insufficient monthly sales.

Enter a number in the field.

This is the minimum number of sales per month you need to consider a product viable. If Amazon's monthly sales are less than this figure, the product is not included in the search results.

 

3.  Using Remove if the Number of Sellers is less than

Omit items based on the number of people who sell that product. You might want, for example, to avoid any product sold by 100+ vendors. Too much competition, perhaps.

Leave the first field blank. Or add a small number if you want avoid products sold by too few people.

Our suggestion

  • New users insert a low number in the second field. That generates a comparatively narrow range of search results.

  • What you consider low or high is relative and depends on a lot of variables. Run a few searches to get a feel for the number that makes sense for your category.

  • Advanced users enter a comparatively large number to see a long results page and learn about the marketplace.

 

4.  Using Remove if the Number of Competitive FBA Sellers is more than

This handly little filter is great for if you want to avoid much competition. If there is more than a certain number of competitors jostling for position for the Buy Box within a set % range (set this on the View Data page), then it might be a difficult sell.
​
However, using this filter and selecting a very low number means you should have a better chance of owning that Buy Box when you come to sell.

 

5.  Using Remove Oversize Products

Products are classified by size. Standard products fit into regular boxes. Oversize items are big, clunky, sometimes are hard to handle. 

If you're set up for regular packages and don't do oversize, use this filter.  

  1. Toggle ON to remove oversize products.

  2. Toggle OFF to include oversize products.

 

6.  Using Remove if Amazon contains no Weight or Size Data

On occasion, weight and size data are not available for Amazon products. 

Why not? 

Dunno. 

Some things are beyond our cognitive abilities. We do know, however, that we aren't smart enough to accurately calculate total cost of goods without weight and size data.

Here's what you can do:

  1. Toggle ON to exclude products with no weight or size data.

  2. Toggle OFF to include products with no weight or size data.

  • Note: In the View Data page, products without weight or size data are displayed in red. In these cases, some fees are estimated by assuming a 1-pound box. These cost estimates should not be regarded as these accurate figures. 

 

7.  Using Remove if Amazon is also a Seller and Now In Stock

Here's you chance to compete directly with the Amazon matrix. Just like Neo, some folks are up for a challenge and don't competing with Amazon. Others get queasy just thinking about it. 

You decide.

  1. Toggle ON to exclude in-stock products sold directly by Amazon. 

  2. Toggle OFF to include in-stock products sold directly by Amazon.

  

8.  Using Remove if Number of Reviews is less than

Set the minimum number of product reviews. A low number of reviews might indicate a problem product. Does that interpretation apply in all cases? Probably not.

  1. Enter a number. If the number of reviews is equal to or less than that figure, the product is excluded from search results. 

  2. Leave the field blank to avoid using this filter.

 

9.  Using Remove if Rating is lower than

You might want to include this filter in your searches.
​
Set the minimum product rating score. If products have a low rating - say 3 out of 5 stars or less - you could be looking at a dud. 

If you sell low quality products, you won't be delivering a positive buying experience, your rating could go down, and you might find yourself spending time dealing with customer complaints. Why bother?

  • Note: We suggest entering a mid-range figure like 3.0.

 

10.  Using Remove Products with a Source price of less than

Use this filter to set minimum and maximum product prices.

  • Can you make money selling a $7 product on this channel? Probably not.

  • Do you have the budget to buy $500 items? Oh yeah? You're crushing it, but not everybody is playing at that level, brah.

Use this filter to set a price range that matches your business plan and budget.

  1. In the first field, exclude products priced lower than your floor target.

  2. In the second field, exclude products priced higher than your ceiling target.

 

11.  Using Remove Products with an Amazon price of less than

Use this filter to set minimum and maximum prices for products sold on Amazon.

This filter is similar to Step 10 above. The difference is that here you are setting a sales price range. 

  1. In the first field, exclude products sold on Amazon priced lower than your floor target.

  2. In the second field, exclude products sold on Amazon priced higher than your ceiling target.

12.  Using Remove Products if Amazon Title contains the Word(s)

Sometimes a search based on UPCs generates juicy results with mouthwatering profit margins on a single product. Then reality hits you like a hockey puck in the mouth. The Amazon price is for a product bundle or a 3+1 item. Ouch.

A good way to avoid this type of pain is to filter out a few keywords in the title. Good keywords to filter include:

  • bundle

  • pack

  • set

  • count

  1. Enter a keyword in the field.

  2. Add new word separated by a comma or space.

 

13.  Using Remove Products containing the Brand(s)

This filter works well when you're doing a promo search. Say, for example, a toy wholesaler has a 20% sale on kid's toys excluding Lego.

Your interest is finding hidden gems, so you run a search and exclude Lego products. You already know it's not part of the sale. Your search will run a bit faster and you'll save time by excluding Lego items in the search results.
​

  1. Enter a brand name in the field.

  2. Add new word separated by a comma or space.

 

14.  Using Remove Product if Amazon Buy Box is not at least

This filter tells the Tactical Arbitrage algorithm you need a minimum ratio between the source buy price and the sell price in Amazon's Buy Box.

Say, for example, the target buy price is $10 and you set a factor of 1.7 in the filter. That means the search results page will include products with an Amazon Buy Box price of $17 or higher. If the Amazon Buy Box price is less, that product is not included in your search results. 

Like all algorithms, and most flat Earthers, there is no gray area. As a result, a product that sells in the Buy Box for $16.99 (i.e. one cent under the $17 threshold) is removed from the search results.

 

15. Using Remove if Amazon has Been in Stock

This is a niche filter. It finds opportunities based on gaps in Amazon's stock control.

  1. Enter a number in the first field. 

  2. Click the second field. A drop-down menu displays. 

  3. Select 30 Days or 90 Days.

 

15.1 Example

Let's look at an example. 

The image below shows a filter. The filter tells the algorithm to remove items that have been in-stock on Amazon for 50% or more of the time over the past 90 days. 

Based on this filter:

  • An item is removed from the search results if has been in stock for 60% (or more) of the time during the last 90 days.

  • An item is included in the search results if it has been in stock for 40% (or less) of the time during the last 90 days. This might be an opportunity worth looking at in some detail: an item regularly out of stock on Amazon.

Did this answer your question?