
Mission 3 of 7
Let Claude hunt Amazon stockouts and score the best gaps.
One prompt and Claude scans a category for products that sell hundreds a month, and checks whether Amazon itself just ran out. Then you score each gap in two minutes and bin most of them.
What you'll do
Point Claude at the moments stockouts cluster, then run a daily scan prompt for a ranked shortlist.
Use the price history to tell a real gap from a fake one in about 30 seconds.
Kill weak picks with a 6-point score, then keep a watch list to catch gaps the day they open.
- Three fake gaps to skip
- A tracker spreadsheet and every prompt in one file
- Claude connected to Keepa (module 2)
- Any spreadsheet app: Google Sheets, Excel or Numbers
Your progress0/5
Where stockouts happen
Point Claude at the places gaps actually appear, not at random.
With Claude connected to Keepa, the first question is where to point it. Scanning at random wastes time.
Stockouts aren't randomThey cluster around a few moments. Hunt there first:
- Hype drops and collectibles: trading cards, limited tins, figures, new LEGO sets. Demand spikes on release and stock is allocated, so Amazon runs out fast. That's our Pokémon example.
- Viral products: something blows up on TikTok and sells out in days. Watch what's trending, then check it on Amazon.
- Seasonal peaks: toys and gifts in November and December, fans and garden gear in a heatwave, school supplies before term.
- New releases: consoles, controllers and accessories, new versions of popular gadgets.
- Everyday products with a supply hiccup: a popular kitchen gadget or pet product where Amazon's order didn't arrive. Quieter gaps, fewer resellers, often the easiest to source.