VariationSupplier
Suppliers can be assigned to variations. The corresponding data is exported with the data format VariationSupplier. 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 VariationSupplier data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.
Field name | Explanation | Filter |
---|---|---|
DeleteSupplier |
Delete supplier |
|
DeliveryTimeInDays |
Delivery time in days |
|
Discount |
Discount |
|
Discountable |
Discountable |
|
ItemName |
Item name |
|
LastPriceQuery |
The date of the last price query |
|
MinimumOrderValue |
Minimum order value |
|
PackagingUnit |
Packaging unit |
|
PurchasePrice |
Purchase price |
|
SupplierID |
The supplier’s ID |
Activate the filter, select the operator and enter the value. |
SupplierItemNo |
The supplier’s item number |
|
SupplierNumber |
The supplier’s number |
|
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 |
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 Setup » 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.
Field name | Explanation | Synchronisation fields |
---|---|---|
Barcode_xxx |
Barcode, as created in the Setup » 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.