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.

• Added optional PartialImport importsetting

Changes from ErpCache_PriceLists XML 1.1 to 1.2

• The VatCode field was replaced by VatPercentage

• MinimumOrderQuantity was added

• AdditionQuantity was added

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_PriceLists</Importer>
        <Version>1.2</Version>
        <PartialImport>N</PartialImport>
    </ImportSettings>
    <PriceLists>
        <PriceList>
            <PriceListName></PriceListName>
            <ProductNumber></ProductNumber>
            <VatPercentage></VatPercentage>
            <MinimumOrderQuantity></MinimumOrderQuantity>
            <AdditionQuantity></AdditionQuantity>
            <BaseUnit></BaseUnit>
            <PriceUnit></PriceUnit>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat Currency=""></NettoPricePerItemExclVat>
                    <DiscountAmountPerItemExclVat Currency=""></DiscountAmountPerItemExclVat>
                    <DiscountPercentagePerItem></DiscountPercentagePerItem>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </PriceList>
    </PriceLists>
</Import>

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.2	Required
PartialImport	Defines if the priceslists in the file contain prices for all the articlenumbers in the pricelist or if the prices represent a partial update of the pricelist.	Boolean, Default N	Optional

PriceList element:

Name	Description	Type	Required/Optional
PriceListName	Name of price list	Text	Required
ProductNumber	The identifier of a product	Text	Required
VatPercentage	VAT Percentage (%)	Decimal	Required
MinimumOrderQuantity	Minimum order quantity for a product	Decimal	Optional
AdditionQuantity	Addition Quantity for a product	Decimal	Optional
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	Decimal	Required
ToQuantity	The to quantity where the discount price is valid to	Decimal	Optional
NettoPricePerItemExclVat	The calculated net price per item. This is the price including discounts.	Decimal	Required
DiscountAmountPerItemExclVat	Discount amount on the default net price. 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 net 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
Boolean	Y, N
Decimal	Number with point (.) as decimal separator character. Other separators are not allowed.