/
1 Data Preparation Stage 1

1 Data Preparation Stage 1

DATA INTEGRATION STAGE 1

Offer Assignment

 

By completing this stage, you enable us to assign your offers. You benefit from the existing product portfolio of our online shop, as your offer data is attached to already maintained products (overlapping assortment).

Once activated, the offers are matched and assigned to our product portfolio. The minimum criteria for this process are item number, price, stock, and EAN/GTIN.

Table of Contents

GTIN & PROVIDER KEY

The Provider Key is the unique item number for a product in the partner’s assortment. It is used as an identification number and must be included in all submitted files. The Provider Key is used on all orders as the identification number for the item. Already assigned item numbers must under no circumstances be reused for other products.

At Galaxus, the Provider Key and GTIN form a unit and correspond to a single product. New GTINs must be submitted with new Provider Keys. Changes to the GTIN for the same Provider Key are prohibited.

Data Flow Galaxus: https://confdg.atlassian.net/wiki/spaces/PHCL/pages/171675230555

 

TRANSMISSION FREQUENCY

Correct and up-to-date information is essential for smooth order processing. We aim for a transmission frequency of at least every 15 minutes.

 

image-20260217-083657.png

Master data, price, and stock are overarching categories for the individual columns.

Stock levels can also be submitted separately, allowing them to be sent quickly and more frequently, independent of other data.

https://confdg.atlassian.net/wiki/spaces/PHCL/pages/171675230154

image-20260217-083719.png

 

 

 

ASSORTMENT DEFINING FILE

Items that are considered EOL (End-of-Life) products, products without an active offer in the system must be removed from the corresponding file by the next transmission at the latest.

 

The specification of the "Assortment file" must be included in the file name:

  • Example: StockPricingData_ExampleAG_assortment.csv

 

NOTES ON DOCUMENTATION

The documentation of the data structure contains technical terms and notes in various places. These are essential for correct data preparation and if properly implemented in the files greatly simplify the technical integration. In the table below, you will find further explanations and examples.

 

DATA STRUCTURE STAGE 1

General notes

  • File name: StockPricingData_[ProviderName].[FILE FORMAT] (e.g. StockPricingData_digitecgalaxus.csv)

  • Transmission frequency: every 30 minutes (at least once per day)

  • All quantity specifications listed here refer to retail packaging (Consumer Unit, CU).

  • Without explicit specification of minimum order quantities and order quantity steps, 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 for Optimizing Availability and Order Processing”.

The minimum criteria listed here are relevant for offer assignment.

We recommend that anyone who wants to benefit from the automated creation of new products implement the extended master data preparation 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: Offer Assignment

Kopfzeile

Data type

Designation

Description

Kopfzeile

Data type

Designation

Description

ProviderKey

Str(50)
ASCII 32-126

Partner-specific ProviderKey

Unique identification number of the item.

  • Item numbers must be unique. Duplicates are not permitted.

  • We only accept characters in the ASCII range 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 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 GTIN assigned to an item should not be changed. Subsequent adjustments are prohibited. It is therefore important that you maintain the correct GTIN from the very beginning. An incorrect or modified GTIN can lead to incorrect assignments and incorrect data and orders.

  • 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

  • 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 can be found at: gtin.info or GS1 Switzerland.

  • The GTIN physically printed on the product must match the GTIN transmitted to us.

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

ManufacturerKey

Str(4-50)

ManufacturerKey of the article

Unique identification number assigned by the manufacturer to 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 spaces, separators, or any other changes.

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

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.

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.

Additional criteria for optimizing availability and order processing

Kopfzeile

Data type

Designation

Description

Kopfzeile

Data type

Designation

Description

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

LeadTime and Made-To-Order or Configure-To-Order Quantity (=MtoCtoQuantity) will only be considered if the partner account is authorized for it. Authorization is granted only to partners who offer Made-To-Order or Configure-To-Order products in their feed. To obtain authorization, please contact your Portfolio Development Manager.

LeadTime

Int(3)*

Production time in working days

The Lead Time refers to the number of working days required from the time of order placement until the goods are manufactured and ready for shipment.

For products that are produced on-demand and not kept in stock, a lead time must be specified. This information impacts availability and the shop display shown to the customer.

  • Maximum value = 90

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

  • Lead Time is only considered if the stock level is 0. If the stock level is positive, the value is ignored.

MtoCtoQuantity

(Made-To-Order / Configure-To-Order)

Int(5)

Possible production quantity

The MtoCto Quantity refers to the amount of goods that can theoretically be produced and made ready for shipment within the specified lead time from the order date.

This information is only relevant when lead time is available and is used for automated ordering processes.

Criteria:

  • Stock level is 0 → If the stock level is positive, the value is ignored.

  • Lead time is available.

  • MtoCtoQuantity is a positive number.

  • MtoCtoQuantity = 0 → considered as unknown availability.

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,…

These data are not yet taken into account; however, we are working on integrating them into our system so that we can consider them in the future.

  • 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