Back to blog

How to count consignment inventory and investigate mismatches

Check physical stock against item records, account for sales during the count, and resolve missing tags without losing the consignor connection.

A tagged cream pitcher, copper bowl and ceramic candleholders on a wooden display, with an open inventory notebook against a charcoal and copper backdrop.

A consignment inventory count should answer more than "How many items are here?" It should confirm which items are here, whose they are, and whether their records describe their current situation. A rack can contain the expected number of jackets while still holding the wrong jacket for one consignor.

Start with a manageable section, compare individual identifiers, and keep unresolved differences on a review list. Treat the count as evidence to investigate, rather than a reason to immediately delete or replace records.

Choose a count you can finish and review

A full stocktake covers the store. A cycle count checks a smaller portion on a recurring schedule. Shopify's guide to cycle counting describes this smaller, repeated approach as a way to verify stock and find discrepancies with less disruption than counting everything at once.

For a first consignment count, pick a clearly bounded area: one display cabinet, one rack and its overflow rail, or a named stockroom shelf. Include the places those items could reasonably be held, such as a fitting-room return rail or a pickup area. Define what is included before comparing totals.

Keep a simple coverage log with the area, count date, counter, reviewer and unresolved items. Rotate through the store so the convenient front display does not get checked repeatedly while the back room is missed.

Agree on the time and the selling unit

Record the time of the list or snapshot you are comparing against, and the start and end of the physical count. Sales, new intake and pickups between those points can explain a difference.

Shopify's inventory-count planning guidance highlights the timing problem when sales occur during a count. A quiet or closed period makes the comparison easier. If trading continues, keep a separate movement log for the area being counted and reconcile it before drawing conclusions.

Also settle what one item means. If two candleholders are sold together under one inventory record, count one selling unit and verify that both components are present. If they have separate records, check them separately. Note a missing component instead of letting an apparently correct set count hide it.

Match the physical piece to its record

For each selling unit, record or scan its identifier into your chosen counting worksheet. Compare the description and consignor reference with the actual piece. Use a temporary mark on the worksheet or a clear physical counting direction to avoid counting the same item twice.

The useful check is the connection between the item and its record. Scanning a readable tag does not establish that it is attached to the right piece. Two similar lamps may have different owners, prices or recorded condition.

Keep a short list of exceptions as you go:

  • An item listed in the count scope cannot be located.
  • A physical item has no readable tag or no matching record.
  • Two tags point to the same record when the pieces should be tracked separately.
  • The item is present, but its owner, description or recorded status needs review.

In ConsignEngine, individual inventory detail pages connect items to their consignors and show item status. Use those records as reference points alongside the physical check. This guide describes a staff counting process; it does not assume a dedicated stocktake session or an automatic count adjustment.

Reconcile movement before calling something missing

Imagine a fictional cabinet list with 24 individually tracked pieces at 9 a.m. During the count, one is sold and one is collected by its consignor. If both departures are supported by the appropriate records, you would expect 22 pieces to remain from that starting list.

Finding 22 is a useful total check, but it is not the end. Confirm the identifiers of the 22 remaining pieces. One missing item and one unrelated item could otherwise cancel out numerically.

Keep any newly received pieces separate from that starting list until their arrival is accounted for. Do not mix a current list with an earlier physical count and describe the resulting difference as a loss.

Give each mismatch a specific next step

For an expected item you cannot find, check the places and records most likely to explain it: another display, a fitting-room rail, a reserved pickup area, a completed sale, a documented return to its owner or a recent move. Ask a second person to recount the affected area before closing the investigation.

For an untagged piece, use its description, distinguishing features, intake notes and any existing reference photos to look for a match. Set it aside while its identity is unresolved. Do not attach the tag from a similar item simply to get it back onto the floor.

For a status mismatch, establish what actually happened and when. A returned item still shown as available and an available item incorrectly shown as sold need different reviews. A count alone does not justify rewriting a completed sale or changing a consignor's earned balance.

Record the finding, supporting reference, reviewer, action taken and any remaining question. If a correction is needed, use the appropriate authorized workflow and preserve the history. Avoid deleting and recreating an item just to make the list look tidy.

Fix the handoff that produced the discrepancy

A useful count ends with a cause you can act on. Repeated missing tags may call for a better attachment method. Items left in a pickup area may reveal an incomplete return handoff. Duplicate records may point back to intake.

Our consignment intake checklist covers the item-to-owner connection when stock arrives. The unsold inventory guide covers the review and departure process when its selling period ends. Use those handoffs to prevent the same discrepancy from reappearing at the next count.

Finish with three short results: the areas checked, the differences resolved, and the exceptions still assigned to someone. Keep that review with your count notes. You should be able to explain both what is on the shelf and what still needs an answer.

Your privacy choice

Google Analytics and Meta Pixel are active by default. Choose Necessary only to opt out. Privacy Policy.