(blue star) Stage 2: product creation

Data transmission (blue star)

DATA INTEGRATION STAGE 3

Enrichment Specifications/Properties

The aim of the third stage is to enrich the created products with further information. This can include properties, accessories and declarations. The more information provided, the higher the filterability and visibility of the products.

For the specifications, preparation in a separate data sheet is mandatory (alternative presentation of the specifications is only possible after consultation). We recommend to transmit the declarations as specifications to enable efficient processing. Finally, the additional Accessory File allows suppliers to display accessories on the product detail page of the main article.

A prerequisite for the implementation of stage 3 are completed and productive stages 1 and 2!

(blue star) Back to stage 1: Offer creation and allocation
(blue star) Back to stage 2: Product creation

Table of Contents

DATA STRUCTURE

DATA SHARING

In addition to the existing product data and offer data, the specifications, declarations and accessory links are now added.

The specifications must be presented in a separate file (alternative presentation of specifications only possible after consultation). The remaining two files are recommended to be presented separately.

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 SPECIFICATION

Specification

  • File name: SpecificationData_[ProviderName]. [FILE FORMAT] (e.g.. SpecificationData_digitecgalaxus.csv)

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

  • File structure:

    • Variant 1: Key-Value-Pair (Standard)

    • Variant 2: Column (special case; only possible after consultation ) (warning)

  • The fields must not contain HTML tags

  • The data quality of the specifications is essential for the buyability f the products. Follow our guidelines on data quality

After consultation, an alternative representation of the specifications can be used (variant 2: Column). This variant offers more flexibility in terms of presentation and format. This special case allows the preparation in .xlsx format as well as the combination with other data (e.g. ProductData or MediaData).

The data preparation of the specifications can be prepared in two file structures. The following is an overview of the two variants.

Option 1: Key-Value-Pair (Standard)

Option 2: Column (special case)

Format

CSV-Standard UTF-8 (see data format)

Format according to file formats specified above

Structure

  • 1 line per article and specification

  • Specification and value in combination per line

  • 1 line per article

  • Specifications in the headers

  • Specification values in the cells

Sorting

  • Sorted by ProviderKey (ascending)

  • free

Suitable for

  • Many different specifications

  • few different specifications

Requirements for the structure

Specifications with multiple values can be delivered in two options:

One SpecificationValue per line (preferred)

ProviderKey

SpecificationKey

SpecificationValue

item_01

color

black

item_01

color

yellow

item_01

color

blue

item_01

material

plastic

item_01

material

metal

Alternativ: Multiple SpecificationValue per SpecificationKey

Within a key-value pair, we can handle only one delimiter.

Allowed delimiters for multiple values are: "," (comma),"/" (slash), "|" (pipe), ";" (semicolon).

Delimiters are searched in the order listed above ( , / | ; ).

Once a delimiter is detected, any subsequent different delimiters are ignored.

ProviderKey

SpecificationKey

SpecificationValue

item_01

color

black|yellow|blue

item_01

material

plastic|metal

What happens with different delimiters:

Provider_SpecificationValue

DG_SpecificationValue

Schwarz , Gelb | Blau

Schwarz Gelb | Blau

Obermaterial 1: 100% Polyester; Obermaterial 2: 95% Polyester, 5% Elasthan

Obermaterial 1: 100% Polyester; Obermaterial 2: 95% Polyester 5% Elasthan

ProviderKey

color

material

size

target group

item_10

blue

Cotton

M

women

item_11

red

Polyester

M

women

item_12

yellow

Cotton

M

men

item_13

yellow, black

Cotton

L

men

note

Use the following CSV-sample

Use the following CSV-sample

note

Use the following XLSX-sample

Use the following XLSX-sample

Option 1: Key-Value-Pair (Standard)

Header

Data type

Designation

Description

ProviderKey

Str(50)

Partner specific item number

Lines with the same ProviderKeys must be listed one after the other. I.e. the document must be sorted numerically ascending by ProviderKey.

SpecificationKey

Str(200)

Specification name

Specification name

  • German and English are preferred languages. For other languages, please contact your Digitec Galaxus representative.

  • For each item number listed in this file, there must be at least one "SpecificationKey" and one "SpecificationValue" in one language.

SpecificationValue

Str(200)

Specification value

Specification value

  • German and English are preferred languages. For other languages, please contact your Digitec Galaxus representative.

  • For each item number listed in this file, there must be at least one "SpecificationKey" and one "SpecificationValue" in one language

Variante 2: Column

Header

Data type

Designation

Description

ProviderKey

Str(50)

Partner specific item number

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

[Specification_1]

Str(200)

Values of the first specification

Specification values of the articles for the specification contained in the header line

E.g.. header: "colour", specification values: blue, black, red, etc.

[Specification_2]

Str(200)

Values of the second specification

Specification values of the articles for the specification contained in the header line

E.g. header: "Material", specification values: cotton, polyester, leather, etc.

…

…

…

…

[Specification_n]

Str(200)

Values of the n-th specification

Specification values of the articles for the specification contained in the header line

E.g. header: "Target group", specification values: ladies, men, children, etc.

Sustainability as Specifications

Header (Key)

Description

Value (Value)

Sustainability Label

Specific standard of the sustainability label

Indication of the specific certification standard of the sustainability label

The exact certification standard must be specified when importing the data:

Example 1: Forest Stewardship Council (FSC)

  • Correct Standard: FSC Recycled, FSC Mix, FSC 100% (tick)

  • Incorrect Standard: FSC (error)

Example 2: Oeko-Tex

  • Correct Standard: Oeko-Tex Eco Passport, Oeko-Tex Made in Green, Oeko-Tex Standard 100 (tick)

  • Incorrect Standard: Oeko-Tex (error)

On the product detail page, only selected labels that have been checked for validity by the internal sustainability team are displayed on the products. To make it easier for customers to understand and filter the labels, they are assigned to so-called sustainability properties (e.g. ‘FSC Recycled’ appears in the filter as ‘Recycled materials’). New sustainability standards are checked by the Sustainability Team. The process can take some time.

Possible Values: Rainforest Alliance, V-Label, Oeko-Tex Standard 100, Blauer Engel, FSC Mix etc.

An overview of the labels accepted to date and their allocation to the respective sustainability properties can be found here.

Sustainability Certificate

Certificate number/licence number

Specification of the certificate number

Possible Values: 10857700, CU3934720, etc.

This information is used to validate the sustainability standards. Failure to provide this information may result in the sustainability labels not being displayed on the product detail page due to a lack of validation!

Certification Body

Certification body for verifying the certificates

Indication of the certification body that issued/verified the certificate

This information is not yet displayed on the product detail page but is already used to validate the sustainability standards. Failure to provide this information may result in the sustainability labels not being displayed on the product detail page due to a lack of validation!

Possible Values: Control Union, CERES, Ecocert etc.

Country of Origin

Country of Origin (corresponds to Production Country/Country of Origin)

Origin (Production Country) of the delivered item or country where the majority of value creation has taken place The EU Rules of Origin must be observed. If a GTIN or product has multiple countries of origin because it was manufactured in different countries (usually only the case for large manufacturers), all countries of origin must be provided. Possible values are country names or country codes: Switzerland, China, Ecuador, Thailand, US, UK

If you have any questions about the criteria, please contact sustainbility@digitecgalaxus.ch

DeclarationData as Specifications

Header (Key)

Designation

Description (Value)

EnergyEfficiencyClass_2021

Energy efficiency class

Values A to G (based on standard 2021)

PowerConnectorAppliance

Power supply to the device

Specification of the socket for articles with power operation

Expected Values: No current, built-in, USB, EC-60320 C1, EC-60320 C5, EC-60320 C7, EC-60320 C13, EC-60320 C15, EC-60320 C15A, EC-60320 C17, Others

PowerConnectorWall

Power supply to the wall

Specification of the plug for articles with power operation

Expected Values: Plug-type C (CEE 7/16), Plug-type C (CEE 7/17), Plug-type F (CEE 7/4), Plug-type J (SEC 1011), others

HazardStatements

H-phrases

Information on hazards of chemical substances

E.g.: H201, H301+H331, EUH204

SolidWoodType

Solid wood type

Scientific name of solid wood according to the wood database

SolidWoodOrigin

Solid wood origin

SolidWoodOrigin based on standard ISO 3166 ALPHA-2, E.g.: CH, DE

FILE STRUCTURE ACCESSORYDATA

Accessory

  • File name: AccessoryData_[ProviderName]. [FILE FORMAT] (ex. AccessoryData_digitecgalaxus.csv)

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

The supplied items will be included in the accessory selection of the main item.

note

Use the following CSV-sample

Use the following CSV-sample

note

Use the following XSLX-sample

Use the following XSLX-sample

Minimal criteria AccessoryData

Header

Data type

Designation

Description

ProviderKey

Str(50)

Article number of main article

Article number of the main article

AccessoryProviderKey

Str(100)

Article number of accessory

Article number of the accessory article (matching to the main article)

(blue star) Stage 2: product creation

(blue star) to Top

Data transmission(blue star)