Skip to main content

Item

Use the item format to export item and variation data.

1. Item

Table 1 lists the fields available for exporting item data.

Table 1. Fields for exporting item data
Field Explanation

ageRestriction

Age rating

amazonFbaPlatform

Fulfilment by Amazon (FBA)

amazonFedas

Amazon-FEDAS

amazonProductType

Amazon product type

conditionApiId

ID of the condition for API

conditionApiName

Name of the condition for API

conditionId

ID of the condition

conditionName

Name of the condition

couponRestriction

Promotional coupon

ebayCategory

Listing category 1

ebayCategory2

Listing category 2

ebayPresetId

Listing template

ebayStoreCategory

Listing store category 1

ebayStoreCategory2

Listing store category 2

feedback

Item feedback

flagOne

Flag 1

flagTwo

Flag 2

free1;
free2;
free3;
…​
free20

Free text fields 1 to 20

id

Item ID

isSerialNumber

Serial number (yes/no)

isShippableByAmazon

Shipment by Amazon (FBA)

isShippingPackage

Shipping package (yes/no)

isSubscribable

Subscription (yes/no)

itemType

Item type

manufacturerId

Manufacturer ID

manufacturerLogo

Logo of the manufacturer

manufacturerName

Name of the manufacturer

maximumOrderQuantity

Max. item order quantity

ownerID

Owner

position

Variation

producingCountryId

Manufacturing country

producingCountryName

Name of the manufacturing country

rakutenCategoryId

Rakuten.de categories

revenueAccount

Revenue account

stockType

Type

storeSpecialId

ID of the store special

storeSpecialName

Name of the store special

2. ItemCrossSelling

Table 2 lists the fields available for exporting cross-selling links.

Table 2. Fields for exporting cross-selling links
Field Explanation

all

All linked cross-selling items

3. ItemDescription

Table 3 lists the fields available for exporting item descriptions.

Table 3. Fields for exporting item descriptions
Field Explanation

description

Item text

itemDeepLink

Complete link to the item including domain

metaDescription

Meta description

metaKeywords

Meta keywords

name

Name

name2

Name 2

name3

Name 3

previewDescription

Preview text

technicalData

Technical data

urlPath

The item’s URL path in the online store (categories and item name)

4. ItemImage

Table 4 lists the fields available for exporting image data.

Table 4. Fields for exporting item images
Field Explanation

allImages

URLs of all item images with positions in the format
url;position,url;position,etc.

createdAt

Time stamp of the creation

fileType

File format of the image (JPG, JPEG, PNG, GIF or SVG)

height

Image height in pixels

id

Image ID

md5Checksum

The MD5 hash value of the image file

md5ChecksumOriginal

The MD5 hash value of the original image file

position

Position

size

Image size in pixels

updatedAt

Time stamp of the last update

url

URL of the image

urlMiddle

URL of the medium sized version of the image

urlPreview

URL of the preview version of the image

urlSecondPreview

URL of the second preview version of the image

width

Image width in pixels

5. ItemSerialNumber

Table 5 lists the fields available for importing serial number data.

Table 5. Fields for exporting serial numbers
Field Explanation

all

All serial numbers

available

Available serial numbers

used

Assigned serial numbers

6. ItemShippingProfile

Table 6 lists the fields available for exporting shipping profiles linked to items.

Table 6. Fields for exporting item shipping profiles
Field Explanation

allShippingProfileNames

Provides a list of names of linked shipping profiles (separated by commas).

allShippingProfiles

Provides a list of IDs of linked shipping profiles (separated by commas).

profileIslinked

Assign the shipping profile in the format. 0 = Not linked, 1 = Linked

7. StockStorageLocation

Table 7 lists the fields available for exporting storage location data.

Table 7. Fields for exporting storage locations
Field Explanation

allIds

All linked storage location IDs are exported to one field, separated by commas.

allNames

All linked storage location names are exported to one field, separated by commas.

batch

Batch

bestBeforeDate

Expiration date

quantity

Quantity

StorageLocationID

Storage location ID

storageLocationName

Name of the storage location

updatedAt

Date of the last update

warehouseId

ID of the warehouse

8. Variation

Table 8 lists the fields available for importing variation data.

Table 8. Fields for exporting variation data
Field Explanation

automaticClientVisibility

Display whether the variation is visible in a client.

automaticListVisibility

Display whether the variation is visible in an item list.

availabilityAverageDays

Average delivery period

availabilityId

ID of the availability (1-10)

availabilityName

Name of the availability

availabilityUpdatedAt

Time stamp of last update of the availability

availableUntil

Available until

bundleType

Bundle type

categoryVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Categories are not inherited from the main variation.
ID of main variation of the item = Categories are inherited from the main variation.

clientVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Clients are not inherited from the main variation.
ID of main variation of the item = Clients are inherited from the main variation.

createdAt

Time stamp of creating the variation

customs

Customs in percent

customsTariffNumber

Customs tariff number

defaultShippingCosts

Default shipping costs of the variation

estimatedAvailableAt

Estimated shipping date

externalId

External variation ID

extraShippingCharge1

Extra charge 1

extraShippingCharge2

Extra charge 2

hasCalculatedBundleMovingAveragePrice

Indicates whether the moving average purchase price (net) is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

hasCalculatedBundleNetWeight

Indicates whether the net weight is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

hasCalculatedBundlePurchasePrice

Indicates whether the net purchase price is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

hasCalculatedBundleWeight

Indicates whether the gross weight is automatically calculated based on the individual components.
1 = Automatic calculation is activated.
Empty field = Automatic calculation is not activated.

heightMM

Height in mm

id

Variation ID

intervalOrderQuantity

Interval order quantity

isActive

Is active

isAvailableIfNetStockIsPositive

Available if net stock is positive

isHiddenInCategoryList

Invisible in item list

isInvisibleIfNetStockIsNotPositive

Store: invisible if net stock is 0 or negative

isInvisibleInListIfNetStockIsNotPositive

Invisible in item list if net stock is 0 or negative

isMain

Is main variation

isUnavailableIfNetStockIsNotPositive

Not available if net stock is 0 or negative

isVisibleIfNetStockIsPositive

Store: visible if net stock is positive

isVisibleInListIfNetStockIsPositive

Visible in item list if net stock is positive

itemId

Item ID

lengthMM

Length in mm

mainVariationId

ID of main variation

mainWarehouseId

ID of the main warehouse

marketVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Markets are not inherited from the main variation.
ID of main variation of the item = Markets are inherited from the main variation.

maximumOrderQuantity

Maximum order quantity

mayShowUnitPrice

Show unit price

minimumOrderQuantity

Minimum order quantity

model

Model

movingAveragePrice

Moving average purchase price (net)

name

Name

number

Variation number

operatingCosts

Operating costs (in percent)

packingUnitTypeId

Packing unit type

packingUnits

Number of packing units

palletTypeId

ID of the pallet type

parentVariationID

Currently not in use
ID of the parent variation

picking

Order picking

position

Position

priceCalculationId

Price calculation

propertyVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Properties are not inherited from the main variation.
ID of main variation of the item = Properties are inherited from the main variation.

purchasePrice

Net purchase price

relatedUpdatedAt

Time stamp of last update of linked data

releasedAt

Release date

salesPriceVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Sales prices are not inherited from the main variation.
ID of main variation of the item = Sales prices are inherited from the main variation.

salesRank

Sales rank of the variation

stockLimitation

Stock limitation

storageCosts

Net storage costs

supplierVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Suppliers are not inherited from the main variation.
ID of main variation of the item = Suppliers are inherited from the main variation.

tagVariationId

Indicates whether the tags are inherited or not.
Inherited = The value is the same as the mainVariationId
Not inherited = The value is the same as the variationId

transportationCosts

Net transportation costs

unit.content

Quantity of the unit

unit.unitId

ID of the unit

unit.unitName

Unit name

unitsContained

Units contained

updatedAt

Time stamp of last update of the variation

valueAddedTax

Value Added Tax in percent

vatId

  • A = 0

  • B = 1

  • C = 2

  • D = 3

warehouseVariationId

Variation ID or ID of the main variation of the item.
ID of the variation = Warehouses are not inherited from the main variation.
ID of main variation of the item = Warehouses are inherited from the main variation.

weightG

Gross weight in g

weightNetG

Net weight in g

widthMM

Width in mm

9. VariationAdditionalSku

Table 9 lists the fields available for exporting additional SKU data.

Table 9. Fields for exporting additional SKUs
Field Explanation

additionalSkuList

A list of all additional SKUs in the format:
marketId;marketAccountId;id;sku:marketId;…​

It’s possible to have multiple SKUs for the same market/account. This field allows you to export all of the SKUs at the same time, rather than just one of them.

createdAt

Time stamp of the creation

id

Unique ID for the link between the additional SKU and the variation.

marketAccountId

ID of the market account

marketId

Market ID

sku

SKU

updatedAt

Time stamp of the last update

10. VariationAttributeValues

Table 10 lists the fields available for exporting attribute values.

Table 10. Fields for exporting attribute values
Field Explanation

attributeValues

Attribute values

11. VariationBarcode

Table 11 lists the fields available for exporting barcode data.

Table 11. Fields for exporting variation barcodes
Field Explanation

code

Code saved for the selected barcode

12. VariationBundle

Table 12 lists the fields available for exporting bundle data.

Table 12. Fields for exporting bundle data
Field Explanation

components

Item bundle components in the format
Component:Quantity;Component:Quantity

13. VariationCategory

Table 13 lists the fields available for exporting categories linked to variations.

Table 13. Fields for exporting category data
Field Explanation

allCategories

Names of the linked categories (separated by commas)

allCategoryIds

IDs of the linked categories (separated by commas)

14. VariationClient

Table 14 lists the fields available for exporting client availabilities.

Table 14. Fields for exporting client availabilities
Field Explanation

isActive

Availability for the selected client

15. VariationComment

Table 15 lists the fields available for exporting notes.

Table 15. Fields for exporting notes
Field Explanation

text

Note text

16. VariationDefaultCategory

Table 16 lists the fields available for exporting default categories.

Table 16. Fields for exporting default categories
Field Explanation

branchId

Category ID

manually

Indicates whether the default category was automatically assigned.
1 = Yes, the default category was automatically assigned.
0 or empty field = No.

17. VariationEigenschaften

Table 17 lists the fields available for exporting property links at the variation level.

Why are the fields empty when exported? Why do they give me unexpected data?

The field is only filled if the property is linked. If the property is not linked, then the field will remain empty.

Also remember to tell plentymarkets which property you want information about. In other words, assign a property. Click on assignment () and choose the desired property from the drop-down list.

The field all is an exception. Here you do not need to assign a specific property since you are receiving information about all of the properties.

Table 17. Fields for exporting variation properties
Field Explanation

all

Returns all of the properties. The information is formatted as follows:
name:value:language;name:value:language

cast

Returns the type of the assigned property, assuming it is linked. If the assigned property is not linked, then the field will be empty.

Name in export file Property type

empty

None

date

Date

file

File

int

Int

float

Float

longText

Long text

shortText

Short text

selection

Selection

multiSelection

Multi selection

id

Returns the ID of the assigned property, assuming it is linked.

linked

Returns a 1 or 0.

  • 1 = is linked

  • 0 = is not linked

value

Returns the value that was saved for the assigned property within the variation.

18. VariationMarket

Table 18 lists the fields available for exporting market availabilities.

Table 18. Fields for exporting market availabilities
Field Explanation

isActive

Availability for the selected market

19. VariationMarketIdentNumber

Table 19 lists the fields available for exporting ASIN/ePID data.

Table 19. Fields for exporting ASIN and ePID
Field Explanation

countryId

Country ID

id

ID for the ASIN. You need this ID if you want to delete ASINs with the help of ElasticSync. The ID is not visible in your plentymarkets system.

position

The ASIN’s position. The position is not visible in your plentymarkets system.

type

Type (ASIN or ePID)

value

Value

20. VariationProperty

Table 20 lists the fields available for exporting properties linked to the item at the item level.

Table 20. Fields for exporting properties
Field Explanation

all

Values of all properties (separated by semicolons), including language for properties of the types Selection and Text
Example: 512;"SomeText":"en"

allIds

All property IDs (separated by semicolons)

value

Property value

21. VariationSalesPrice

Table 21 lists the fields available for exporting price data.

Table 21. Fields for exporting prices
Field Explanation

netPrice

Net prices saved for the selected sales price

price

Gross prices saved for the selected sales price

22. VariationSKU

Table 22 lists the fields available for exporting SKU data.

Table 22. Fields for exporting SKU data
Field Explanation

accountId

ID of the market account

marketId

Market ID

parentSku

The parent SKU

sku

SKU

23. VariationStock

Table 23 lists the fields available for exporting stock data.

Table 23. Fields for exporting stock data
Field Explanation

deltaReorderLevel

Required reordered quantity to reach the reorder level

netStock

Net stock

physicalStock

Physical stock

purchasePrice

Purchase price

reorderLevel

Net stock \+ reordered quantity + reorder level delta

reservedBundles

Quantity reserved for item packages

reservedListing

Quantity reserved for listings

reservedStock

Reserved stock

valueOfGoods

Value of items (Purchase price * Physical stock)

virtualPhysicalStock

Entire physical stock; Stock from all warehouses of the type = 0 (Sales)

warehouseId

ID of the warehouse

24. VariationSupplier

Table 24 lists the fields available for exporting supplier data.

Table 24. Fields for exporting supplier data
Field Explanation

all

All linked supplier IDs, names, purchase prices and link IDs are exported to one field, separated by commas.
ID, name, purchase price and link ID of an individual supplier are separated by a colon. Different suppliers are separated by a semicolon. Example:
id:supplierId:supplierName:purchasePrice;…​

allIds

All linked supplier IDs are exported to one field, separated by commas.

allNames

All linked supplier names are exported to one field, separated by commas.

deliveryTimeInDays

Delivery time in days

discount

Discount

isDiscountable

Discountable

itemDescription

Supplier item name

itemNumber

Supplier item No.

lastPriceQuery

Last price query

lastUpdateTimestamp

Time stamp of the last update

minimumPurchase

Minimum purchase

PackagingUnit

Packaging unit

purchasePrice

Purchase price

SupplierID

Supplier ID

supplierPriceList

Supplier price list in the format
SupplierID:SupplierRowID,PurchasePrice:MinimumPurchase;…​.

supplierRowId

Supplier link ID

25. VariationTag

Table 25 lists the fields available for exporting tags linked to variations.

Table 25. Fields for exporting variation tags
Field Explanation

tagId

Tag ID

tagIds

Tag IDs

tagName

Tag name

tagNames

Tag names

26. VariationWarehouse

Table 26 lists the fields available for exporting warehouse data.

Table 26. Fields for exporting warehouse data
Field Explanation

allIds

All linked warehouse IDs are exported to one field, separated by commas.

allNames

All linked warehouse names are exported to one field, separated by commas.

isBatch

Batches are activated

isBestBeforeDate

Best before date is activated

lastUpdateTimestamp

Time stamp of the last update

maximumStock

Maximum stock

reorderLevel

Reorder level

stockBuffer

Stock buffer

stockTurnoverInDays

Stock turnover in days

storageLocation

Suggested storage location

storageLocationType

Storage location type

warehouseZoneId

ID of the warehouse zone

27. custom_value

Table 27 lists the fields available for exporting custom values.

Table 27. Fields for exporting custom values
Field Explanation

custom_value

Custom value

28. date

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

Table 28. Field for exporting the current date
Field Explanation

date

Current date

To top