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

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

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