Skip to main content

VariationSupplier

Suppliers can be assigned to variations. The corresponding data is exported, edited and imported with the data format VariationSupplier. 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 VariationSupplier 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 VariationSupplier
Field name Explanation Filter

DeleteSupplier

Delete supplier
Value to delete = 1
Delete the supplier by marking the field SupplierRowID and selecting Synchronisation.

DeliveryTimeInDays

Delivery time in days

Discount

Discount

Discountable

Discountable

ItemName

Item name

LastPriceQuery

The date of the last price query
Format: DD.MM.YYYY

MinimumOrderValue

Minimum order value

PackagingUnit

Packaging unit

PurchasePrice

Purchase price

SupplierID

The supplier’s ID
See: Customers » Tab: Supplier

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

SupplierItemNo

The supplier’s item number

SupplierNumber

The supplier’s number
See: Tab: Customer data of a supplier

SupplierRowID

Unique matching field for the suppliers. It is used if a supplier was saved several times for a variation, e.g. in order to set up different prices for various quantities.

VariationCustomNumber

Variation number

VariationID

Variation ID

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

Barcode_xxx

Barcode
Note: The number of the barcode data fields that is displayed here depends on the barcode type that you selected in the System » Item » Barcode menu. Available barcode types: GTIN 8, GTIN 13, GTIN 14, GTIN 128, ISBN, QR, CODE 128 und UPC.

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

Export for customer class

Note: filter setting only

Activate the filter and select the customer class. In order to export data for all customer classes, do not activate the filter. Go to System » CRM » Classes to set up customer classes.

2. Overview of the mandatory fields

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

  • SupplierID

  • VariationID

3. Overview of the synchronisation fields

The data fields that are listed in table 2 are available for data synchronisation. For mandatory synchronisation fields, select the option Synchronisation as Import procedure. The rest of the fields can also be used for the synchronisation if desired. Mandatory synchronisation fields are marked with an M.

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

Barcode_xxx

Barcode, as created in the System » Item » Barcode menu

Alternative to Variation ID

SupplierID

Supplier ID

M

SupplierItemNo

The supplier’s item number

Alternative to Variation ID

SupplierNumber

The supplier’s number

Alternative to SupplierID

SupplierRowID

Unique matching field

VariationCustomNumber

Variation number

Alternative to Variation ID

VariationID

Variation ID

M

Deviating import procedure if the supplier was not yet saved for the variation

If the supplier was not yet saved for the variation, it is strictly speaking not a synchronisation, but an import. Therefore, when creating the data format, make sure that the data fields SupplierID and VariationID have the import procedure set to Import.

4. Overview of the procedures

In the Procedures tab, select which procedures you want to be carried out during the data export. Activate the LastPriceQuery procedure. Select the set the current date option from the drop-down list. A timestamp will be added to the supplier data during the import, indicating when the last price query took place.

To top