- query
- The BiggestBook URL you submitted, echoed on every row so an export covering many products stays separable. Keep it: it is the only record of which input the rest of the row answers.
- sku_code
- The item code as the catalogue prints it. Paired with
sku below - check both before choosing a join key, because in this schema family they are populated independently. - product_url
- The canonical product page. Distinct from
url, which reports the address the row was actually produced from; the two differ whenever a submitted link redirects. - name
- The product title as shown on the page.
- description
- The description copy. Expect a long free-text field rather than a short label, and give it a wide column or a text type in your database.
- parsed_price
- The price as a bare number, with no symbol and no thousands separator - the one to use for arithmetic, sorting and thresholds.
- price
- The price as displayed. Use it when you need to show a customer exactly what the catalogue said; use
parsed_price when you need to compute. - currency
- The currency the price is quoted in. Always read it rather than assuming - a distributor catalogue can serve a different currency to a different account or region.
- availability
- The stock state as published on the page. Treat it as the catalogue's claim at scrape time, not as a live inventory feed.
- rating
- The average rating, where the page publishes one. A distributor catalogue frequently does not, so write the importer to accept an empty cell rather than to fail on it.
- reviews
- The review count, subject to the same caveat as
rating. Where both are present they belong together; a rating with no count behind it is not worth ranking on. - images
- Every image the page carries, in one field. Split it before storing if you need one row per asset.
- brand
- The manufacturer or brand. This is the field to group on for assortment work - which makers a distributor lists, and how deep each line goes.
- sku
- The stock-keeping unit. The other half of the identifier pair with
sku_code. - url
- The address the row was produced from. Compare it against
query to spot redirects, and against product_url to spot canonicalisation. - image
- The primary image on its own, so the common case - one thumbnail per product - needs no string splitting.
- status
- A per-row flag written by our exporter, not by BiggestBook. It reports whether the row was retrieved. Both runs behind this page carry
http 404 here, because the URL submitted was a placeholder that does not exist.
Two runs sit behind this page, from 14 and 15 July 2026, and their payloads are byte-identical. Both submitted https://www.example.com/product/123 - a placeholder, not a BiggestBook address - and both returned a single row reading http 404 with all fourteen data columns empty. So we can tell you the schema with confidence and we can tell you nothing about BiggestBook's values, and this page does not pretend otherwise. The seventeen names appear in the same order in our CDW, AutoZone, Brady and Decathlon exports, and the Decathlon run is populated across 66 rows, which is how we know the schema is live rather than a stub.