Value guide

Here is a description of the columns contained in the Value Guide package, provided in the order they are encountered in the extract file. This document attempts to be database-independent by providing a proper description of the column type, instead of a SQL statement. The Value Guide package only contains information on successful listings.
  • Each field is delimited by character 127, DEL. Try typing this by holding the alt key, then pressing 0,1,2,7 in sequence. Try representing it with your favourite programming language with "\x7F".
  • Items ended are split into one file for each meta category, for each auction end date.
PositionNameColumn TypeDescription
1 Item_id Integer, up to 18 digits The unique ebay item id for the transaction. This number is a valid primary key over all of the auctions returned from eBay from all points in time.
2 Item_title String, up to 255 characters. Listing Title as entered by the seller. Listings titles have a 55 character limit.
3 Item_subtitle String, up to 255 characters. Listing subtitle as entered by the seller. See the description of the title for more information.
4 Auction_end_date Date and time, in DD-Mon-YY HH24:MM:SS This is the time that the auction ends. This time is in the Pacific standard time zone.
5 Auction_duration_days Integer, up to 18 digits long The duration of the auction (end date - start date). Can be different from the value set by the seller in some cases, such as when an auction ends with buy it now.
6 Auction_type_code Integer, between 1 - 10. The auction type code:
  • 1= Chinese (listings w/qty = 1)
  • 2= Dutch (listing w/qty >1)
  • 5= Live Auctions
  • 7= Store Fixed Price
  • 8= Personal offer
  • 9= Pure Fixed Price
7 Listing_currency_id Integer, 9 digits The unique identifier of the currency of the auction. Users should download the currency extract file to get a list relating the identifier to the name of the currency.
8 Leaf_category_id Integer, 12 digits The ID of the lowest level category that the item was listed in. See the cateogry extract for more information.
9 Leaf_Category_id2 Integer, 12 digits Secondary category ID associated with the item. This field may or may not be filled in. Use of this field indicates that the listing was listed in two categories; that is, the seller paid for the multi-listing feature. The value here may be a valid category ID, or, to indicate that the feature was not used, an empty string, a 0, or -999. Consider a category valid if it greater than 0 and not a zero-length string.
10 Current_price_usd A decimal field capable of storing monetary values less than 10 trillion dollars. The price at which the bidder or buyer is entitled to purchase the item, if the reserve price has been met. Price is displaced in US dollars.
11 Quantity_sold Integer, up to 9 digits Quantity of items sold in a listing. This will always be 1 for Chinese auctions
12 Bidcount Integer, up to 9 digits This shows the number of bids a listing received.
13 Success_flag Character, either 'Y' or 'N' Flag to indicate if a listing was successful. A successful auction sells at least one item. This flag should always be 'Y' in this file.