Price Lists
Short description
The ERP Cache PriceList interface allows the import of price lists into the ERP Cache. The import can contain multiple price lists. Prices can be defined in multiple currencies. If no currency is specified then the price will be imported in Euro.
Delivery method
Update Frequency: Batch at least once a day Incremental or complete set: Incremental
Filetype: Zipped XML
Filename: [SHOPNAME]_ErpCache_PriceLists_[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
Changes from ErpCache_PriceLists XML 1.0 to 1.1
An optional currency attribute was added to NettoPricePerItemExclVat and DiscountAmountPerItemExclVat.
Fields XML
Import element:
Name | Description | Type | Required/Optional |
ImportSettings | Container element for importsettings | Element | Required |
PriceLists | Container element for PriceList data | Element | Required |
ImportSettings element:
Name | Description | Type | Required/Optional |
Importer | Name of the importer. Must be ErpCache_PriceLists. | Text | Required |
Version | Version of the import xml. To be used for backward compatibility issues. | Text, must be 1.1 | Required |
PriceList element:
Name | Description | Type | Required/Optional |
PriceListName | Name of price list | Text | Required |
ProductNumber | The identifier of a product | Text | Required |
VatCode | HIGH = 21 % LOW = 6% ZERO = 0% | Text | Required |
BaseUnit | The base unit of the product, eg pce or meter. | Text | Required |
PriceUnit | The quantity on which price is based | Positive integer | Required |
QuantityDiscountPrices | Container element for QuantityDiscountPrice data | Element | Required |
QuantityDiscountPrice element: Prices can optionally be defined in multiple currencies. The NettoPricePerItemExclVat and DiscountAmountPerItemExclVat elements may therefore occur more then once within a 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 |
Currency | Attribute on NettoPricePerItemExclVat or DiscountAmountPerItemExclVat. Must contain the ISO 4217 3-letter currency code. Default is EUR. | Char[3] | Optional |
Type | Values |
---|---|
Decimal | Number with point (.) as decimal separator character. Other separators are not allowed. |
Last updated