VariationSalesPrice

The data format VariationSalesPrice is used to create, edit or delete sales prices for items. Create and export the data format in the Data » Dynamic export menu. Import the data format in the Data » Dynamic import menu. The Exporting data and Importing data pages of the manual describe how you export and import 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 VariationSalesPrice 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 **VariationSalesPrice**
Field name	Explanation	Filter
DeleteSalesPrice	Delete price
IsNet	1 = Net prices 0 = Gross prices	Activate the filter and select the value from the drop-down list.
ItemMarking1	Flag 1 of the item; 0 = No flag
ItemMarking2	Flag 2 of the item; 0 = No flag
SalesPriceExternalName	External name of the sales price
SalesPriceID	Sales price ID	Activate the filter and select the price from the drop-down list.
SalesPriceInternalName	Internal name of the sales price
SalesPriceLiveConversion	Live conversion of sales prices; is activated in the Setup » Item » Sales prices menu.
SalesPriceLang	Language of the sales price; is activated in the Setup » Item » Sales prices » Open sales price » Tab: Language menu.	Activate the filter and select the language from the drop-down list.
SalesPriceMinimumOrderQuantity	Minimum order quantity of the sales price
SalesPricePosition	Position of the sales price; sales prices are sorted in ascending order in the Sales prices area of item variations.
SalesPriceType	Type of the sales price
VariationAttributes	Attribute name and attribute value name of the variation; format: Name:Value
VariationNumber	(previously VariationCustomNumber) Variation number
VariationID	Variation ID	Activate the filter, select the operator and enter the value.
VariationName	Name of the variation
VariationPrice	Price of the variation

2. Overview of the mandatory fields

The following mandatory fields must be available for the data format VariationSalesPrice and need to have a valid value saved for them:

Variation ID and SalesPriceID for editing a sales price
VariationID, SalesPriceID and DeleteItemPrice for deleting a sales price

3. Overview of the synchronisation fields

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

Table 2. Data fields with the import procedure set to **Synchronisation**
Field name	Explanation
VariationCustomNumber	Variation number
VariationID	Variation ID
SalesPriceID	Sales price ID