ItemListingMarketRicardo

The data format ItemListingMarketRicardo is used to create new Ricardo listings or edit existing ones, e.g. to change or delete individual parameters. Create and export the data format in the Data » Dynamic export menu. The Exporting data page of the manual describes how you export 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.

1. Overview of the data fields

Table 1 explains the data fields for the ItemListingMarketRicardo 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
AttributeValueSetID	ID of the selection of attributes	Activate the filter, select the operator and enter the value.
BasicPriceInText	Specification of the unit price NO = Unit price is not specified TITLE_START = Unit price at the beginning of the title TITLE_END = Unit price at the end of the title SUBTITLE = Unit price in the subtitle	Activate the filter and select the operator and the value from the drop-down list.
DeleteListingID	1 = Delete listing ID 0 = Do not delete listing ID
DeleteListingMarketID	1 = Delete listing ID for the corresponding market 0 = Do not delete listing ID for the corresponding market
DeleteSchedulerIDs	1 = Delete all activated schedulers for the listing 0 = Do not delete
Description	Descriptive text	Activate the filter, select the operator and enter the value.
DirectoryID	Directory ID	Activate the filter, select the operator and enter the value.
Duration	Duration; in days or GTC	Activate the filter, select the operator and enter the value.
Enabled	Y = Active N = Not active	Activate the filter, select the operator and enter the value.
ErrorCode	Error code
ErrorText	Error message
ErrorType	info = information error = error warning = warning
Fee	Listing fee	Activate the filter, select the operator and enter the value.
FixedPrice	Fixed price	Activate the filter, select the operator and enter the value.
ItemID	Item ID	Activate the filter, select the operator and enter the value.
ItemNo	Item number	Activate the filter, select the operator and enter the value.
ItemPriceID	Item price ID	Activate the filter, select the operator and enter the value.
Lang	Language de = German en = English, etc.	Activate the filter, select the operator and enter the value.
LastUpdate	Last update	Activate the filter, select the operator and enter the value. Use the operator Period to select a range of dates.
LayoutTemplateID	Layout template ID	Activate the filter, select the operator and enter the value.
LID	Listing ID	Activate the filter, select the operator and enter the value.
ListAllVariations	List with all variations Y = Yes N = No This value may only be activated for items with variations.	Activate the filter and select the operator and the value from the drop-down list.
ListingType	Listing type auction = Auction for bidding fixed = Fixed price offer dutch = Dutch auction shop = Store item	Activate the filter and select the operator and the value from the drop-down list.
MarketID	Market ID 2001 = ricardo.ch	Activate the filter, select the operator and enter the value.
MaxNumOfImages	Maximum number of images	Activate the filter, select the operator and enter the value.
MaxOnlineListings	Endless lister Maximum number of active listings 0 = Deactivated 1 - 8 = Number	Activate the filter, select the operator and enter the value.
MaxQuantity	Maximum number to be sold	Activate the filter, select the operator and enter the value.
MLID	Market listing ID	Activate the filter, select the operator and enter the value.
NumberPerLot	Number per lot	Activate the filter, select the operator and enter the value.
OrderStatus	Order status	Activate the filter, select the operator and enter the value.
ReservePrice	Minimum price	Activate the filter, select the operator and enter the value.
RicardoAvailabilityID	Item availability ID for Ricardo 0 = Immediately deliverable 1 = Within 5 business days 2 = Within 10 business days 3 = Within 15 business days 4 = Within 30 business days 5 = Within 60 business days	Activate the filter, select the operator and enter the value.
RicardoCategoryID	Ricardo category ID	Activate the filter, select the operator and enter the value.
RicardoDeliveryCost	Ricardo shipping costs	Activate the filter, select the operator and enter the value.
RicardoDeliveryID	Ricardo shipping ID 1 = Letters; A Mail (Swiss Post) 2 = Letters; B Mail (Swiss Post) 3 = Packages; A Mail (Swiss Post) 4 = Packages; B Mail (Swiss Post) 5 = Registered mail 6 = Cash on delivery (only possible for companies) 8 = Pick-up by purchaser 9 = Delivery by seller 10 = Shipping from a foreign country 11 = Freight forwarder 12 = Courier 0 = According to the description	Activate the filter, select the operator and enter the value.
RicardoEnhancements	Additional Ricardo options None = None Bold = Bold font HomePage = Home page feature TopCat = Featured plus Gallery = Gallery Highlight = Background color SubTitle = Subtitle ShowCase = Showcase	Activate the filter, select the operator and enter the value.
RicardoItemConditionID	Ricardo item condition 0 = New (according to the description) 1 = New and in original packaging 3 = Used 4 = Antique 5 = Defective	Activate the filter, select the operator and enter the value.
RicardoPaymentID	Ricardo payment ID; only one can be selected 5 = Wire transfer via bank / post 1 = Cash payment 0 = Other	Activate the filter, select the operator and enter the value.
RicardoPaymentMethods	Ricardo payment methods (multiple selection separated by commas) 2 = Visa 4 = Credit card (via seller) 8 = American Express 16 = Switch 32 = Solo 64 = Delta 2048 = Credit card 4096 = Moneybookers 8192 = in advance 262144 = Ricardo Pay 0 = According to the description 1073741824 = upon pick-up	Activate the filter, select the operator and enter the value.
RicardoPriceIncrement	Increment	Activate the filter, select the operator and enter the value.
RicardoWarrantyID	Ricardo warranty ID 0 = According to the description 1 = No warranty	Activate the filter, select the operator and enter the value.
SchedulerIDs	Enter the listing scheduler IDs that should be activated.
ShippingProfileID	Shipping profile ID	Activate the filter, select the operator and enter the value.
StartPrice	Minimum bid price	Activate the filter, select the operator and enter the value.
StockDependence	Depending on the stock level 0 = Unlimited, with synchronisation 1 = Limited, with reservation 2 = Limited, without reservation 3 = Unlimited, without synchronisation	Activate the filter and select the operator and the value from the drop-down list.
Subtitle	Subtitle of the listing	Activate the filter, select the operator and enter the value.
Title	Title of the listing	Activate the filter, select the operator and enter the value.
TransmitItemNumberType	Transfer of the item number type none = none EAN = EAN ISBN = ISBN MPN = Manufacturer part number EPID = eBay product ID GTIN = GTIN UPC = UPC no-name = Custom-made item or no-name product	Activate the filter, select the operator and enter the value.
UseItemPrice	Y = Tie fixed price to item N = Use the price from the listing settings	Activate the filter and select the operator and the value from the drop-down list.
UserID	Account ID	Activate the filter, select the operator and enter the value.
VAT	VAT rate	Activate the filter, select the operator and enter the value.
Verified	succeeded = Listing verification was successful unknown = Not verified failed = Verification was not successful	Activate the filter and select the operator and the value from the drop-down list.
WarehouseID	Warehouse ID	Activate the filter, select the operator and enter the value.

Field name

Explanation

Filter

AttributeValueSetID

ID of the selection of attributes

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

BasicPriceInText

Specification of the unit price
NO = Unit price is not specified
TITLE_START = Unit price at the beginning of the title
TITLE_END = Unit price at the end of the title
SUBTITLE = Unit price in the subtitle

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

DeleteListingID

1 = Delete listing ID
0 = Do not delete listing ID

DeleteListingMarketID

1 = Delete listing ID for the corresponding market
0 = Do not delete listing ID for the corresponding market

DeleteSchedulerIDs

1 = Delete all activated schedulers for the listing
0 = Do not delete

Description

Descriptive text

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

DirectoryID

Directory ID

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

Duration

Duration; in days or GTC

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

Enabled

Y = Active
N = Not active

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

ErrorCode

Error code

ErrorText

Error message

ErrorType

info = information
error = error
warning = warning

Fee

Listing fee

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

FixedPrice

Fixed price

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

ItemID

Item ID

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

ItemNo

Item number

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

ItemPriceID

Item price ID

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

Lang

Language
de = German
en = English, etc.

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

LastUpdate

Last update

Activate the filter, select the operator and enter the value. Use the operator Period to select a range of dates.

LayoutTemplateID

Layout template ID

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

LID

Listing ID

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

ListAllVariations

List with all variations
Y = Yes
N = No
This value may only be activated for items with variations.

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

ListingType

Listing type
auction = Auction for bidding
fixed = Fixed price offer
dutch = Dutch auction
shop = Store item

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

MarketID

Market ID
2001 = ricardo.ch

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

MaxNumOfImages

Maximum number of images

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

MaxOnlineListings

Endless lister
Maximum number of active listings
0 = Deactivated
1 - 8 = Number

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

MaxQuantity

Maximum number to be sold

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

MLID

Market listing ID

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

NumberPerLot

Number per lot

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

OrderStatus

Order status

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

ReservePrice

Minimum price

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

RicardoAvailabilityID

Item availability ID for Ricardo
0 = Immediately deliverable
1 = Within 5 business days
2 = Within 10 business days
3 = Within 15 business days
4 = Within 30 business days
5 = Within 60 business days

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

RicardoCategoryID

Ricardo category ID

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

RicardoDeliveryCost

Ricardo shipping costs

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

RicardoDeliveryID

Ricardo shipping ID
1 = Letters; A Mail (Swiss Post)
2 = Letters; B Mail (Swiss Post)
3 = Packages; A Mail (Swiss Post)
4 = Packages; B Mail (Swiss Post)
5 = Registered mail
6 = Cash on delivery (only possible for companies)
8 = Pick-up by purchaser
9 = Delivery by seller
10 = Shipping from a foreign country
11 = Freight forwarder
12 = Courier
0 = According to the description

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

RicardoEnhancements

Additional Ricardo options
None = None
Bold = Bold font
HomePage = Home page feature
TopCat = Featured plus
Gallery = Gallery
Highlight = Background color
SubTitle = Subtitle
ShowCase = Showcase

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

RicardoItemConditionID

Ricardo item condition
0 = New (according to the description)
1 = New and in original packaging
3 = Used
4 = Antique
5 = Defective

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

RicardoPaymentID

Ricardo payment ID; only one can be selected
5 = Wire transfer via bank / post
1 = Cash payment
0 = Other

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

RicardoPaymentMethods

Ricardo payment methods (multiple selection separated by commas)
2 = Visa
4 = Credit card (via seller)
8 = American Express
16 = Switch
32 = Solo
64 = Delta
2048 = Credit card
4096 = Moneybookers
8192 = in advance
262144 = Ricardo Pay
0 = According to the description
1073741824 = upon pick-up

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

RicardoPriceIncrement

Increment

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

RicardoWarrantyID

Ricardo warranty ID
0 = According to the description
1 = No warranty

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

SchedulerIDs

Enter the listing scheduler IDs that should be activated.

ShippingProfileID

Shipping profile ID

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

StartPrice

Minimum bid price

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

StockDependence

Depending on the stock level
0 = Unlimited, with synchronisation
1 = Limited, with reservation
2 = Limited, without reservation
3 = Unlimited, without synchronisation

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

Subtitle

Subtitle of the listing

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

Title

Title of the listing

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

TransmitItemNumberType

Transfer of the item number type
none = none
EAN = EAN
ISBN = ISBN
MPN = Manufacturer part number
EPID = eBay product ID
GTIN = GTIN
UPC = UPC
no-name = Custom-made item or no-name product

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

UseItemPrice

Y = Tie fixed price to item
N = Use the price from the listing settings

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

UserID

Account ID

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

VAT

VAT rate

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

Verified

succeeded = Listing verification was successful
unknown = Not verified
failed = Verification was not successful

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

WarehouseID

Warehouse ID

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

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

2. Overview of the synchronisation fields

The data fields that are listed in table 2 are available for data synchronisation. For mandatory synchronisation fields, select the option Synchronisation as Import procedure. The rest of the fields can also be used for the synchronisation if desired. These data fields are marked with an A. Mandatory synchronisation fields are marked with an M.

Field name	Explanation	Synchronisation field
ItemID	Item ID	A
ItemNo	Item number	A
ItemPriceID	Item price ID	A
LID	Listing ID	M
Market-ID	Market ID	A
MLID	Market listing ID	M
UserID	Account ID	A

Field name

Explanation

Synchronisation field

ItemID

Item ID

ItemNo

Item number

ItemPriceID

Item price ID

LID

Listing ID

Market-ID

Market ID

MLID

Market listing ID

UserID

Account ID

Table 2: data fields with the import procedure set to *Synchronisation*

Import: What to do if there is no match

When importing data, make sure that the setting If there is no match during the synchronisation is set to Create a new data record. If you select Skip data record, then the corresponding information will be lost if there is no match.