TCG Inventory Management: A Game Store Owner's Guide

It's 2:40 on a Saturday. A customer asks for the last foil copy of a card you listed online this morning. You say yes and walk to the case. It's there. Your phone buzzes: someone just bought it.

Now you're doing math you didn't sign up for. The sheet says one. The shelf says one. The order says sold.

Nobody did anything wrong, and your shop isn't disorganized. Your count just lives in too many places at once: the sheet, the case, the order screen and one person's head. Fixing that is the real job of TCG inventory management. The number you tell people has to match the card in the case.

What is TCG inventory management, and why are singles hard?

It is how a store tracks every card it owns as its own item, down to set, printing, finish, language and condition. Done well, it tells you what you have, where it sits, what is spoken for, and what is safe to sell right now.

Singles are harder than sealed product because one card name fans out into many items, and each needs its own count. One popular card can mean twenty or thirty rows. Collectors want the exact printing too, which is why the collector view of a shop asks for it.

How do you grade and price cards by condition?

Grade every copy as near mint, lightly played, moderately played, heavily played or damaged, and write down how your shop prices each step. Condition is part of the item, so each grade is its own stock line with its own count.

Market prices are daily estimates, and they move. Your own price is the number you put on the card. Keep those apart in your head and in your tools. Our full walkthrough is in NM, LP, MP, HP: a condition and pricing guide for stores.

What is the difference between on hand, held and available?

On hand is what is physically in your shop. Held is the part already promised to someone, such as a pickup request. Available is on hand minus held, and it is the only number safe to show a customer.

Most systems show one number and call it quantity. That is the source of the Saturday scene. It can't tell you whether a copy in the case is also sitting in someone's request. The fix is one live count, with a hold on the exact copy the moment someone asks. Never store available. Work it out every time, or it will drift. The worked example, and what should end a hold, are in on hand vs held vs available stock for card shops.

Where does stock live, come in and go out?

Every copy needs a named home: a bin, a binder, a case or a back-room box. Keep the scheme boring, such as game, then set, then alphabetical. A new hire should read a bin label and know what's inside. See our guide to card storage for game stores.

Stock should arrive three ways: you log a delivery, you import a file, or you fix a count. Each leaves a record you can trace and undo. In Oskii, a mistaken delivery batch can be undone without touching anyone's hold.

Imports are how most shops start. Export a ManaBox binder as a CSV, or the CSV CrystalCommerce generates from Inventory > Products > Export, and upload it. Oskii shows a dry run first, and held cards are always kept. It's a snapshot, not a live connection. Stuck? Ask on the support page.

Going out works the same way. A pickup request holds the exact copy when it is sent. Staff get a pick list with the bin on every line and mark each line found or not found. Not-found lines go back to the shelf, and unclaimed holds expire at close. Oskii doesn't take payment, so you key the total into your own register. The retail solutions page walks through it.

Spreadsheet or store software: how do you choose?

Match the tool to how many people touch stock and whether customers search it. A spreadsheet suits one person and one counter. A marketplace tool suits shipping orders. Store software suits a shop where several staff, a kiosk and in-person customers all depend on one count.

There's no shame in the spreadsheet. It starts to strain when a second person edits it, when stock sells in two places, or when a customer wants to search it. At that point the missing piece is held versus available, and that's hard to bolt on by hand.

Questions game store owners ask about TCG inventory

What is the difference between on-hand and available stock?

On hand is what is physically in your shop. Available is on hand minus anything held for a customer. Customer-facing screens should always show available.

How do game stores keep track of singles?

They give every copy a record and a home. Each record carries the printing, finish, condition and a bin or binder. Stock comes in through logged deliveries or file imports, and a small weekly count catches drift before it grows.

How do you stop selling a card that is already reserved?

Place a hold on the exact copy the moment a request is sent, and work out availability as on hand minus held each time anyone looks. Holds should also expire so unclaimed copies return to stock.

Where Oskii fits

At Oskii, we're obsessed with organization, so we built the mechanism above into software for local game stores that sell Magic singles. It keeps on hand, held and available apart, holds the exact copy when a request is sent, and gives staff a pick list with the bin on every line. It doesn't replace your register.

We love our local game store, and we'd rather the owner closed on time. If that sounds like your Saturday, read why we build it, see what a game store operating system covers, or join the waitlist.