Skip to main content

Active listings

Use the Active listings format to export 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 number

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
Display on Hood store homepage
Hood shipping discount
Hood delivery time when in stock from (in days)
Hood delivery time when in stock to (in days)
Hood delivery time when out of stock from (in days)
Hood delivery time when out of stock to (in days)
ricardo warranty ID
ricardo delivery conditions
ricardo availability ID ricardo delivery costs
ricardo payment condition ID
ricardo increment
ricardo condition ID
ricardo number of reactivations
ricardo individual shipping costs for each item
ricardo package size
ricardo use secondary language
ricardo template ID
ricardo reactivate until sold out

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 plentymarkets 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
Display on Hood store homepage
Hood shipping discount
Hood delivery time when in stock from (in days)
Hood delivery time when in stock to (in days)
Hood delivery time when out of stock from (in days)
Hood delivery time when out of stock to (in days)
ricardo warranty ID
ricardo delivery conditions
ricardo availability ID ricardo delivery costs
ricardo payment condition ID
ricardo increment
ricardo condition ID
ricardo number of reactivations
ricardo individual shipping costs for each item
ricardo package size
ricardo use secondary language
ricardo template ID
ricardo reactivate until sold out

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

/en/table-custom-value 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

To top