How to read a supplier stock list without misreading the deal

Image: AI-generated illustration of supplier stock list.

Open a supplier stock list and it is easy to start calculating margins straight away. Fifty available, an attractive price, a familiar product name: perhaps there is a deal here. But fifty what? Individual items or cartons? Available today or waiting for another buyer’s payment? A neat spreadsheet can contain a surprisingly untidy offer. Read the meaning of the columns before you get excited about the numbers.

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.

The crucial question is when those goods become yours to promise. Does an accepted purchase order reserve them, or does allocation happen only after payment? Until you know, avoid turning a supplier’s quantity into a guarantee on your own website. A stock list that was accurate yesterday can still produce an embarrassing customer conversation today.

Same description, different goods

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.

Take two rows that both show a quantity of 50. If one means pieces and the other means cartons of 24, they describe 50 items and 1,200 items. That is a different buying decision, not a minor formatting issue. Find the case pack, minimum and order multiple, then put both offers into the same unit before comparing the price.

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.

Keep the original, however messy

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 find a promising row, send it back to the supplier with the file date, product code and quantity you want. Ask for confirmed availability and a complete quotation. That short exchange is where a spreadsheet entry becomes an actual offer. Keep the original file too: if the wrong variant turns up later, being able to show exactly what you asked for is far more useful than remembering that the list “looked clear”.