Multi-Location Inventory Management: A Practical Guide for Art Galleries

Key takeaways:

• Disconnected records cost sales. When location, availability, and ownership live in separate files, every client question becomes an investigation, and ready buyers don't wait.
• Every work needs one shared record. It should show current location, status, ownership, consignment or loan terms, movement history, pricing, and sales context, and every team member should work from the same version.
• No work moves without its record moving too. Log each movement with a destination, date, owner, and next action, and confirm the location on arrival, not at shipment.
• Spreadsheets have a ceiling. Duplicate entries, stale availability, and version conflicts are signs your gallery has outgrown them.
• Choose software that connects inventory to operations. Locations, consignments, loans, sales, documents, and reporting should all draw from the same artwork record.

‍

A collector emails on a Thursday afternoon asking whether a painting from your spring show is still available. The answer should take thirty seconds. Instead, someone checks the exhibition spreadsheet, then the storage log, then messages the registrar, who thinks the work may have shipped to a fair in Miami last month. By the time anyone confirms where it is and whether it's on hold, the collector has moved on.

Multi-location inventory management is the practice of keeping one accurate record of every artwork's location, status, and terms as it moves between your gallery spaces, storage, art fairs, loans, and consignments. For galleries that operate across more than one site, it's the difference between answering a client with confidence or guessing.

This guide covers why disconnected records fail, what to track for each work, a workflow your team can follow from storage to sale, and how to tell when it's time to move beyond spreadsheets.

Why Multi-Location Inventory Breaks Down with Disconnected Records

Multi-location inventory breaks down when each part of the gallery keeps its own version of the truth. The exhibitions team tracks what's on the walls. The registrar keeps a shipping log. Sales maintains a list of holds and reserves. Storage has its own sheet, often updated only when someone remembers to walk over and check. Each record is accurate to the person who made it, and none of them agree with each other.

The problem compounds as your program grows. A gallery with two exhibition spaces, an offsite warehouse, and four or five fairs a year can have hundreds of works in motion at any given time. Add consignments from artists and secondary-market sellers, plus loans out to institutions, and the number of places a single work could be multiplies fast. When those movements live in separate files, every question about a work turns into a small investigation.

That investigation has a real cost:

• Missed sales. If your team can't confirm availability quickly, a ready buyer waits, and buyers at this level rarely wait long.
• Double commitments. A work gets offered to one client while it's already on hold for another, or promised to a fair while it's still committed to a museum loan.
• Eroded client confidence. Collectors and artists notice when the gallery isn't sure where a work is. Consignors in particular expect to know where their property is and who has seen it.
• Slow coordination. Shipping, installation, insurance, and invoicing all depend on knowing what's where. When location data is stale, every handoff needs a follow-up message to confirm.

Location accuracy is sales readiness. A work your team can locate, price, and confirm in one place is a work you can sell today. A work that requires three people and a spreadsheet hunt is, for practical purposes, unavailable.

What Galleries Need to Track Across Locations

Every artwork record should answer seven questions: where the work is, whether it can be sold, who owns it, what terms apply, where it has been, what it costs, and who has shown interest. If your current system can't answer all seven from a single record, gaps will show up at the worst possible moment.

The details matter less than one principle: every team member works from the same record. When the registrar updates a location, sales should see it instantly. When sales places a hold, the exhibitions team shouldn't be able to schedule that work for a show without seeing the conflict.

Separate versions create drift. One person's copy is updated on Monday, another's on Wednesday, and by Friday nobody is sure which is right. A shared record removes that question. It also makes accountability simpler, because every change is tied to a person and a date rather than buried in someone's local file.

Build a Reliable Workflow

A reliable multi-location workflow follows each work through five stages, and the record is updated at every one of them. The goal is simple: no work moves without its record moving too.

1. Create the artwork record. Do this the moment a work enters your care, whether it arrives from an artist's studio, a consignor, or a secondary-market purchase. Capture title, artist, date, medium, dimensions, images, edition details, ownership, and any consignment terms before the work goes anywhere else.
2. Assign a location and status. Be specific. "Storage" isn't a location; "Warehouse B, rack 4" is. Pair the location with a clear status so anyone looking at the record knows whether the work can be offered.
3. Log each movement. Every time a work leaves one place for another, record where it's going, the date, who authorized it, and the purpose: exhibition, fair, loan, framing, photography, or client viewing. Attach shipping documents, condition reports, and loan agreements to the record rather than storing them in a separate folder.
4. Update availability as the work moves. A painting on loan to a museum for six months isn't available for a client to take home next week, even if it's technically for sale. A work installed at a fair may be available but need a hold process the booth team can apply on the spot. Status should reflect reality, not just ownership.
5. Record the sale or return. When a work sells, update the status, link the invoice, and log its final shipment to the buyer. When a consigned work goes back to its owner or a loan comes home, close out the movement and confirm the work is back in a known location. A work should never sit in limbo between two states.

Checklist: What to Record Every Time an Artwork Moves

Most tracking errors happen at handoffs, when a work passes from one person or place to another. Use this checklist every time a work moves:

• Confirm the work's current location and status in the record before it leaves.
• Record the destination, expected arrival date, and purpose of the move.
• Note who authorized the move and who is responsible for it in transit.
• Attach the shipping document, condition report, and any loan or consignment paperwork.
• Update availability if the move affects whether the work can be sold or shown.
• Confirm arrival and update the location once the work is received, not when it ships.
• Note the next action and its date: return from fair, end of loan term, consignment review.
• Flag any condition changes found on arrival.

The last two items get skipped most often. A fair ends, works come back in crates, and nobody updates the records until a client asks about one of them weeks later. Assign one person to close out every fair and loan return within a set number of days, and make it part of their role rather than a favor.

When a Gallery Should Move Beyond Spreadsheets

In our 2026 Gallery Report, 51% of galleries say "reduces manual administrative time" is the most important thing they want from their gallery management software. A gallery should move beyond spreadsheets when keeping them accurate takes more effort than the work they're meant to support. Spreadsheets are flexible and familiar, and for a single space with a small inventory and one person managing it, they can do the job. The trouble starts when records move between people and locations faster than anyone can keep the files in sync.

These are the warning signs:

• Duplicate entries. The same work appears twice with slightly different titles, dimensions, or prices, and nobody is sure which row is current.
• Unclear locations. A cell reads "fair" or "out" with no date, destination, or responsible person.
• Stale availability. A work shows as available after it sold, or as on hold for a client who passed months ago.
• Version conflicts. Two people edit copies of the same file, and one set of changes overwrites the other. Someone emails "inventory_FINAL_v3" and the team works from that until a newer version surfaces.
• Difficult reconciliation. Closing out a fair, preparing an insurance schedule, or sending a consignor a status report takes hours of cross-checking between files.

If two or more of these sound familiar, your spreadsheets are already costing more time than they save, and the risk of a costly mistake grows with every new location or staff member. Large programs typically feel this first. More staff, more locations, and more works in motion mean more chances for a record to fall out of date, and a higher cost when one does.

The right move is a system that fits how your gallery actually operates: the number of people who need access, the locations you manage, the volume of consignments and loans, and how closely inventory needs to connect to sales and finance. Start from your workflow and choose tools that support it, not the other way around.

Choose Software That Connects Inventory with Gallery Operations

The best inventory software for a multi-location gallery connects each artwork record to everything that happens around it: locations, consignments, loans, sales, documents, and reporting. A tool that only tracks location solves one problem and leaves the rest scattered across email, shared drives, and accounting files.

When you evaluate options, look for a system where:

• Artworks and locations live in one record, with a full movement history your whole team can see.
• Consignments and loans are tracked with their terms, including dates and responsibilities, so nothing expires unnoticed.
• Sales activity connects to inventory, so a hold, offer, or invoice updates availability without a second step.
• Documents attach to the work, whether that's a condition report, shipping paperwork, or a consignment agreement.
• Reporting draws from the same data, so a consignor report, insurance schedule, or fair inventory list is generated rather than assembled by hand.
• Access works for the whole team, from directors to registrars to sales staff at a fair booth, with the right permissions for each role.

We built Artlogic Gallery Management to support exactly this kind of connected workflow. Your team works from one shared database of artworks, contacts, and transactions, so a location change, a new hold, or a completed sale shows up for everyone at once. Instead of reconciling separate files after every fair or loan, your gallery keeps one record per work and lets that record follow the work wherever it goes.

If your team is spending more time tracking works than selling them, talk to our team about how Artlogic can support your gallery's locations, people, and program.

Frequently Asked Questions

How do galleries track artwork across multiple locations?

Galleries track artwork across multiple locations by keeping one central record for each work and updating it every time the work moves. That record should show the current location, availability status, and a dated movement history, so anyone on the team can confirm where a work is and whether it can be sold without checking with a colleague.

How do galleries manage works at fairs or on loan?

Galleries manage works at fairs or on loan by recording the location, status, terms, and next action directly on the artwork record. For a fair, that means the booth, dates, pricing, and the return plan. For a loan, it means the borrowing institution, loan dates, insurance responsibility, and credit line. Setting a clear next action, such as a return date or a consignment review, keeps works from going untracked once the event ends.

Can a spreadsheet manage multi-location inventory?

A spreadsheet can manage multi-location inventory for a small gallery with a single person maintaining it. It becomes hard to control once several people edit records and works move regularly between spaces, storage, fairs, and loans. Duplicate rows, stale availability, and conflicting versions are common signs that a gallery has outgrown spreadsheets and needs a shared system.