> 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/erp-cache-batch/pricelist.md).

# 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.\
\
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\_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

### Changes from ErpCache\_**PriceLists** XML 1.0 to 1.1

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

### Changes from ErpCache\_**PriceLists** XML 1.1 to 1.2

* The VatCode field was replaced by VatPercentage
* MinimumOrderQuantity was added
* AdditionQuantity was added

```markup
<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_PriceLists</Importer>
        <Version>1.2</Version>
        <PartialImport>N</PartialImport>
    </ImportSettings>
    <PriceLists>
        <PriceList>
            <PriceListName></PriceListName>
            <ProductNumber></ProductNumber>
            <VatPercentage></VatPercentage>
            <MinimumOrderQuantity></MinimumOrderQuantity>
            <AdditionQuantity></AdditionQuantity>
            <BaseUnit></BaseUnit>
            <PriceUnit></PriceUnit>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NettoPricePerItemExclVat Currency="EUR"></NettoPricePerItemExclVat>
                    <NettoPricePerItemExclVat Currency="GBP"></NettoPricePerItemExclVat>
                    <DiscountAmountPerItemExclVat Currency="EUR"></DiscountAmountPerItemExclVat>
                    <DiscountAmountPerItemExclVat Currency="GBP"></DiscountAmountPerItemExclVat>
                    <DiscountPercentagePerItem></DiscountPercentagePerItem>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </PriceList>
    </PriceLists>
</Import>

```

## Fields XML

**Import element:**

<table data-header-hidden><thead><tr><th width="176">Name</th><th width="186">Description</th><th width="150">Type</th><th>Required/Optional</th></tr></thead><tbody><tr><td>Name</td><td>Description</td><td>Type</td><td>Required/Optional</td></tr><tr><td>ImportSettings</td><td>Container element for importsettings</td><td>Element</td><td>Required</td></tr><tr><td>PriceLists</td><td>Container element for PriceList data</td><td>Element</td><td>Required</td></tr></tbody></table>

**ImportSettings element:**

<table data-header-hidden><thead><tr><th width="186">Name</th><th>Description</th><th width="155">Type</th><th>Required/Optional</th></tr></thead><tbody><tr><td>Name</td><td>Description</td><td>Type</td><td>Required/Optional</td></tr><tr><td>Importer</td><td>Name of the importer.<br>Must be ErpCache_PriceLists.</td><td>Text</td><td>Required</td></tr><tr><td>Version</td><td>Version of the import xml. To be used for backward compatibility issues.</td><td>Text,<br>must be 1.2</td><td>Required</td></tr><tr><td>PartialImport</td><td>Defines if the priceslists in the file contain prices for all the articlenumbers in the pricelist or if the prices represent a partial update of the pricelist.</td><td>Boolean,<br>Default N</td><td>Optional</td></tr></tbody></table>

**PriceList element:**

<table data-header-hidden><thead><tr><th width="196">Name</th><th width="189">Description</th><th width="154">Type</th><th>Required/Optional</th></tr></thead><tbody><tr><td>Name</td><td>Description</td><td>Type</td><td>Required/Optional</td></tr><tr><td>PriceListName</td><td>Name of price list</td><td>Text</td><td>Required</td></tr><tr><td>ProductNumber</td><td>The identifier of a product</td><td>Text</td><td>Required</td></tr><tr><td>VatPercentage</td><td>VAT Percentage<br>(%)</td><td>Decimal</td><td>Required</td></tr><tr><td>MinimumOrderQuantity</td><td>Minimum order quantity for a product</td><td>Decimal</td><td>Optional</td></tr><tr><td>AdditionQuantity</td><td>Addition Quantity for a product</td><td>Decimal</td><td>Optional</td></tr><tr><td>BaseUnit</td><td>The base unit of the product, eg pce or meter.</td><td>Text</td><td>Required</td></tr><tr><td>PriceUnit</td><td>The quantity on which price is based</td><td>Positive integer</td><td>Required</td></tr><tr><td>QuantityDiscountPrices</td><td>Container element for QuantityDiscountPrice data</td><td>Element</td><td>Required</td></tr></tbody></table>

**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.

<table data-header-hidden><thead><tr><th width="201.0185480575293">Name</th><th width="190">Description</th><th width="155">Type</th><th>Required/Optional</th></tr></thead><tbody><tr><td>Name</td><td>Description</td><td>Type</td><td>Required/Optional</td></tr><tr><td>FromQuantity</td><td>The from quantity where the discount price is valid from</td><td>Decimal</td><td>Required</td></tr><tr><td>ToQuantity</td><td>The to quantity where the discount price is valid to</td><td>Decimal</td><td>Optional</td></tr><tr><td>NettoPricePerItemExclVat</td><td>The calculated net price per item.  This is the price including discounts.</td><td>Decimal</td><td>Required</td></tr><tr><td>DiscountAmountPerItemExclVat</td><td>Discount amount on the default net price. 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.</td><td>Decimal</td><td>Optional</td></tr><tr><td>DiscountPercentagePerItem</td><td>A percentage of the give discount on the default net price per item excluding VAT. When this field is set, the field DiscountAmountPerItemExclVat is required.</td><td>Decimal</td><td>Optional</td></tr><tr><td>Currency</td><td>Attribute on NettoPricePerItemExclVat or DiscountAmountPerItemExclVat. Must contain the ISO 4217 3-letter currency code. Default is EUR.</td><td>Char[3]</td><td>Optional</td></tr></tbody></table>

| Type    | Values                                                                                  |
| ------- | --------------------------------------------------------------------------------------- |
| Boolean | Y, N                                                                                    |
| Decimal | Number with point (.) as decimal separator character. Other separators are not allowed. |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://shoxl.gitbook.io/erp-integration-guide/erp-cache-batch/pricelist.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.