Customers

Short description

Via the ERP Cache Customer interface it is possible to link customers to price lists. The interface supports one price list per customer.

Delivery method

Update Frequency: Batch at least once a day Incremental or complete set: Incremental

Filetype: Zipped XML

Filename: [SHOPNAME]_ErpCache_Customers_[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_Customers XML 1.0 to 1.1

• The ImportSettings node is now required as well as the 'Importer' and 'Version' settings.

• DeliverySchemeCode was added as an optional element.

• InvoiceTo was added as an optional element.

• DiscountPercentage was added as an optional element.

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_Customers</Importer>
        <Version>1.1</Version>
    </ImportSettings>
    <Customers>
        <Customer>
            <AccountNumber></AccountNumber>
            <InvoiceTo></InvoiceTo>
            <PriceListName></PriceListName>
            <DeliverySchemeCode></DeliverySchemeCode>
            <CumulativeSalesVolume></CumulativeSalesVolume>
            <CashBack></CashBack>
            <CashBackCalculateToDate></CashBackCalculateToDate>
            <DiscountPercentage></DiscountPercentage>
        </Customer>
    </Customers>
</Import>

Fields XML

Import element:

Name	Description	Type	Required/Optional
ImportSettings	Container element for importsettings	Element	Required
Customers	Container element for Customer data	Element	Required

ImportSettings element:

Name	Description	Type	Required/Optional
Importer	Name of the importer. Should be ErpCache_Customers.	Text, default Authorization	Required
Version	Version of the import xml. To be used for backward compatibility issues.	Text, default 1.1	Required

Customer element:

Name	Description	Type	Required/Optional
AccountNumber	Account number (debtor number) of the customer	Text	Required
InvoiceTo	Account Number of the Invoice debtor. If this field is filled, the webservice will return the prices as specified for the invoice debtor when beïng requested for the customer's accountnumber	Text	Optional
PriceListName	Name of price list	Text	Required
DeliverySchemeCode	Name of the DeliveryScheme	Text	Optional
CumulativeSalesVolume	The calculated cumulative sales volume until the given date (CashBackCalculateToDate)	Decimal #,###.##	Optional
CashBack	The calculated cashback until the given date	Decimal #,###.##	Optional
CashBackCalculateToDate	The cumulative sales volume and the cashback are calculated until this date	DateTime yyyy-MM-dd	Optional
DiscountPercentage	Discount percentage applied after all other discounts have been applied	Decimal ##.##	Optional