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 Shoxl CustomerPrices interface. The import file can contain multiple prices for multiple customers.

The import enables the filtering of articles on net prices if the price model of the ERP system can be mapped to PriceLists and Customer-specific prices. We expect the customer-specific prices to be the exceptions on the PriceList prices. If the price calculation in the ERP is so complex that a Customer-specific price would be needed for each product/customer combination, this solution - and net price based filtering - might not be an option.

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]_Shoxl_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: \ShoxlPro\XmlImport\

Structure XML

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>Shoxl_CustomerPrices</Importer>
        <Version>1.0</Version>
        <PartialImport>Y</PartialImport>
    </ImportSettings>
    <CustomerPrices>
        <CustomerPrice>
            <AccountNumber></AccountNumber>
            <ProductNumber></ProductNumber>
            <VatPercentage></VatPercentage>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat Currency=""></NettoPricePerItemExclVat>
                </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 Shoxl_CustomerPrices.	Text	Required
Version	Version of the import xml. To be used for backward compatibility issues.	Text, must be 1.0	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
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
Currency	Attribute on NettoPricePerItemExclVat or DiscountAmountPerItemExclVat. Must contain the ISO 4217 3-letter currency code. Default is EUR.	Char[3]	Optional

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