/
2 Data Preparation Stage 2

2 Data Preparation Stage 2

Owned by Digitec Galaxus AG
Last updated: Apr 28, 2025 by Nikita Stanimirovic

DATA INTEGRATION STAGE 2

Product creation/New assortment

The aim of the second integration stage is to map their full range by expanding the master data. Additional product data is needed for the realisation. They serve to clearly identify, categorise and present the products so that they can be purchased by the end customer.

The new files or required extensions are documented in this chapter.

A prerequisite for the implementation of stage 2: product creation is a completed and productive stage 1!

Back to stage 1: offer creation and allocation

DATA STRUCTURE

In addition to the existing offer data, further aspects are now added to the master data as well as the media for the products. We recommend preparing the media in another separate file.

Illustration 5: Data structure in stage 2

 

The provider key is the unique article number for an article of the supplier/retailer/provider. It is used as an identification number and must be included in all files supplied.

 

DATA FORMAT

We offer various file formats for data preparation. Select the standard suitable for your application and note the file structure requirements in the following overview. We recommend the CSV standard for automated data preparation, while XLSX files are more suitable for manual interventions in the files.

 

NOTES ON DOCUMENTATION

The documentation of the data structure contains technical terms and notes in various places. These are central to correct data preparation and - if correctly implemented in the files - simplify technical integration enormously. You will find more detailed explanations and examples in the table below.

 

DATA STRUCTURE PRODUCTDATA

General notes on the ProductData

  • File name: ProductData_[ProviderName]. [FILE FORMAT] (Eg: ProductData_digitecgalaxus.csv)

  • Transmission frequency: every 24 hours (optimal: every 12 hours)

Information marked with is already listed in the master data stage 1. The remaining master data listed here can be regarded as an extension of the existing data

 

Minimal criteria: ProductData

Header

Data type

Designation

Description

Header

Data type

Designation

Description

ProviderKey

Str(50)
ASCII 32-126

Partner specific item number

Unique identification number of the partner item

  • The item numbers must be unique. Duplicates are not permitted.

  • We expect only characters in the range ASCII 32-126

Gtin

Int(8)
Int(12)
Int(13)
Int(14)



EAN/GTIN code of the article

Unique and globally valid identification number of the article. The following data structures are permitted within the GTIN family:

  • GTIN-12 (UPC), GTIN-13 (EAN-13, ISSN, ISBN), GTIN-14 (EAN/UCC-128 or ITF-14), GTIN-8 (EAN-8)

  • The EAN/GTIN forms the basis for our automated allocation and product creation processes. Therefore, request GTINs for your products for a smooth data transfer: GS1 Switzerland: Request barcode, GS1 Germany: Request barcode

  • The EAN/GTINs must be unique and globally valid. Duplicates are not permitted.

  • The EAN/GTIN must be visible on the retail packaging.

  • Further information on Gtins and GS1 at: http://gtin.info

  • or GS1 Switzerland.

BrandName

Str(100)

Brand / Publisher

Manufacturer's brand of the item.

Products can only be created/processed with an associated mark.

CategoryGroup_[index]

Str(200)

Category groups of the article

The category groups, starting with the highest level CategoryGroup _1, together form a category family tree that assigns the item hierarchically.

  • "index" - Consecutive numbering of the CategoryGroups, E.g.: CategoryGroup_1, CategoryGroup_2, CategoryGroup_3, …

  • The category groups are not mandatory if the product categories (see ProductCategory) are complete and clearly assignable.

ProductCategory

Str(200)

Product category of the article

The product category is the deepest (most detailed) level of all categories.

  • The Digitec Galaxus category structure is available for download here:

  • It is not mandatory to name the categories in the data transmission exactly the same as Digitec Galaxus. A partner-specific categorisation can also be used, from which Digitec Galaxus will automatically create a category matching.

  • For the preparation of product specifications (also known as product attributes) 3 Data Preparation Stage 3, a property structure per ProductCategory can be provided on request.

Weight_[unit]

Dec(8,4)

Packaging weight [mg,g,kg]

Packaging weight: Product weight plus original packaging of a retail package.

  • Items without weight are categorically excluded for EU hub merchants

  • "unit" - mögliche Einheiten: mg (Milligramm), g (Gramm), kg (Kilogramm)

ProductTitle_de

Str(100)

German article/product name

Cleaned name of the item for the German-speaking region. Product names must be uniform and cleansed of specifications.

  • The provieded product title will be used as title in german.

  • The quality of the product names is crucial for a consistent appearance in the online shop and the buyability of the products. Please note our guidelines on data quality.

 

Supplementary criteria for EU hub partners: ProductData

Header

Data type

Designation

Description

Header

Data type

Designation

Description

TARICCode

Int(6-11) od. Str(14)

Commodity code (TARIC) for the EU

TARIC database, normally consists of 11 characters (without spaces) or 14 characters (with spaces), e.g. "49019900009" or "4901 9900 00 9".

The validation of the content only allows optional spaces. Other special characters are not allowed. Tariccodes with less than 11 characters are padded with zeros at the end (right).

CountryOfOrigin

Str(2)

Country of origin

Origin (country of production) of the delivered item or country where the majority of the value creation has taken place

CountryOfOrigin in the ISO 3166 ALPHA-2 standard, e.g. CH, DE

 

Supplementary criteria for product safety regulations: ProductData

Header

Data type

Designation

Description

Header

Data type

Designation

Description

GPSRNameAddress

Str(300)

Name and postal address of manufacturer

The company name and the postal address of the manufacturer importing the product into the European Economic Area (EEA).

  • Format: "{name}, {street} {number}, {zip code} {town}, {country}"

  • Example: "Mustermann GmbH, Musterstraße 123A, 12345 Musterstadt, Deutschland"

  • Commas separate the different parts of the address (name, street and number, zip code and city, country).

  • Spaces separate street and house number as well as zip code and city.

  • Country: Use the full country name or the ISO 3166-1 alpha-2 code (e.g. "Deutschland" or "DE").

  • Address suffix (optional): If necessary, you can add additional information such as "c/o" or "floor" after the name, e.g. "Mustermann GmbH, c/o Max Mustermann, Musterstraße 123A, 12345 Musterstadt, Germany".

GPSREmailUrl

Str(200)

Email address or URL

The email address or the URL of the manufacturer importing the product into the European Economic Area (EEA).

  • The URLs must be accessible.

Warnings can be transmitted as before via the specification feed (stage 3).

Supplementary criteria for optimising data quality: ProdcutData

 

Optional criteria for future optimisation of ProductData

FILE STRUCTURE MEDIA DATA

General information on the Media Data

  • File name: MediaData_[ProviderName]. [FILE FORMAT] (Ex: MediaData_digitecgalaxus.csv)

  • Transmission frequency: every 48 hours (optimal: every 24 hours)

Use the following CSV-sample

Use the following XLSX-sample

 

Minimal criteria: Media Data

Header

Data type

Designation

Description

Header

Data type

Designation

Description

ProviderKey

Str(50)
ASCII 32-126

Partner specific item number

Unique identification number of the partner item

  • The item numbers must be unique. Duplicates are not permitted.

  • We expect only characters in the range ASCII 32-126

MainImageURL

Str(300)

First image link (HTTPS)

Cropped product image with white background, preferably frontal view. The longest edge of the images must be at least 600px (without border around the product). The size of 8 MB per image must not be exceeded.

  • The URL must be freely accessible.

  • The formats JPG, JPEG and PNG are supported.

  • Qualitative requirements, please observe data quality guidelines.

ImageURL_[index]

Str(300)

Additional image links (HTTPS)

One link per column. The link must be freely accessible. JPG, JPEG and PNG are supported. The longest edge of the images must be at least 600px (without border around the product). The size of 8 MB per image must not be exceeded.

  • The URL must be freely accessible.

  • The formats JPG, JPEG and PNG are supported.

  • Qualitative requirements, please observe data quality guidelines..

  • "index" - Consecutive numbering of the images

  • E.g.: MainImageURL, ImageURL_1, ImageURL _2, ImageURL _3, …, ImageURL_n

 

Supplementary criteria: MediaData

 

Declaration Media in MediaData

 

Optional criteria: MediaData