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

The URLs and position numbers for all of the item’s images.

Format: urlImage1;positionImage1,urlImage2;positionImage2

Example: https://www.example.com/image1.png;1,https://www.example.com/image2.png;2

createdAt

The timestamp when the image was created.

fileType

The image’s file format (PNG, JPG, GIF, SVG).

hasLinkedVariations

Indicates whether the image has a linked variation.

  • 0 = No. There is no linked variation.

  • 1 = Yes. There is a linked variation.

height

The image’s height in pixels.

id

The image’s ID.

md5Checksum

The MD5 hash value of the image file.

md5ChecksumOriginal

The MD5 hash value of the original image file.

position

The image’s position number.

size

The image’s size.

updatedAt

The timestamp when the image was last updated.

url

The image’s URL.

urlMiddle

The URL of the medium sized version of the image.

urlPreview

The URL of the preview version of the image.

urlSecondPreview

The URL of the second preview version of the image.

width

The image’s 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.
Note: The default storage location has the ID 0.

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
Note: The default storage location has the ID 0.

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

Old price calculation

priceCalculationUUID

New 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

ID of the tax rate

  • 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

branchName

Category name

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 PlentyONE 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. It doesn’t matter which property you assign here since you receive information about all of the properties.
Table 17. Fields for exporting variation properties
Field Explanation

all

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

Note: The language is only listed for language-specific properties, i.e. for the types HTML and Text.

Example: Length:10;Text:This is an example text:en

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

int

Whole number

float

Decimal number

selection

Selection

multiSelection

Multi selection

date

Date

file

File

string

Character string

html

HTML

text

Text

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

The following fields are used for exporting ASINs and ePIDs.

19.1. countryId

Specifies the country’s ID. In other words, this field specifies the country platform, e.g. Amazon Germany, eBay France, eBay UK, etc.

You can find the country IDs as a list in the manual or in the menu Setup » Orders » Shipping » Settings » Tab: Countries of delivery.

Click on and select the appropriate market.

19.2. id

Specifies the ASIN or ePID’s internal ID.

Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Column: ID.

Use-case: You need the ID if you want to delete ASINs or ePIDs with the help of the import tool.

Click on and select the appropriate market.

19.3. position

Specifies the ASIN or ePID’s position number.

Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Column: Position.

Click on and select the appropriate market.

19.4. type

Specifies the type, i.e. whether you are dealing with an ASIN or an ePID.

Value in the export file Meaning

ASIN

You are dealing with an ASIN.

EPID

You are dealing with an EPID.

Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Column: Type.

Click on and select the appropriate market.

19.5. value

Specifies the actual ASIN or ePID, i.e. the numeric or alpha-numeric product identifier.

Corresponds to the option in the menu: Item » Items » [Open variation] » Element: ASIN/ePID/MOIN » Column: Value.

Click on and select the appropriate market.

20. VariationProperty

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

Table 19. 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 20 lists the fields available for exporting price data.

Table 20. Fields for exporting prices
Field Explanation

createdAt

The timestamp when the sales price was created.

lowestPrice

The lowest price of the last 30 days. This is a monetary value, i.e. a number.

lowestPriceCalculation

Indicates whether the lowest price of the last 30 days is automatically calculated with the help of the change history.

netPrice

Net prices saved for the selected sales price

price

Gross prices saved for the selected sales price

updatedAt

The timestamp when the sales price was last updated.

22. VariationSKU

Table 21 lists the fields available for exporting SKU data.

Table 21. Fields for exporting SKU data
Field Explanation

accountId

ID of the market account

marketId

Market ID

parentSku

The parent SKU

sku

SKU
What’s the difference between the SKU and parent SKU?

The parent SKU is only necessary if you work with variation items.

  • The parent SKU is for the main variation.

  • The SKU is for the sub-variations.

You only need the SKU for items without variations.

23. VariationStock

Table 22 lists the fields available for exporting stock data.

Table 22. 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 23 lists the fields available for exporting supplier data.

Table 23. Fields for exporting supplier data
Field Explanation

all

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

allCompanyNames

Returns all of the company names separated with commas

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.

allNamesWithCompany

Returns all of the linked supplier names with their company names.

companyName

Returns the assigned company name. Click on assignment () and select the appropriate supplier.

currencyPurchasePrice

Purchase price from account

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 system currency

SupplierID

Supplier ID

supplierPriceList

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

supplierRowId

Supplier link ID

25. VariationTag

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

Table 24. Fields for exporting variation tags
Field Explanation

tagId

Tag ID

tagIds

Tag IDs

tagName

Tag name

tagNames

Tag names

26. VariationWarehouse

Table 25 lists the fields available for exporting warehouse data.

Table 25. 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 26 lists the fields available for exporting custom values.

Table 26. Fields for exporting custom values
Field Explanation

custom_value

Custom value

28. date

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

Table 27. Field for exporting the current date
Field Explanation

date

Current date