Skip to main content

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โ€‹

AspectDetail
ProtocolFTP (SFTP recommended)
File formatCSV (downloaded from the SBP platform as XLSX templates, exported as CSV)
Column orderFixed โ€” do not reorder or rename columns
UpdatesUse the platform's Export file button, edit rows, re-upload
Automation scopeAny ETL/scheduler capable of writing CSV files and uploading via FTP

The 12 data injection areasโ€‹

#AreaModuleColumnsMandatory
1Supplier RegistrySupplier Management114
2Material LibraryMaterial Library6028
3Product LibraryProduct Library5933
4CCF โ€” MaterialsCCF75
5CCF โ€” ManufacturingCCF95
6CCF โ€” ShippingsCCF2317
7CCF โ€” Business TravelsCCF109
8CCF โ€” CommutingCCF98
9CCF โ€” Other WorkspacesCCF2417
10CCF โ€” VehiclesCCF98
11CCF โ€” WasteCCF485
12CCF โ€” Capital GoodsCCF426

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:

BehaviorAreas
Persistent โ€” existing records are retained; new rows are added or updatedSupplier Registry
Incremental โ€” existing records are updated if data is present, otherwise unchangedMaterial Library
User choice โ€” UI lets you choose between incremental or delete-and-reloadCCF Materials, CCF Manufacturing, CCF Shippings, CCF Business Travels
Delete and reimport โ€” existing data is permanently deleted on every new uploadCCF 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.