Skip to main content
  2. Data

VariationSalesPrice

The data format VariationSalesPrice is used to export sales prices for items. 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. 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
To top