Mercari Japan & Yahoo Auctions Scraper – メルカリ ヤフオク Sold Prices
Pricing
from $2.00 / 1,000 listings
Japan resale scraper API, no login: Mercari Japan listings & sold items, Mercari Shops, Yahoo Auctions live & sold (ヤフオク落札), Yahoo Flea Market, Rakuma. Item details, seller items & profiles, sold comps (median, p25/p75, days to sell). Filters, JPY→USD, delta. $0.002/listing.
auto (default): keywords -> search, urls/ids -> item_details, users -> seller_items. search = listings (status on_sale/sold/all). market_research = keyword -> sold comps per market + live listings priced vs the sold median + one insight row (recommended price, best market after fees, arbitrage spread, deals). sold_comps = price stats per keyword x market. item_details, seller_items, seller_profiles, seller_reviews (Mercari). capabilities = free.
Keywords for search and sold_comps, one per item. Japanese works best; English is searched as given AND in Japanese when expandQuery knows the term (pokemon card -> ポケモンカード, rolex -> ロレックス). Each row shows queryUsed. Example: ["ポケモンカード", "nintendo switch"].
Item URLs for item_details: jp.mercari.com/item/m…, jp.mercari.com/shops/product/…, auctions.yahoo.co.jp/jp/auction/…, paypayfleamarket.yahoo.co.jp/item/…, item.fril.jp/…. Marketplace search URLs (jp.mercari.com/search?keyword=…, auctions.yahoo.co.jp/closedsearch/…) run a search; seller profile URLs (Mercari, Yahoo! Auctions) run seller_items. Bad ones return an INVALID_URL error row (free).
Bare item ids for item_details: Mercari m12345678901, Yahoo! Auctions x1234567890 / 1234567890 (a Yahoo! Flea Market id when markets is only yahoo_flea), Mercari Shops 22-char ids, Rakuma 32-hex ids. Use the itemId field of listing rows.
Seller ids for seller_items, seller_profiles, seller_reviews: the sellerId of a listing row. Numeric = Mercari (684797252) or https://jp.mercari.com/user/profile/. Letters+digits = Yahoo! Auctions (3UC93wYwb7qvoqVWhjM1R8rtbBxgo) or https://auctions.yahoo.co.jp/seller/. Yahoo! Auctions: live listings + profile; seller_reviews is Mercari-only.
Which marketplaces to search: mercari (Mercari Japan, includes Mercari Shops rows), mercari_shops (Shops only), yahoo_auctions (ヤフオク live + sold), yahoo_flea (Yahoo! Flea Market / PayPayフリマ), rakuma (楽天ラクマ), or all. Default: mercari + yahoo_auctions. Example: ["mercari", "yahoo_auctions", "yahoo_flea", "rakuma"].
on_sale (default) = active listings / live auctions. sold = sold items (Mercari sold + in trade, Yahoo! Auctions closed/落札, Flea Market and Rakuma sold out). all = both. sold_comps always uses sold items.
Total billable rows for the run, 1-10000 (clamped). Default 100. A default call costs at most 100 x $0.002 = $0.20 (listings).
Rows per keyword per market (search), per seller (seller_items, seller_reviews), or sold sample size per keyword x market (sold_comps 120, market_research 60). 1-1000 (clamped). Defaults: search 50, seller_items 50, seller_reviews 50.
market_research only: live (on-sale) listings returned per keyword per market, each annotated with soldMedianRef, vsSoldMedianPct and dealFlag (deal / below_p25 / fair / above_p75 / too_cheap_check_item). 0-200 (clamped), default 20; 0 = comps + insight only.
Return only these fields (plus type), e.g. ["title", "price", "status", "url", "soldAt"]. Leave empty for the outputMode default. The capabilities row lists every field per row type.
details = open every listing for the full item (description, all photos, condition, shipping, seller rating; billed as item-detail $0.004 instead of listing). seller = one seller row per unique Mercari or Yahoo! Auctions seller ($0.005). evidence = sold_comps / market_research also return the sold listings behind each stat ($0.002 each). insights = sold_comps adds the computed insight row (free). comments = latest Mercari comments on item rows (free).
compact (default) = stable flat rows. full = every field. lean = minimal rows for LLMs (listing: market, title, price, status, condition, soldAt, bids, end time; empty values dropped; url rebuilt from summary.urlPatterns + id). table = lean + one TSV table per row type in key-value record LEAN_TABLE (fewest tokens).
newest (default) = newest listed (sold: newest sold on Yahoo! Auctions). price_asc / price_desc = by price. likes = most liked (Mercari, Flea Market). ending_soon = Yahoo! Auctions ending soonest. relevance = marketplace best match. Markets without a sort fall back to newest.
Lowest price in yen. Applied by the marketplace where supported, then checked on every row.
Highest price in yen. Applied by the marketplace where supported, then checked on every row.
Drop listings whose title contains any of these words (e.g. ["ジャンク", "まとめ"]). Mercari also applies it server-side.
JPY (default) or any ISO code such as USD, EUR, GBP: adds priceConverted and converted comps using the day's ECB rate (api.frankfurter.dev). price always stays in JPY.
Stop before the run's charges exceed this amount; rows so far are kept and a BUDGET_REACHED row (free) explains it. Example: 0.5.
Return one plan row per task (markets, queries, estimated rows, cost, seconds) and a summary, without fetching or billing anything.
Keep only these conditions: new (新品、未使用), like_new (未使用に近い), good (目立った傷や汚れなし), fair (やや傷や汚れあり), poor (傷や汚れあり), bad (全体的に状態が悪い). Rows whose condition is unknown (Rakuma search, most live Yahoo! Auctions rows) are dropped unless include has details.
Keep only rows whose title contains every term (case/width-insensitive), e.g. ["本体", "lite"]. Filters after fetch: it does not reduce pages fetched or cost of comps; billed rows only include matches.
Drop rows whose title has none (any) or not all (all) of the keyword's words (either query variant). Default any for market_research (marketplace search is fuzzy), off elsewhere. Filters after fetch.
sold_comps / market_research: off (default) = raw stats. outliers = drop prices outside p25-1.5 IQR .. p75+1.5 IQR (>= 8 rows). accessories = also drop accessory / part / empty-box titles (case, film, charger, dock, 空箱, 部品 ...) while collecting, so the sample refills; live research listings too. Comps rows always carry cleanMedian / cleanP25 / cleanP75 / accessoryShare.
Yahoo! Auctions search now mixes in Yahoo! Flea Market fixed-price items (rows say collectionWarnings yahoo_flea_market_cross_listing). include (default) = keep, exclude = real auctions only (comps = auction prices), only = cross-listings only. Filtered after fetch; more pages are read to refill.
A live listing is a deal when its buyable price is at least this % below the sold median (1-90, default 20). Rows under 35% of the median are flagged too_cheap_check_item instead (usually a different or partial item).
market_research: scan up to max(5 x maxListingsPerKeyword, 100) live listings per market (max 300, scanning is not billed) and return only those flagged deal or below_p25, cheapest vs the sold median first, max maxListingsPerKeyword. You pay only for returned rows. Default false.
Override seller fees used for net-after-fee prices, e.g. {"rakuma": 6}. Defaults (checked 2026-10-13): mercari 10, mercari_shops 10, yahoo_auctions 10, yahoo_flea 5, rakuma 10 (4.5-9 for high-volume sellers).
Optional shipping cost subtracted from every market's net sale price in the insight row (default 0 = not included; the row then warns shipping_not_included).
market_research: add the computed insight row per keyword (free). Default true.
With deltaKey: rows get snapshotAt, previousSnapshotAt and deltas vs the previous run (listings: priceDelta, likesDelta, bidCountDelta, watchCountDelta; comps: medianDelta, activeListingsDelta, soldPerDayDelta, sellThroughRateDelta). onlyChanges then defaults to false. Only compact numbers are stored.
Native category ids: Mercari categoryId (e.g. 1289 = ポケモンカードゲーム) or one Yahoo! Auctions category id (auccat). Take them from the categoryId field of earlier rows.
Keep only Yahoo! Auctions rows with a buy-now (即決) price or fixed price.
Keep only Yahoo! Auctions rows with at least this many bids.
Keep only live Yahoo! Auctions ending within N minutes (combine with sortBy ending_soon).
seller = free shipping (送料込み) only; buyer = buyer pays (着払い). Leave empty for any.
sold_comps: only sales from the last N days count (1-3650, default 90). Rakuma rows have no sale date and are not cut.
Name for change tracking between runs (e.g. "switch-watch"). Rows get changeType new / price_drop / price_up / sold / relisted / unchanged and previousPrice. State lives in a named key-value store in your account. Use status all to catch items that sold.
With deltaKey: skip unchanged rows (not billed). Default true (false when trackMetrics is on).
Search English keywords as given AND in Japanese when the dictionary knows the term (400+ resale terms: brands, franchises, item types, condition words). Results are merged and de-duplicated. Default true.
Drop repeated items across queries and markets (a Flea Market item also listed on Yahoo! Auctions counts once). Default true.
seller_reviews: keep only good, normal and/or bad reviews.
seller (default) = reviews the user got as a seller; buyer = as a buyer; all = both.
item rows: return the first N photo URLs in imageUrls (1-50; default 3 in compact, all in full). imageCount always gives the total, so nothing is hidden.
Comments per item (include comments)
commentsPerItem
Optional
Latest Mercari comments per item row with include comments (0-50, default 5). Commenter ids are hashed.