How to Build Supplier Files That Truly Add Value in Procurement

During a conversation with a manufacturing‑procurement colleague, the author discovers that despite having over 80 fields for more than 300 suppliers, the procurement process is still disorganized. The core problem is not the lack of a supplier file, but that the file functions merely as a data repository instead of a management tool.

Key Insight: Supplier management should focus on making procurement decisions observable, traceable, and predictive. A useful supplier file must answer five questions:

Who is the supplier?

What do they supply?

Are they reliable?

How are they performing now?

Can they continue cooperating in the future?

If a field does not address these questions, it is considered a decorative field.

Six Essential Field Categories

1. Supplier Identity Information

Fundamental fields that support all downstream processes:

Supplier Code (unique identifier)

Supplier Name

Type (raw material / processing / logistics / service)

Grade (A/B/C)

Status (active / paused / eliminated)

Using a unique code prevents duplication and enables consistent linking across purchase orders, inventory, quality, and accounting records.

2. Supply Capability Information

Beyond price and relationship, the critical factor is stable supply. Recommended fields:

Supply Category

Production Capacity Range

Lead Time

Minimum Order Quantity

Stock‑piling Capability

Without these, issues such as strong order‑taking ability but weak delivery, low pricing with insufficient capacity, or verbal commitments that lag in response remain hidden until a problem occurs.

3. Quality Performance (Data‑Driven)

Qualitative statements like “quality is okay” are unmanageable. Mature systems record quantitative metrics:

Incoming Material Pass Rate

Return Rate

Number of Quality Complaints

Quality Penalty Amount

Number of Defective Batches

Example: Supplier A – Pass Rate 98%; Supplier B – Pass Rate 85%.

4. Delivery Performance

Timeliness is the biggest supply‑chain risk. Capture:

On‑time Delivery Rate

Number of Delays

Average Delay Days

Emergency Order Response Capability

Scenario: Production plans are ready, but material delays halt the line, yet the file only notes “good cooperation,” illustrating information distortion.

5. Price and Cost Volatility

Recording only the current price ignores trends. Valuable fields include:

Historical Price Curve

Price Increase Frequency

Annual Volatility Range

Occurrence of Sudden Price Spikes

Example comparison: Supplier A – 10 → 12 → 15 over three years; Supplier B – stable at 11. Without data, selection relies on intuition.

6. Cooperation Risk Information

Often omitted, yet critical for long‑term decisions. Record:

Major Quality Incidents

Supply Interruptions

Legal Disputes

Financial Risks

Penalties / Complaints

These factors influence the decision to continue cooperation.

Why Procurement Remains Chaotic

Data exists in isolated silos: supplier files in Excel, orders in WeChat groups, accounting in finance systems, quality in inspection sheets, delivery in production plans. The lack of a closed data loop means no one truly “sees” the supplier.

Building a Data Chain

Mature enterprises treat each supplier as a traceable object, linking all actions to the supplier:

Purchase Order → Supplier

Inbound Record → Supplier

Quality Record → Supplier

Reconciliation Record → Supplier

When opening a supplier file, users can view yearly supply count, quality trend, on‑time delivery rate, total spend, and risk score changes.

Although many companies use platforms like 简道云 to build such systems, the goal is not mere digitization but converting suppliers from “contacts” into “computable objects.”

Final Takeaway

The true value of a supplier file lies in its ability to continuously evaluate a supplier within the system, enabling ongoing elimination of unsuitable partners and amplification of high‑performing ones.