Import and export inventory with CSV

CSV import adds many inventory items at once. Allow time to review the first import from a new source.

CSV import requires Manage inventory. Buy price, all-in cost, minimum price, and notes additionally require View financials. Without it, those columns are ignored or left unmapped in both preview and import.

Prepare the file

1. Open the import area in Inventory.
2. Download the current template.
3. Move your data into the provided columns.
4. Remove empty trailing rows, merged cells, and decorative headings.
5. Save the result as a CSV file.

Use the current template even if you already maintain your own spreadsheet. This makes field mapping more predictable.

Choose the file currency during import. Mixed currencies are supported when a mapped currency column or an individual money value contains a supported code or symbol. The preview shows the conversion into your dealer workspace's base currency.

Run a small test first

Create a copy with 20 representative rows for your first run. Include cards, stackable items, empty optional fields, and pricing.

For Card, one row represents one physical copy and quantity must be one. Multiple identical cards require multiple rows. For a stackable non-card type, quantity_on_hand can contain a larger starting quantity.

Review the preview

Before importing, pay close attention to:

• correctly recognized columns,
• consistent numbers, quantities, status values, and currency codes,
• warnings about required values,
• empty or invalid rows,
• unexpectedly empty prices or conditions.

Complete the import only when the preview looks plausible.

A file may contain no more than 1,000 data rows and 2 MiB. Split larger inventories into controlled batches.

Understand duplicates and retries

The preview does not compare the file with existing inventory for possible attribute duplicates. Multiple identical rows in one file are treated as separate physical items in their file order.

Re-importing the same unchanged file is idempotent: CaseLink recognizes each repeated row occurrence in order and skips the corresponding record when it already exists.

Import never updates an existing inventory record. Changing only prices or notes does not update the previously imported item. Changing identity data can create a new record instead. Check Inventory before retrying or importing a revised file.

Export inventory

1. Open Inventory.
2. Select Export CSV.
3. CaseLink downloads caselink-inventory.csv with every non-voided inventory record. The current search, filters, and status selection do not limit the export.

The export contains these columns in order:

name, player, sport, year, set_name, manufacturer, card_number, parallel,
serial_number, grade, grading_co, cert_number, condition, sticker_price,
buy_price, all_in_cost, min_price, status, storage_location, image_url,
notes, item_type, quantity_on_hand, language, rarity

Records are sorted by creation time, newest first. Exporting does not require Manage inventory. Private cost columns are populated only with View financials; without it, they remain empty.

Exported money values are already in the dealer workspace's base currency, so the export has no separate currency column. The parallel column maps to the Parallel / Variation field shown in CaseLink.

The export works as a controlled backup and maps back into the CSV importer. It is not a replacement for a complete database and image backup.

Verify the result

Filter Inventory for the newly added items and open several samples. Check item type, identity, quantity, pricing, and status.

Do not restart an import only because the screen is still loading. First verify whether records were created.

Continue with Inventory types, quantities, and status, Find and bulk edit inventory, and Use pricing fields correctly.