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 product 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.
- item_id
- Walmart’s numeric item id, taken from the URL. The same product submitted with and without its slug yields the same id, which makes this the column to join on.
- name
- The listing title as Walmart publishes it.
- brand
- The brand the product is filed under, separate from the title.
- price
- The asking price, as text rather than as a number and without a 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.
- rating
- The average rating shown on the listing. Text, like the price.
- review_count
- How many reviews that average is built on. Also text - cast it before you sort on it.
- availability
- The stock status, as a machine-shaped uppercase token rather than display prose, which is what makes it safe to filter on directly.
- seller
- The merchant behind the buy box. A walmart.com listing is not always sold by Walmart, so this is the column that separates a marketplace listing from a first-party one.
- category
- The category the listing sits in.
- description
- The product description as published.
- 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.
- position
- Where the product fell in the order it was collected for that query, counting from one. It arrives as a real number while the counts beside it arrive as text, and unlike some scrapers here it is a published column in both the spreadsheet and the JSON.