The Product Scout tool is a useful tool to quickly research existing Amazon listings using a specific search term, ASIN or UPC. This feature allows you to quickly upload a supplier's list of items, and then calculate how much net profit there is to be made after Amazon commission and FBA fees, as well as see other useful information such as the: sales rank; historic sales rank and price; image; ASIN; description; features; dimensions, and more. Additionally, we will return up to 10 search results per query(Page 1 of a search using the Amazon search bar), with all of the calculations and information included.
Due to getting the results directly from Amazon, which have strict limits of the amount of requests per hour, as follows:
If searching using UPC - You are limited to 30,000 search items per hour
If searching using a search term other than UPC or ASIN - You are limited to 700 items per hour
The following article will take you through the steps of uploading your list of products and understanding the results.
Filling out the Template
Navigate to the "Product Scout" tab on the navigation panel and open the Product Research module. On the top of the page is the "Get Template" button, as seen below:
Click on the button and the template will download to your computer. Open the template in Excel and you should see the following template with the first four columns filled out with sample data:
Column A contains sample data that you would like to search, this is where you enter the data for which you would like to search Amazon.
Column B is the ID type, this is where you specify which data type you are searching.
Column C is where you enter your cost so that the program can research your profits after Amazon fees.
Column D is the formula column which contains an Excel formula to ensure that your search term is accurate and unchanged when you upload the template.
Please note: Do not make any changes to the column headers as if they are changed, your sheet will not be valid.
Step 1) Copy or enter your search terms into column A. If this is a UPC, the formula in Column D will take our any dashes the UPC may contain and add leading zeroes if needed. Once all of the search terms are entered, if they contain UPC's, copy Column D and Paste the data into column A as "Values".
Step 2) Enter the corresponding ID type into column B, for UPC's enter "UPC", for ASIN's, enter "ASIN" and for search terms enter "search term"(lowercase letters only).
Step 3) Enter the item costs into Column C.
Step 4) Save and close the template as a CSV file format.
Uploading the Template
Navigate back to SellerWit product research page and select the choose file button:
Find the file you saved and select it and click "Open", and click on the "Import CSV" button:
Depending on the type of search terms and the quantity of items on the list, it may take up to 20 minutes for all results to be displayed. You can monitor the results by watching the percentage counter on the navigation panel, as seen below;
Understanding the Search Results
Once the search is complete, displayed on the product research will be the following fields:
- An Image of the item from the Amazon listing page.
- The Search Term you provided for the search.
- The ASIN (Amazon Standard Identification Number) for the item, the Amazon listing page will be launched in a new tab of your browser if clicked on in SellerWit.
- The Product Name that appears on the Amazon listing.
- The Sales Rank of the item, this is a number that’s purportedly calculated hourly (as stated by Amazon) and is linked to the number of recent sales of the product (while also taking into account historical sales data), relative to the other products in that category. The ranks are color coded by number of digits in the first rank of the item to be clear which items are ranked highest. Green ranks are 4 or less digits, yellow is 5 digits, blue signifies 6 digits and 7 digits are shown in red. Also shown in the Sales Rank section is the historic sales and ranking data for the item, which can be seen by hovering your cursor over the graph icon at the end of the sales rank information, as seen in the image below:
- The current Buy Box Price, this is the buy box price at the time of the search.
- The Number of Sellers on the item listing, this column is broken down by the number of sellers selling the item as "New", "Used", and 'Refurbished", and the total number of sellers of all item conditions.
- Additional Responses, this is the number of results brought back for the search term, in the event that the number of responses is more than 1, the next response will be displayed on the next line. The limit for additional responses is 10 per search term, for UPC searches, there is no limit.
- Your Cost, this is the cost that was entered on the uploaded template.
- FBA Fees, this is the sum of the fees that Amazon charges including Referral fees, Variable Closing Fees, Monthly Storage, Order Handling, Pick & Pack, Weight Handling and the Monthly Storage Fees.
- Net Profit, this is the sum of profit you will make after your cost and Amazon selling fees.
- Net Percent, this is the percent of profit over your cost.
All of the above columns are sort-able by clicking on the column header.
Exporting your Results
If you would like to export your results click on the "Export" button on the top of the page:
Once clicked, an Excel file will download to your desktop and you can edit and sort through the results as needed.
Please note: if a file is not exported, all data will be cleared from the program once another search file is imported to SellerWit.