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 optinoal 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