Learn how to import your product and packaging data into GS1Trade Packaging using the data import template in Excel.
The data import template is designed to import product data, packaging components and packaging units to help you get your basic data in place.
Forming integrated components and packaging systems can subsequently be done in the system.
From the front page, click Import in the top right corner. Here you can choose to download one for your own use or multiple templates for your suppliers.
Please note that each supplier must have its own unique import template, as each file comes with a unique ID. The Excel files cannot be reused or copied.
For this purpose, we download a single template for your own use.
We start by creating products, packaging components and packaging units separately. Then we link them together. The order is not important, but we recommend starting by creating the packaging components.
In this example, we create a jam product. The packaging components for this are glass, label and lid.
Go to the PackagingComponent tab. Fill in the required data fields: Name, Element type, Type, Weight and Unit of measurement.
In addition, there is an option for you to fill in additional technical properties, but this is not a requirement for importing data.
For each packaging component, you need to specify a Packaging component reference identifier. You will use the reference number to link your packaging components to a packaging unit shortly. You can choose a code from 1-1,000.
Please note that each reference number is unique and can only be used once in the template. If you use the same reference number multiple times, the field in Column C will turn red to indicate that there is a duplicate.
Go to the PackagingUnit tab. Fill in the data fields: Name, Type and Status.
Enter the Packaging unit reference identifier for each packaging unit. This is used to link your packaging components to a packaging unit and subsequently link your packaging unit to one or more products.
Go to the Product tab. Fill in the required data fields: Brand name, Product name, Language, Product ID, GTIN (optional), Net content, Unit of measurement and Status.
Enter the Product reference identifier for each product. You will need this to link your packaging unit to one or more products.
Now you have created the product, packaging components and packaging unit. The next step is to link them together.
We start by connecting packaging components to the packaging unit.
Go to the ComponentToUnitAssociate tab.
Insert the reference number of the components in Column B 'Packaging Component reference identifier'.
Insert the reference number of the packaging unit they are part of in Column D Packaging Unit reference identifier.
You have now connected packaging components to the packaging unit. The next step is to connect the packaging unit to the product.
Go to the ProductAssociate tab.
Insert the reference number of the product in Column B, Product reference identifier.
Insert the packaging unit reference number in Column D, Packaging Unit reference identifier.
You have now linked the packaging unit to the product. If you have multiple products that use the same packaging, you can easily link the packaging unit to multiple products.
When you're done, save the file to your computer.
Open GS1Trade Packaging and select Import. Click the upload field or drag the Excel file into the upload field. The processing will start automatically.
If the file is filled in correctly, the status will change from Waiting in queue to Import complete.
If the import fails, the status will show an error message and an Excel file will be created for download with an overview of the given errors.
You can import up to 1,000 lines at a time (product and packaging data combined). When the sheet is full, simply download a new template and continue working.
You can link one packaging unit per product. That packaging unit will be created as the product's primary packaging. You can subsequently create secondary and tertiary packaging directly in the platform.
Still need help? Then get to GS1 Denmark's support team. We're always ready to help.
