Product spec

TrackID
Crates

Turn forum lore into buyable Discogs crates.

This is the playlist feature, but with a sharper collector-native angle: paste a TrackID thread, resolve the records, then find which ones are actually for sale from cached sellers.

MVP promise

Paste a thread. Get the records. See who sells them.

Input
Text first
Match
Discogs
Output
Buyable
Pipeline step

1. Ingest

Paste TrackID forum text, Reddit comments, YouTube descriptions, DJ set tracklists, or a raw URL when a scraper exists.

Output

Raw mentions with source context and timestamps.

Example input

Track at 31:20 is probably Kerri Chandler - Atmosphere E.P. on Shelter.
45:10 sounds like early Prescription Records, maybe Ron Trent.
A2 from some Guidance release, deep house, 1996 or 1997.
ID confirmed: Gemini - Swimmin' Wit Sharks, Peacefrog.

Parsed preview

82
Kerri Chandler
Atmosphere E.P.
label clue: Shelter
46
Ron Trent
Unknown Prescription-style ID
artist/style only
38
Unknown
Guidance A2
label + era clue
91
Gemini
Swimmin' Wit Sharks
confirmed ID

Data model

CREATE TABLE forum_crates (
  id TEXT PRIMARY KEY,
  title TEXT NOT NULL,
  source_url TEXT,
  raw_text TEXT NOT NULL,
  created_at INTEGER NOT NULL
);

CREATE TABLE forum_crate_items (
  id TEXT PRIMARY KEY,
  crate_id TEXT NOT NULL,
  raw_mention TEXT NOT NULL,
  artist TEXT,
  title TEXT,
  label TEXT,
  year INTEGER,
  timestamp TEXT,
  discogs_release_id INTEGER,
  discogs_master_id INTEGER,
  confidence INTEGER NOT NULL DEFAULT 0,
  status TEXT NOT NULL DEFAULT 'candidate',
  source_context TEXT,
  FOREIGN KEY (crate_id) REFERENCES forum_crates(id)
);

SELECT l.*, r.*, f.confidence
FROM forum_crate_items f
JOIN listings l ON l.release_id = f.discogs_release_id
JOIN releases r ON r.id = l.release_id
WHERE f.crate_id = ?
ORDER BY f.confidence DESC, l.price ASC;

Confidence scoring

Exact artist + title+45
Fuzzy artist + title+25 to +40
Label mentioned in thread+15
Year within ±2+10
Track duration/timestamp clue+5
Forum answer has multiple confirmations+15
Thread language says maybe, sounds like, unknown-10 to -25

API surface

POST /api/forum-crates
Create a crate from pasted text or source URL
GET /api/forum-crates/:id
Load parsed crate, matches, unresolved IDs, and source notes
POST /api/forum-crates/:id/resolve
Run Discogs matching and confidence scoring
GET /api/forum-crates/:id/sellers
Return buyable matches across cached sellers
POST /api/forum-crates/:id/export
Export CSV, wantlist, or playlist-style JSON

UX states

Screen behavior

Paste

User drops a TrackID thread, setlist, or comment dump. The app previews detected timestamps and candidate mentions before saving.

Primary CTA
Parse thread
Risk
Scraper fragility
Fallback
Paste raw text

How it works for the user

01

Bring the source

Paste a TrackID forum URL, DJ set comments, a YouTube description, or just raw text copied from a thread.

I heard this in a set. What is it and can I buy it?

02

Review the finds

The app splits the thread into confirmed IDs, likely IDs, maybe IDs, and unresolved mystery cuts.

Show me the records people actually identified, not the whole noisy thread.

03

Hunt the bombs

Each record gets a Bomb Score based on provenance, rarity, price, condition, audio availability, and seller overlap.

Tell me which ones are worth stopping for.

04

Build the crate

Pick a seller, budget, condition floor, and shipping preference. Diggers Delight turns the thread into a buyable crate.

Give me the best €100 bag from this lore.

Bomb finder

How it finds bombs

A bomb is not just a matched record. It is a high-conviction record with cultural proof, scarcity, listenability, and a buyable copy at a sane price.

Provenance
+25

Played by a known DJ, appears in a respected set, or confirmed by multiple forum heads

Obscurity
+20

Low marketplace supply, rare label, small press, or no obvious repress flood

Price gap
+20

Listed below median or cheaper than similar copies

Condition
+15

VG+ or NM copy with clean sleeve notes

Taste fit
+15

Matches selected genres, eras, labels, or previous saved records

Audio confidence
+10

YouTube/SoundCloud/Spotify match found, so the user can verify quickly

Seller efficiency
+10

Available from a seller already holding other wanted records

Unresolved mystique
+5

Thread has demand but no clean ID yet. Good for research, not auto-buy

Bomb score formula

bomb_score =
  provenance_score
+ scarcity_score
+ price_gap_score
+ condition_score
+ taste_fit_score
+ audio_confidence_score
+ seller_efficiency_score
- repress_risk
- bad_condition_penalty
- weak_match_penalty

The UI should never expose this as fake precision. Show it as a simple badge: Instant pull, Strong bomb, Maybe weapon, or Background dig.

User-facing badges

Instant pull
90-100

Rare, proven, correctly priced, clean copy. Show first.

Strong bomb
75-89

Highly promising. Worth listening and comparing.

Maybe weapon
55-74

Good context, but needs ears or price check.

Background dig
0-54

Keep in crate, do not interrupt the user.

Recommended build order
  1. 01
    Paste-text MVP with local parser and saved crates
  2. 02
    Discogs resolver with confidence bands and manual override
  3. 03
    Join resolved IDs against cached seller listings
  4. 04
    Crate UI inside results with buyability and provenance badges
  5. 05
    URL scrapers for TrackID, Reddit, YouTube, and setlist pages