SBP Data Injection โ Overview
SBP (Sustainable Brand Platform) collects sustainability data from client companies and their supply chains. Data is injected via CSV files uploaded to an FTP endpoint. There is no REST API โ every data area is covered by a dedicated import template (CSV/XLSX).
Integration methodโ
| Aspect | Detail |
|---|---|
| Protocol | FTP (SFTP recommended) |
| File format | CSV (downloaded from the SBP platform as XLSX templates, exported as CSV) |
| Column order | Fixed โ do not reorder or rename columns |
| Updates | Use the platform's Export file button, edit rows, re-upload |
| Automation scope | Any ETL/scheduler capable of writing CSV files and uploading via FTP |
The 12 data injection areasโ
| # | Area | Module | Columns | Mandatory |
|---|---|---|---|---|
| 1 | Supplier Registry | Supplier Management | 11 | 4 |
| 2 | Material Library | Material Library | 60 | 28 |
| 3 | Product Library | Product Library | 59 | 33 |
| 4 | CCF โ Materials | CCF | 7 | 5 |
| 5 | CCF โ Manufacturing | CCF | 9 | 5 |
| 6 | CCF โ Shippings | CCF | 23 | 17 |
| 7 | CCF โ Business Travels | CCF | 10 | 9 |
| 8 | CCF โ Commuting | CCF | 9 | 8 |
| 9 | CCF โ Other Workspaces | CCF | 24 | 17 |
| 10 | CCF โ Vehicles | CCF | 9 | 8 |
| 11 | CCF โ Waste | CCF | 48 | 5 |
| 12 | CCF โ Capital Goods | CCF | 42 | 6 |
Import order and dependenciesโ
Some areas depend on data already present in SBP. The required import order is:
1. Supplier Registry โ no dependencies
2. Material Library โ references Supplier Registry (supplier code)
3. Product Library โ references Supplier Registry (TIER 1) + Material Library
4. CCF โ Materials โ references Material Library (same reporting year)
5. CCF โ Manufacturing โ references Supplier Registry (TIER 1)
6โ12. Remaining CCF areas โ self-contained
Attempting to import a file that references a code not yet present on SBP will result in an import error.
Import behavior by areaโ
Different areas handle re-imports differently:
| Behavior | Areas |
|---|---|
| Persistent โ existing records are retained; new rows are added or updated | Supplier Registry |
| Incremental โ existing records are updated if data is present, otherwise unchanged | Material Library |
| User choice โ UI lets you choose between incremental or delete-and-reload | CCF Materials, CCF Manufacturing, CCF Shippings, CCF Business Travels |
| Delete and reimport โ existing data is permanently deleted on every new upload | CCF Commuting, CCF Vehicles, CCF Waste, CCF Capital Goods |
Reporting yearโ
Material Library, Product Library, and all CCF areas are yearly. Each import is scoped to a specific (Company ร Reporting Year) combination. A material created for Year N is not automatically available in Year N+1.