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. 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_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

Changes from ErpCache_CustomerPrices XML 1.0 to 1.1

  • An optional currency attribute was added to NettoPricePerItemExclVat and DiscountAmountPerItemExclVat.

Changes from ErpCache_CustomerPrices XML 1.1 to 1.2

  • Added VatCode, BaseUnit and PriceUnit to the customer price import. This was necessary if you only want to use Customer Prices. Without those values, customer prices only will not work since the product table will have no matching records.

  • Added optional PartialImport importsetting

Changes from ErpCache_CustomerPrices XML 1.2 to 1.3

  • The VatCode field was replaced by VatPercentage

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_CustomerPrices</Importer>
        <Version>1.3</Version>
        <PartialImport>Y</PartialImport>
    </ImportSettings>
    <CustomerPrices>
        <CustomerPrice>
            <AccountNumber></AccountNumber>
            <ProductNumber></ProductNumber>
            <VatPercentage></VatPercentage>
            <BaseUnit></BaseUnit>
            <PriceUnit></PriceUnit>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat Currency=""></NettoPricePerItemExclVat>
                    <DiscountAmountPerItemExclVat Currency=""></DiscountAmountPerItemExclVat>
                    <DiscountPercentagePerItem></DiscountPercentagePerItem>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </CustomerPrice>
    </CustomerPrices>
</Import>

Fields XML

Import element:

Name

Description

Type

Required/Optional

ImportSettings

Container element for importsettings

Element

Required

CustomerPrices

Container element for CustomerPrice data

Element

Required

ImportSettings element:

Name

Description

Type

Required/Optional

Importer

Name of the importer. Must be ErpCache_CustomerPrices.

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 Y

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

VatPercentage

VAT Percentage (%)

Decimal

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

Decimal

Required

ToQuantity

The to quantity where the discount price is valid to

Decimal

Optional

NettoPricePerItemExclVat

The calculated netto 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

Decimal

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