Note: Excel sheet examples for data structure and attributes at the bottom
Introduction
When working with supplier, product, and packaging data in the Prduct platform, having a clear and structured Excel format is essential. Clean data—free from excessive or irrelevant information—not only ensures a smooth upload process but also lays the foundation for strong data relationships across your value chain.
Necessary Data-attributes
Each dataset (suppliers, products, and packaging) must include the necessary attributes you will actively use on the platform. For example, supplier files should at least include company name and VAT number.
Click here to see "What data attributes should you collect?"
Just as important is the use of a consistent identifier - an ID number - that links related/connected data across the different Excel sheets. For instance, each supplier should have a unique ID that is also referenced in the product and packaging files (e.g., which products are related to which supplier - and what packaging are used for which products).
This allows the platform to automatically connect which products come from which supplier and which packaging components are used for which product.
Data structure
When uploading products containing dimension and weight, do not write all dimensions in one column but rather create a column for each dimension type.
(See example below)
Note: Do not add units (g, kg, cm, mm) - you will configure the unit of measure in the platform.
Note: Are you working with variants of the same product, or do your products consist of components? Read here
Excel sheets - (Data examples)
Download 'data structure' examples for Supplier and Product data below: