Short answer: good artwork inventory management means one authoritative record per artwork — images, details, provenance, location, status and documents — that everyone in the gallery reads from and writes to. Set it up in six steps: define the record, photograph to a standard, fix a status vocabulary, track locations, attach documents to the record, and reconcile on a schedule. A spreadsheet survives under ~50 artworks; beyond that, dedicated gallery software pays for itself in avoided mistakes.
Ask three people in a gallery "is this piece available?" and you will often get three answers: the spreadsheet says one thing, the inbox another, and the gallery manager's memory a third. Artwork inventory management is the discipline that ends that — and it is mostly process, not software. This guide gives the process.
What artwork inventory management is
Definition: the practice of maintaining a single, authoritative record per artwork — images, artist, details, provenance, edition, physical location, commercial status and documents — and running every question ("is it available?", "where is it?", "what did it sell for?") against that record. The catalogue is the source of truth; the website, offers and invoices are views of it.
The six steps to a clean inventory
- Define the record. Agree the fields every artwork must have before anything else (the checklist below). Without a standard, every entry becomes a negotiation.
- Photograph to a standard. One master image per work — consistent lighting, angle and colour reference — with crops derived from the master, never re-shot. Our guide to the studio-to-website photo workflow covers the pipeline.
- Fix a status vocabulary. Exactly five: available, reserved, sold, on loan, in transit. Anything else ("maybe", "held for John") belongs in a note with a date, not in the status field.
- Track locations, not just ownership. Stockroom shelf, consignment, fair booth, framer, client's home on approval — the location explains the status and prevents the classic "it's somewhere in the storage" afternoon.
- Attach documents to the record. Certificates, condition reports, invoices, shipping paperwork. A document that isn't attached to its artwork might as well not exist.
- Reconcile on a schedule. Monthly: review statuses and locations changed that month. Yearly: full physical check. Block it in the calendar before the two busiest selling periods.
What to record per artwork — the field checklist
| Group | Fields |
|---|---|
| Identification | Internal reference · artist · title · year · medium · dimensions (H×W×D) · edition size and number · signature/numbering |
| Images | One master photo · approved crops (website, proposal, print) · installation views if any |
| Commercial | Status (the five-word vocabulary) · price or price range · owner/consignor and split · invoice history |
| Physical | Current location · framing · condition notes · weight and crating for shipping |
| History | Provenance · exhibition history · literature · certificates and attached documents |
Editions and variants
Editions are where spreadsheets die. Model an edition as one parent record with numbered child records — so AP 2/10 and 7/10 can sit in different cities with different statuses without corrupting the parent's history. If your current tool can't do this natively, that's a sign to move (see: what gallery software costs in 2026).
The five mistakes that cost real money
- Duplicated truth. One list for the website, one for sales, one for accounting — and three prices. The catalogue must be the only place a price lives.
- Statuses nobody trusts. If "reserved" sometimes means "sold but don't tell anyone", the whole vocabulary collapses. Notes carry nuance; statuses stay binary.
- Images without records. A beautiful TIFF in a folder, unlinked, is unsellable. The image lives on the record.
- Edition chaos. Numbered children as free-text rows guarantee double-selling an edition eventually.
- No exit test. Keep the inventory somewhere you can export in open formats. An inventory you can't leave owns you.
Spreadsheet or dedicated software?
Honest threshold: under ~50 artworks, a handful of artists and one user, a disciplined spreadsheet plus a free image tool (ours: the in-browser Image Editor for true-scale room previews) is enough. Cross any of those lines and the failure mode is silent — errors surface as a double-sold edition or a wrong price on a proposal. When that threshold nears, our comparison of the main gallery platforms lays out the options; and if collector follow-up is slipping while you're at it, read how to manage collector relationships next.
FAQ
What is artwork inventory management?
Keeping one authoritative record per artwork — images, details, provenance, location, status, documents — and running availability, price and location questions against that single source instead of memory and scattered files.
What should a gallery record for each artwork?
At minimum: identification (artist, title, year, medium, dimensions, edition), one master image with approved crops, commercial fields (status, price, owner, invoices), physical fields (location, framing, condition) and history (provenance, exhibitions, documents).
How do galleries track editions without double-selling?
One parent record per edition with numbered child records per print — each child carries its own location and status. Free-text rows in a spreadsheet are the usual cause of double sales.
How often should inventory be audited?
Monthly light reconciliation of changed statuses and locations; a full physical audit yearly, timed before peak selling periods.
One record per artwork, one source of truth
Art Gallery CRM keeps inventory, images, documents and collector history in one EU-hosted workspace. Try it free for 15 days.
Start the free trial