# Gross Prices Import

## Short description

This interface describes which gross price information is transported from the ERP system to Shoxl Shop. Gross prices are shown at product level and come from Shoxl Shop, at article level the prices are retrieved realtime from the ERP system. The gross price information can be extended with tiered prices, in which case the price is shown as of the number of articles to which the tiered price applies.

Prices can be defined in several currencies. If no currency is specified for a price, the prices are imported in Euros.

## Gross price information includes:

* Article number&#x20;
* Gross price excl.&#x20;
* Net price including VAT
* Suggested Retail price including VAT&#x20;
* Minimum order quantity&#x20;
* Discount price excluding VAT
* Number per package&#x20;
* Packaging unit&#x20;
* Minimum quantity discount price

## Aanleverwijze

**Update Frequency**: Batch 1x per day&#x20;

**Incremental or complete set:** complete set&#x20;

**Filetype:** Zipped XML

**Bestandsbenaming: \[SHOPNAME]\_**&#x62;rutoprices\_**\[INDEXNUMBER]**.xml\
**Transport:** over FTPS, FTPS Vendisto server is hosted by INTEGRACE, file is put on FTPS server by ERP party

**Location within FTP root:** \Vendisto\Production\\

## Structure Gross prices XML

```markup
<?xml version="1.0" encoding="utf-8"?>
<brutoPrices>
    <brutoPrice>
        <productNumber></productNumber>
        <priceListNumber></priceListNumber>
        <brutoPriceExclVat Currency=""></brutoPriceExclVat>
        <vatCode></vatCode>
        <VatPercentage></VatPercentage>
        <PriceInclVat Currency=""></PriceInclVat>
        <SuggestedRetailPriceInclVat Currency=""></SuggestedRetailPriceInclVat>
        <MinimumOrderQuantity></MinimumOrderQuantity>
        <AdditionQuantity></AdditionQuantity>
        <DiscountPriceExclVat Currency=""></DiscountPriceExclVat>
        <BaseUnit></BaseUnit>
        <PriceUnit></PriceUnit>
        <AccumulativeDiscounts>
            <AccumulativeDiscount>
                <DiscountMinimumQuantity></DiscountMinimumQuantity>
                <brutoPriceExclVat Currency=""></brutoPriceExclVat>
                <PriceInclVat Currency=""></PriceInclVat>
            </AccumulativeDiscount>
        </AccumulativeDiscounts>
    </brutoPrice>
</brutoPrices>

```

## Fields Gross Prices XML

Prices can optionally be defined in several currencies. The grossPriceExclVat and PriceInclVat may therefore occur more than once within a grossPrice or AccumulativeDiscount element.

The AdditionQuantity element was introduced in the 2022.3 release and defines the steps of quantities (in base units) in which the product can be ordered. The ordered quantity must be a multitude of the AdditionQuanity and be equal or above the MinimumOrderQuantity.

For legacy purposes the shop can be defined to use the MinimumOrderQuantity as AdditionQuantity. In these cases AdditionQuantity will default to MinimumOrderQuantity if the element is not present. For new shop implementations the AdditionQuantity will default to 1.



<table data-header-hidden><thead><tr><th width="218.3739959317605">Name</th><th width="175.87731144793972">Description</th><th width="155">Type</th><th>Required / Optional</th></tr></thead><tbody><tr><td><strong>Name</strong></td><td><strong>Description</strong></td><td><strong>Type</strong></td><td><strong>Required / Optional</strong></td></tr><tr><td>productNumber</td><td>The identifier of a product</td><td>Text</td><td>Required</td></tr><tr><td>priceListNumber</td><td>The identifier of a pricelist.<br>This legacy field is no longer in use.</td><td>Text</td><td>Optional<br><br></td></tr><tr><td>brutoPriceExclVat</td><td>Manufacturer's suggested retail price</td><td>Decimal</td><td>Required</td></tr><tr><td>vatCode</td><td><p>Legacy field still available for backwards compatibilty reasons.</p><p></p><p>HIGH = 21 % LOW = 6%</p><p>ZERO = 0%</p></td><td>Text</td><td>Required when the shop is using multiple price regions with different VAT percentages.</td></tr><tr><td>VatPercentage</td><td>VAT Percentage<br>(%)</td><td>Decimal</td><td>Required</td></tr><tr><td>PriceInclVat</td><td>Retail price including vat<br>(for future use)</td><td>Decimal</td><td>Optional</td></tr><tr><td>SuggestedRetailPriceInclVat</td><td>Suggested retail price including VAT</td><td>Decimal</td><td>Optional</td></tr><tr><td>DiscountPriceExclVat</td><td>Discount price excluding vat</td><td>Decimal</td><td>Optional</td></tr><tr><td>MinimumOrderQuantity</td><td>Minimum order quantity</td><td>Positive Integer</td><td>Required</td></tr><tr><td>AdditionQuantity</td><td>The ordered quantity has to be a multitude of the AdditionQuantitty. Default value: 1. For legacy purposes the shop can also be defined to default to MinimumOrderQuantity.</td><td>Positive Integer</td><td>Optional</td></tr><tr><td>BaseUnit</td><td>The base unit of the product, eg. ST, stuk, meter, etc.</td><td>Text</td><td>Required</td></tr><tr><td>PriceUnit</td><td>The quantity on which price is based</td><td>Decimal</td><td>Required</td></tr><tr><td>DiscountMinimumQuantity</td><td>The minimum quantity for which the discount will apply</td><td>Positive Integer</td><td>Optional</td></tr><tr><td>Currency</td><td>Attribute on brutoPriceExclVat, PriceInclVat or DiscountPriceExclVat. 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. Other separators are not allowed. |
