Active listings

1. Listing

Table 1 lists the fields available for exporting listing data.

Table 1. Fields for exporting listings
Field	Explanation
id	ID of the table entry
itemID	Item ID
stockDependenceTypeId	ID of the stock dependence
typeId	Listing type ID
unitCombinationId	ID of the listing content

2. ListingMarket

Table 2 lists the fields available for exporting market listing data.

Table 2. Fields for exporting market listings
Field	Explanation
allVariations	List with all variations
createdAt	Date that the market listing was created on
credentialsId	ID of the eBay account
directoryId	ID of the directory
duration	Duration in days or GTC
enabled	Specifies whether the listing is enabled.
id	ID of the table entry
listingId	Listing ID
quantity	Quantity
referrerId	Order referrer ID
updatedAt	Date that the market listing was updated on
variationId	Variation ID
verified	Status of the listing’s check

3. ListingMarketDate

Table 3 lists the fields available for exporting date information for market listings.

Table 3. Fields for exporting market listing dates
Field	Explanation
date	Value of the market listing’s date. Possible mappings: Last price change Last listing attempt Start time End time

4. ListingMarketHistory

Table 4 lists the fields available for exporting active listings.

Table 4. Fields for exporting active listings
Field	Explanation
createdAt	Date that the active listing was created on
currency	Currency
externalId	External ID of the active listing
id	ID of the table entry
listingMarketId	Market listing ID
price	Preis
quantity	Quantity
quantityRemain	Remaining quantity
quantitySold	Quantity that was sold
quantitySoldDelta	Reserved quantity for orders in the data exchange
referrerId	Order referrer ID
sku	SKU
statusId	Order status ID
updatedAt	Date of the last market listing update

5. ListingMarketHistoryDate

Table 5 lists the fields available for exporting date information for active listings.

Table 5. Fields for exporting active listing data
Field	Explanation
date	Value of the active listing’s date. Possible mappings: Last price change Last listing attempt Start time End time Last marketplace update Last sale

6. ListingMarketHistoryProperty

Table 6 lists the fields available for exporting properties of active listings.

Table 6. Fields for exporting properties of active listings
Field	Explanation
value	Listing property. Possible mappings: Shipping profile ID Order status Layout template ID Number of images Warehouse ID Add unit price specification VAT rate VAT country Language Number per lot Transfer as item number Relisted external listing ID Second Chance Offer Special sale UUID Listing faulty List with all variations End listing Created by Payment methods Category ID 1 Category ID 2 Shop category ID 1 Shop category ID 2 Shop category ID 3 Additional options Parts compatibility listing ID eBay market listings active at the same time eBay private auction eBay gallery type eBay featured first eBay transfer RRP eBay hit counter eBay condition ID eBay description of the condition eBay best offer eBay reject minimum price eBay accept minimum price eBay Plus eBay Click & Collect Use eBay image service

7. ListingMarketHistoryText

Table 7 lists the fields available for exporting active listings texts.

Table 7. Fields for exporting active listing texts
Field	Explanation
historyId	ID of the active listing in the ListingMarketHistory table
id	ID of the table entry
lang	Language
title	Title of the active listing

8. ListingMarketInfo

Table 8 lists the fields available for exporting information about errors concerning market listings.

Table 8. Fields for exporting market listing dates
Field	Explanation
code	Error code if an error occurred during the listing check. This can be a PlentyONE error code or an eBay error code.
createdAt	Date that the error message was created on
id	ID of the table entry
listingMarketId	Market listing ID
message	Error message belonging to the error code
type	Error type belonging to the error code and error message

9. ListingMarketPrice

Table 9 lists the fields available for exporting price information about market listings.

Table 9. Fields for exporting market listing prices
Field	Explanation
currency	Currency
value	Value of the market listing’s price. Possible mappings: Start price Fixed price Minimum price SCO minimum price

10. ListingMarketProperty

Table 10 lists the fields available for exporting properties of market listings.

Table 10. Fields for exporting market listing properties
Field	Explanation
value	Listing property. Possible mappings: Shipping profile ID Order status Layout template ID Number of images Warehouse ID Add unit price specification VAT rate VAT country Language Number per lot Transfer as item number Relisted external listing ID Second Chance Offer Special sale UUID Listing faulty List with all variations End listing Created by Payment methods Category ID 1 Category ID 2 Shop category ID 1 Shop category ID 2 Shop category ID 3 Additional options Parts compatibility listing ID eBay market listings active at the same time eBay private auction eBay gallery type eBay featured first eBay transfer RRP eBay hit counter eBay condition ID eBay description of the condition eBay best offer eBay reject minimum price eBay accept minimum price eBay Plus eBay Click & Collect Use eBay image service

11. ListingMarketSpecific

Table 11 lists the fields available for exporting specifics of market listings.

Table 11. Fields for exporting market listing specifics
Field	Explanation
id	ID of the table entry
listingMarketId	Market listing ID
name	Name
value	Value

12. ListingMarketText

Table 12 lists the fields available for exporting market listing texts.

Table 12. Fields for exporting market listing texts
Field	Explanation
description	Description of the market listing
id	ID of the table entry
lang	Language
listingMarketId	Market listing ID
subtitle	Subtitle of the market listing
title	Title of the market listing

13. ListingProperty

Table 13 lists the fields available for exporting listing properties.

Table 13. Fields for exporting listing properties
Field	Explanation
value	Value of the listing property. Possible mappings: Tie to item price Number per lot Transfer as item number

14. custom_value

Table 14 lists the fields available for importing custom values.

Table 14. Fields for exporting custom values
Field	Explanation
custom_value	Custom value

15. date

Table 15 lists the field available for exporting the current date. For further information, refer to this page.

Table 15. Field for exporting the current date
Field	Explanation
date	Current date