Data dictionaryFifteen columns,
in export order.
The export's header row, in order, confirmed against the platform's published column list. Where a value shape has actually been observed it is described; where it has not, the entry says what the field is for and stops.
- query
- The Zalando URL you submitted, repeated on every row that came from it - returned character for character, including any pagination parameter. Written by the scraper rather than taken from the page, so it is there on every row.
- service
- Which retailer this row came from - also written by the scraper. It matters because this tool serves several retailers behind one form, so a file assembled from more than one job stays separable.
- name
- The product name as the listing gives it. On Zalando that runs brand and model, then the category, then the colourway - which is where a variant is identified, since the export has no colour column of its own.
- price
- The asking price, as text rather than as a number - a decimal point and no currency symbol. Cast it before you compare or total. The unit is in
currency, not in this column. - currency
- The currency the price is quoted in. Read it per row rather than assuming it from the storefront: Zalando runs a different shop per country and the column is what tells you which one a row came from.
- availability
- The stock status the listing publishes.
- brand
- The brand the product is filed under, on its own rather than glued to the front of the name.
- sku
- Zalando's own article code for the listing - the identifier to quote back to them, and the one that stays stable when a product name is reworded.
- mpn
- The manufacturer's part number. The field to match on when the same item is sold by more than one retailer under different article codes.
- gtin
- The global trade item number - the barcode identifier. The most reliable join key across catalogues when it is published.
- rating
- The average rating shown for the product.
- reviews
- How many reviews that average is built on.
- image
- A link to the product image.
- url
- A link to the product page. The column to keep if you ever need to check a value by hand.
- description
- The product description as published.