> 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/2025.1/batch-interfaces/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 Shoxl CustomerPrices interface. The import file can contain multiple prices for multiple customers.

The import enables the filtering of articles on net prices if the price model of the ERP system can be mapped to PriceLists and Customer-specific prices. We expect the customer-specific prices to be the exceptions on the PriceList prices. If the price calculation in the ERP is so complex that a Customer-specific price would be needed for each product/customer combination, this solution - and net price based filtering - might not be an option.

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]\_Shoxl\_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:** \ShoxlPro\XmlImport\\

## Structure XML

```markup
<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>Shoxl_CustomerPrices</Importer>
        <Version>1.0</Version>
        <PartialImport>Y</PartialImport>
    </ImportSettings>
    <CustomerPrices>
        <CustomerPrice>
            <AccountNumber></AccountNumber>
            <ProductNumber></ProductNumber>
            <VatPercentage></VatPercentage>
            <QuantityDiscountPrices>
                <QuantityDiscountPrice>
                    <FromQuantity></FromQuantity>
                    <ToQuantity></ToQuantity>
                    <NetPricePerItemExclVat Currency=""></NetPricePerItemExclVat>
                </QuantityDiscountPrice>
            </QuantityDiscountPrices>
        </CustomerPrice>
    </CustomerPrices>
</Import>

```

## Fields XML

**Import element:**

<table data-header-hidden><thead><tr><th width="184">Name</th><th>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>CustomerPrices</td><td>Container element for CustomerPrice data</td><td>Element</td><td>Required</td></tr></tbody></table>

**ImportSettings element:**

<table data-header-hidden><thead><tr><th width="178">Name</th><th>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>Importer</td><td>Name of the importer.<br>Must be Shoxl_CustomerPrices.</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.0</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 Y</td><td>Optional</td></tr></tbody></table>

**CustomerPrice element:**

<table data-header-hidden><thead><tr><th>Name</th><th width="187">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>AccountNumber</td><td>Account number (debtor number) of the customer</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>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>Name</th><th width="187">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>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>NetPricePerItemExclVat</td><td>The calculated netto price per item.  This is the price including discounts.</td><td>Decimal</td><td>Required</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                                                                                 |
| ------- | -------------------------------------------------------------------------------------- |
| Decimal | Number with point (.) as decimal separator character. Oher separators are not allowed. |