3 Data Preparation Stage 3

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!

⬅ Back to stage 1: Offer creation and allocation
⬅ 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.

Expand here for detailled data format

Type	CSV-Standard	XLSX-Standard	Exception/ Remark / Example
File format	CSV / TXT	XLSX	Other formats possible in consultation but not recommended
File name	File names for initial configuration - without spaces / special characters / umlaut. File names for file updates - the files must be replaced by the old files for each transmission and have exactly the same file names as the previous ones.		Examples: ProductData_DigitecGalaxus.csv PriceData_DigitecGalaxus.xlsx
Character coding	UTF-8	-	Other character codes possible in consultation but not recommended
Separator	; (Semicolon)	-	Other limit signs possible in consultation
Header	Header with column designation is mandatory		Duplicates are not allowed for column names Column name must be present Column names must not contain line breaks Example XLSX - break in Header
Decimals	Decimal places must be separated with a . (dot) or , (comma).		Example - VatRatePercentage: 8.1 Thousands separators are not allowed: 1000 or 1',00 Comma must not be used if the separator in the CSV is also a comma
Text / Parsing	Strings (data type: text) must be enclosed in inverted commas (").	-	In the case of descriptions and product data, it is particularly important that these are enclosed in inverted commas because they can contain the characters that also act as separators (semicolon, comma, pipe) and/or line breaks which, if unmasked, prevent the import. In the example, you can see the correct masking of inches, as well as the masking of the inverted commas that appear in the texts. LongDescription_en: "TV with size 46"" and stand with white label ""Kings of E-Commerce""
Strcuture	The structuring of the data within the text file must be observed.	The data to be read in is in the first sheet tab and there are no hidden sheet tabs Completely empty lines or notes in the file should be avoided if possible.	ExampleXLSX - Multiple worksheets Example - Empty Line / notes
Scientific notations	Scientific notations are not allowed		Often csv files are opened and saved in Excel. This process changes the structure of the numbers contained in the file. Information such as Gtin, item number and others become unusable as a result. See example: Example - Scientific notations
Number format	-	·Cells with numeric values may only be in standard or number format. Other formats, such as accounting or user-defined, are not allowed Excel deletes leading zeros from numbers, which can lead to problems, especially with article numbers or GTINs. In such a case, the partner should format the affected column as text.	Example - number formats Example - Leading zeros
Date	Option 1: YYYY-MM-DD Option 2: DD.MM.YYYY		One-digit days/months must be supplemented with a leading zero, e.g. 2020-07-01 or 01.07.2020. Separators are to be used according to the formats.

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.

Expand here to see detialled notes on documentation

Topic	Designation	Example
Data declaration	Str: String, Text Int: Integer, Number Short: (Signed short) 0 - 32'767 Ushort: (Unsigned short) 0 - 65’535 Dec: Decimal, Number with decimals Bool: Boolean, true/false, 1/0 Date: Date	-
Information in brackets	After the data type, the permissible number range, the number of characters or the format is indicated in brackets. (10): A maximum of 10 digits or characters are permitted. (10,4): A maximum of 10 digits before and 4 digits after the decimal point are permitted. (8-14): Between 8 and 14 digits or characters are allowed.	Str(100), Int(5), Dec(8,4)
Indexierung	*_index: Describes a consecutive numbering of columns with the same content.	ImageUrl_1, ImageUrl_2
Sprachen	_language: Describes the language identification of language-dependent columns with the same content. (following standard ISO 639-1)*	ProductTitle_de, ProductTitle_en
Währung	*_currency: Describes how to mark the currency of price columns. Prices can be indicated in CHF or in EUR.	SalesPriceExclVat_CHF, PurchasePriceExclVat_EUR
Einheiten	*_unit: Describes the labelling of the units of dimension-specific columns. The permissible units are indicated in the corresponding columns.	Weight_g, Length_cm
Länder	_country: Describes the country identification of country-specific columns. (following standard ISO 3166 ALPHA-2)*	ReleaseDate_CH, ReleaseDate_DE

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 )
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:

Option 1: Key-Value-Pair

Ein SpecificationValue pro Zeile (bevorzugt)

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

For this structure, the same separator must be used in the complete file. Allowed separators for multiple values: "; "(semicolon), "," (comma), “|“ (separator), “\” backslash.

ProviderKey	SpecificationKey	SpecificationValue
item_01	color	black\|yellow\|blue
item_01	material	plastic\|metal

Option 2: Column

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

Use the following CSV-sample

KeyValue: SpecificationData_kv_Provider.csv
Column:SpecificationData_c_Provider.csv

Use the following XLSX-sample

KeyValue: not available
Column: SpecificationData_c_Provider.xlsx

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 (Spezialfall)

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.

DeclarationData as Specifications

Click here to view the declarations → EnergyEfficiencyClass, HazardStatements, PrecautionaryStatements, SolidWoodType, etc.

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

Expand here to show further information

Designation	Description	Illustration
No current	The article has no connection to the power grid.	-
Built-in	The article has a fixed power cable	-
USB	Socket for USB cable	-
EC-60320 C1	Socket for electric shavers. These are somewhat similar to the C7 connector, but have no waist.
EC60320 C5	Commonly referred to as a "clover-leaf" or "Mickey Mouse". Used for many switched-mode power supplies for notebooks.
EC-60320 C7	Socket for small appliances. Commonly referred to as "figure 8" or "infinity" in the UK.
EC60320 C13	Very common on personal computers and peripherals. Mainly used for the power connection of devices which do not generate any significant heat during operation.
EC60320 C15	For use in high-temperature settings (for example electric kettle, computer networking closets).
EC60320 C15A	For use in very-high-temperature settings, such as some stage lighting instruments. Similar to C15/C16, but the top is narrowed to exclude the C15 cord connector.
EC60320 C17	Socket for cold appliance plug without earthing contact.
Others	“Others" includes all connector types that are not included in the list.	-

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

Weitere Erläuterungen HIER einblenden

Designation	Description	Illustration
Plug type C (CEE 7/16)	The Europlug has no protective conductor and is not reverse polarity protected. The contacts with a diameter of 4 mm are at a distance of 19 mm from each other.
Plug type C (CEE 7/17)	This contour connector has two contacts with a diameter of 4.8 mm at a distance of 19 mm. Above and below the axis, there are two recesses to accommodate the French earthing pin or the German earthing terminals.
Plug type F (CEE 7/4)	This plug, commonly referred to as Schuko plug, has two contacts with 4.8 mm diameter and 19 mm length. Two contact surfaces on the connector side ensure the earth contact with existing contact springs on the socket.
Plug type J (SEV 1011)	The Swiss plug type J has three contact pins. The middle pin serves as a protective contact and is slightly offset. In addition, it forms the first contact, since the current-carrying contacts are lower in the socket.
Others	“Others" includes all connector types that are not included in the list.	-

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.

Use the following CSV-sample

AccessoryData_Provider.csv

Use the following XSLX-sample

AccessoryData_Provider.xslx

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)

⬅ Stage 2: product creation

⬆ to Top

Data transmission➡