Exchange Rate

Short description

The ERP Cache ExchangeRate interface allows the import of exchange rates into the ERP Cache.

Delivery method

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

Filetype: Zipped XML

Filename: [SHOPNAME]_ErpCache_ExchangeRates_[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_ExchangeRates</Importer>
        <Version>1.0</Version>
    </ImportSettings>
    <ExchangeRates>
        <ExchangeRate>
            <SourceCurrency></SourceCurrency>
            <TargetCurrency></TargetCurrency >
            <Rate></Rate>
        </ExchangeRate>
    </ExchangeRates>
</Import>

Fields XML

Import element:

Name

Description

Type

Required/Optional

ImportSettings

Container element for importsettings

Element

Optional

ExchangeRates

Container element for exchange rate data

Element

Required

ImportSettings element:

Name

Description

Type

Required/Optional

Importer

Name of the importer. Should be ErpCache_ExchangeRates.

Text,

default ErpCache_ExchangeRates

Optional

Version

Version of the import xml. To be used for backward compatibility issues.

Text, default 1.0

Optional

ExchangeRate element:

Name

Description

Type

Required/Optional

SourceCurrency

Source Currency

Text

Required

TargetCurrency

Target Currency

Text

Required

Rate

Multiplication factor to convert price from source currency to target currency

Decimal

Required