When the Shelf Becomes a Liability
Retro collectors reach a breaking point. It usually happens when you're standing in front of three shelves of ISA cards, two milk crates of Socket 7 motherboards, and a bin of mystery drives with peeling labels, and someone messages you asking if you have a working SCSI controller. You spend 45 minutes digging. You find two — but one is already sold, you just never updated anything, and the other has a cracked trace near the host bus adapter connector that you vaguely remember noticing but never documented.
That's the cost of an unmanaged collection: not just inconvenience, but missed sales and repeated work. The moment you started pulling gear from estate sales, swap meets, and eBay lots faster than you can mentally catalog them, the physical inventory decoupled from your mental model of it. The mental model is now fiction.
A collection that can't answer basic questions — what do I have, where is it, what's it worth, has it been tested — is a warehouse, not a collection.
What the Record Actually Tracks
The Vintage Computer Parts template is built around a few fields that look simple but carry serious weight once you start working at volume.
Type + Motherboard Class + CPU Socket form the primary taxonomy. Classifying something as "Motherboard" is just the start — layering in that it's a Super Socket 7 board with a VLB and PCI bus, sourced before the K6-2 shortage hit the reseller market, turns it into a searchable object with real market context. The Motherboard Class field covers XT through Socket 478, which maps cleanly to the eras most serious PC collectors focus on. The CPU Socket options go granular: DIP, PLCC, PGA, Slot A — types that most general inventory apps wouldn't even know to list.
FCC ID and Serial Number are where provenance lives. The FCC ID is underused by casual collectors, but it's essential for two reasons: verifying country of manufacture on boards where the silk-screen markings are ambiguous, and cross-referencing with online FCC databases to pull original approval documentation. When you're trying to authenticate a particularly early OPTi chipset board or a first-run ISA Sound Blaster, the FCC ID is the primary verification anchor — more reliable than a sticker that can be reprinted. The template provides dedicated fields for both, along with a second image slot specifically for macro shots of these markings.
Visual Condition vs. Tested is a distinction that matters enormously in this market. A board can look mint — no corrosion, no bent pins, no marker damage — and be completely dead due to a failed CMOS backup battery that dumped charge into the BIOS chip. Conversely, boards that look terrible clean up and POST just fine. The template separates these assessments with a 5-star visual rating and a boolean Tested field, which forces you to record them as distinct facts rather than conflating cosmetics with function.
Moving a Super Socket 7 Board Under Time Pressure
The financial side of this template is where it earns its complexity. You have Purchase Price, Purchase Source, Purchased From, Sale Price, Sale Date, Platform Payment, and a calculated Sale Total that auto-subtracts the platform fee. A second calculation gives you Gain/Loss Total across the entire transaction.
When a buyer reaches out at 11 PM for a Chaintech 5AGM2 — Super Socket 7, SIS 5591 chipset, ALi M1531, AGP and PCI both present — you need to answer three questions in under a minute: do I have it, where exactly is it, and what did I pay. If Item Location says "Storage" and Purchase Price is in the record, you can quote a number and commit. If Status says "Sold" or "Parted out," you can say so without digging. The board's "Had parts" relational field tells you if the AMD K6-2 that was mounted on it is still linked to its own record or was separated into a component entry during a parting.
That relational structure — "Was part of" and "Had parts" — is what separates a collection database from a flat list. A complete AT tower gets its own Computer entry. Every component pulled from it links back. When someone asks if a specific Roland MPU-401 card came from an original manufacturer build or an aftermarket installation, you have a chain of custody.
The For Sale flag combined with the Platform and Price fields gives you a lightweight consignment layer. Mark it active, set the listing platform and ask price, and your entire "for sale" inventory is one filter away. When it sells, flip Status to Sold, enter Sale Date and Sale Price, and the Gain/Loss Total calculates itself.
The template is denominated in PLN, which reflects its creator's market context, but the field types work in any currency — the math doesn't care.