Customer

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.1</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

Last updated