Help · Getting going
Bring in your stock list from Collectr, Excel or a spreadsheet
If your cards are already listed in Collectr, Excel or a spreadsheet, bring the list in rather than typing it again. Nothing is paid, so nothing comes out of the till. It needs signal.
- In Collectr, export your collection as a CSV file. From Excel or Google Sheets, keep the file as it is (.xlsx or CSV) with a header row, or copy the cells.
- Open "Stock", tap "Actions", then "Bring in a list". Owners and managers can do this. On a new shop it is also on "Today" under Prep, on the empty Stock list, under the empty pile in Prep, and at the foot of "Set up your shop".
- Tap "Choose a file" and pick your file. Or tap "Paste from a spreadsheet", paste the cells with the header row first, check how many cards were read, and tap "Use these cells". More than a couple of thousand rows? Choose the file instead: a phone handles a big file better than a big paste.
- An Excel file with more than one sheet opens on the first sheet with cards. Pick another under "Sheet" if your cards are on it.
- A Collectr export or the TenthPocket template is recognised and every column is matched for you. For any other file, check each column is right, or tap "Change columns". Columns you change are remembered on that phone for the next file laid out the same way.
- If the file has no condition, language, game or finish column, pick one for every card, or leave it as not given. Nothing comes in until you do.
- Check the counts: cards ready, cards with no price, cards with no cost in the file, any kept as written, and any left out, such as cards on your Collectr watchlist.
- Untick any card you do not want, for example your own keepers. Tick "Leave out cards under a price" to skip cheap cards. With more than one Collectr portfolio, pick which to bring in.
- If the file has a currency column in your shop's currency, that is all. If it has none, tick the box that says the prices in the file are in your currency: we ask rather than guess.
- Tap the button to bring the cards in. When it is done, tap "Print labels", or "Check prices" to check them against today's market.
The TenthPocket template
- Download the template, or tap "Download the template" on the Bring in a list screen. It is a CSV file that opens in Excel or Google Sheets.
- Its columns are Game, Name, Set, Number, Language, Finish, Condition, Graded by, Grade, Quantity, Price, Cost, Location and Notes. Delete the two example rows and add your cards, one card or a stack of the same card a row.
- Leave a cell blank when you do not know it. Price and Cost are in your shop's currency.
What the file can say
- Conditions as words or codes: NM, Near Mint, LP, Lightly Played, Excellent, MP, HP, DMG and the like. Finishes: Normal, Holofoil, Reverse Holo, Foil, Etched, or foil yes or no. Languages as names or codes: EN, JP, Japanese, KR. Grading as PSA 10, BGS 9.5 or CGC 10 Pristine, or a Graded by column beside a Grade.
- A word we do not recognise is kept as your file wrote it, never guessed, and counted on the screen when the cards are in, so you can check them in Stock.
- CSV files can use commas, semicolons or tabs. A file with semicolons may write 2,50 or 2.50, and each price column is read the way it is written. If a column only has prices like 1.234, which could be either, you are asked how the file writes money, so no price is guessed. Files saved from Excel on Windows with accents, such as Pokémon, read correctly.
- A currency column in a different currency from your shop stops the bring in. Prices are never converted. Export the list in your shop's currency instead.
- Older Excel files (.xls), Numbers and OpenDocument files cannot be read. Save them as .xlsx or CSV first.
Prices and costs
- Your own price in the file is kept. Otherwise your selling rules work out a price from the market price in the file. A card with no price in the file comes in with no price.
- The market price in the file is not kept as today's market price. Stock, "Prices" counts these cards under "Need a fresh price" and looks each one up fresh when you tap its look up button.
- What you paid is kept where the file has it. A cost of 0 means it was not entered, so it comes in as unknown and margins show as unknown, never as profit that is not real.
Good to know
- Bringing in the same file again adds nothing twice. Changing what you tick and bringing it in again would add those cards again, and the screen warns you when it has seen the file before.
- Cards come in today, with no photo and no label. Print labels from Prep, "Labels", and add photos later in Prep.
- No scans are used.