Keepa Product Finder Deep Dive

by Brandon | Last Updated: September 15, 2021

Overview

I had intentions of making this part of my overall How To Use Keepa Graphs guide but it was just getting to be too long, so I decided to give it its own section. However, if you’re not familiar with Keepa itself and stumbled upon this page, I highly recommend you go back and read my guide here.

I don’t see a lot of people covering the Keepa Product Finder and it is an incredibly powerful tool by itself.

With that being said, let’s get to it.

Keepa Product Finder

Keepa Product Finder (LINK) is a way to setup parameters to search via their website for certain products. There are literally 100s of fields you can select so I’m going to show you a few important ones and how I look at the results.

I’m going to trim out a lot of fields and show you, in the order they are on the page, what I’ve set. This way you can go down the page and fill these in yourself to get some results.

Set everything like this and hit Find Products. This will be a good starting point.

Quick Overview Of Settings

• Sales Rank – We want to capture any products between 1 and 50,000 for Toys & Games. Over 50k does not interest us a lot right now.
• Buy Box Price – We want products that have a price of at least $10, this will weed out a lot of the $3 crayons and such that we can’t make any money on anyway.
• Title Brand and More – This is the category setting, which for our purposes here we are working in Toys & Games.
• New Offer Count – At least 3 to weed out any potential brands selling products, over 100 will probably be too saturated for longer than we want. But 150 might be worth exploring too.
• Buy Box Seller – Selecting 3rd Party will tell us Amazon is currently out of stock and someone else owns the Buy Box. This will be a prime target to set a Keepa alert for when Amazon does come back in stock.
• 90 days out of stock percentage (OOS%) – Let’s see products where Amazon has been out of stock at least 70% of the last 90 days.

Next, the table is going to come up with nine million fields, so let’s narrow things down and clean up what we’re looking at.

The good news is after you do this, Keepa should remember these settings for your future searches. So just like the image says, click Configure Columns and then click Hide all, then start to toggle on the following options:

• Amazon: 90 days avg.
• Amazon: 90 days OOS
• Amazon: Current
• Sales Rank: Current
• New 3rd Party FBA: Current
• New 3rd Party FBA: 90 days avg.
• Buy Box: Current
• Buy Box: 90 days avg.

And, hopefully you get something that looks like the following. You can drag and rearrange the column header name if needed. And also I like to shrink the title column to make it easier to see everything at once. To do this move your mouse just to the left of the first column after Title until the cursor changes, then click down and drag to the left.

If ever you want to go back and change some of the search parameters, just click on Advanced Filter up at the top.

Now, what we’re looking for is fairly simple. We want to scan the rows and look for items where the Current Buy Box price or at least the 90 days avg price is around double of what the Amazon current or 90 day average price is.

1st Example Listing

And hey, what do you know…the 6th option is pretty close. Let’s take a closer look. Just click on the title to the left: “Hot Wheels Track Builder…” and it will look like this:

A quick look at the graph tells us it’s priced ok, amazing rank, barely any sellers…this warrants a closer look still. Go ahead and right click on where the Amazon.com logo is and Open in New Tab or CTRL + click so it opens in a new tab. You DO NOT want to just click it because it will be a pain to get back to the product lists.

Also, if you want out of this popup, click the Red X circle in the top right, DO NOT hit the back button.

So once you’re on the listing page (click here to open) and you have the Revseller extension loaded we can check if it’s profitable. If you don’t have this extension, it’s a must have IMO, and I did a deep dive Revseller guide that you can check out.

The first and most important thing to look at is in the top right hand corner. If this doesn’t say “Sell-New” then you can’t sell it. You are either gated or restricted. Getting ungated is super easy for most toys and I will have an in depth guide written soon on that topic!

If you can sell it, then we look at the profit. $3.69 profit (23% ROI) @ a sell price of $29.99 doesn’t exactly move the needle for me, especially after factoring the shipping back to Amazon and the time to prep, etc.

Historically speaking, it has reached a price of $39.99. With so few sellers and a total stock of only 46 this does become a little bit more intriguing if we think we can squeeze $39.99 out again, which is $12.19 in profit and a 76% ROI.

I think it’s worth setting up an alert to see if we can catch Amazon in stock at under $16 re-evaluate then.

If you don’t know how to set a Keepa Alert, that is something else I covered in my Keepa Chart guide.

So, after we’ve set the alert up, we click the red X circle at the top right and get back to our list.

We’re going to keep scanning through the list…all 55 pages. Once you get the hang of it on the first couple pages it should start to go much quicker and you can scan a page in probably less than a minute.

2nd Example Listing

Page 2 gives us a couple more worth looking at:

And:

Amazon Links to both listings: HERE and HERE

When we plug the cost in to the Revseller extension we get some interesting results:

Great news to start off with is we can sell these items as indicated in the top right.

The Pterodactyl is not bad, a lot more sellers than I’d like but I think the rank more than makes up for it.

The Spinosaurus looks like a home run. But the rank is the same as the other item which is something we should pause with and look at more closely.

Product Listing Variations

We need to talk about variations for a minute. When you come across what seems like a good ranking item it’s important to actually go to the Amazon listing page and give the listing a once over. If you can select different items/colors/sizes directly from the listing page, that means it has variations available.

A really good example of variations would be t-shirts. Colors could easily be variations of a t-shirt, along with sizes.

If a product has variations then it would look like this:

The rank that Keepa/Product Finder and the Revseller extension displays could be, but not always, the average rank of all of these items. If one is selling much better, it could make the other items look better and you could wind up with a dud even though all the other metrics look good.

If you notice in the image above, the green button called Variation Viewer, this is part of the Revseller extension that you should have installed by now.

Click on it, and we’ll get some clues.

This gives us a breakdown of the reviews in the last 8 months or so, and we can see that the two items we were looking at got the most reviews of the variations. They were all pretty close, so we can probably assume that all of these variations are actually selling quite well. Just not quite as well as the rank suggests.

You can also skim through the reviews yourself and see which variations stick out the most to you.

I’d look at it like this. If the rank suggests 3500 sales a month, and since all of them are pretty close, I’d divide that number by 6 to get what each are selling. About 583 sales each, so that is still really good.

Spinosaurus is the type of home run we’re looking for. The bad news is Amazon has barely been in stock, but I’ve set up an alert and now we wait. We will not score on every listing like this we find, but the idea is to cast a wide enough net that we do catch something eventually.

And if/when you see that alert pop up you’ll be so nervous you’ll forget how to check out. (Just make sure you have a separate, non-prime Amazon account ready to go for your buying.)

3rd Example Listing

Let’s look at an example that on first glance catches our eye in the product list but ultimately would not be a good buy IMO.

Once we click on the title and get the secondary Keepa popup chart we see the following.

LINK if you want to view this listing.

Right away we have 3 things I don’t like.

Only 107 days old. This is too new. Amazon could come in stock at anytime with a container load full and you’ll be holding this product for months and months.

The amount of sellers has been steadily rising, up to about 100 right now. This tells me this product is probably easy to get somewhere else. I’m not going to bother looking into it further.

And the price is declining to match the amount of sellers joining.

So, even though right now, when I run the numbers I can make $5.33 on a $9.99 item (if I can find it) which would be a 53% ROI, this is a pass for me.

By the time we get the product, turn around and prep it and send it back to Amazon the price will surely drop more and there could even be way more sellers by then.

The risk far outweighs the reward in this case, let’s find something with a better chance of success.

Listings Requiring Approval

Also, just to show you that I am not able to sell everything, I do run across this a lot:

This is a pretty decent item but I can’t sell it. I’m gated. To get ungated I would need to find a distributor and purchase 10 of an item and then turn in the invoice to Amazon and ask for approval.

It’s not that hard to do, but sometimes it isn’t worth it. Initially there will be several brands you’ll want to get ungated in that always have a lot of opportunity. Check out my ungating guide and it will teach you how all this works and the easiest way to make it happen.

But MOST IMPORTANTLY, don’t get discouraged if you can’t sell certain items. You can always set Keepa alerts up for good products and delete them later if you decide for sure you won’t pursue getting ungated in that brand.

4th Listing Example

Page 4 of my search turned up my old friend Optimus Prime.

If you have read my guide on how to read Keepa charts you know that I used this item to go through explaining the graphs.

This is another home run and I’m actually writing an even more detailed piece on this and several other good buys and bad buys I’ve made. I will hopefully remember to come back and update this post with a link to it when it is ready. But you’ll be able to get some more insights into when and why I made my buying decisions and some discussions of what the data shows nearly 6 months later.

I’m going to go through one more example that I think is relevant and then I’ll leave you to do the rest of the exploring on your own.

At first glance, this doesn’t necessarily pass the 2x rule, but what caught my eye is that the current new price and current buy box price have increased over the 90 day average, meaning the price is actually on the rise. It made me want to take a closer look, worst case is I just click back and move on.

Things that stood out to me that I like.

• Amazon Exclusive – This means the only place you can get this item is Amazon. Not Target, not Walmart, only Amazon. If Amazon is out of stock, 3rd party sellers are the only option.
• 15,224 Reviews – Wow! To get this many reviews I have to assume this item has moved hundreds of thousands of units over time.
• New Offers – The number of sellers has actually been declining from near 40 to near 20 in the last few months. That’s an indication that this item is still selling a ton of product.
• 2136 Days – Plenty of history for us to look at, this is not some 100 day new flash in the pan item.
• Sales Rank – Over the last 90 days the average sales rank has been 2800, which is phenomenal. In the last year, average rank of 12763 is still really, really good.

The one year chart looks even better:

This is looking like a home run, right?

Let’s plug in the numbers to Revseller:

That’s mighty juicy if we think we can return to those numbers for Q4. (Well, technically it was the beginning of Q1 but just barely lol.)

And Amazon is in stock right now…do we buy now?

Well…just one problem.

I’d really like to know how many more they have. Sometimes we get lucky and it will show an exact number like 4325 or sometimes we’ll get a stupid “max order of 3” or “max order of 27” message.

But this is concerning, because if this also gets picked up and a bunch of other people find it that could really put a smackdown on our profits. As we get close to Q4 we don’t have a lot of time to misjudge this one or we could be holding for a while.

This isn’t a deal breaker though. I will actually set an alert for this one to see if Amazon lowers the price back below $15 (they were at $14.99 recently) and then wait and see. I’ll refresh the page once a day and see if the stock levels change. The ship date is still a couple weeks out so I have some time to monitor this one.

So it very well could be a home run, but it could also be caught at the warning track. I’ll post an update here if I do wind up moving on this.

Seasonality

As I was putting this guide together a lot of the searches that looked somewhat promising were costumes. Nearly double the sales price of Amazon on many different ones. But these are not something I even bother to look at.

Why? They’re seasonal items. It is now mid September when I’m writing this so Halloween is now about 6 weeks away. If I were to buy these now, it’d be very risky to turn around and sell these in time for Halloween.

That’s not to say you couldn’t work together a strategy around seasonal products like this to do you research and buying earlier on.

I just want you to take a minute to pause when you’re doing your research to ask yourself if there is a particular reason this item is doing well.

A Quick Word About Group Postings

Here’s something to keep in mind. Lots of people are running similar searches every day to find products like this. Maybe they are using different search parameters but the concept is the same.

They compile their own Keepa alerts and then might post to Discord groups or to Twitter when Amazon comes in stock (to make affiliate commissions) and a massive amount of resellers will flock to buy the item and then inevitably the price will go down. So the deal you thought you found will become a buy and hold.

Nothing wrong with any of that, you just need to be aware and adjust your strategy. That’s why it is also so important to learn this on your own, compile your own lead lists and be QUICK to jump on something you KNOW is a good deal, because you have historical data to back you up.

Here’s a good example of what can happen when a lead is posted to a popular group. For the record, I don’t know for sure if that’s what happened here, but it definitely fits the mold of what I’ve seen before.

I can only imagine how that person selling at near $100 was feeling when this listing got wrecked. This is why most people won’t share things like this when they find a good listing.

A lot of people might think I’m crazy for sharing real examples of my own listings too. But I try to approach things with an abundance mindset. There’s room for all of us to prosper.

And if I can help enough people make a better life for themselves I have no doubt it will come back to me 10 fold anyway.

Final Thoughts

I hope you have learned at least the basics of how to use Keepa Product Finder at this point.

Now, start playing around with Keepa yourself.

Change some search parameters. Maybe look at what products Amazon has in stock now, maybe change the sales rank, the pricing, etc.

The more you use this tool, the better you will get. It is like building muscle. Small, consistent movements will bring better gains than doing a lot of work one time.

And you can also check out my Keepa product analysis where I cover some actual purchases I made (good, bad, and wildcards.)

Last, but not least, I cover 70 side hustles that you should check out if you’re looking to make money.