Card workflow status

Every card in the vault has a workflow_status — a single value that says where in your process the card currently is. Status is set automatically as you work, but you can also override it manually.

The six stages

1. imported — the card row exists; basic data is in (a photo or a CSV row), but identification hasn't been confirmed yet.
2. identified — set, number, player, and variant are filled in (either by AI or by you).
3. priced — at least one of asking_price, purchase_price, or pricecharting_price is set.
4. photographed — you've attached final listing-quality photos (separate from any initial scan).
5. listed — an eBay listing has been published and is currently active.
6. sold — the listing closed with a sale.

Two terminal-ish states sit alongside the main flow:

• needs_review — AI identification failed or was low-confidence; awaiting your input.
• archived — card is no longer in inventory (sold long ago, lost, traded).

How status updates

The vault advances status automatically when the relevant data changes:

• Saving an identification → identified
• Setting an asking price → priced
• Uploading new "listing" photos → photographed
• Publishing to eBay → listed
• eBay reports a sale → sold

You can also override status manually from the card detail page or via bulk-edit on a batch. Useful when you want to mark a card as photographed even though the source photos are the listing photos.

Why bother

Status is the foundation of three big workflows:

• The Dashboard counters — "12 cards need review, 47 need pricing, 23 ready to list."
• Batch progress bars — visual percentage through each stage.
• Filtering inventory — "show me every card priced but not listed" is the workhorse query.

Once Wave 2 Automation Rules ship, rules will trigger on status changes (e.g. "when a card hits priced, generate a SKU using the inventory settings format").

What "listed" really means

listed requires an active eBay listing record. If the listing ends without selling, the card moves to identified (or priced) — not back to imported. The vault assumes if you got it identified once, it's still identified.

Archiving vs deleting

Don't delete cards you've sold — archive them. Archived cards stay in the database for P&L reporting, tax records, and historical search. Deleting actually removes the row and breaks references in your sold listings.