Supply Chain Traceability Maps
A supplier register already holds the tier, the site and the audit date. A map arranges those rows by place, and that is all it can honestly claim to do.
The supplier register is eleven columns wide. Most of it has not changed since the last quarter. Two rows spell the same mill differently, and the audit column reads pending for the suppliers whose review lapsed in the spring.
The map drawn from that register adds no new facts. It arranges the same ones by place, and that distinction decides what the published map can honestly claim.
Three fields carry most of the story
Tier, site, status. Tier says how far the supplier sits from the finished product. Site says where the work happens. Status says what the last review found and when it happened.
The rest of the register, volumes, contract terms, contacts, purchase prices, belongs in the systems that already hold it. A public map carrying commercial terms is a document nobody can keep accurate for a month.
Status is the field that causes trouble, because a marker coloured by audit result reads like a claim. The map cannot make that claim. It can show that a review happened on a date, by a named body, with the report filed where a buyer can request it. The step from that record to a conclusion about a supplier is inference, and inference is what an auditor is paid to check.
What due diligence actually asks for
The OECD Guidelines for Multinational Enterprises ask companies to carry out risk-based due diligence across their operations, supply chains and business relationships. The framework expects companies to prioritise the most significant impacts and to keep the process running over time. It does not hand out a pass mark that a map can display.
European rules point the same way. The Corporate Sustainability Due Diligence Directive requires large companies in scope to identify and address adverse human rights and environmental impacts in their chains of activities, with public communication as part of the duty.
Read together, both put the weight on the process and its record. A map of supplier sites can show where the process has reached and where the record is thin. That is a narrower claim than "sustainable supply chain", and it survives a follow-up question.
Turn register rows into sites
Import the sheet and answer three questions in the preview: which column gives the position, which gives the label a reader sees, and which becomes the text inside the place. Those choices are the whole conversion from a row to a supplier site with its own note.
Set the note column to the field that holds the audit body, the review date and the certificate reference. Every marker now carries its citation. When someone asks how you know, the answer sits on the marker in the same words as the register. Where the register has no date, the marker has no date, and the gap shows up in public, where it will be asked about.
That property is worth more than any visual polish. A traceability map is judged by whether a reader can walk from the pin back to the record, and the record is a spreadsheet somebody maintains on a schedule.
A mill is a point, a growing region is not
Supplier sites do not share a shape. A spinning mill is one address. A cooperative of smallholders is a district with hundreds of households in it, and publishing those households because they appear in a column is a decision with legal consequences.
The published version can hold a district polygon with the supplier count in its own text, while the working version holds the sites. Same register, different level of detail. Choose the level before the file goes out, since a public link is a disclosure.
Let the reader switch a status off
Give each status its own marker style: audited, in progress, lapsed, not yet reviewed. Readers of a public map can hide a style, so switching off the audited sites leaves the part of the chain where the evidence is thin. That is the view a sustainability lead wants for planning, and anyone holding the link can produce it without a second version of the map.
It also keeps the map honest. A reader who hides a group is choosing the question they want answered, and the map answers that question with the sites that remain.
Where these maps go wrong
A marker sits where somebody placed it. Nothing checks the coordinate against the address in the register, so one bad geocode becomes a supplier in the sea. Spot check the outliers before publishing.
An undated map drifts. Put the register cut-off date where it gets read, and refresh the map when the register closes a quarter.
Tier diagrams drawn as three tidy boxes suggest material moves one hop per tier. Cotton goes by truck to a gin, by road to a port, by sea to a mill. If the route matters to the story, draw the routes you can defend and say plainly where the rest is unknown.
Supplier emissions data carries the same gap. The GHG Protocol's Scope 3 Standard divides value chain emissions into fifteen categories, and most of that data arrives from suppliers at different levels of confidence. A map can show who has reported and who has not.
The interesting number is the count of suppliers whose audit is older than the certificate suggests. The map can show that gap when the dates are in the data.
Traceability is a citation habit that happens to produce a map. Build it from a dated register and it survives the first question a buyer asks: where is this site, and who says so.
References
- Due diligence for responsible business conduct, OECD. The risk-based due diligence framework for operations, supply chains and business relationships.
- Corporate sustainability due diligence, European Commission. The Directive 2024/1760 duty to identify and address impacts across chains of activities.
- Corporate Value Chain (Scope 3) Standard, GHG Protocol. The fifteen categories of value chain emissions and the reporting method behind them.
Related reading
- Location Privacy on Web Maps
- CSV Geocoding Best Practices
- How to Structure Location Data in a Spreadsheet
The register stays the record. Tasmap is one way to read it by place.