Step 2: Product Searching & Extraction

an
Product extractions as a key part of the sourcing process as they provide the most efficient way for
us to generate lists of potential products to go after.

st
ki
Task Summary

Pa
1. ​Install Keepa Chrome Extension

s
es
First, search ​‘’Keepa Extension’’​ on Google then you will need to add this extension on your Google
Chrome.

cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su

2. ​Configure Keepa Chrome Extension

First, click on the ​“Log In”​.

ce
er
m
om
Ec
 Then simply write your Log In information and click on the Log In button.

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m

3. ​Sign Up for Snov.io

om

s
Sign up for a free account with Snov.io (​https://snov.io/​). This will help you find contact information
es
later on in this process.
Ec

cc
Su
ce
er
m
om
Ec

You will likely to install the Snov.io Chrome Extension as it makes finding email addresses even faster.
 4. ​Overview

an
To find your Product Extraction assignment, you can check the Competitor Tracking Sheet. In the

st
event that you are extracting a supplier catalog, you will need to follow the KEEPA a Supplier Catalog
SOP.

ki
When a competitor or keyword extraction is assigned to you, your name will be in ​Column G​ (Google

Pa
Sheet Shared with VA).

This sheet will contain the storefront link for the competitor, or keyword, (in ​Column A​: name) and a
link to the Google Sheet found in ​Column F​.

s
es
Make note that the extraction assigned to you might be in a separate tab within the spreadsheet. Be
sure to check ​all ​tabs while looking for your assignment (this will mostly depend on what on the
category the competitor was found in).
cc
*Note for Sellers/Supervisors: this will allow you to see which niche/category your suppliers were
Su
found in later on.

an
ce

st
ki
er

Pa
m
om

s
es
Make note that the extraction assigned to you might be in a separate tab within the spreadsheet. Be
Ec

sure to check through ​all ​tabs while looking for your assignment.
cc
Su
ce

1. I have found my Product Extraction Assignment

er

2. I have found the Storefront Link

3. I have found the Google Sheet Link
m
om
Ec
 5. ​Extract the Full List of Products

an
First, you need to ​Extract the Sellers​ for Product Extraction. Go to ​Amazon​ & Choose your ​Category​.

st
ki
Pa
s
es
cc
Su

an
ce

st
Then on the selected category product page simply apply some filter & run ​AMZ Scout.

ki
er

a. Rating ​( 4.0 & Up )

Pa
m

b. Price Filter ​( Min $15 to Max $100 )

c. FBA ​(Check) ​and AMZ & MCH ​(Uncheck)
om

d. Sellers ​( Min 3 )
s
es
Ec

cc
Su
ce
er
m
om
Ec
 Now just check all the products so the chances of getting an efficient seller which meets your criteria

an
of Finding Competitors on Amazon Step - 1.

st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 As you see this seller meets your Step - 1 criterion so simply shortlist the ​Seller Name​ & his ​Seller ID.

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

This above method is going to help you for ​Seller Extraction, ​now for the ​Product Extraction​ in
Keepa​, you need to apply some filter & then run it.
cc

a. Amazon Out of Stock ​( Check )

Su

b. New FBA Price Current ​( $24 to $200 )

c. Root Category ​( Your Choice )
d. Buy Box Seller ​( 3rd Party )
Amazon ​( Seller ID )
ce

e.
f. Rating ​( 3.5 )
g. Availability of the Amazon Offer ​( Amazon Offer is in Stock & Shippable Uncheck )
er

h. New Offer Count ​( Minimum 3 )

i. Additional Switches ​( Adult Product & Trade in Eligible Uncheck )
m
om

*Note: If you want to extract the efficient products for Wholesale so you must have to follow these
above instructions.
Ec
 Click here to open the KEEPA extension

an
st
ki
Pa
After you Log in the Keepa tool you have to select the ​“DATA”​ option.

s
es
cc
Su

an
ce

st
ki
er

Pa
m

Then click on the ​“Product Finder”​ option.

om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 Now we have to set up these filters on this extension so we can easily find the most efficient

an
products for Wholesale.

A. Amazon Out of Stock ( Check )

st
ki
Pa
B. New, 3rd Party FBA Price Range ( Current From $24 To $200 )

s
es
cc
Su
C. Root Category Selection ( Your Choice )

an
ce

st
ki
er

Pa
m

D. Buy Box Seller ( 3rd Party Check )

om

s
es
Ec

cc
Su

E. Ratings ( 3.5 )
ce
er

F. Availability of the Amazon Offer ( Amazon Offer is in Stock & Shippable and Amazon Offer
m

is currently not in stock, but will be in the future (back-ordered, pre-order) Uncheck )
om
Ec
 G. New Offer Count ( Minimum 3 )

an
st
ki
H. Additional Switches ( Adult Product & Trade-In Eligible Check “NO” )

Pa
s
es
cc
Su

an
I. Amazon ( Seller ID)
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 Then finally click on the button​ “FIND PRODUCTS”​.

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc

Then some products will appear on your screen like this.

Su
ce
er
m
om
Ec
 Now we are exporting the Data on the Google Spreadsheet like this.

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 6. ​Filter the Data in Excel

an
Once the data has been extracted, Keepa will provide an Excel Spreadsheet that contains the results.

st
You will need to filter these results in Excel, prior to copying it into the supplier’s Product Extraction
Spreadsheet.

ki
*Note: to filter the data, right click the desired column and select sort Sheet A - Z.

Pa
Filters to Add/Check in Excel:

a. Sort the column labeled: ​BuyBox Price New $USD

s
es
You will need to sort this column A - Z

b. Delete all lines that have a value under $24 for the column labeled: ​BuyBox Price New

c.
cc
Sort the column labeled:​ 90 Days Avg Sales Rank
Su
You will need to sort this column A - Z

an
d. Delete all lines with BSR more than 80K under the ​90 Days Avg Sales Rank ​column
ce

Sort the column labeled: ​New Offer Count

st
e.

You will need to sort this column A - Z

ki
er

Pa
f. Delete all products (lines) with 8+ sellers in the column labeled:​ New Offer Count
m
om

1​ ​I have replaced all the dashes with 0

s
es
2​ ​I have removed lines where “BuyBox Price New $USD” < $24
Ec

3​ ​I have removed lines where “New Offer Count” are 8 or more

cc

4​ ​I have removed lines where “90 Days Avg Sales Rank” > 80,000
Su

5​ ​I have deleted the unnecessary columns

ce
er
m
om
Ec
 7. ​Copy the Data to the Google Spreadsheet

an
Once you have filtered the data in Excel, select all of the remaining rows to copy and paste them into

st
the assigned Product Extraction Sheet from step 4 - Overview.

ki
Once you paste the data into the Google Sheet, the embedded formulas should auto populate the
remaining columns.

Pa
You will need to manually check that the formulas were carried through the full Google Sheet.

s
es
cc
Su
Copy the Data to the Google Spreadsheet - Figure 1

an
ce

1​ ​I have copied the information from Excel into the Google Sheet

st
2​ I​ have made sure everything copied over correctly and fixed the necessary errors

ki
er

(including formulas)

Pa
m

a. Check for Existing Records in HubSpot

om

b. Check Number of Competitive Sellers s

c. Check if Amazon Holds the BuyBox
es
d. Check if Amazon is a Seller but Not the BuyBox Holder
Ec

e. Check if the Brand is the Only Seller on the Listing

f. Check Price Stability
cc

g. Populate Google Sheet URL

Su
ce
er
m
om
Ec
 A. Check for Existing Records in HubSpot

an
Log into Hubspot (​https://www.hubspot.com​).

Sometimes we find companies that already have records in HubSpot. Be sure to do a quick search for

st
the company in HubSpot before looking for the contact information.

ki
Search for the company in HubSpot by using the ​Brand ​name.

Pa
s
es
cc
Su
Copy the Data to the Google Spreadsheet - Figure 2

an
ce

st
If the company already exists in HubSpot, then you will color the ​Email ​cell gray and move on to the
next row. If the company does Not exist in HubSpot, proceed with the steps below.

ki
er

Pa
m
om

s
es
Ec

cc
Su

Copy the Data to the Google Spreadsheet - Figure 3

ce
er
m
om
Ec
 B. Check Number of Competitive Sellers

an
To do this, click the URL from the ​URL: Amazon ​Column to visit the product page.

st
ki
Pa
s
es
cc
From here click the number of ​Other Sellers on Amazon​.
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m

From the Other Sellers Page, count the number of Prime Sellers that are within 2% of the lowest
Prime price. If the actual number of sellers in Buy Box contention is different than what is in the
om

Google Sheet, update the Google sheet.

In the case where there are no FBA (If there are only FBM sellers), highlight the ​FBA Sellers in Buy
Ec

Box Contention ​cell in green, mark as 0 FBA Sellers, and PROCEED to find the contact information for
that brand.
 an
st
ki
Pa
s
es
cc
Su
Copy the Data to the Google Spreadsheet - Figure 4

an
1 I have checked the number of Competitive Sellers
ce

st
C. Check if Amazon Holds the BuyBox

ki
er

The area of the product detail page that contains the Price, Seller and Add to Cart option is referred

Pa
m

to as the Buy Box.

When Amazon is a competitive FBA seller for a product, they may or may not share the Buy Box.
om

s
We must manually check the product page to see if Amazon is the Buy Box holder.
es
Ec

cc
Su
ce
er
m
om

Copy the Data to the Google Spreadsheet - Figure 5

If Amazon is the BuyBox holder, highlight the ​ASIN ​in Yellow and do not proceed to find the contact
information.
Ec
 an
st
ki
Pa
s
Copy the Data to the Google Spreadsheet - Figure 6

es
D. Check if Amazon is a Seller but Not the BuyBox Holder

cc
If Amazon doesn’t have the BuyBox, but if the seller has then marked the ASIN by highlighting the
ASIN ​in Orange and continue to find the contact information.
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

Copy the Data to the Google Spreadsheet - Figure 7

cc

E. Check if the Brand is the Only Seller on the Listing

Su

In this case that the brand name is the exact same name in the Buy Box holder, change the ​FBA
Sellers in Buy Box Contention​ to 0 sellers and do NOT proceed to find the contact information.
ce
er
m
om
Ec
 Copy the Data to the Google Spreadsheet - Figure 8

an
1​ ​I have highlighted all products where Amazon is the Buy Box Holder

st
2​ ​I have highlighted all products where Amazon is a Seller but not the Buy Box Holder

ki
3​ ​I have checked if the Brand is the only seller on the listing

Pa
F. Check Price Stability

Open ​camecamelcamel.com​ and then enter your product URL on the search bar so you can easily

s
find your price graph which shows the price trend for the past few months.

es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

If the price has been consistent over the last 90 days (i.e, if you can draw a straight line through from
the current price and the graph, stays relatively close to that line), you will enter ​Yes ​in the ​Price
cc

Stable ​column.
Su
ce
er
m
om
Ec
 Copy the Data to the Google Spreadsheet - Figure 9

an
If the price has not been consistent, you enter ​No ​in the ​Price Stable ​column.

st
ki
Pa
s
es
cc
Su

an
ce

st
Copy the Data to the Google Spreadsheet - Figure 10

ki
er

Pa
m
om

s
es
Ec

cc

Copy the Data to the Google Spreadsheet - Figure 11

G. Populate Google Sheet URL

Su

The final step is to copy and paste the Google Sheet URL into the column titled ​Google Sheet URL​.

You will need the Google URL Shortener for this step.
ce

​Copy the Google Sheet URL into Google Sheet URL Column
er

1​
m

After you have completed these steps, do NOT delete or hide any rows​.
om
Ec
 8. ​ Analyze the Brand

an
A. When you should NOT Analyze the Brand

st
You do NOT need to determine the brand’s revenue for:

ki
1. Records where rows have been Hidden (leave the rows hidden)

Pa
2. Records where Amazon is the Buy Box holder - you will already have highlighted ​ASIN
yellow in this case.
3. Records where the manufacturer is the only seller listed on the listing.

s
4. Companies that already have records in HubSpot (see step 9 for clarification)

es
B. Checking for Brand Restrictions

cc
Some brands are restricted meaning that sellers who desire to sell their products on Amazon must
first ask the brand for approval.
Su
You will need to check manually on your Amazon Seller Central for this step.

an
If it reads ​Sell Yours-New?​ It means there are no brand restrictions. In this case, enter ​No ​into the
ce

Brand Restricted ​column. (See the figures below)

st
To determine if the product is Brand Restricted or Not, simply go to the ​Catalog ​option.

ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 Ec
om
Ec m

Analyze the Brand - Figure 1

om er
ce
m Su
er
ce cc
Su es
cc s
es Pa
s ki
st
Pa an
ki
st
an
 If it reads ​Need Approval-New?​ It means there are brand restrictions. In this case, enter ​Yes ​into the
Brand Restricted ​column. (See the figures below)

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec

Analyze the Brand - Figure 2

 an
st
ki
Pa
Analyze the Brand - Figure 3

C. Determining a Brands Revenue

s
Determining a brand’s revenue is a simple yet important process. You will need to follow the steps

es
below for each and every brand that he made through the filters.

cc
While on the product listing page, select the ​brand name ​to be taken to their Amazon storefront.
This is typically found near the title as a blue hyperlink.
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc

Analyze the Brand - Figure 4

Su

You will need the Jungle Scout extension for this step. If you do not already have the Jungle Scout
extension so you can download it HERE
(​https://chrome.google.com/webstore/detail/jungle-scout-extension/bckjlihkmgolmgkchbpiponapgj
ce

enaoa?hl=en​) and sign in using your credentials.

er
m
om
Ec
 1. From the brand’s storefront, select the Jungle Scout extension and click the ​Extract Next Page

an
a few times.

*Note: This option might not be available on a smaller storefront. The goal behind this is to

st
view the results on all the products a given brand carrier in the storefront.

ki
Pa
Analyze the Brand - Figure 5

s
es
2. Sort the result by ​Revenue ​with the highest dollar amount first. To sort by revenue, simply
click the ​Revenue ​column within the Jungle Scout.

cc
Su

an
ce

st
Analyze the Brand - Figure 6

ki
er

Pa
m

3. Add together each line with an estimated revenue greater than ​$3K​.
om

4. Enter the total into the ​Estimated Brand Revenue ​field in the extraction spreadsheet. In the
s
case there are multiple lines for the brand, enter the total into each row.
es
Ec

*Note: be sure to enter the total as a value, NOT a dollar amount.

cc
Su
ce
er

Analyze the Brand - Figure 7

m
om
Ec
 D. Determining the Brand’s Opportunity

an
With Jungle Scout still open on the brand’s storefront, look in the upper right corner and enter that
number into the ​Opportunity Score​ column of the product extraction. In the case there are multiple

st
lines for the brand, enter the opportunity score into each row.

ki
Pa
s
es
Analyze the Brand - Figure 8

cc
Su

an
ce

st
ki
er

Analyze the Brand - Figure 9

Pa
m

1​ ​I have checked for Brand Restrictions

om

2​ ​I have determined the Brand’s Revenue and entered into the Spreadsheet
s
3​ ​I have entered the Brand’s Opportunity Score
es
Ec

cc

9. ​Enter the Contact Information

Su

A. When You Should not Find Contact Information:

You do NOT want to find contact information for:

ce

1. Records where rows have to be Hidden

er

2. Records where Amazon is the BuyBox holder

3. Records where the manufacturer is the only seller listed on the listing
m

4. Companies that have already in HubSpot

om

If multiple records have the same email address, only the email address ​once​. For multiple records
with the same email, enter the word “SAME” into the email cell for those records.
Ec
 B. How to Check that the Company is NOT in HubSpot:

an
We suggest starting from the ​“Linkedln”​ ​https://pk.linkedin.com/​ (because if the company isn’t in
HubSpot, you will already be at the correct page to complete the next step)

st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 First, type the ​Company Name​ into the search bar and then select ​Company​. Use the hyperlinked

an
company name to take you to the company’s LinkedIn profile. (See the figure below)

st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
For example, if the company searched on LinkedIn was Samsung, you will find a link to the website
Ec

once you click on the company name.

cc
Su
ce
er
m
om
Ec
 Select the ​“About” ​section to see the Company URL.

an
st
ki
Pa
s
es
cc
Su

an
ce

st
ki
er

Pa
m
om

If the company name differs from the company URL (the name after @ sign), you will need to search
s
for the company URL in HubSpot.
es
Ec

cc
Su
ce
er

If the company is not yet in HubSpot, continue with the rest of the steps in this SOP.
m
om
Ec
 C. Find Contact Information:

an
Step 1: ​if you haven’t already done so, search on LinkedIn for the company by ​Brand ​and click on the
Number of Employees on LinkedIn ​to see a list of the people that work for his company.

st
ki
Pa
s
es
Once you have the list of employees, you should look for someone in charge of ​eCommerce, Sales, or
Marketing​.

cc
Su

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su

As you can see above, there is one Sr. Regional Sales Manager you choose Paul Kaplan.
ce

Once you find the person that you want to get in contact with, choose their profile. After you have
gotten to their profile, click the ​Snov.io ​extension
(​https://chrome.google.com/webstore/detail/email-finder/einnffiilpmgldkapbikhkeicohlaapj​) and
er

select ​Find Emails and Save​.

m

Once you have saved this contact, choose the ​Go to list ​option. The Go to list option will take you to
your ​Snov.io ​account.
om
Ec
 an
st
ki
Pa
s
es
cc
You can see in this example that there was no email address found for the contact that we were searching for.
Su
Occasionally, Snov.io will not be able to find an email address.

an
In the event of this, go back to the company employee page on LinkedIn. From this page, select the ​Snov.io
ce

extension​ ​as you did before.

st
In the dropdown dialogue box from Snov.io, make sure that all of the contacts are selected. Next, choose the

ki
er

Find Emails and Save​ ​option.

Pa
m

Next, select ​Go to list ​to be taken to your Snov.io profile once again.
om

s
es
Ec

cc
Su
ce
er
m
om
Ec
 Now, look through the list that Snov.io generated. Look for any contacts that have an email address and add

an
the appropriate contact to the Product Extraction Spreadsheet.

st
ki
Pa
s
es
cc
Su
If there is a contact available then enter the person’s First Name, Last Name, Title, Company Phone (can be

an
found on their website), and Email address into the spreadsheet in the appropriate column.
ce

st
D. If you still cannot find a Contact Email:

ki
er

Type the company name + contact information into Google. Sometimes this is the easiest way to find
information.

Pa
m

You can also search the companies URL and navigate to the contact page to their contact email. In
om

the event that only a contact us form is available, fill it out with and use the template below for the
body of your text.
s
es
Ec

“Hi, I have a question regarding the resale of your products. Will you kindly direct me to the person
I need to speak with?”
cc

Once you receive a response from the brand, copy and paste the email address of the respondent
Su

into the email address cell in the spreadsheet.

1​ I​ have checked each record in HubSpot to see if it already exists & marked the cell
ce

gray

2​ ​I have entered contact information for records that aren’t already in HubSpot
er

3​ ​I have entered SAME for the email field where records are duplicates
m
om
Ec
 10. ​Update the Competitor Tracker Worksheet

an
Once you have completed the extraction, please enter the date (in the red box-column H), your name

st
(in the blue box-column I), and how many usable records were found in (in the green box-column K)
in the appropriate columns in the Competitor Tracking Spreadsheet.

ki
Pa
s
es
cc
Su
1​ ​I have entered the date, my name and number of usable records

an
ce

st
ki
er

Pa
m
om

s
es
Ec

cc
Su
ce
er
m
om
Ec