Data dictionaryFifteen columns,
in export order.
The export's header row, in order, confirmed against the platform's published column list. Descriptions say what each field is for; they claim nothing about its format or how often it arrives filled - see the note above.
- query
- The Lyreco URL you submitted, repeated on every row that came from it. 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.
- price
- The asking price. The unit is in
currency, not in this column. - currency
- The currency the price is quoted in. Worth reading per row rather than assuming from the storefront, since Lyreco operates across several countries.
- availability
- The stock status the listing publishes.
- brand
- The brand the product is filed under.
- sku
- The retailer's own article number - Lyreco's identifier for the line, and the one to quote back to them.
- mpn
- The manufacturer's part number. The field to match on when the same item is sold by more than one supplier under different article numbers.
- 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.