How to read a supplier stock list without misreading the deal

Image: AI-generated illustration of supplier stock list.

A supplier stock list looks precise because it contains rows and numbers. That does not mean every column has the meaning you expect. A quantity may describe total warehouse stock rather than stock available to you. A price may apply only above a minimum order. Before comparing suppliers or importing a file into your system, work out what the list actually represents.

Establish the date and availability basis

Check when the file was produced, how often the supplier updates it and whether it is a live offer or an indicative catalogue. Ask whether quantities are available for immediate allocation, already committed to other customers or subject to sourcing. A dated export can be useful, but it should not be presented to your customers as guaranteed stock.

Confirm how stock is reserved. Some suppliers allocate goods only after payment; others reserve them after accepting a purchase order. If you sell before confirming availability, your apparent margin can disappear into refunds, customer support and replacement purchases. Keep the list’s update time visible wherever your team uses it.

Translate identifiers and descriptions

Use product identifiers to distinguish similar descriptions. A supplier SKU identifies a record in that supplier’s system, while your SKU identifies your own item. A barcode can help match a product, but differences in packaging and variants still need checking. Preserve the supplier’s original identifier alongside your internal mapping so an error can be traced.

Read condition and grading columns carefully. New, sealed, refurbished, open box and used are different offers. Ask what is included: retail box, charger, cables, manuals, accessories or warranty support. For mixed lots, request the composition and the permitted variation. An average description may hide a wide spread of resale values.

Resolve the units behind the numbers

Determine whether quantities refer to pieces, pairs, cases, cartons or pallets. Find the case pack and order multiple. A supplier listing 50 cartons of 24 items is offering a different volume from a supplier listing 50 individual items. Convert both offers to the same unit before comparing prices.

Check the price basis, currency and treatment of delivery and other charges. Ask whether the displayed price depends on ordering a whole lot, buying a particular assortment or meeting an account threshold. Identify whether an apparently low price is a deposit, a starting price or a complete unit price. Record the supplier’s explanation rather than relying on a spreadsheet heading.

Clean the data without losing the evidence

Keep an unchanged copy of the original file, then work on a separate import version. Preserve leading zeros in identifiers, avoid automatic date conversion of model numbers and check decimal separators. Spreadsheet software can silently alter data that looks numeric, leaving a product match wrong even though the row appears tidy.

Validate a sample of imported rows against the source before using the list commercially. Check duplicated identifiers, missing currencies, negative quantities and improbable prices. Do not automatically merge products just because their descriptions look similar; a small difference in specification can be the reason one is cheaper.

When you request a quotation, name the exact rows, quantities and file date. Ask the supplier to confirm availability and the complete commercial terms. A stock list is a starting point for purchasing, not a substitute for an accepted order. Reading it carefully protects both your buying decision and the accuracy of the offers you pass on to customers.