Introduction
This article shows you how to use the SORT AND FILTER DATA tool. This tool is available on the Basic View Data page.
For information about the filters on the Advanced platform, see:
- View Data Filters: Advanced
Certain conditions are imposed on the Basic View page to help new users get directly to results that are more likely to be profitable matches.
These include a Match Quality of over 75%, and Gross ROI of over 1%.
Reset filters
If you filter table data, and then want to return the table back to its unfiltered number of results, click the RESET FILTERS button. This button removes filtered data and places all of the search results back into the View Data table.
In Basic View, this will still keep the above conditions in place (Match, Quality, and ROI).
1. Opening the sort and filter data panel
- Go to the Basic View Data page.
- Scroll up to the top of the page.
- Click the SORT AND FILTER DATA button. The Sort & Filter Data panel opens.
The Sort & Filter Data panel has 13 tools. Each tool is described below.
1.1 Sort By
This tool sorts all table data based on one of four filters.
- Click the field next to Sort By. A drop-down menu displays.
- Select a sort option on the menu.
The options are:
Added
- Items with the most current information are placed at the top of the table. Items with older information are placed lower down the table. Check the time on the Last Update line.
Estimated Sales
Products are listed according to estimated monthly sales, from the best selling on down.
ROI
Products are listed according to gross ROI, from the highest gross ROI down. As shown in the image below. Remember to check ROI manually as well as the product just to be doubly sure the items match and are profitable.
Match Quality
This filter sorts products by the Match Quality score. Scores run from 100 (a perfect product match between the supplier and Amazon) to 75 by default (an average product match confidence).
- Sometimes, you might want to spend time inspecting products with low scores. They could still be identical products with mismatched images.
1.2 Show Qty between
Use this tool to see which products on your View Data table are for items with a specific quantity, to avoid multipacks, or to specifically show them.
1.3 Source
If the items in your product list come from more than one source, you can sort the data by supplier.
- Click the field next to Source. A drop-down menu displays.
- Select a supplier on the menu.
- Note: If there is only only product supplier (e.g. Abe Books), this filter doesn't work.
1.4 In Stock
Filter the data according to the supplier's stock position. There are three options:
- currently in stock (yes)
- not in stock (no)
- display both (all)
1.5 Match quality
Filter out products by Match Quality score. The score range is from 0 to 100.
- Enter a low and high score in the fields. Or you can also leave one field blank.
Items which do not have a score inside this range are filtered out.
Match Quality is based on a number of factors including image recognition. Numbers over 75 have a much better certainty of a match.
1.6 Amazon category
If your search involves more than one Amazon product category, you can narrow the list of options.
- Click the field next to Amazon Category. A drop-down menu displays.
- Select a category from the menu.
1.7 Buy Box
Filter out products based on the Buy Box holder on Amazon.
- Click the field next to Buy Box. A drop-down menu displays.
- Select a category on the menu.
Choose one, two, or all of these:
- AMZ (sold by Amazon)
- FBA (fulfillment by Amazon)
- MF (merchant fulfilled)
1.8 Gross profit
Filter out products which do not have a minimum gross profit measured as a dollar amount and not a percentage.
- Enter a low and high profit number in the fields. Don't add a dollar sign. You can also leave one field blank.
Items which do not have a projected gross profit inside this range are filtered out.
1.9 Gross ROI
Filter out products which do not have a minimum gross ROI measured as a percentage.
- Enter a low and high ROI number in the fields. These numbers represent percentages, but don't add a percentage sign.
- An example of this might be a range of 5 to 200.
Items which do not have a projected gross ROI inside this range are filtered out.
1.10 Sales Rank (30 Day Average) <
Filter out products which do not meet a minimum product sales rank threshold. This threshold is calculated as the average sales rank in a given product category over the last 30 days.
- Enter a number in the field.
Items which do not have a 30 day average sales rank equal to or greater than this number are filtered out.
1.11 Estimated Monthly Sales >
Filter out products which do not meet a minimum monthly sales threshold.
- Enter a number in the field. In this example I have entered 5, but any sales of note in a month can be attractive, so I would usually recommend keeping this number low.
Items which do not meet or exceed this monthly sales volume are filtered out.
1.12 Reviews between
Filter out products which do not have a minimum number of Amazon reviews.
- Enter a low and high number in the fields. You can also leave one field blank.
Items whose total number of reviews falls outside this range are filtered out. Again these numbers are just examples and you should err on the side of little or even no reviews as those items can still sell very well.
1.13 Rating >
Filter out products which do not meet a minimum Amazon rating score (between 0 and 5 stars).
- Enter a number in the field.
Items with a score less than this figure are filtered out.