/
2 Data Preparation Stage 2

2 Data Preparation Stage 2

DATA INTEGRATION STAGE 2

New assortment

The goal of the second stage is the complete creation and enrichment of your product portfolio. This includes mapping your entire assortment using extended master data and supplementing items with additional information.

For product creation, we require additional product data used for the clear identification, categorization, and presentation of items. The required files and fields are described in this chapter.

A separate file is mandatory for specifications. An optional accessory file allows you to clearly assign accessories to the main items.

A prerequisite for implementing Stage 2 (product creation and enrichment) is the completion of Stage 1.

back to Stage 1: Offer creation and assignment

Table of Contents

DATA STRUCTURE

In addition to the existing offer data, additional aspects are now added to the master data, including specifications, media, and accessory links. The specifications must be provided in a separate file. We also recommend preparing the product media as well as other relevant master data in their own separate files.

 

Option 1

Option 2

Option 1

Option 2

image-20260123-121434.png

 

image-20260123-121452.png

 

The ProviderKey is the partner’s unique item number for a product. It is used as an identification number and must be included in all delivered files. The ProviderKey is used to consolidate the information.

 

DOCUMENTATION NOTES

The documentation of the data structure contains technical terms and notes in several places. These are essential for correct data preparation and—if implemented correctly in the files—greatly simplify the technical integration. In the table below, you will find further explanations and examples.

 

 

 

ALL PRODUCT-TYPES

To provide the best possible shopping experience, we need to adapt our structure to our customers' needs. That's why it's constantly changing. To get an overview of our product types (categories), you can download the extract.

For new assortment, correct product type assignment is critical. To achieve the best possible quality, we recommend sending us all the raw data rather than trying to map to our categories yourself. Our product type AI achieves the best results with original data.

Download:

DATA STRUCTURE PRODUCT DATA

 

General notes on product data

  • File name: ProductData_[ProviderName].[FILE FORMAT] (e.g., ProductData_digitecgalaxus.csv)

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

  • Information marked with is already included in the master data in Stage 1. The information listed in Stage 2 can be added as a supplement to the product data files already implemented.

 

Use our CSV-Templates

Use our XLSX-Template

Minimum requirements: Product 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.

  • Item numbers must be unique. Duplicates are not permitted.

  • We only accept characters in the ASCII 32–126 range.

Gtin

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

 

EAN/GTIN Code of the article

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

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

  • The GTIN stored for an item should not be changed. At present, a later adjustment does not trigger a new assignment, meaning the old GTIN remains active. Therefore, it is important to maintain the correct GTIN from the start. An incorrect or changed GTIN can lead to incorrect assignments and processed data.

  • The EAN/GTIN is the basis for our automated assignment and product-creation processes. Therefore, to ensure smooth data transfer, request GTINs for your products: GS1 Switzerland: Request a barcode, GS1 Germany: Request a 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 can be found at gtin.info or GS1 Switzerland.

  • The GTIN printed on the product must match the transmitted GTIN.

  • Please use only the GTINs officially assigned by the manufacturer.

BrandName

Str(100)

Brand / Publisher

Manufacturer brand of the item.

Products can only be created/processed if a corresponding brand is provided.

CategoryGroup_[index]

Str(200)

Category groups of the article

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

  • "index" – sequential numbering of the CategoryGroups, e.g.: CategoryGroup_1, CategoryGroup_2, CategoryGroup_3, …

  • Category groups are not strictly required as long as the product categories (see ProductCategory) can be assigned completely and unambiguously.

ProductCategory

Str(200)

Product category of the article

The product category represents the lowest (most detailed) level of the category tree.

  • It is not mandatory to name the categories in the data delivery exactly as they are named at Digitec Galaxus. A partner-specific categorization can also be used; Digitec Galaxus will then automatically create a category matching.

PackagingWeight_[unit]

Dec(8,4)

Packagin weight [mg,g,kg]

Packaging weight / gross weight: product weight plus the original packaging of a retail unit.

  • Items without weight are categorically excluded for EU hub merchants.

  • "unit" – possible units: mg (milligram), g (gram), kg (kilogram)

ProductTitle_[language]

Str(100)

Article/Product name

Cleaned item name in one of the following languages: German, English, French, or Italian. Product titles must be consistent and free of specifications.

  • Die Qualität der Produktnamen ist für ein einheitliches Auftreten im Online-Shop und die Kaufbarkeit der Produkte entscheidend. Beachten Sie unsere Richtlinien zur Datenqualität.

  • "language" im Standard ISO 639-1, Bsp:

    ProductTitle_de, ProductTitle_en, ProductTitle_fr, ProductTitle_it

CountryOfOrigin

Str(2)

Country of origin

The country of origin is the country in which the goods were wholly obtained or produced, or in which the last substantial processing was carried out.

 

Additional requirements for EU partners

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.

WEEENumber

Str(10)

WEEE Number

Example: “DE12345678”

  • Only valid WEEE numbers may be submitted. If the partner deregisters from the EAR register again (market exit), the number must no longer be submitted.

  • If multiple WEEE numbers exist, the most recent number must be submitted.

Warnings can be transmitted as before via the specification feed .

Optional criteria for optimising data quality: ProductData

Header

Data type

Designation

Description

Header

Data type

Designation

Description

Length_[unit]

Dec(8,4)

Packaging length

Length of the original packaging

"unit" – possible units: mm (millimeter), cm (centimeter), m (meter)

Width_[unit]

Dec(8,4)

Packaging width

Breite der Originalverpackung

"unit" - mögliche Einheiten: mm (Millimeter), cm (Zentimeter), m (Meter)

Height_[unit]

Dec(8,4)

Packaging height

Height of the original packaging

"unit" – possible units: mm (millimeter), cm (centimeter), m (meter)

ReleaseDate_[country]

Date

Release date

Release date for new product launches. The date is displayed in the shop.

"country" according to ISO 3166-1 alpha-2, e.g., ReleaseDate_CH

TARESCode

Str(9)

Swiss customs tariff number (TARES)

TARES database, Example: "12345678" or "1234.5678"

  • Content validation only allows the optional character "." (dot). Other special characters are not permitted.

  • Validation regex: /^([0-9]{4})\.?([0-9]{4})$/

VariantName

Str(100)

Family name / variant name

Unique identification for related items. Digitec Galaxus uses this information to create product variants.

It is recommended to use the ProductTitle without any additions, as it is already identical for many products with variants.

LongDescription_[language]

Str(4000)

Detailed item description [de,en,fr,it]

Detailed description of the item with relevant information about the product such as size, material, age range, special features, technical specifications, shape, pattern, fabric type, design)

  • The quality of the product description is crucial for a consistent presence in the online shop and the purchasability of products. Please follow our Data Quality Guidelines.

  • The product description should be kept general and must not include marketing copy or partner-specific information.

  • Web links and bullet points are not allowed.

  • One of the following languages is required: German, English, French, or Italian.

  • "language" in ISO 639-1 standard, e.g.: LongDescription_de, LongDescription_fr

Composition_[language]

Str(4000)

Zusammensetzung [de,en,fr,it]

Description of the composition or ingredients of a product. These are legally required for specific product groups and are therefore compliance-relevant.

  • These include, for example:

    • Ingredients list (All ingredients contained in a food product must be declared)

    • Allergen declaration (Ingredients and products made from them that can trigger allergies or other adverse reactions must be specifically declared)

    • Ingredients / constituents (e.g., perfume)

  • The quality of the product texts is crucial for a consistent appearance in the online shop and the purchasability of the products. Please follow our data quality guidelines.

  • "language" according to ISO 639-1, e.g., Composition_de, Composition_en, Composition_fr

Application_[language]

Str(4000)

Application[de,en,fr,it]

Description of the application/use of a product. This is legally required for specific product groups and is therefore compliance-relevant.

  • This applies, for example, to the following product groups:

    • Medical devices

    • Medicinal products

  • The quality of the product texts is crucial for a consistent appearance in the online shop and the purchasability of the products. Please follow our data quality guidelines.

  • "language" according to ISO 639-1, e.g., Application_de, Application_en, Application_fr

MinimumAge_[country]

Int(2)

Legal age restriction

Legal age restriction (in years)

"country" according to ISO 3166-1 alpha-2, e.g., MinimumAge_DE

We can currently process this information only in the specifications. Therefore, please include the age restriction in the specifications field under “Specifications enrichment”.

TARICCode

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

Taric code for the EU area

TARIC database, usually consists of 11 characters (without spaces) or 14 characters (with spaces), Example: "49019900009" or "4901 9900 00 9"

Content validation allows only optional spaces. Other special characters are not permitted. TARIC codes with fewer than 11 digits are padded with zeros at the end (right).

DATA STRUCTURE MEDIA

General notes on media

  • File name: MediaData_[ProviderName].[FILE FORMAT] (e.g., MediaData_digitecgalaxus.csv)

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

Use our CSV-Template

Use our XLSX-Template

 

Minimum requirements: Media

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.

  • Item numbers must be unique. Duplicates are not permitted.

  • We only accept characters in the ASCII 32–126 range.

MainImageURL

Str(500)

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.

Below you will find a selection of tools that enable you to do this:

https://imageshack.com/

https://imgur.com/

https://i-converter.com/files/jpg-to-url

https://app.photobucket.com/explore

https://postimages.org/

Digitec Galaxus recommends the tools mentioned above. However, there are no agreements or special conditions for the platforms mentioned.

ImageURL_[index]

Str(500)

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

EnergyLabel

Str(300)

Energy label Image link (HTTPS)

One link per column and indication of energy efficiency class.

  • The link must be freely accessible. JPG, JPEG and PNG are supported.

  • The energy label class has to be additionally transmitted in the specifications.

 

Optional Criteria: Media

The following information cannot currently be processed. However, we continuously optimize our technical systems and will expand information processing for the corresponding fields in due course. Providing this information in the data files helps us better assess the relevance and prioritize future enhancements.

Header

Data type

Designation

Description

Header

Data type

Designation

Description

DocumentURL_[language]_[index]

Str(300)

Documents links (HTTPS)

One link per column. Document links can include instructions for use, size tables, safety data sheets, etc.