Skip to main content


The data format Variation is used to export variation data. 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. Important notes

Each variation is given a number (ID) and as such is also uniquely defined by the data field VariationID. The following three scenarios could occur for the export and import:

  • If the field VariationID is neither exported along with the export of variation fields nor imported later on, then new variations will be created with available variation IDs.

  • If the data record VariationID is exported and later imported again, then changes will be made to the corresponding variations.

  • If variation data is imported with variation IDs that do not yet exist in plentymarkets, then new variations will be created with these variation IDs.

If the import procedure Synchronisation is selected in the data export settings, then the variation data will be synchronised during the import.

2. The 1:n problem

The 1:n problem, i.e. one to n, occurs when several characteristics were defined for one variation. The following characteristics can be allocated to a variation multiple times in plentymarkets:

  • Sales prices

Every sales price is uniquely defined by the field SalesPriceID. If this ID is not specified, then a new sales price will always be added and the existing prices will be deleted. If available, the existing price will be changed.

  • Categories

One variation can be available in multiple categories at the same time. However, if category data fields (CategoryLevel) were entered during the import, then all of the previous category links for this variation will be deleted.

Use the data format Category for new categories

It is not possible to use the data format Variation for creating new categories. With the data format Variation, you can only create new category links within the variation. Use the data format Category instead to create new categories.

  • Item images

This data format allows you to import external images with the help of URLs. Existing item images will be replaced in the process. If multiple item images are imported, then these item images have to be separated by a comma without spaces when they are entered. If you do not want to replace the existing images, then import the images via FTP upload.

3. Overview of the data fields

Table 1 explains the data fields for the Variation data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.

Table 1. Data fields of the data format Variation
Field name Explanation Filter


Active variations
N = No
Y = Yes


Internal ID; determines the variation type
Example: ID 1 = colour red, size XL; ID 2 = colour green, size XL.


Automatically invisible in the online store. Set online store to 0 if no stock is available.
N = No
Y = Yes


The variation’s availability icon
N = Has to be deactivated manually
Y = Hide when there is no net stock


The variation’s availability icon
N = Has to be activated manually
Y = Display when the net stock is positive


Automatically visible in the online store. Set store to 1 if the stock is available.
N = No
Y = Yes


Availability of the variation


Available until
The setting is found under Item » Edit item » [Open item] » [Open variation] » Tab: Settings in the Availability area.


Date and time when the variation was created. Format: hh:mm
Note: The field is only available for the export.


Variation number

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


Percentage of the customs duties


1 = Deletes the variation
Deletes the variation when the value 1 is entered.
Note: Main variations cannot be deleted.


Availability in supply


External variation ID

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


Extra shipping charge 1


Extra shipping charge 2


Height in mm


Interval order quantity


Y = Variation is not visible in item list
N = Variation is visible in item list


Unique item ID; maximum numerical value 2^31

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


Last change, date and time. Format: hh:mm


Length in mm


Limit variation to stock
0 = No limitation
1 = Limited to net stock
2 = Do not administer stock for this variation


The main warehouse’s ID reference number. The setting is found under Item » Edit item » [Open item] » [Open variation] » Tab: Settings in the Shipping area.


Maximum order quantity for one order
The value 0 is selected by default; with the value 0, the maximum order quantity is unlimited.


Minimu order quantity per order


Model name


Percentage of the entire operating costs


Type of packaging for packing units


Packing units; numerical value


Order picking


This position number is used to sort the variation within the variation list in the online store.


ID of the calculated price; decimal value


Purchase price (net)


Release date, format YYYY-MM-DD HH:MM:SS


Storage costs


Transportation costs


ID of the unit; ID lists are found in the menu Setup » Item » Units.


Quantity contained within the unit


Pallet type


Units contained


ID of the VAT rate


Variation ID

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


Name of the variation


List of the attributes that are linked to the variation; ID list can be found in the menu Setup » Item » Attributes


The gross weight (with packaging) in grams; numerical value


The net weight (without packaging) in grams; numerical value


Width in mm

4. Overview of the synchronisation fields

The data fields that are listed in table 2 are available for data synchronisation. These data fields are compulsory synchronisation fields. At least one of the data fields from the following table must be selected for synchronisation. For the selected data field, select the option Synchronisation as Import procedure.

Table 2. Data fields with the import procedure set to Synchronisation
Field name Explanation


Variation number


External variation ID


Variation ID

Field VariationID

The field VariationID is usually a mandatory synchronisation field. However, this field does not necessarily have to be used for this data format. You can use any of the fields listed. One field is sufficient for the synchronisation.

To top