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!
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.
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)
Minimal criteria: ProductData
Header | Data type | Designation | Description |
|---|---|---|---|
ProviderKey | Str(50) | Partner specific item number | Unique identification number of the partner item |
Gtin | Int(8) | 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:
|
BrandName | Str(100) | Brand / Publisher | Manufacturer's brand of the item. |
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. |
ProductCategory | Str(200) | Product category of the article | The product category is the deepest (most detailed) level of all categories. |
Weight_[unit] | Dec(8,4) | Packaging weight [mg,g,kg] | Packaging weight: Product weight plus original packaging of a retail package. |
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. |
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".  |
CountryOfOrigin | Str(2) | Country of origin | Origin (country of production) of the delivered item. |
Supplementary criteria for optimising data quality: ProdcutData
Optional criteria for future optimisation of ProductData
FILE STRUCTURE MEDIA DATA
Minimal criteria: Media Data
Header | Data type | Designation | Description |
|---|---|---|---|
ProviderKey | Str(50) | Partner specific item number | Unique identification number of the partner item |
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. |
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. |
Supplementary criteria: MediaData
Declaration Media in MediaData
Optional criteria: MediaData