Why antiques are not SKU-bin retail
A box of identical modern candles can be counted as twelve units of one SKU. A Victorian dresser cannot. Antique and collectibles dealers mostly manage unique items (or very small lots) where condition, provenance notes, and photos matter as much as quantity. Spreadsheet rows that only store “chair – 1” lose the detail that justifies price and proves what you still have.
Consignment is common: the shop does not own every piece on the floor. Mixing consigned and owned inventory without ownership fields creates payout disputes and false margin reports when something sells.
Dealers often sell across a physical shop, antique mall booths, fairs, and online marketplaces. A unique item listed in two channels without inventory sync is how you get a double sale and a refund headache, and a damaged reputation with buyers who expected the piece they reserved.
Unlike commodity retail, turn rates are uneven. A mid-century lamp may sell in a week; a niche ceramic lot can sit for months. Inventory software for antiques has to support item-level truth and aging, not just reorder points designed for fast movers.
What to track for unique items and small lots
Give each unique piece an identifier (SKU, tag, or barcode) and store location, cost or consignment terms, asking price, condition notes, and channel status (on floor, in booth, listed online, sold, returned to consignor). Small lots of similar smalls can share a SKU with a quantity, but high-value pieces should stay one-to-one.
Receive and tag items when they enter the shop so nothing sits in a back room unlisted. When an item moves to a booth or photographer’s queue, transfer location in the same step, physical move and system move should be one habit, not a weekend catch-up.
StockFlow supports item-level stock, locations, and barcode workflows so a dealer can see what is in the shop versus a booth, keep consignment separate with clear records, and avoid selling the same unique piece twice.
- Unique ID/tag per high-value piece
- Ownership: owned vs. consignment terms
- Location: shop, booth, storage, photo queue
- Channel status so online listings match on-hand
- Condition grade and short provenance or maker notes
- Cost/basis and asking price for margin after sale
Intake workflow: tag, grade, photograph, list
Strong antique inventory starts at intake. Unpack, assign a tag, note condition (chips, restorations, odors, working parts), and capture at least one clear photo before the piece hits the floor. Items that skip this step become “mystery stock”, hard to price, hard to list online, and easy to lose in a crowded booth.
A simple status path works for most dealers: received → tagged → photographed → priced → on floor / in booth / listed online. Moving an item through those states in the same system that holds quantity and location keeps the sales floor and the online catalog aligned.
For lots of smalls (buttons, postcards, costume jewelry), batch intake with a lot ID and quantity is fine. For furniture, clocks, art, and signed pieces, treat each unit as its own record from day one.
- Tag at receiving, before the piece goes to the floor
- Condition notes written once at intake, updated after restoration
- Photo queue as a real location or status, not a sticky note
- Lot IDs for low-value smalls; unique IDs for high-value singles
Consignment payouts and aging stock
Track consignor, split, and days-on-hand so you know what to renew, markdown, or return. Aging unique inventory ties up floor space; a monthly aging view beats discovering dead pieces only during a full shop reset.
When a consigned item sells, the sale should reference the consignment record so payout math is reproducible, not reconstructed from memory and a paper tag. Include intake date and agreed terms so staff who did not take the piece in can still settle correctly.
Set review checkpoints (for example 60 or 90 days) to renegotiate split, reduce asking price, or return stock to the consignor. Without aging alerts, shops keep displaying pieces that stopped earning their footprint months ago.
Condition, provenance, and insurance values
Buyers and insurers care about more than “antique chair.” Maker marks, period, known restoration, and ownership history support asking price and protect you if a piece is damaged, stolen, or disputed. Store those notes on the item record so they travel with the tag, not only in a binder that stays in the office.
For higher-value pieces, log an insured or replacement value separately from cost and retail. That figure is what you need after a booth flood or break-in; cost-only spreadsheets understate exposure when many items were bought cheaply at estates but sell at collector prices.
Authenticity and attribution should stay conservative in the system: record what you know (signed, labeled, attributed to, style of) so marketing copy stays honest and staff do not invent certainty at the counter.
Estate buy-ins and mixed lots
Estate and auction buy-ins often arrive as mixed lots: one purchase price covering dozens of pieces of unequal value. Inventory systems that only store a single lot cost make it hard to know which items earned their keep after sell-through.
A practical approach is to create the lot, then split or allocate cost across individual tagged pieces as you process them, even rough allocations beat leaving everything as one opaque “estate box” forever. Pieces you decide not to keep can be noted as liquidated, donated, or discarded so the lot does not haunt your on-hand counts.
Dealers who buy frequently benefit from linking purchase source (estate, auction house, picker, private seller) on each item for later margin analysis by source, not only by category.
Shop, booth, and online as one inventory
Treat every selling surface as a location or status. Listing online should reserve or mark the item so the floor team does not sell it to a walk-in. When it sells in either channel, mark it sold once and pull sibling listings the same day.
Antique mall booths and weekend fairs add another layer: stock physically leaves the shop. Transfer items to a booth location when you load the van, and transfer back what returns unsold. That habit is what makes “what is still at the mall?” answerable without a midnight booth count.
If multiple staff list to marketplaces, require that listings reference the internal item ID. Free-form titles without a link to stock are how double listings of the same unique piece happen.
Pricing, markdowns, and floor-space ROI
Unique inventory does not reorder itself when it sells, but slow movers still cost rent. Track days on hand and last price change so markdown decisions are based on data, not only on which piece you are tired of looking at.
Category-level reports (furniture vs. glass vs. textiles vs. ephemera) show which parts of the shop earn their square footage. Dealers often discover that a crowded corner of low-turn furniture is subsidizing faster smalls, insight you only get when each piece has a sell date and a holding period.
For owned stock, compare realized margin to days held. For consignment, compare commission earned to space used so you can tighten intake standards with consignors who fill booths with slow pieces.
Related resources
- Consignment inventory software
- Furniture store inventory management
- Jewelry inventory management
- Home decor inventory management
- Retail inventory management
- Multi-location inventory control
- Salon and spa inventory management
- Emergency response inventory management
- Cosmetics and skincare brand inventory management
Run your antique shop from one stock list
Tag unique pieces, separate consignment from owned stock, and keep shop, booth, and online channels in sync, free to start.
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”