Parsing 400 Supplier Quotations Into One Table: What Actually Breaks

I went through roughly four hundred quotations from soft-toy suppliers in Yiwu and tried to put them into one comparable table. The interesting part was not the price data. It was how many different things a quotation can mean when nobody defines the columns.

Here is what the same "unit price" turned out to mean across suppliers: price per piece for a single design; price per piece assuming a fixed assortment; price per inner box; price per carton with the piece count to be confirmed later; and price per piece for the polybag version with display boxes quoted separately.

Five different meanings, one column heading.

The four columns that fixed it

Rebuilding the table with explicit columns removed almost all of the ambiguity:

• unit_basis — piece / inner box / carton
• pieces_per_carton — a number, not "as per assortment"
• packing_type — polybag / display box / header card
• trade_term — FOB / DDP / EXW, with the named port

Once those exist, quotes become comparable without a conversation. Anything that cannot be filled in is not a quote yet, it is an enquiry.

The failure mode nobody warns about

The subtle one is pieces_per_carton for mixed assortments. Suppliers often quote "200 pcs per carton" where 200 is a capacity, not a commitment — if the assortment mixes large and small shapes, the real count per carton can land anywhere between 160 and 220 depending on how the packer fills voids.

That single ambiguity moves freight cost by more than a small price negotiation does, because volumetric weight is calculated per carton.

What I would do differently

Ask for the carton breakdown in writing before comparing anything: pieces per inner box, inner boxes per outer carton, carton dimensions, gross weight. Those four numbers decide landed cost far more than the quoted rate.

If you want to see how the categories are actually grouped for wholesale buyers, the assortment is laid out by family in the product catalogue, and the buyer-facing version of this same problem is written up in the wholesale guides.

The tooling is not the hard part. Agreeing what the columns mean is.

---

Written by Zhao Jin, sales at Yiwu Jinji Trading Company (King Squishy), a Yiwu-based supplier of wholesale squishy and fidget toys working with partner workshops. [e-mail] · WhatsApp [phone].