Customer-specific Prices
Short description
Price agreements for specific articles that supersede the price as specified in the customers pricelist can be defined via the ERP Cache CustomerPrices interface. The import file can contain multiple prices for multiple customers.
Delivery method
Update Frequency: Batch at least once a day Incremental or complete set: Incremental
Filetype: Zipped XML
Filename: [SHOPNAME]_ErpCache_CustomerPrices_[INDEXNUMBER].xml Transport: over FTPS, FTPS Vendisto server hosted by INTEGRACE, file will be placed on FTPS server by ERP party.
Location within FTP root: \ErpCache\
Structure XML
Fields XML
Import element:
Name | Description | Type | Required/Optional |
ImportSettings | Container element for importsettings | Element | Optional |
CustomerPrices | Container element for CustomerPrice data | Element | Required |
ImportSettings element:
Name | Description | Type | Required/Optional |
Importer | Name of the importer. Should be ErpCache_CustomerPrices. | Text, default ErpCache_CustomerPrices | Optional |
Version | Version of the import xml. To be used for backward compatibility issues. | Text, default 1.0 | Optional |
CustomerPrice element:
Name | Description | Type | Required/Optional |
AccountNumber | Account number (debtor number) of the customer | Text | Required |
ProductNumber | The identifier of a product | Text | Required |
QuantityDiscountPrices | Container element for QuantityDiscountPrice data | Element | Required |
QuantityDiscountPrice element:
Name | Description | Type | Required/Optional |
FromQuantity | The from quantity where the discount price is valid from | Positive integer | Required |
ToQuantity | The to quantity where the discount price is valid to | Positive integer | Optional |
NettoPricePerItemExclVat | The calculated netto price per item. This is the price including discounts. | Decimal | Required |
DiscountAmountPerItemExclVat | This field can be used to give the calculated Discount Amount using a discount percentage. Or just give a discount amount when no discount percentage is used for the calculation. | Decimal | Optional |
DiscountPercentagePerItem | A percentage of the give discount on the default netto price per item excluding VAT. When this field is set, the field DiscountAmountPerItemExclVat is required. | Decimal | Optional |
Last updated