Compare Vendor Price List CSV Files Before Quarterly Negotiation

Vendor price lists look simple until procurement needs to compare them. One supplier uses item codes, another uses internal SKUs, a third changes pack sizes, and the newest file may include discontinued items beside current products.

A local-first workflow with DataOlllo lets procurement teams prepare negotiation evidence without uploading supplier terms to a third-party web tool.

Price List Fields to Normalize First

Field	Common variation	Recommended normalized column
Supplier SKU	SKU, Item, Vendor Item, Product Code	`supplier_sku`
Internal SKU	Item ID, Part No, Product	`internal_sku`
Pack size	Case, Each, Units per carton	`pack_units`
Currency	USD, EUR, local currency symbols	`currency`
Effective date	Date formats vary by file	`effective_date`
Unit price	Net, list, contract, promotional	`unit_price_type` and `unit_price`

The goal is not to make every supplier look identical. The goal is to make differences explicit enough that a buyer can ask the right question.

A Practical Comparison Flow

Import the current and previous vendor CSV files.
Rename columns into a shared schema.
Filter to active products and current effective dates.
Join vendor SKUs to internal SKUs using the approved mapping table.
Flag rows where price changed, pack size changed, or the SKU disappeared.
Export a supplier-by-supplier review file before the negotiation meeting.

Review Matrix

Review area	Signal	Buyer action
Price increase	Same SKU, higher normalized unit price	Ask for volume tier or explanation
Pack size change	Same item, different unit count	Recalculate true per-unit cost
Missing SKU	Previously purchased SKU absent	Confirm discontinuation or replacement
New SKU	New code with similar description	Check for renamed items
Currency change	Same supplier, new currency	Confirm contract basis

Why Local Processing Matters

Supplier pricing can contain commercial terms that should not drift into random online tools. Running the comparison locally keeps the raw files and intermediate joins inside the procurement team's environment.

DataOlllo is not a replacement for negotiation strategy. It is the preparation layer that helps buyers arrive with cleaner facts.

Download DataOlllo

Prepare vendor comparison files locally with DataOlllo: download DataOlllo.