Skip to main content

Item

Use the Item sync type to import item and variation data.

In order to import item data via ElasticSync, the following data records must be present in plentymarkets:

  • Categories (Item » Categories menu)

  • Sales prices (Setup » Item » Sales prices)

In order to import variation data with attributes via ElasticSync, the following data records must be present in plentymarkets:

  • Attributes and attribute values (Setup » Item » Attributes menu)

1. Fields for item matching

Table 1 explains the fields that are available for matching item data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 1. Matching fields for importing items
Matching field Explanation

Variation ID

Variation no.

External variation ID

Barcode

Select the barcode type from the second drop-down list.

Item ID

For variations with attributes, use this field only in combination with attribute selection combination.

Attribute selection combination

For variations with attributes, use this field only in combination with the item ID. Select the format from the second drop-down list that contains the data of the file.

Supplier item No.

2. Fields for the item mapping

This chapter explains the fields that are available for mapping item data.

2.1. Item

Table 2 lists the fields available for importing item data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 2. Fields for importing items
Mapping field Permitted import values Explanation

Type

default = Default item
multipack = Multipack item

If no item type is specified, the item is treated as a Default item.

Stock type

0 = Stocked item
1 = Production item
2 = Colli
3 = Special order item

Store special

0 = none
1 = Special offer
2 = New items
3 = Top items

Owner

Numeric (internal user ID)

For owner IDs, see Setup » Settings » User » Accounts

Manufacturer ID

Numeric (internal ID)

See Setup » Item » Manufacturer

Manufacturing country

Numeric (internal ID);
0 = unknown

For IDs see Country IDs

Customs tariff number

Numeric

Revenue account

Coupon for special offers

0 = Possible
1 = Prohibited
2 = Purchasable with coupon only

Condition

0 = New
1 = Used
2 = New and in original packaging
3 = New with label
4 = Factory seconds

Item condition

Condition for API

0 = New
1 = Used but as new
2 = Used but very good
3 = Used but good
4 = Used but acceptable
5 = Factory seconds

Item condition. This is transferred via the API to other markets

Subscription (yes/no)

0 = No
1 = Yes

Can the item be ordered as a subscription?

Serial number (yes/no)

0 = No
1 = Yes

Assign serial number?

Shipping package (yes/no)

0 = No
1 = Yes

Use shipping package?

Fulfilment by Amazon (FBA)

0 = Do not use
1 = AMAZON EU
2 = AMAZON FE
3 = AMAZON NA
-1 = FBA and SellerCentral

Shipment by Amazon (FBA)

0 = No
1 = Yes

FBA shipping?

Amazon product type

Numeric

For IDs see amazon_product_type value table

Amazon-FEDAS

FEDAS product group key

Listing template

Numeric (internal ID)

Listing category 1;
Listing category 2

Numeric

Listing store category 1;
Listing store category 2

Numeric

Rakuten.de categories

Numeric (internal ID)

Flag 1

Numeric (internal ID)

ID of flag 1, see Setup » Items » Flags » Tab: Flag 1

Flag 2

Numeric (internal ID)

ID of flag 2, see Setup » Items » Flags » Tab: Flag 2

Age rating

0 = None available
3 = Released for age 3 and older
6 = Released for age 6 and older
12 = Released for age 12 and older
16 = Released for age 16 and older
18 = Released for age 18 and older
50 = Not marked
88 = Not required
99 = Still unknown

Age rating

Item feedback

Numeric

Initial rating from 1 to 5 or 1 to 10

Field 1;
Field 2;
Field 3;
…​
Field 20

Alpha-numeric

Free text fields 1 to 20

Max. item order quantity

Numeric

Manufacturer name

Alpha-numeric

If not available in the system, a new manufacturer is created.

Item template

Numeric

ID of the category item template
Note: Item templates are only available for the old web design Callisto.

Delete item

0 = No
1 = Yes

2.2. Item sets

Table 3 lists the fields available for importing item sets. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 3. Fields for importing item sets
Mapping field Permitted import values Explanation

Add components (IDs, comma-separated)

Alpha-numeric

ID and quantity of the items to be added to the set
Format: itemID:quantity,itemID:quantity

Remove components (IDs, comma-separated)

Alpha-numeric

IDs of the items to be removed from the set

Discount

Decimal number

Discount on total price of set in %

2.3. Cross-selling

Table 4 lists the fields available for importing cross-selling links. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 4. Fields for importing cross-selling links
Mapping field Permitted import values Explanation

Delete all cross selling links

0 = No
1 = Yes

Add cross-selling links

Alpha-numeric

Cross-selling links in the format
Item ID:Reference type;Item ID:Reference type;etc.
Available relationship types:
Accessory = Accessory
ReplacementPart = Replacement part
Similar = Similar
Bundle = Item bundle

Delete cross selling links

Numeric

Cross-selling links to be deleted in the format
ItemID;itemID;etc.

2.4. Item description

Table 5 lists the fields available for importing item descriptions. Create one mapping per language. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 5. Fields for importing item descriptions
Mapping field Permitted import values Explanation

Name

Alpha-numeric

Name 2;
Name 3

Alpha-numeric

Preview text

Alpha-numeric

Meta description

Alpha-numeric

Item text

Alpha-numeric

Technical data

Alpha-numeric

URL path

Link

Meta keywords

Alpha-numeric

2.5. Shipping profile

Table 6 lists the fields available for importing shipping profiles. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 6. Matching fields for shipping profiles
Mapping field Permitted import values Explanation

Shipping profile ID

Numeric

Shipping profiles (separated by commas)

Makes it possible to import more than one shipping profile

Delete shipping profile links (profile IDs, comma-separated)

Alpha-numeric

2.6. Variations

Table 7 lists the fields available for importing variation data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 7. Matching fields for variations
Mapping field Permitted import values Explanation

ID

Numeric

Item ID

Numeric

Position

Numeric

Active

0 = No
1 = Yes

Is the variation active, i.e. is it available in the online store and on markets?

Variation no.

Alpha-numeric

Model

Alpha-numeric

Model name

External variation ID

Alpha-numeric

Availability

Numeric (internal ID)

Net purchase price

Numeric

Purchase price

Mov. av. purchase price (net)

Numeric

Moving average price (net)

Price calculation

Numeric (internal ID)

Units contained

Numeric

Packaging unit; standard = 1

Number of packages

Numeric

Unit of packing units

0 = No packaging
1 = Bale
2 = Dispenser
3 = Coil
4 = Roll pallet
5 = Colli
6 = Container
7 = Bucket
8 = Cask
9 = Bottles
10 = European flat pallet
11 = Structural frame
12 = Gas cylinder
13 = Pallet cage
14 = Hobbock
15 = Half pallet
16 = Pallet of food items
17 = Wooden coaster
18 = IBC container
19 = Pitcher
20 = Wicker bottle
21 = Case
22 = Canister
23 = Customer pallet
24 = Cardboard box
25 = Composite packaging
26 = Package
27 = Ring
28 = Roll
29 = Sack
30 = Unit
31 = Tank
32 = Drum
34 = Crate
35 = Quarter pallet
36 = Other pallets
37 = Bin
38 = One-way pallet
39 = Foil bag

Net transportation costs

Numeric

Net storage costs

Numeric

Customs

Numeric

Percentage value

Operating costs

Numeric

Percent

VAT

Numeric (%)

Bundle type

bundle = Variation is a bundle
bundle_item = Variation is a bundle component

Invisible in item list

0 = No
1 = Yes

Order picking

single_picking = Single order picking is possible
no_single_picking = Single order picking is not possible
exclude_from_picklist = Exclude from pick list

Stock limit

0 = No limitation
1 = To net stock
2 = No stock

Visibility Client: Visible automatically if net stock is positive

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Visibility Client: Invisible automatically if net stock is 0 or negative

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Visibility Item list: Always invisible

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Visibility Item list: Visible automatically if net stock is positive

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Visibility Item list: Invisible automatically if net stock is 0 or negative

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Availability Online store: Available automatically if net stock is positive

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Availability Online store: Not available automatically if net stock is 0 or negative

0 = No
1 = Yes

Corresponds to the same availability setting as in the item overview.

Main warehouse

Numeric (internal ID)

Max. order quantity

Numeric

Min. order quantity

Numeric

Interval order quantity

Numeric

Show unit price

0 = No
1 = Yes

tagVariationId

Numeric

Delete variations

0 = No
1 = Yes

Main variation ID

Alpha-numeric

Available until

Date

Last date that the main variation is available.

Release date

Date

Date on which the main variation becomes available.

Name

Alpha-numeric

Name of the variation

Gross weight in g

Numeric

Net weight in g

Numeric

Width in mm

Numeric

Length in mm

Numeric

Height in mm

Numeric

Extra shipping charge 1;
Extra shipping charge 2

Numeric

2.7. Barcodes

Table 8 lists the fields available for importing barcode data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per barcode type.

Table 8. Fields for importing barcodes
Mapping field Permitted import values Explanation

Code

Alpha-numeric

Delete barcode

0 = No
1 = Yes

2.8. Variation prices

Table 9 lists the fields available for importing variation price data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per sales price.

Table 9. Fields for importing variation prices
Mapping field Permitted import values Explanation

Price

Numeric

Select a sales price from the drop-down list on the right.

Delete price

0 = No
1 = Yes

Deletes a linked price.

Net price (Yes/No)

0 = No
1 = Yes

Select if the price to be imported is a net price.

2.9. Categories

Table 10 lists the fields available for importing category data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 10. Fields for importing categories
Mapping field Permitted import values Explanation

Category ID

Numeric (internal ID)

Alternatively, transfer the name of the category.

Position

Numeric

Is Neckermann.de main category

0 = No
1 = Yes

Category name

Alpha-numeric

  • Complete category path, separated by semicolons (e.g. shoes;unisex)
    or

  • Category ID

Tip: Create additional mappings to import more categories.

Delete all category links

0 = No
1 = Yes

Removes all linked categories.

Category IDs (separated by commas)

Alpha-numeric

The IDs of the categories that shall be linked to the variation.

Category names (separated by commas)

Alpha-numeric

Name of the categories that shall be linked to the variation.

Delete links (Category IDs, separated by commas)

Alpha-numeric

IDs of the categories that shall be removed from the variation.

Delete links (Category names, separated by commas)

Alpha-numeric

Name of the categories that shall be removed from the variation.

Create not found categories

2.10. Default categories

Table 11 lists the fields available for importing category data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 11. Fields for importing default categories
Mapping field Permitted import values Explanation

Category ID

Numeric (internal ID)

ID of the default category

Category name

Alpha-numeric

Name of the default category

Create not found categories

2.11. Stock

Table 12 lists the fields available for importing stock data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 12. Fields for importing stock
Mapping field Permitted import values Explanation

Warehouse

Numeric (internal ID)

Can only be used in combination with quantity and storage location.

Quantity

Numeric

Can only be used in combination with warehouse and storage location.

Storage location

Numeric (internal ID)

Can only be used in combination with warehouse and quantity.

2.12. Client

Table 13 lists the fields available for importing client availabilities. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each client.

Table 13. Matching fields for importing client availabilities
Mapping field Permitted import values Explanation

Active

0 = No
1 = Yes

2.13. Markets

Table 14 lists the fields available for importing market availabilities. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each market.

Table 14. Fields for importing market availabilities
Mapping field Permitted import values Explanation

Active

0 = No
1 = Yes

2.14. Attributes

Table 15 lists the fields available for importing attribute links. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each format.

Table 15. Fields for importing attribute links
Mapping field Permitted import values Explanation

Attribute selection combination

Alpha-numeric

Combination of Attribute name (internal) and Attribute value (internal) in the format
attributeName:valueName; or attributeName<>valueName<||>
Import of more than two attribute links.
Note: Every attribute selection combination must be unique for each variation.

Attribute ID

Numeric

Import of up to two attribute links.
Tip: If two links exist, the IDs must be in different columns. Create a mapping in the format attribute name:value name; and an additional mapping in the format attribute name<>value name<||> and assign the separate columns.

Attribute Name

Alpha-numeric

Import of up to two attribute links.
Tip: If two links exist, the names must be in different columns. Create a mapping in the format attribute name:value name; and an additional mapping in the format attribute name<>value name<||> and assign the separate columns.

Value name

Alpha-numeric

Import of up to two attribute links.
Tip: If two links exist, the names must be in different columns. Create a mapping in the format attribute name:value name; and an additional mapping in the format attribute name<>value name<||> and assign the separate columns.

Value ID

Numeric

Import of up to two attribute links.
Tip: If two links exist, the IDs must be in different columns. Create a mapping in the format attribute name:value name; and an additional mapping in the format attribute name<>value name<||> and assign the separate columns.

2.15. Item images

Table 16 lists the fields available for importing image data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 16. Matching fields for importing item images
Mapping field Permitted import values Explanation

Image ID

Numeric (internal ID)

Position

Numeric

File name

Alpha-numeric

Base64 data

Alpha-numeric

URL

Alpha-numeric

Link to item image

Multi URL (separated by commas)

Alpha-numeric

Several image URLs in the format
image1url;positionImage1,
image2url;positionImage2
If no position is transferred, the position corresponds to the order of the URLs.

Delete images

0 = No
1 = Yes

1 deletes all images of the item. Images that should not be deleted must be entered as URL in the sync.

Link to variation

0 = No
1 = Yes

1 links the image to the variation.
0 deletes an existing link.

Availability client (store)

Numeric (internal ID)

For client IDs, see Setup » Client » Open client » Settings
-1 activates all clients

Availability referrers

Numeric (internal ID)

For referrer IDs, see Order referrer IDs
Specify more than one referrer separated by commas.
-1 activates all referrers

Availability listings

Numeric (internal ID)

-1 activates all listings

Name

Alpha-numeric

Name of the item image in the format Name:Language1,Name:Language2
Alternative text of the item image in the format Name:Language1:AlternativeText,Name:Language2:AlternativeText

Market attribute link (attribute value ID)

Numeric (internal ID)

ID of the attribute value

Remove all availabilities

0 = No
1 = Yes

2.16. Characteristics

Table 17 lists the fields available for importing characteristics data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 17. Fields for importing characteristic links
Mapping field Permitted import values Explanation

ID

Numeric (internal ID)

See Setup » Item » Characteristics

Characteristic combination

Alpha-numeric

Combination of back end name, value and language in the format
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Internal name

Alpha-numeric

Value

Alpha-numeric

Language

Letters

Only for characteristics of the type Text
For codes, see Languages

Selection ID

Numeric (internal ID)

Only for characteristics of the type Selection Links a characteristic’s selection values by their IDs.
For selection IDs, see Setup » Item » Characteristics » Open characteristic

Delete (yes/no)

0 = No
1 = Yes

2.17. Properties

Table 18 lists the fields available for importing property links at the variation level. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 18. Fields for importing property links
Mapping field Permitted import values Explanation

ID

Numeric (internal ID)

For IDs, see Setup » Settings » Properties » Configuration

Language

Letters

Only for properties of the type Text or Short text
For codes, see Languages

Value

Alpha-numeric

Description

Alpha-numeric

Internal name

Alpha-numeric

Property combination

Alpha-numeric

Combination of name, value and language in the format
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Selection ID

Numeric (internal ID)

Only for properties of the type Selection Links a property’s selection values by their IDs.
For selection IDs, see Setup » Settings » Properties » Configuration » Open property » Values

Delete (yes/no)

0 = No
1 = Yes

2.18. Variation tags

Table 19 lists the fields available for importing tag links. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 19. Fields for importing tag links
Mapping field Permitted import values Explanation

Tag ID

Numeric

Tag name

Alpha-numeric

Tag names
(separated by commas)

Alpha-numeric

Tag list

Delete all linked tags

0 = No
1 = Yes

Delete all links?

Delete tag links (name, comma-separated)

Alpha-numeric

Delete tag links (ID, comma-separated)

Alpha-numeric

2.19. Inheritance

Table 20 lists the fields available for importing inheritance settings. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 20. Fields for importing inheritance
Mapping field Permitted import values Explanation

Category

0 = No
1 = Yes

Markets

0 = No
1 = Yes

Client

0 = No
1 = Yes

Purchase price

0 = No
1 = Yes

Supplier

0 = No
1 = Yes

Warehouse

0 = No
1 = Yes

Availability

0 = No
1 = Yes

Tags

0 = No
1 = Yes

2.20. Content

Table 21 lists the fields available for importing content data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 21. Fields for importing content
Mapping field Permitted import values Explanation

Content unit

Numeric (internal ID)

For IDs, see Unit IDs
Alternatively, transfer content units of measure (ISO)

Content quantity

Numeric

Can only be used in combination with Content unit and Content units of measure (ISO).

Content Units of measure (ISO)

Alphanumeric ISO code

Alternatively, transfer Content unit

2.21. ASIN/ePID

Table 22 lists the fields available for importing ASIN/ePID data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 22. Fields for importing ASIN/ePID
Mapping field Permitted import values Explanation

Country

Numeric (internal ID)

For IDs see Country IDs

Type

ASIN; ePID

Position

Numeric

Value

Alpha-numeric

2.22. Warehouse

Table 23 lists the fields available for importing warehouse data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per warehouse.

Table 23. Fields for importing warehouse data
Mapping field Permitted import values Explanation

Zone

Numeric

Storage location type

none = none
small = small
medium = medium
large = large
europallet = Euro pallet

Reorder level

Numeric

Maximum stock

Numeric

Stock turnover (in days)

Numeric

Storage location

Numeric (internal ID)

Stock buffer

Numeric

Batch (yes/no)

0 = No
1 = Yes

Best before date (yes/no)

0 = No
1 = Yes

Delete warehouse link

0 = No
1 = Yes

2.23. Supplier

Table 24 lists the fields available for importing supplier data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 24. Fields for importing supplier data
Mapping field Permitted import values Explanation

Supplier link ID

Numeric

ID of the link between variation and supplier
This ID is automatically generated by plentymarkets. The ID is not visible in your plentymarkets system. Rather, the ID is only saved in the background. If you want to see the ID anyway, then you’ll need to export this information from your plentymarkets system. You can do this with the export format VariationSupplier in FormatDesigner.
The mapping field Supplier link ID may or may not be a required value. It depends on what exactly you want to do. For example, you need this field if you want to create suppliers while you import items.

Purchase price

Numeric

The variation’s purchase price

Minimum purchase

Numeric

Supplier item No.

Alpha-numeric

External item number assigned to the variation by the supplier

Last price query

Date

Date of the last price negotiations

Delivery time in days

Numeric

Discount

Numeric

Percent

Discountable

0 = No
1 = Yes

Packaging unit

Numeric

Supplier ID

Numeric

Contact ID of the supplier, see CRM » Contacts
Tip: Set Type filter to Supplier to only show contacts of the type Supplier.

Supplier name

Alpha-numeric

For supplier name, see CRM » Contacts
Tip: Set Type filter to Supplier to only show contacts of the type Supplier.

Delete supplier

0 = No
1 = Yes

Unlinks the supplier from the variation.

2.24. SKU

Table 25 lists the fields available for importing SKU data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 25. Fields for importing SKU
Mapping field Permitted import values Explanation

Market ID

Numeric

For referrer IDs, see Order referrer IDs

Account ID

Numeric

ID of the market account
For Amazon, see Setup » Markets » Amazon » Settings
For eBay, see Setup » Markets » eBay » Accounts

SKU

Alpha-numeric

Parent SKU

Alpha-numeric

Delete SKU

0 = No
1 = Yes

2.25. Additional SKUs

Table 26 lists the fields available for importing additional SKU data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 26. Fields for importing additional SKU
Mapping field Permitted import values Explanation

Market ID

Numeric

For referrer IDs, see Order referrer IDs

Account ID

Numeric

ID of the market account
For Amazon, see Setup » Markets » Amazon » Settings
For eBay, see Setup » Markets » eBay » Accounts

SKU

Alpha-numeric

Parent SKU

Alpha-numeric

Delete additional SKU

0 = No
1 = Yes

2.26. Bundle

Table 27 lists the fields available for importing item bundles. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 27. Fields for importing bundles
Mapping field Permitted import values Explanation

Item bundle components

Alpha-numeric

Adds components to a bundle. Enter the component’s variation ID and quantity. Use a colon to separate the variation ID and quantity. Use a semicolon to separate multiple components. Example:
VariationID:Quantity;VariationID:Quantity;etc.

Item bundle components (variation numbers)

Alpha-numeric

Adds components to a bundle. Enter the component’s variation number and quantity. Use a colon to separate the variation number and quantity. Use a semicolon to separate multiple components. Example:
VariantionNumber:Quantity;VariationNumber:Quantity;etc.

Delete bundle components

Alpha-numeric

Deletes components from a bundle. Enter the variation ID of whichever component should be deleted. Use a semicolon to separate multiple variation IDs. Example:
VariationID;VariationID

Delete bundle

0 = No
1 = Yes

Deletes all components from a bundle. You do not need to enter the variation IDs of individual components since all of the bundle components will be deleted at the same time.

2.27. Serial number

Table 28 lists the fields available for importing serial number data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 28. Fields for importing serial numbers
Mapping field Permitted import values Explanation

ID

Numeric

ID of the serial number

Number

Numeric

Serial number

Delete Serial number

0 = No
1 = Yes

3. Required values for various item sync procedures

Table 29 gives several different examples of things that can be done with item syncs. The table lists the required values for each scenario.

Table 29. Procedures for item syncs
Procedure Required values

Item description

Update item description

  • Name

Shipping profile

Update shipping profile

  • Shipping profile ID

Variation tags

Delete all tag links

  • Delete all linked tags = 1

Delete tag

One tag:

  • Tag ID
    or

  • Tag name

Multiple tags:

  • Tag names (separated by commas)

Variations

Create variation

  • ID of the default category
    or

  • Name of the default category

Add variation to item

  • Content quantity

  • Content unit
    or

  • Content quantity

  • Content Units of measure (ISO)

and

  • Item ID
    or

  • Main variation ID

For variations with attributes, the following applies in addition:

  • Attribute selection combination
    or

  • Attribute (name or ID)

  • Value (name or ID)

Update content

  • Content quantity

  • Content unit
    or

  • Content quantity

  • Content Units of measure (ISO)

Barcodes

Change barcode

  • Code via barcode mapping

Categories

Link category

  • Category ID
    or

  • Category name

Tip: Create additional mappings to import more categories.

Update link

  • Category ID
    or

  • Category name

Variation prices

Change price

  • Price via sales price mapping

Default categories

Link default category

  • Category ID
    or

  • Category name

Update default category

  • Category ID
    or

  • Category name

Stock

Update stock

  • Warehouse

  • Quantity

  • Storage location

Item images

Delete all images before upload

  • Delete images = 1

Save images

  • Multi URL
    or

  • URL
    or

  • File name

  • Base64 data

Update images

  • Image ID

Link image with variation

  • Multi URL
    or

  • URL

Characteristics

Save characteristics

  • Characteristic combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Update characteristics

  • Characteristic combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Properties

Link a property

  • ID

  • Language

  • Value

Supplier

Link supplier

  • Purchase price

  • Supplier link ID (leave empty for new links)

and

  • Supplier ID
    or

  • Supplier name

Update supplier

  • Purchase price

  • Supplier link ID

and

  • Supplier ID
    or

  • Supplier name

SKU

Add SKU

  • Market ID

  • SKU

For eBay/Amazon, the following applies in addition:

  • Account ID

Update SKU

  • Market ID

  • SKU

For eBay/Amazon, the following applies in addition:

  • Account ID

Bundle

Create bundle

  • Item bundle components

Delete bundle components

  • Delete bundle components

Delete bundle

  • Delete bundle = 1

To top