A useful sneaker inventory has one row per physical pair and separate columns for identity, condition, ownership and evidence. It should distinguish what you paid from what you hope to receive if you sell.
Build around physical pairs
Two pairs of the same release are two assets if you own both. Give each its own record, even when the style code and size match. This lets you record different purchase costs, wear and sales without overwriting one pair's history.
A row describing a model you want belongs in a wishlist, not in the owned total. For a pair you sold, preserve its purchase and sale history but remove it from current holdings.
A practical column layout
| Column group | Fields |
|---|---|
| Identity | Record ID, brand, model, style code, colorway, version |
| Pair details | Labeled size and system, condition, box and extras |
| Ownership | Owned/wanted/sold status, purchase date, purchase cost |
| Evidence | Source URL, date checked, evidence type, estimate or unknown |
| Sale record | Sale date, gross amount, selling expenses and net proceeds |
Use one currency consistently when adding totals. If you retain purchases in different currencies, preserve the original amounts and record any conversion method separately. Do not silently add dollars and euros as if they were the same unit.
Three rules that keep totals honest
- Leave an unknown purchase cost unknown rather than entering zero as a shortcut.
- Do not add wanted or sold pairs to current collection value.
- Keep the estimate date and evidence type beside the amount.
Illustrative example: Pair A cost $180 and Pair B cost $220. Both currently have an entered estimate of $200. Their combined cost is $400 and estimated total is $400; this does not mean they have the same individual return. Selling Pair A should not erase Pair B or their distinct records.
Spreadsheet or collection app?
A spreadsheet suits collectors who want custom columns and manual evidence review. A photo-led app suits people who want to browse their actual pieces on a phone. iCollect and SneakersBook demonstrate category-specific cataloging; compare the workflow rather than assuming every app has the same import or export support.
Pieces is another option for a mixed collection. Our existing inventory template is a standalone starting point, not a supported Pieces CSV import format. Review data transfer options before moving an established spreadsheet.
Sources and further reading
Written by the Pieces team for personal collection recordkeeping. Competitor resources inform the topic; examples and checklists here are original. Pieces is independent of the named services.
Building a complete collection record? Start with how to track your closet’s value, then use this guide for the details.