Inventory · Inventory system
How to Build a Card Show Inventory Spreadsheet
The fields and workflow for a practical card show inventory spreadsheet covering identity, cost, price, location, status, certs, sales, and show reconciliation.
By the Sports Card Vending research desk · Published July 21, 2026
Quick answer
Quick answer
Track one row per card or lot with a stable ID, exact description, cost basis, asking price, lowest acceptable price, physical location, online-listing status, and sale result. The sheet should help find and reconcile inventory at the table, not become a perfect database nobody updates.
The short version
- A stable item ID connects the sheet, price label, case, and sale record.
- Physical location and online-listing status prevent the most expensive mistakes.
- Capture sold price and payment method before removing the row from the active view.
Which columns should every inventory sheet have?
Start with item ID, category, year, set, player or character, card number, variation, grade or condition, cert number, quantity, cost basis, asking price, floor price, and current location. Add acquisition date and source when they help evaluate aging and supplier performance.
Use controlled values for sport, grading company, status, and case location. Free-form variations such as Case One, case1, and front case make filtering unreliable during a show.
How should online listings be connected?
Add platform, listing ID or URL, listing price, and listing status. Before the show, mark cards that travel and decide whether listings stay active. After a sale, update every channel before the card can sell twice.
- Use a show status such as packed, displayed, sold, traded, or returned.
- Record the case, row, binder, or box where the item sits.
- Keep customer information out of the inventory file unless truly required and protected.
- Back up the file before importing or bulk editing.
How is the sheet reconciled after the show?
Record sold price, payment method, fees, buyer discount, and sold date. Trades need cards-out, cards-in, assigned values, and cash difference. Return unsold cards to their normal location and update online status only after a physical count.
Review aging, margin, and requests. A spreadsheet becomes valuable when it changes what gets repriced, packed, or purchased for the next show.
Working checklist
Put this guide into practice
- 1.Assign a stable item ID.
- 2.Record exact card identity and cert number.
- 3.Track cost, asking price, and floor price separately.
- 4.Use controlled physical-location names.
- 5.Link active online listings.
- 6.Record sales before removing active inventory.
- 7.Back up before bulk changes.
Quick answers
Frequently asked questions
Should every one-dollar card get its own row?
Only if the value of detailed tracking exceeds the labor. Low-dollar cards can be tracked as lots or box counts, while premium inventory usually needs item-level records.
What is the difference between asking price and floor price?
The asking price is customer-facing. The floor price is an internal decision boundary based on cost, margin, and strategy. Do not expose a private floor column in a public inventory export.
Can a phone spreadsheet work at a show?
Yes if key fields are easy to filter and the file works offline. Test the exact update flow during a simulated rush and keep a recovery copy.
Keep working