> For the complete documentation index, see [llms.txt](https://shoxl.gitbook.io/erp-integration-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://shoxl.gitbook.io/erp-integration-guide/2021.4/erp-cache-batch/customer-price.md).

# Customer-specific Prices

## Short description

Price agreements for specific articles that supersede the price as specified in the customers pricelist can be defined via the ERP Cache CustomerPrices interface. The import file can contain multiple prices for multiple customers.\
\
Prices can be defined in multiple currencies. If no currency is specified then the price will be imported in Euro.

## Delivery method

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

**Filetype:** Zipped XML

**Filename: \[SHOPNAME]\_ErpCache\_CustomerPrices**\_**\[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\_CustomerPrices XML 1.0 to 1.1

* An optional currency attribute was added to NettoPricePerItemExclVat and DiscountAmountPerItemExclVat. 

```markup
<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_CustomerPrices</Importer>
        <Version>1.1</Version>
    </ImportSettings>
    <CustomerPrices>
        <CustomerPrice>
            <AccountNumber></AccountNumber>
            <ProductNumber></ProductNumber>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat Currrency=""></NettoPricePerItemExclVat>
                    <DiscountAmountPerItemExclVat Currrency=""></DiscountAmountPerItemExclVat>
                    <DiscountPercentagePerItem></DiscountPercentagePerItem>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </CustomerPrice>
    </CustomerPrices>
</Import>

```

## Fields XML

**Import element:**

| Name           | Description                              | Type    | Required/Optional |
| -------------- | ---------------------------------------- | ------- | ----------------- |
| ImportSettings | Container element for importsettings     | Element | Required          |
| CustomerPrices | Container element for CustomerPrice data | Element | Required          |

**ImportSettings element:**

| Name     | Description                                                              | Type                        | Required/Optional |
| -------- | ------------------------------------------------------------------------ | --------------------------- | ----------------- |
| Importer | <p>Name of the importer.<br>Must be ErpCache\_CustomerPrices.</p>        | Text                        | Required          |
| Version  | Version of the import xml. To be used for backward compatibility issues. | <p>Text,<br>must be 1.1</p> | Required          |

**CustomerPrice element:**

| Name                   | Description                                      | Type    | Required/Optional |
| ---------------------- | ------------------------------------------------ | ------- | ----------------- |
| AccountNumber          | Account number (debtor number) of the customer   | Text    | Required          |
| ProductNumber          | The identifier of a product                      | Text    | Required          |
| QuantityDiscountPrices | Container element for QuantityDiscountPrice data | Element | Required          |

**QuantityDiscountPrice element:**

Prices can optionally be defined in multiple currencies. The NettoPricePerItemExclVat and DiscountAmountPerItemExclVat elements may therefore occur more then once within a 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          |
| Currency                     | Attribute on NettoPricePerItemExclVat or DiscountAmountPerItemExclVat. Must contain the ISO 4217 3-letter currency code. Default is EUR.                                           | Char\[3]         | Optional          |