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

TypeValues

Boolean

Y, N

Decimal

Number with point (.) as decimal separator character. Other separators are not allowed.