- query
- The product URL you submitted, repeated on every row that came from it. Written by the scraper rather than read off the page, so it is there on every row including the ones that failed.
- sku_code
- A stock code for the item. This schema carries two stock-code columns - see
sku below and the note under this table. - product_url
- A link to the product. This schema carries two link columns - see
url below. - name
- The product name as the page gives it.
- description
- The product description as published.
- parsed_price
- A price field. This schema carries two price columns alongside
currency - see price below. - price
- The other price field. Which of the two is numeric and which is the displayed string is not something we can tell you, and the note under this table explains why.
- currency
- The currency the price is quoted in. Read it per row rather than assuming it from the storefront.
- availability
- The stock status the page publishes.
- rating
- The average rating shown for the product, where the page shows one.
- reviews
- How many reviews that average is built on.
- images
- An image field, plural. See
image below - the schema carries both. - brand
- The brand the product is filed under.
- sku
- The second stock-code column. If you are joining across suppliers, check both this and
sku_code on your own first rows before choosing one. - url
- The second link column. Worth knowing: on the failed rows we hold, this one carried the address that was submitted while
product_url was empty - which is a hint about error behaviour, not a description of a successful row. - image
- The singular image field, second to last in the file.
- status
- How the request went, in readable words. This is the column to check first: a query that returns no product data still produces a row, and the reason is written here.