/
Stage 1: Alternative Approach

Stage 1: Alternative Approach

DATA STRUCTURE

For the fastest possible activation of the complete assortment, the master data of the items as well as stock and price data are required. For a successful data flow, it is essential to provide structurally stable files. Therefore, it is strongly recommended that these three information areas be split into three separate files, provided that stock levels are transmitted with a delay.

 

 

image-20260217-074031.png

 

 

 

ASSORTMENT DETERMINING FILE

One of the files is the assortment-determining file (assortment file), which controls the active assortment. Only items that are included in the assortment file are activated.
Items that can no longer be delivered or are considered EOL products (products with no active offer in the system), must be removed from the respective file—ideally from all files—no later than with the next transmission.
We recommend controlling the assortment via the price data.

The file name must include the identifier for the assortment file:

  • Example: StockData_BeispielAG_assortment.csv

 

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.

 

MASTER DATA FILE STRUCTURE

General notes on master data

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

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

The minimum criteria listed here are only relevant for offer data creation and assignment.

We recommend that anyone who wants to benefit from the automated creation of new assortments implements the advanced data preparation of the master data directly in “Stage 2: Product creation”.

→ Go directly to Master Data Preparation "Stage 2: Product creation"

 

Use our CSV template

Use our XLSX-Template

 

 

Minimum Criteria: Master 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.

MainGtin

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

 

Main EAN/GTIN code of the sales unit (consumer unit)

Unique and globally valid identification number of the manufacturer’s 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 main GTIN once assigned to an item should not be changed. Subsequent modification is prohibited. It is therefore important that you maintain the correct GTIN from the outset. An incorrect or changed GTIN may lead to incorrect assignments as well as incorrect data and orders. The product may be blocked and not taken into account for purchase.

  • The physically printed GTIN must match the submitted GTIN.

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

  • The EAN/GTIN must be visible on the retail packaging.

  • The EAN/GTINs must be unique and globally valid. Duplicates are not permitted.

  • The EAN/GTIN forms the basis for our automated assignment and product creation processes. For a smooth data transfer, please obtain GTINs for your products from: GS1 Switzerland: Request barcode, GS1 Germany: Request barcode

  • Further information on GTINs and GS1 can be found at: gtin.info or GS1 Switzerland.

Gtin_[index]

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

Additional / new EAN/GTIN code of the sales unit (consumer unit)

If multiple GTINs exist for the same sales unit, they must be submitted here. GTINs of the trade unit or logistic unit must not be submitted.

GTINs to be submitted as additional GTINs include those that:

  • were not assigned by the manufacturer, e.g. by suppliers or distributors

  • replace an old GTIN

  • are due to packaging changes

The main GTIN once assigned to an item should not be changed.

  • The physically printed GTIN must match the submitted GTIN.

  • The EAN/GTIN must be visible on the retail packaging.

  • The EAN/GTINs must be unique and globally valid. Duplicates are not permitted.

ManufacturerKey

Str(4-50)

Manufacturer Key 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.

  • Please provide the manufacturer number in full and unchanged. It must not be shortened or modified by adding spaces, separators, or any other changes.

  • Duplicate manufacturer-number/brand combinations are strictly excluded.

PRICE DATA FILE STRUCTURE

General notes on price data

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

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

Use our CSV-Template

Use our XLSX-Template

Minimum Criteria: Price Data

Kopfzeile

Datentyp

Bezeichnung

Beschreibung

Kopfzeile

Datentyp

Bezeichnung

Beschreibung

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.

PriceExclVat_[currency]

Dec(8,4)

Price excluding vat

Digitec Galaxus price excluding VAT and including/excluding product fees.

  • Product fees must be included in the price information depending on the supplier’s registered office:

    • Suppliers with their registered office in the same country as the purchasing party: purchase price incl. product fees

    • Suppliers with their registered office in a different country than the purchasing party: purchase price excl. product fees

  • "currency": currency specified in the header row as CHF or EUR

    • Marketplace CH: only CHF is permitted as the currency.

SuggestedRetailPriceInclVat_[currency]

Dec(8,4)

Suggested retail price incl. VAT.

Suggested retail price incl. VAT.

"currency": currency specified in the header row as CHF or EUR

Not required for merchants.

VatRatePercentage

Dec(2,2)

Vat Rate

VAT rate as a numeric value without the % sign.

Example (Switzerland): 8.1, 2.6, 0.0

Not required for supplier.

STOCK DATA FILE STRUCTURE

General Notes on Stock Data

  • Filename: StockData_[ProviderName].[FILEFORMAT] (e.g. StockData_digitecgalaxus.csv)

  • Transmission Frequency:

Quantity information

  • All quantity information listed here refers to retail packaging units (Consumer Unit, CU).

  • If no minimum order quantities and order quantity steps are explicitly provided, all retail packaging units are processed without minimum quantities. Mandatory order quantities (> 1) must therefore be specified according to the fields described below under “Additional criteria to optimize availability and order processing”.

Use our CSV-Template

  • Minimal:

  • Extenden:

Use our XLSX-Template

  • Minimal:

  • Extenden:

 

Minimum Criteria: Stock Data

Kopfzeile

Datentyp

Bezeichnung

Beschreibung

Kopfzeile

Datentyp

Bezeichnung

Beschreibung

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.

QuantityOnStock

Int(5)

Exact stock quantity

We recommend submitting the exact stock level. This value influences the prioritization of the merchant/supplier when selecting sales offers.

Negative stocks are treated as backlogs.

We primarily use “QuantityOnStock” for availability calculation.
If this value is not provided, 0 , or empty, we use “RestockDate/Time” and “ExpectedRestockQuantity”. This information affects availability and is used for automated ordering processes.

RestockTime

Int(3)*

Restock time in business days

Restock or provisioning lead time in business days until the item is back in the partner’s stock (RestockDate – today). National public holidays can be ignored

  • Maximum value = 365

  • If the value 0 (days) is transmitted, we treat it the same as if no value had been transmitted.

  • Either RestockTime or RestockDate can be provided — both together are not technically possible.

  • RestockTime or RestockDate is only considered if stock level is 0. If stock is positive, the value is ignored.

RestockDate

Date

Restock Date

Date when the item is back in the partner’s stock.

ExpectedRestockQuantity

Int(5)

Expected restock quantity

Expected available stock level at the time the item is back in the partner’s stock.

  • Positive Number

  • 0 treated as unknown availability

 

Additional criteria for optimizing availability and order processing

MinimumOrderQuantity

Short

 

Minimum Order Quantity (MOQ)

The minimum orderable quantity of retail packaging units (consumer units). In contrast to the trade unit (TU), the quantity specified here is binding for both warehouse deliveries and end-customer deliveries. Example: MOQ = 5 → possible order quantities: 5,6,7,8,…

In general, an MOQ > 1 should only be set for logistical reasons and always in combination with the order quantity step (OQS). For example, if plates or glasses cannot be transported individually due to their fragility. If individual shipping is possible, the MOQ should be 1 and a larger outer packaging unit (TU) should be specified instead.

  • Maximum value = 65,535

  • If no MOQ value is provided, we assume 1 unit as the default value .

  • Specifying MOQ < OQS is not valid.

OrderQuantitySteps

Short

 

Order Quantity Steps (OQS)

The minimum orderable quantity and order quantity step for retail packaging units (consumer units). In contrast to the trade unit (TU), the quantity specified here is binding for both warehouse deliveries and end-customer deliveries. Example: OQS = 5 → possible order quantities: 5,10,15,…

In general, an OQS > 1 should only be set for logistical reasons and always in combination with the minimum order quantity (MOQ) should be used. For example, if plates or glasses cannot be transported individually due to their fragility. If individual shipping is possible, the OQS should be 1 and instead a larger outer packaging unit (TU) should be specified.

  • Maximum value = 32,767

  • If no OQS value is provided, we assume 1 unit as the default value .

  • Specifying OQS > MOQ is not valid.

WarehouseCountry

Str(2)

Warehouse country

The country of the warehouse from which the item is shipped. This information is relevant for assortments with multiple warehouses and different delivery times.

  • Indication according to the ISO 3166-2 country code standard.

WarehouseId

Str(50)

Warehouse GLN

The identification number of the warehouse. This information is relevant for assortments with multiple warehouses located in the same country.

  • Global Location Number GLN | GS1 Switzerland

  • If no GLN can be provided, the postal code can be used instead.

DirectDeliverySupported

Bool

Direkt delivery supported

For suppliers with enabled end-customer delivery, individual items can be approved for end-customer delivery or excluded from it.

Permissible values: true, false / 1, 0

RetailUnitQuantity

Int(4)

Retail unit quantity

Number of items per retail unit (consumer unit) packaging.

TradeUnit

Ushort

 

Trade Unit (TU)

Number of retail items (consumer units) per trade unit (TU) / outer packaging quantity. The TU specification is only relevant for warehouse deliveries. Example: TU = 6 → possible order quantities: 6,12,18,…

When purchasing, we use this value as a reference and, where possible, order the exact outer packaging quantity or a multiple of it. Correctly transmitted trade unit quantities (TU) therefore significantly optimize warehouse deliveries.

  • Maximal Value = 65’535

LogisticUnit

Ushort

 

Logistic Unit (LU)

Number of items in retail packaging units (consumer units) per pallet. The LU specification is only relevant for warehouse deliveries.

  • Maximal Value = 65’535