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

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

Fields XML

Import element:

Name	Description	Type	Required/Optional
ImportSettings	Container element for importsettings	Element	Optional
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	Optional
Version	Version of the import xml. To be used for backward compatibility issues.	Text, default 1.0	Optional

Customer element:

Name	Description	Type	Required/Optional
AccountNumber	Account number (debtor number) of the customer	Text	Required
PriceListName	Name of price list	Text	Required
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