ItemListingMarketHistory

The data format ItemListingMarketHistory is used to export active listings. Create and export the data format in the Data » Dynamic export menu. Import the data format in the Data » Dynamic import menu. The Exporting data and Importing data pages of the manual describe how you export and import the data format.

Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.

Table 1 explains the data fields for the ItemListingMarketHistory data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.

Field name	Explanation	Filter
EndTime	Listing end time	Activate the filter and select the operator and date. Use the operator Period to select a range of dates.
ExternalID	The market’s offer number	Activate the filter, select the operator and enter the value.
ExternalSKU	SKU	Activate the filter, select the operator and enter the value.
HasVariations	Y = Listing with variations N = Listing without variations	Activate the filter and select the operator and the value from the drop-down list.
ID	The active listing’s ID	Activate the filter, select the operator and enter the value.
LastUpdate	Last update	Activate the filter and select the operator and date. Use the operator Period to select a range of dates.
MLID	Market listing ID	Activate the filter, select the operator and enter the value.
MarketID	Market ID	Activate the filter, select the operator and enter the value.
Price	Current offer price (fixed price)	Activate the filter, select the operator and enter the value.
Promotion	Y = Special sale is available N = No special sale is available	Activate the filter and select the operator and the value from the drop-down list.
Quantity	Number to be sold	Activate the filter, select the operator and enter the value.
QuantityRemain	Remaining quantity	Activate the filter, select the operator and enter the value.
QuantitySold	Sold quantity	Activate the filter, select the operator and enter the value.
RelistedExternalID	Offer number of the restarted listing	Activate the filter, select the operator and enter the value.
SCOStatus	Y = This is a Second Chance Offer N = This is not a Second Chance Offer CREATED = Second Chance Offers were created for the listing	Activate the filter, select the operator and enter the value.
StartTime	Listing start time	Activate the filter and select the operator and date. Use the operator Period to select a range of dates.
Status	Status of the listing active = Activated ended = Ended relisted = Relisted hidden = Hidden	Activate the filter and select the operator and the value from the drop-down list.
Title	Title of the listing	Activate the filter, select the operator and enter the value.
UpdateError	Y = An error occurred while updating the listing N = No error occurred	Activate the filter and select the operator and the value from the drop-down list.
UseEPS	Y = Use eBay image service. N = Do not use eBay image service.	Activate the filter and select the operator and the value from the drop-down list.
UUID	Identification number	Activate the filter, select the operator and enter the value.

Field name

Explanation

Filter

EndTime

Listing end time

Activate the filter and select the operator and date.
Use the operator Period to select a range of dates.

ExternalID

The market’s offer number

Activate the filter, select the operator and enter the value.

ExternalSKU

SKU

Activate the filter, select the operator and enter the value.

HasVariations

Y = Listing with variations
N = Listing without variations

Activate the filter and select the operator and the value from the drop-down list.

The active listing’s ID

Activate the filter, select the operator and enter the value.

LastUpdate

Last update

Activate the filter and select the operator and date.
Use the operator Period to select a range of dates.

MLID

Market listing ID

Activate the filter, select the operator and enter the value.

MarketID

Market ID

Activate the filter, select the operator and enter the value.

Price

Current offer price (fixed price)

Activate the filter, select the operator and enter the value.

Promotion

Y = Special sale is available
N = No special sale is available

Activate the filter and select the operator and the value from the drop-down list.

Quantity

Number to be sold

Activate the filter, select the operator and enter the value.

QuantityRemain

Remaining quantity

Activate the filter, select the operator and enter the value.

QuantitySold

Sold quantity

Activate the filter, select the operator and enter the value.

RelistedExternalID

Offer number of the restarted listing

Activate the filter, select the operator and enter the value.

SCOStatus

Y = This is a Second Chance Offer
N = This is not a Second Chance Offer
CREATED = Second Chance Offers were created for the listing

Activate the filter, select the operator and enter the value.

StartTime

Listing start time

Activate the filter and select the operator and date.
Use the operator Period to select a range of dates.

Status

Status of the listing
active = Activated
ended = Ended
relisted = Relisted
hidden = Hidden

Activate the filter and select the operator and the value from the drop-down list.

Title

Title of the listing

Activate the filter, select the operator and enter the value.

UpdateError

Y = An error occurred while updating the listing
N = No error occurred

Activate the filter and select the operator and the value from the drop-down list.

UseEPS

Y = Use eBay image service.
N = Do not use eBay image service.

Activate the filter and select the operator and the value from the drop-down list.

UUID

Identification number

Activate the filter, select the operator and enter the value.

Table 1: data fields of the data format *ItemListingMarketHistory*