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

Last updated