The Bulk Product Scout tool is a useful tool to quickly research existing Amazon listings using a specific search term, ASIN or UPC, EAN or ISBN. 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. The direct links for each products Keepa, CamelCamelCamel and Amazon listing are also returned and available for further research.
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
Step 1) Go to the "Bulk Product Scout" tab on the top navigation panel, as shown in the image below:
Step 2) Click on the " Actions" toolbar button and select either "Template" or "Import".
1) If you select the "Import" option, you can upload any CSV Excel sheet, as long as the columns that contain the Search Term and Cost of the item have the correct column headers.
2)The "Template" option will download a CSV Excel sheet that can be populated by your data as shown below:
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 3) 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 4) 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 5) Enter the item costs into Column C.
Step 6) Save and close the template as a CSV file format to your desktop.
Step 7) Go back to AsinScout and under the "Actions" toolbar, select "Import" and choose the file you saved, and click "Import". AsinScout will start scanning your list of items right away and the information will start populating on the screen.
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. With Links for Keepa, CamelCamelCamel and Amazon underneath as well as the option to open the item in our Single Item Search, and to add it to the Wishlist.
- 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.
- 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 beginning of the sales rank information.
- The item dimensions and package dimensions.
- 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.
- The Date the item First appeared on Amazon.
- 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 ROI over your cost.
All of the above columns are sort-able by clicking on the column header.
To quickly sort all of the data that is returned, you can use the filters found in the "Actions" toolbar, as seen in the screenshot below:
In the Filters window, you have the option of filtering the data by Brand, ASIN, Search Terms, BSR's less than a specific number (with the option of either the first category or second), Net Profit, or Net Percent ROI, as seen in the screenshot below:
Simply select the filters you desire and click on the "Apply Filter" button. To undo a filtered selection, simply click on the "Clear Filter" button.
To Export all of the data returned to a CSV Excel spreadsheet, click on the "Export" button in the "Actions" toolbar.