Product Research · Blog post · source May 14, 2026
Wholesale Price List Scanner Built with Claude and the SP-API
Screen a distributor price list for profitable FBA buys without a paid scanner
“she pays $6/month for the server”
Per source Self-reported by the source, not independently verified.
Copy-paste prompt
Attached is the column layout of my distributor price list (UPC, item, dealer cost, weight, status). Help me build a tool that: drops inactive items, items over 2 lb, items with no UPC and anything on my restricted list; looks up each remaining UPC through SP-API (catalog, competitive pricing, fees estimate); and outputs Buy Box price, fees, profit, ROI, sales rank, number of FBA offers and whether Amazon is on the listing, with BUY if ROI >= [30]% and profit >= $[4], REVIEW if close, SKIP otherwise. Explain each step for someone who has never used an API.
The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].
What they did
A wholesale seller with no coding background asked Claude whether there was a cheaper way to replace her scanning subscription. Claude explained Amazon's SP-API, walked her through registering as a private developer and getting credentials, then helped her build a tool from her distributor file: it filters out inactive items, products over 2 lbs, items restricted in her state and items with no UPC, looks up each remaining product's Buy Box price, fees, sales rank, FBA seller count and whether Amazon sells it, and marks each BUY, REVIEW or SKIP with an Excel export.
How it went
She had it running live within 2 days. The software cost is $0 and she pays $6/month for the server that runs it.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
She owns Avetlist, the site that published this, and discloses it; the tool itself is described as a separate personal one. Check Amazon's current SP-API terms for private developers before you build your own, as she advises.