The Global Language of Business
Kontakt oshvidt omrids af cirkel med hvid pil i midten der peger mod venstre
How to import your data using the Excel template

In this guide, we will show you how to import your product and packaging data into GS1Trade Packaging using the data import template.

The data import template is designed to import product data, packaging components, and packaging units, helping you get your basic data in place.

You can then create integrated components and packaging systems within the platform by following the respective guides.

How to download the template

From the frontpage, click on 'Import' in the upper right corner. Here, you can choose to download a single template for your own use or multiple templates for your suppliers.

Please note that each supplier must have their own unique import template, as each file comes with a unique ID. Excel files cannot be reused or copied.

For this example, we will download a single template for our own use.

How to fill out the data import template

We will start by creating products, packaging components, and packaging units separately. Then, we will link them together.

The order is not important, but we recommend starting with creating the packaging components.

In this example, we will create a jam product: The packaging components for this are a jar, a label, and a lid.

Step 1: Create packaging components

Go to the PackagingComponent tab.

Fill out the required data fields: Name, Element type, type, weight and unit of measurement.

Additionally, you can fill out further technical properties, but this is not required for data import.

For each packaging component, you must specify a Packaging component reference identifier.

  • You can choose a code from 1-1,000 (for example 1, 2, 3...). The reference number is needed when linking the packaging components to a unit.
  • 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 the Unique Identifier-column will turn red to indicate a duplicate.

Step 2: Create packaging unit

Go to the PackagingUnit tab.  

Fill out the required data fields: Name, Type and Status.

Specify the Packaging unit reference identifier for each packaging unit.

You will use this to link your packaging components to a packaging unit and subsequently link your packaging unit to one or more products.

Step 3: Create product master data

Go to the Product tab.

Fill out the requied data fields:  Brand name, Product name, Language, Product ID, GTIN (optinal), Net content, Unit of measurement og Status.

Specify the Product reference identifier for each product. You will use this to link your packaging unit to one or more products.

Step 4: Link packaging components to packaging unit

Go to the ComponentToUnitAssociate tab.

Insert the reference number of the components in the cokumn, Packaging Component reference identifier.

Insert the reference number of the packaging unit they are part of in the column, Packaging Unit reference identifier.

Now you have connected the components to a unit. Next step is associating packaging units to the product.

Step 5: Link packaging unit to product

Go to the ProductAssociate tab.

Insert the reference number of the product in the column, Product reference identifier.

Insert the reference number of the packaging unit in the column, Packaging Unit reference identifier.

You have now linked the packaging unit with the product.

If you have multiple products using the same packaging, you can easily link the packaging unit to multiple products.

When you are finished, save the file on your computer.

How to upload the data import template

Open GS1Trade Packaging and select Import.

Click on the upload field or drag the Excel file into the upload field.

The processing will start automatically.

If the file is filled out correctly, the status will change from Waiting in queue to Import completed.  

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.

Good to know before you start

  • You can import up to 1,000 lines at a time (product and packaging data combined). When the sheet is filled up, simply download a new template and continue working.
  • You can link one packaging unit per product. The packaging unit will be created as the product’s primary packaging. Secondary and tertiary packaging can be created directly in the platform afterwards.

Ønsker du at downloade vejledningen?

arrow-right-circle
Hent den her

Har du stadig brug for hjælp? Så tag fat i GS1 Denmarks support team. Vi står altid klar til at hjælpe.

Nyeste vejledninger

GS1 Trade Packaging ikon - grøn cirkel med  illustration af en åben papkasse
Trade Sync ikon - en lyserød cirkel med en illustration af tre cirkler ovenpå hinanden i en cylinder
Exact ikon - en solgul cirkel med en illustration af et forstørrelsesglas
Image ikon - en lyselilla cirkel med en illustration af et kamera i midten
Transact ikon - en lyseblå cirkel med en illustration af et stykke papir med tekst og en stjerne på
GLN ikon - en orange cirkel med en illustration af et lokationssymbol
Logo til Activate service grøn cirkel med grafik af papir med tekst og check-mærker
GTIN ikon - en grøn cirkel med en illustration af fem lodrette streger som en stregkode
|
Videokamera ikon i en mørkeblå cirkel
Ikon for læsetid - en mørkeblå cirkel med fire horisontale streger der indikerer tekst
120
 min
Oprettelse af data til Sverige i GS1Trade Sync
Samhandel med Sverige stiller specifikke krav. Bliv klogere på dataoprettelse af varestamdata til det svenske marked.
This is some text inside of a div block.
GS1 Trade Packaging ikon - grøn cirkel med  illustration af en åben papkasse
Trade Sync ikon - en lyserød cirkel med en illustration af tre cirkler ovenpå hinanden i en cylinder
Exact ikon - en solgul cirkel med en illustration af et forstørrelsesglas
Image ikon - en lyselilla cirkel med en illustration af et kamera i midten
Transact ikon - en lyseblå cirkel med en illustration af et stykke papir med tekst og en stjerne på
GLN ikon - en orange cirkel med en illustration af et lokationssymbol
Logo til Activate service grøn cirkel med grafik af papir med tekst og check-mærker
GTIN ikon - en grøn cirkel med en illustration af fem lodrette streger som en stregkode
|
Videokamera ikon i en mørkeblå cirkel
Ikon for læsetid - en mørkeblå cirkel med fire horisontale streger der indikerer tekst
 min
Hvornår skal jeg skifte GTIN på mit produkt?
Få en forklaring på, hvornår og hvordan du bør skifte GTIN på dine produkter.
This is some text inside of a div block.
GS1 Trade Packaging ikon - grøn cirkel med  illustration af en åben papkasse
Trade Sync ikon - en lyserød cirkel med en illustration af tre cirkler ovenpå hinanden i en cylinder
Exact ikon - en solgul cirkel med en illustration af et forstørrelsesglas
Image ikon - en lyselilla cirkel med en illustration af et kamera i midten
Transact ikon - en lyseblå cirkel med en illustration af et stykke papir med tekst og en stjerne på
GLN ikon - en orange cirkel med en illustration af et lokationssymbol
Logo til Activate service grøn cirkel med grafik af papir med tekst og check-mærker
GTIN ikon - en grøn cirkel med en illustration af fem lodrette streger som en stregkode
|
Videokamera ikon i en mørkeblå cirkel
Ikon for læsetid - en mørkeblå cirkel med fire horisontale streger der indikerer tekst
10
 min
Brugervejledning til GS1Trade Sync - oprettelse af produkter
Guide til dig, som er ny i GS1Trade Sync eller har brug for en genopfriskning.
This is some text inside of a div block.