The problem
If you resell on Mercari, or you price inventory against it, you already know the annoying part. There's no export button. No bulk download. Just a search page you can scroll through and click into, one listing at a time, while trying to keep a mental average of what things are actually going for.
That gap matters more than it sounds like it should. Asking price and sold price are not the same number. Anyone can list a jacket at $120. Whether it sold for $120, $60, or $35 is the number that tells you if buying that jacket was a good call in the first place.
The solution
Mercari US Scraper pulls both active and sold listings from any search or category in one run. Price, condition, brand, seller rating, sales count, shipping fee, all as clean data you can drop straight into Excel, Google Sheets, or Airtable. No account, no login, no clicking through pages by hand.
One result, once it's sitting in your spreadsheet:
| Field | Example |
|---|---|
| Title | Vintage Patagonia Fleece Jacket, Size L |
| Price | $45 |
| Original price | $120 |
| Status | Sold |
| Condition | Like New |
| Seller rating | 4.9 (94 sales) |
| Shipping fee | $7.99 |
Line up a few hundred of those and a pricing pattern shows up fast, instead of a guess based on the five listings you happened to click through last week.
How to use it
- Open the Actor in Apify Console and enter a keyword ("Patagonia fleece") or paste a Mercari search or category URL.
- Set status to
sold_outfor completed sales, oron_salefor what's currently listed. - Narrow by price range or condition if you want to (new, like new, good, fair, poor).
- Set how many results you want and run it.
- Download as JSON, CSV, Excel, or HTML, whatever your workflow already uses.
No code involved. Same steps whether you're pulling 20 results to sanity-check a category or 5,000 to build a full pricing model.
What it's actually for
Checking sold comps before you buy inventory to flip, so you're pricing off what buyers actually paid instead of what a seller hoped for. Keeping your own listings competitive by seeing what similar sellers are charging right now. Feeding a pricing spreadsheet on a schedule so you're not re-checking Mercari by hand every week.
None of that requires touching a line of code. It just requires not doing the clicking yourself.
Try Mercari US Scraper
Mercari US Scraper pulls active and sold listings with condition, seller rating, and shipping fee included. $2.99 per 1,000 results, no login required.
Top comments (0)