- item_id
- eBay's own id for the listing, as digits. Present on every row, and the value the
url column ends with. - title
- The listing title as written by the seller. Present on every row.
- price
- The price as the listing displays it, symbol and all - the string, not a number. Some listings show text such as See price instead of an amount; see
currency below. - price_parsed
- The same price as a bare number, still a string. This is the one to sort and compare on. It is empty on the rows where the listing showed text rather than an amount.
- currency
- The currency, normally a three-letter code, as its own column so a file spanning several eBay sites stays comparable. Caveat: where the price was text rather than an amount, this picks up the leading word instead of a code - filter those rows out with
price_parsed. - condition
- The condition as the listing states it, free text rather than a fixed set. It includes
-- where no condition is given. - availability
- How much stock the listing declares, as free text such as More than 10 available rather than a count. Item-id and URL lookups only - empty on keyword searches.
- sold
- How many have sold, as a number in a string. Present on many search rows and on some item lookups; absent where the listing does not show it.
- shipping
- Shipping as the listing presents it - Free shipping, Delivery: Varies, or an amount. Read the note above: on a fair share of rows this repeats the price string, so check it against
price before relying on it. - item_location
- Where the item ships from, as free text. Item-id and URL lookups only. This - not
country - is the item's location. - returns
- The returns terms as a sentence of listing text. Item-id and URL lookups only.
- seller_name
- The seller's display name. Item-id and URL lookups only - a keyword search does not carry it.
- seller_feedback_percent
- The seller's positive-feedback percentage, as a string. Item-id and URL lookups only.
- brand
- The brand as the listing declares it. Item-id and URL lookups only.
- type
- The item type as the listing declares it. Item-id and URL lookups only.
- image
- One image URL, the listing's main picture, as a plain string.
- images
- A JSON array of image URLs, not a delimited string - sometimes one entry, sometimes several. Present on every row.
- url
- The listing's canonical link. On every row of every export we hold it ends with the
item_id, which makes it safe to derive one from the other. - country
- The country you asked for, echoed onto every row - a run setting, not an attribute of the item.
- postcode
- The delivery postcode you asked for, echoed onto every row. Empty when you left the field blank.
- position
- Rank within the results for that query, as a number rather than a string. It restarts at 1 for each query, so sort by
query then position to rebuild a results page. - query
- The exact input this row came from - the id, URL or search term you submitted. Written by the scraper, so it is on every row; group by it whenever a file covers more than one input.