2 Data Preparation Stage 2

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

Table of Contents

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.

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 to show 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 for detailled 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 PRODCUTDATA

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

Use the following CSV-sample

Minimal: ProductData_min_Provider.csv
Minimal EU-Hub: ProductData_min_EUhub_Provider.csv
Extended: ProductData_all_Provider.csv
Extended EU-Hub: ProductData_all_EUhub_Provider.csv

Use the following XLSX-sample

Minimal: ProductData_min_Provider.xlsx
Minimal EU-Hub: ProductData_min_EUhub_Provider.xlsx
Extended: ProductData_all_Provider.xlsx
Extended EU-Hub: ProductData_all_EUhub_Provider.xlsx

Minimal criteria: ProductData

Header	Data type	Designation	Description
ProviderKey	Str(100) 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	Die Produktkategorie bildet die tiefste (detaillierteste) Ebene des Kategorien-Stammbaums. Digitec Galaxus can provide the in-house category structure 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 minimum criteria for EU hub partners: ProductData

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). Validation based on expample "bound children's book"
CountryOfOrigin	Str(2)	Country of origin	Origin (country of production) of the delivered item. CountryOfOrigin is Standard ISO 3166 ALPHA-2, E.g.:* CH, DE*

Supplementary criteria for optimising data quality: ProdcutData

Expand here for display of supplementary product data fields → manufacturer number, packaging dimensions, release date, variant names, product description.

Header	Data type	Designation	Description
ManufacturerKey	Str(4-50)	Manufacturer number of the article	Unique identification number of the manufacturer of a product. Manufacturer numbers must be unique within the same brand/manufacturer. Manufacturer numbers must contain at least four characters. Duplicate manufacturer number-brand combinations are categorically excluded.
Length_[unit]	Dec(8,4)	Packing length	Width of the original packaging "unit" - possible units: mm (millimeter), cm (centimeter), m (meter)
Width_[unit]	Dec(8,4)	Packaging width	Width of the original packaging "unit" - possible units: mm (millimeter), cm (centimeter), m (meter)
Height_[unit]	Dec(8,4)	Packing height	Height of the original packaging "unit" - possible units: mm (millimeter), cm (centimeter), m (meter)
ReleaseDate_[country]	Date	Publication date	Date information for new publications. The date is displayed in the shop. "country" based on standard ISO 3166 ALPHA-2, e.g.* ReleaseDate_CH*
TARESCode	Str(9)	Swiss customs tariff number (TARES)	TARES database, e.g.* "12345678" od. "1234.5678"* The validation of the content only allows the optional character "." (dot). Other special characters are not allowed Regex for validation: /^([0-9]{4})\.?([0-9]{4})$/
VariantName	Str(100)	Family name/variant name	Unique identification for items that belong together. Digitec Galaxus uses this information to create product variants It is recommended to use the ProductTitle without additions as this is already identical for many products with variants
ProductTitle_[language]	Str(100)	Item name/Product name [en,fr,it]	Cleaned name of the item in a complementary language English, French or Italian. Product names must be consistent and cleansed of specifications. 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. "language" based on standard ISO 639-1, e.g.* ProductTitle_en, ProductTitle_fr, ProductTitle_it*
LongDescription_[language]	Str(4000)	Detailed description of the article [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 appearance in the online shop and the buyability of the products. Please note our guidelines on data quality. The product description is kept general and does not contain any advertising texts or partner-specific information. Web links and bullet points are not allowed. One of the languages German, English, French or Italian is compulsory. "language" based on ISO 639-1 standard, e.g.* LongDescription_en, LongDescription_fr*
Composition_[language]	Str(4000)	Composition [de,en,fr,it]	Description of the composition or ingredients of a product. These are required by law for specific product groups, i.e. they are compliance-relevant. These are e.g.: List of ingredients (all ingredients contained in a food must be listed) Allergy declaration (ingredients and the products made from them that may cause allergies or other adverse reactions must be specifically identified) Ingredients (e.g. perfume) 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. “language” based on ISO 639-1, e.g.* Composition_de, Composition_en, Composition_fr*
Application_[language]	Str(4000)	Application [de,en,fr,it]	Description of the application of a product. These are required by law for specific product groups, i.e. they are compliance-relevant. This applies to the following product groups: Medical devices Medicine 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. “language” based on ISO 639-1, e.g.* Application_de, Application_en, Application_fr*

Optional criteria for future optimisation of ProductData

Expand here to display the optional master data fields → Warranty and DOA period, return type, age restriction.

The following information cannot be processed at the moment. However, we are constantly optimising our technical systems and will expand the information processing for corresponding fields in due course. Supplying the information in the data files helps us to better assess the relevance and prioritisation of future extensions.

Header

Data type

Designation

Description

WarrantyPeriod

Int(3)

Warranty period

Service case type: Warranty. Manufacturer's specifications. (in months)

DeadOnArrivalPeriod

Int(3)

DOA deadline

Service case type: DOA (Dead on Arrival). Manufacturer's specifications. (in days)

A DOA case is considered to be all directly recognisable defects in the product that already existed at the time of delivery to the end customer or that occur within the specified DOA period.

ReturnType

Int(1)

Return type

1: BringIn, 2: OnSite, 3: PickUpAndReturn / manufacturer's information

MinimumAge_[country]

Int(2)

Legal age limit

Legal age limit (in years)

"country" based on standard ISO 3166 ALPHA-2, Bsp: MinimumAge_DE

NutritionalValue_language

Str(4000)

Nutrition labelling

Nutritional values in continuous text form

ProductRemark

Int(2)

Product remarks

1: small parts, 2: assorted colours, 3: biocidal products, 4: plant protection products, 5: electrical safety, 6: delivery of tyres, 7 animal encolusre, 8: CO2 Emissions

Product information is displayed in the shop on the product page.

Expand here for further information

No	Type	Note in shop
1	Small items	“Attention: Not suitable for children under 36 months due to small parts that can be swallowed.” “Attention: Not suitable for children under 18 months”
2	Assorted colors	The color of this item cannot be selected.
3	Biocidal products	Use biocides carefully. Always read the label and product information before use.
4	Plant protection products	Use pesticides with care. Always read the label and product information before use.
5	Electrical safety	Due to its high power, this device requires a 16 amp fused socket (type 23). If no suitable box is available, the conversion must be carried out by an authorised installer.
6	Delivery of tires	The price is per tire. The rim shown is not included.
7	animal enclosure	IMPORTANT! When purchasing a rodent home, rodent house and free-range enclosure, please observe the provisions of the Animal Welfare Ordinance (TSchV 455.1). Please note the information below on animal-friendly husbandry as well as the legally prescribed minimum space for each animal species.
8	CO2 Emissions	Average CO2 emissions of all new cars offered in Switzerland: 137 g/km.Driving style, road and traffic conditions, environmental influences and vehicle condition can affect the consumption values.

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

Minimal: MediaData_min_Provider.csv
Extended: MediaData_all_Provider.csv

Use the following XLSX-sample

Minimal: MediaData_min_Provider.xlsx
Extended: MediaData_all_Provider.xlsx

Minimal criteria: Media Data

Header	Data type	Designation	Description
ProviderKey	Str(100) 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 / FTP)	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. You cannot generate image links yourself? No problem! 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(300)	Additional image links (HTTPS / FTP)	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

Click here to view the supplementary criteria media → product link

Header	Data type	Designation	Description
ProductLink_[language]_[index]	Str(300)	Product links (HTTPS)	EOne link per column. Product links can point to manufacturer pages, product reviews, etc. · Links to resale platforms and other online shops are prohibited. "language" based on standard ISO 639-1 "index" - Consecutive numbering for multiple URLs in the same language. E.g.: ProductLink_de_1, ProductLink_de_2, ProductLink_en_1, ProductLink_en_2, ...

Declaration Media in MediaData

Expand here to show declaration media → Engerylabel, SafetyDataSheet

Header	Data type	Designation	Description
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. See Stage 3: Declaration Data as Specification
SafetyDataSheet	Str(300)	Safety data sheet Document link (HTTPS)	Product specific safety data sheet

Optional criteria: MediaData

Click here to view optional criteria Media → Documents, Videos, Customs Documents

The following information cannot be processed at the moment. However, we are constantly optimising our technical systems and will expand the information processing for corresponding fields in due course. Supplying the information in the data files helps us to better assess the relevance and prioritisation of future extensions.

Header	Data type	Designation	Description
ProductShopURL	Str(300)	Product link(HTTPS)	Direct link to the offer in the partner's online shop
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. "language" based on Standard ISO 639-1 "index" - Consecutive numbering for multiple URLs in the same language. E.g.: DocumentURL_de_1, DocumentURL_de_2, DocumentURL_en_1, DocumentURL_en_2, ...
VideoURL_[language]_[index]	Str(300)	Video links (HTTPS)	One link per column. Currently only YouTube and Vimeo video links are supported. Only official videos from the manufacturer are used (copyright). We do not show violence for advertising purposes, neither on animals nor on humans "language" based on Standard ISO 639-1 "index" - Consecutive numbering for multiple URLs in the same language E.g.: VideoURL_de_1, VideoURL_de_2, VideoURL_en_1, VideoURL_en_2, ...
CustomsDocumentType_[country]	Str(300)	Customs document type	"country" - in the ISO 3166 ALPHA-2 standard, e.g. CustomsDocumentType_DE Example of a customs document type: "3LLC.N.O.R.N.R. O.A18".
CustomsDocumentURL_[country]	Str(300)	Customs document link (HTTPS)	One link per column "country" - based on Standard ISO 3166 ALPHA-2, E.g.:* CustomsDocumentURL_DE*

⬅ Stage 1: offer creation

⬆ to top

Stage 3: specification enrichment ➡