TCGplayer inventory CSV export and import, done right

For a Level 4 seller, TCGplayer's Pricing tab can export live inventory and import an edited CSV for bulk price or quantity changes. Getting the file back into the portal is the easy part. The built-in validation and Staged Inventory step is what confirms the update is the one you meant to make before it touches live listings.

Know what the export is for

Export From Live is the right starting point when you need to edit existing listings. Export Filtered CSV is safer when the job is limited to a set, product line, or other defined slice. A filtered export makes your review smaller and makes an accidental broad price change less likely.

The export includes products with a price even when their quantity is zero. Do not treat every row as live stock. A zero-quantity row can still carry price data, and a bulk edit can still change it.

The fields to leave alone and the fields to edit

Start from TCGplayer's export. Do not rebuild its columns from scratch. The portal describes TCGplayer ID and product details such as product line, set, product name, title, number, rarity, condition, and market references as reference-only fields needed to match inventory changes accurately.

For an ordinary Marketplace update, the editable work is usually in Add to Quantity and TCG Marketplace Price. Add to Quantity is a delta: a positive integer adds copies, zero makes no quantity change, and a negative integer subtracts copies without taking the total below zero. TCG Marketplace Price is required and must be at least $0.01.

Pro sellers using My Store Channel can see extra price and reserve-quantity fields. Do not fill those casually: a reserve quantity requires a My Store Price, and reserved inventory is not listed on the Marketplace.

A safe export, edit, validate, review workflow

1. Export current data. Choose Export From Live for the whole store or Export Filtered CSV for a bounded job. Save an untouched copy before editing.
2. Make one kind of change. For example, change Marketplace Price for a selected group, or apply an Add to Quantity adjustment. Avoid mixing a pricing project with a quantity cleanup unless you can review both confidently.
3. Check the file before upload. Keep the headers and reference columns intact. Filter the edited column for blank, unexpected, or extreme values. Confirm a handful of known rows by TCGplayer ID and price or quantity.
4. Import to Staged, not directly to live. TCGplayer validates headers, records, duplicates, and row values before it offers Save Updates. If validation finds an error, cancel with no changes or use Fix Errors to download, edit, or remove invalid rows.
5. Review the staged update. After validation succeeds, inspect the record-update count and the price or quantity deltas. Choose Cancel and View Staged Inventory if you need another look. Move to Live only when the staged changes match the job you intended.

This is the same round trip whether you're editing quantities or prices. Reimporting a repriced CSV back into TCGplayer follows the same export, edit, stage, and review pattern. The safety comes from making every large update reversible until the final Move to Live step.

The manual version is worth understanding even if you do not plan to run it forever. Hoard saves the source inventory and repriced CSV from each sync, and supports a review-first path before an upload. For where this workflow fits against the rest of an inventory system, see the inventory management guide.

Worked quantity correction: four listed, three counted

Illustrative example: the fresh export shows four copies of one exact printing and condition. A physical check finds three sellable copies, with no intervening sale or pending quantity change. The intended adjustment is 3 − 4 = −1. Entering 3 in Add to Quantity would add three copies; it would not set the stock to three.

Before moving the edit live, confirm the identifier, the expected −1 adjustment, and the resulting count. If an order arrives after the export, stop and reconcile that sale first. A correct subtraction against an old count can still produce the wrong inventory.

Common questions

What fields does the TCGplayer inventory CSV actually need to match?

Keep TCGplayer's exported headers and reference-only columns intact, including TCGplayer ID and product details. The usual editable fields are Add to Quantity and TCG Marketplace Price; Marketplace Price is required and must be at least $0.01.

Why does a CSV re-import sometimes overwrite the wrong listing?

The safer assumption is that an edited file needs validation before it is trusted. Import to Staged first: TCGplayer validates headers, records, duplicates, and row values, then lets you fix or remove invalid rows before anything is moved live.

Is it safe to edit yesterday's CSV export?

Use a fresh export for a live update whenever practical, and save the original untouched. The important safeguard is to review the exact staged deltas before moving them live, especially if sales or other edits may have happened since export.

How do I catch a bad CSV before I re-import it?

Check the edited column for blanks and extreme values, spot-check known TCGplayer IDs, then use Import to Staged. Resolve any header, duplicate, record, or validation errors and review the staged price or quantity deltas before choosing Move to Live.

Source: Importing and Exporting CSVs to Mass Update Prices and Quantities