If you search Mercari for a Coach Tabby 26 right now, the typical bag is listed at $379. The typical bag that actually sold went for $146. Same marketplace, same bag, a 61% gap.
I pulled both sides on 2026-11-05 with a small scraper run and cleaned the data by hand. Here is what it shows, and how to pull the same numbers yourself.
The data
Two runs of the Mercari Sold & Active Listings Scraper on Apify, search term coach tabby 26, minimum price $60:
- Active listings (asking prices): 117 listings
- Sold listings: 44 rows, 32 left after cleaning (I dropped other models like the Tabby 20, Plaza 22 and Times Square, a "reserved" listing, and titles that don't say Tabby 26)
Both runs together took under 20 seconds and cost a fraction of a cent.
Asking vs. sold
| Listings | Median | Middle half (25th to 75th percentile) | |
|---|---|---|---|
| Asking (for sale now) | 117 | $379 | $300 to $450 |
| Sold | 32 | $146 | $124 to $190 |
The asking side is anchored to what the bag costs new at Coach. The sold side is what buyers actually pay. If you price from active listings, you price from hope.
Sold price by condition
| Condition | Sales | Median | Range |
|---|---|---|---|
| New | 19 | $134 | $103 to $185 |
| Like new | 11 | $209 | $110 to $485 |
| Good | 1 | $316 | |
| Fair | 1 | $165 |
What stands out
1. "New" sold for less than "Like new". 18 of the 19 "New" sales went for under $160, which is a fraction of Coach's retail price. Eight of them write the name as one word, "tabby26". A new bag selling that far under retail does not prove anything about any one listing, but it is a pattern worth noticing: if you buy at that price, authenticate before you accept the item.
2. Special editions hold their value. The highest sold prices were not plain leather bags: a Crystal Signature Jacquard Tabby ($485), a Cargo Turnlock Tabby ($470), a black denim Tabby ($423) and a quilted suede one ($316). Plain leather and denim bags make up most of the cheap end.
3. The active list is full of bags that will not sell at that price. Half the active listings ask $379 or more. Only 4 of the 32 cleaned sales reached $350. If you are selling, the sold list is your real price guide; if you are buying, an offer near the sold median is normal on Mercari, not rude.
Pull this yourself
Input for the actor:
{ "queries": ["coach tabby 26"], "status": "sold", "maxItemsPerSearch": 80, "minPrice": 60 } Run it a second time with "status": "on_sale" (or "all") for asking prices. Each row has title, price, condition, status, brand and url.
Cleaning I did in Python:
import re, statistics as st rows = [...] # dataset items tabby26 = [r for r in rows if re.search(r"tab+y ?26|tabby shoulder bag 26", r["title"], re.I)] prices = [r["price"] for r in tabby26] print(len(prices), st.median(prices), st.quantiles(prices, n=4)) Limits
- One day of data, one search term. Mercari shows the most recently sold items first, so this is "the last few weeks", not a long history.
- 32 sales is a small sample. The medians are solid enough to show the gap, but don't read much into the "Good" and "Fair" rows with one sale each.
- Titles are written by sellers. My filter keeps anything that says Tabby 26, so a few listings may be mislabeled.
- I can't check authenticity from a listing. The "New under $160" finding is a price pattern, not a verdict on any seller.
I run SoldSignal, a free weekly resale price index built on the same kind of sold-listing data.
