Reading a Wholesale Price List: The Columns That Matter and the Ones Missing

18 July 2026 · The Glow Trade

Two wholesalers send their K-beauty price lists on the same day. One is a forty-megabyte spreadsheet with nine thousand rows, product names in three languages, and prices. The other is a portal login with half the products but EAN codes, case packs, stock levels and an expiry policy per line. The buyer who judges by assortment size picks the first and spends the next month discovering what the missing columns cost.

A price list is not a catalogue; it is the supplier's operational honesty in spreadsheet form. The columns it has tell you how they run their warehouse. The columns it lacks tell you which surprises you will meet later.

The short version

A usable price list carries, per line: EAN or GTIN, case pack, net wholesale price, RRP, stock status, and an expiry or shelf-life policy. Anything less shifts the work and the risk to you.
Compare two lists like-for-like only after equalising currency, Incoterm, case quantities and what the price includes, because the cheapest column wins every naive comparison.
The format itself is information: a supplier whose list has live stock, documents and clean data runs the kind of operation that answers damage claims in days.

The columns that decide your work

The EAN or GTIN first, because it is the product's identity across your till, your online shop, your marketplace listings and your reorder sheet; a list without identifiers forces you to match products by name, and "Rice Toner 150ml" matches three products and none of them reliably. Case pack second, because it rewrites your quantities, per the minimums article. Net price and RRP third, together, because the margin conversation starts there, with the net-versus-gross discipline from the margin article applied before any comparison. Stock status fourth: a list that shows what is actually in the warehouse saves the weekly farce of ordering into backorders.

Then the two columns almost no list has and every buyer should demand. The expiry or minimum-shelf-life policy: what remaining life the supplier guarantees on delivery, in writing, because cosmetics come with a clock and the receiving discipline of the batch code guide only works if the promise exists. And the data package: whether images, descriptions and product data come with the list, and with what usage rights, per the product data article, because nine thousand products without usable data is a list you cannot sell from.

The columns that mislead

Discount columns: "30 percent off RRP" means nothing until the RRP's realism is checked against the actual street price, and inflated RRPs are the oldest trick in wholesale marketing. Popularity badges: "bestseller" on the supplier's list measures what the supplier sells, which overlaps imperfectly with what your shop will sell. And the currency column, when the list is in won or dollars: a price that looks better than the EU wholesaler's by eight percent can evaporate in the exchange rate and the freight, which is why comparisons run on landed cost or not at all, per the landed-cost article.

The comparison protocol

Comparing two suppliers on their lists is a five-step flattening. One: match products by EAN, not name, and accept that the overlap between two lists is smaller than the lists suggest. Two: equalise the commercial terms to the same currency, the same Incoterm and the same included costs. Three: normalise quantities to the unit, after case packs. Four: price your actual basket, the fifty SKUs you will really buy, not the list average, because wholesalers win and lose on different lines and the basket decides. Five: price the invisible columns, the expiry policy, the data package, the damage handling, because a two-percent price gap reverses the first time a short-dated pallet arrives.

The column checklist

PRICE LIST CHECK, per supplier

[ ] EAN/GTIN per line
[ ] case pack + per-SKU minimum per line
[ ] net price + currency + Incoterm stated
[ ] RRP per line (and is it the real RRP?)
[ ] stock status: live, dated, or "on request"?
[ ] expiry / minimum-shelf-life guarantee in writing
[ ] product data + image package with usage rights
[ ] tier thresholds and what counts toward them
[ ] lead time per line or per brand
[ ] damage/short-shipment policy, claim window in days
missing 3+ -> expect the surprises to arrive with the pallets

Questions buyers ask

The supplier's list is huge but has no stock levels. How do I plan?

You do not, on that list alone: a no-stock list is a wish list, and planning around it means confirming availability per order and accepting that a share of lines will come back unavailable. The workaround that keeps such suppliers usable: treat them as the breadth source for products with flexible timing, run your heroes through a supplier with live stock, and keep a substitution line for every traffic product, as the bestseller rules require. Ask also how often the list updates; a weekly-refreshed flat list beats a beautiful portal from last season.

Is a portal better than a spreadsheet?

For the daily work, usually yes: live stock, order history, invoices and tracking in one place remove a dozen emails per month. But the portal is a wrapper, and the checklist applies to what is inside it: a portal without EANs, case packs, expiry policy and data rights is a spreadsheet with a login. Judge the data, not the interface, and remember the spreadsheet has one advantage portals rarely match: it is yours to filter, annotate and keep, which is why the best working setup is often the portal for ordering plus the exported list for planning.

How often should I re-compare my suppliers?

Formally, once or twice a year, and whenever a structural thing changes: a currency move, a freight shift, a tier you newly qualify for, or a new brand you want that only one of them carries. The full protocol takes a day with the flattened basket, and it is one of the highest-paid days in retail, because supplier drift is real and the list you chose eighteen months ago may no longer be the list you would choose today. The tier lever inside that comparison is in the volume tiers article.