Navigation

Migros Data Access

Logins for Data Access

You can get your credentials by filling out this form.

Migros Product Data

The product data consists of 2 ZIP files (7z) with data of Migros products in JSON format: /products/products_de.7z for product data with German texts, whereas the file /products/products_en.7z contains the product data with English texts, as far as there are English texts available. Mostly, when no English text is available, the texts are in German as a fallback.

Each file within the ZIP file represents the data for one product.
The filename is the Migros article number of the product.

Model Structure

The structure of the JSON in each file is defined in the file openapi.yaml as an OpenAPI specification.
You can visualize this file on https://editor.swagger.io/ if you like.

Not every product has all the fields described in the specification.
There might also be fields in the specification which no product has set.
 

CO2 Data

Most food products have CO2 data. Those data can be found in the object «co2_compensation». The value of «co2_compensation.kg_co2» tells you how much CO2 emmissions have been caused by this product for production, transport and packaging. The field «co2_compensation.kg_co2_compensation» has the same value, unless the product got paid to offset the carbon footprint.

 

Data for M-Check sustainability scale

Every food product from a Migros-owned brand has some M-Check sustainability data. Those data can be found in the object «m_check2», and it includes its CO2 footprint, including the CO2 percentage through production, packaging and transportation. Additionally, it also contains an "animal welfare" rating. 

Here is a visual representation of those data:
 

M-Check

Circularity and Material Health

The file "Dimension_circularity.csv" consists of the following data for selected non-food articles (Migros owned brands):

  • Column 'Material_health': This data indicates how environmentally friendly the ingredients are 5 star(*****) is best.
  • Column 'Circularity': This data indicates how recyclable the ingredients are 5 star(*****) is best.
  • Column 'Product_number': Migros article number
  • Column 'Product_description': Product description

Fish

The file "Fish.csv" consists of the following data for selected fish articles (Migros owned brands):

  • Column 'Product_number': Migros article number
  • Column 'Product_description': Product description
  • Column 'M-Check Fisch': Rating to what extent fish and seafood are caught and produced in a way that preserves wild stocks and ecosystems in the long term '5' is best.

Packaging

The file "M-Check_packaging.csv" consists of the following data for selected articles (Migros owned brands):

  • Column 'Product_number': Migros article number
  • Column 'Product_description': Product description
  • Column 'M-Check Packaging': Rating how environmental friendly the packaging is '5' is best.

Migros Shopping Cart Data

The shopping cart data consists of 20 CSV files with shopping cart / sales data from the past 20 months from anonymized customers.

In total the files contain the purchases of 10'000 households. Each household is uniquely (even accross files) identified by the `KundeID`. Each shopping cart is uniquely identified by the combined key YYYYMM-KundeID-WarenkorbID.

Each file is a sample of the sales of one month.

Each file contains 10 columns:

  • `YYYYMM`: reflects the filename and is year and month
  • `KundeID`: anonymised household number
  • `WarenkorbID`: a per-file, per-household sequence number
  • `ProfitKSTID`: shop ID
  • `ProfitKSTNameD`: shop name
  • `GenossenschaftCode`: cooperative ID
  • `TransaktionDatumID`: date of purchase in the form YYYY-MM-DD
  • `TransaktionZeit`: time of purchase (local time) in the form (H)HMMSS
  • `ArtikelID`: Migros product number
  • `Menge`: contains the amount bought: This might be in pieces or kilogram, depending on the article (meter or square meter are possible too but both are uncommon).