| The value guide package contains a partial record of an eBay listing excluding, listing promotions, unsuccessful listings, pre-sale data such as quantity available for example, bid history, listing description, demographics and shipping information. Some listing promotions which are currently on eBay are also not currently available in eBay's Market Data such as adding a border to your listing. |
Pos |
Column |
Column Type |
Description |
1 |
Item_id | DECIMAL 18,0 | The unique ebay item id for the transaction |
2 |
Item_title | VARCHAR 255 | Listing Title as entered by the seller. |
3 |
Item_subtitle | VARCHAR 255 | Listing Subtitle as entered by the seller. |
4 |
Auct_end_date | TIMESTAMP | The end date and time of the auction in the following format "DD-MON-YY HH24:MI:SS" |
5 |
Auct_durtn_days | DECIMAL 18,0 | The duration of the auction (end date - start date). Can be different from the value set by the seller in some cases, like BIN. |
6 |
Auct_type_code | DECIMAL 18,0 | 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 |
Lstg_curncy_id | DECIMAL 9,0 | Currency Id |
8 |
Leaf_categ_id | DECIMAL 12,0 | Ebay category id associated with the item. See lookup file : Categories . |
9 |
Leaf_Categ_id2 | DECIMAL 12,0 | Secondary category id associated with the item (if any) . See lookup file : Categories . |
10 |
Curnt_price_usd | DECIMAL 15,2 | The price at which the bidder or buyer is entitled to purchase the item. (If the reserve price is met)( in USD). |
11 |
Qty_sold | DECIMAL 9,0 | Quantity of items sold for a listing. This will always be 1 for Chinese Auctions |
12 |
Bidcount | DECIMAL 9,0 | Number of bids the item received |
13 |
Success_yn | VARCHAR 1 | Flag to indicate if Auction was successful (Y/N) |
| Example Row: |
|