Price Lists

Short description

The ERP Cache PriceList interface allows the import of price lists into the ERP Cache. The import can contain multiple price lists.

Delivery method

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

Filetype: Zipped XML

Filename: [SHOPNAME]_ErpCache_PriceLists_[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_PriceLists</Importer>
        <Version>1.0</Version>
    </ImportSettings>
    <PriceLists>
        <PriceList>
            <PriceListName></PriceListName>
            <ProductNumber></ProductNumber>
            <VatCode></VatCode>
            <BaseUnit></BaseUnit>
            <PriceUnit></PriceUnit>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat></NettoPricePerItemExclVat>
                    <DiscountAmountPerItemExclVat></DiscountAmountPerItemExclVat>
                    <DiscountPercentagePerItem></DiscountPercentagePerItem>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </PriceList>
    </PriceLists>
</Import>

Fields XML

Import element:

Name

Description

Type

Required/Optional

ImportSettings

Container element for importsettings

Element

Optional

PriceLists

Container element for PriceList data

Element

Required

ImportSettings element:

Name

Description

Type

Required/Optional

Importer

Name of the importer. Should be ErpCache_PriceLists.

Text,

default ErpCache_PriceLists

Optional

Version

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

Text, default 1.0

Optional

PriceList element:

Name

Description

Type

Required/Optional

PriceListName

Name of price list

Text

Required

ProductNumber

The identifier of a product

Text

Required

VatCode

HIGH = 21 % LOW = 6%

ZERO = 0%

Text

Required

BaseUnit

The base unit of the product, eg pce or meter.

Text

Required

PriceUnit

The quantity on which price is based

Positive integer

Required

QuantityDiscountPrices

Container element for QuantityDiscountPrice data

Element

Required

QuantityDiscountPrice element:

Name

Description

Type

Required/Optional

FromQuantity

The from quantity where the discount price is valid from

Positive integer

Required

ToQuantity

The to quantity where the discount price is valid to

Positive integer

Optional

NettoPricePerItemExclVat

The calculated netto price per item. This is the price including discounts.

Decimal

Required

DiscountAmountPerItemExclVat

This field can be used to give the calculated Discount Amount using a discount percentage. Or just give a discount amount when no discount percentage is used for the calculation.

Decimal

Optional

DiscountPercentagePerItem

A percentage of the give discount on the default netto price per item excluding VAT. When this field is set, the field DiscountAmountPerItemExclVat is required.

Decimal

Optional

Last updated