Build a stock record that tracks the actual variants

A product name alone is often not enough to identify the piece in a wholesale order. The same style may have several lengths, colours or cap options, and those differences matter when you receive, store and sell the collection. A useful stock record follows the actual variant and records changes as they happen. You can begin with a straightforward spreadsheet or notebook, provided the entries are consistent and the physical items can be matched to them.

Choose an identifier before the order arrives

Keep the seller’s product and variant identifiers where supplied, including the SKU. Add your own internal reference only if it helps your workflow, and make clear that it is your reference rather than a manufacturer identifier. Do not overwrite the original information simply to make the record look cleaner.

Use separate fields for style, colour, length, cap option and any other selected specification. A compact sentence in one cell may be readable today but harder to sort or compare later. The purpose is to distinguish items that could otherwise be confused, particularly when their packaging or photographs look similar.

Prepare a receiving sheet from the order

Record what you ordered and the expected quantity for each variant. Leave a separate column for the quantity actually received. Keep the order reference and date so the receiving sheet can be connected to the purchase record without relying on memory.

When the shipment arrives, compare labels, quantities and condition against that sheet. Follow any inspection requirements supplied with the order and preserve the received condition while checking for discrepancies. If something does not match, document the exact line and contact the store through the appropriate channel. Do not change the expected quantity to match the box without recording the difference.

Separate physical stock from available stock

A unit can be physically present without being ready to offer to a customer. It may be awaiting inspection, reserved for an existing order, used as a display item or needing attention. Create status fields that reflect your actual workflow, and make sure each unit or quantity belongs to a clear status.

Avoid counting a reserved piece as both available stock and a completed sale. Define the point at which your records move it between stages. Consistency matters more than choosing elaborate software at the beginning. A simple process followed every time is easier to reconcile than several detailed sheets that disagree with each other.

Record movements as events

For each sale, return, adjustment or transfer, note the date, variant identifier, quantity and reason. This gives you a history to consult when the final count differs from expectation. A corrected total with no explanation may solve today’s number while hiding the source of tomorrow’s mismatch.

For example, if six units were received and one became a display sample, record the display movement explicitly. If two units were then sold, the remaining available quantity can be understood from the sequence. This is an illustrative workflow, not a rule about how your accounting system should value display stock; use the appropriate professional guidance for financial records.

Reconcile the shelf with the record

Choose a count routine that fits the size and activity of your collection. Count by variant and location, then compare with the recorded quantity. Investigate a difference before replacing the number. It may come from an unrecorded reservation, a misplaced item or a receiving mistake rather than an unexplained loss.

Keep stock locations simple and labelled. If the same variant lives in two places, record both so a partial count does not look like a shortage. When possible, avoid moving items during a count or clearly log those movements. The aim is to compare the same moment in the physical collection and the record.

Use the record to inform the next order

Review actual sales and enquiries by variant, not only by broad product category. A style may attract interest while one particular length remains slow to move. Keep that distinction visible when deciding what to reorder. Our focused assortment guide helps turn those observations into a buying brief, and the wholesale pack checklist brings the variant record back into the next purchase.