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

  • Gross price excl.

  • Net price including VAT

  • Suggested Retail price including VAT

  • Minimum order quantity

  • Discount price excl.

  • Number per package

  • Packaging unit

  • Minimum quantity discount price

Aanleverwijze

Update Frequency: Batch 1x per day

Incremental or complete set: complete set

Filetype: Zipped XML

Bestandsbenaming: [SHOPNAME]_brutoprices_[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

<?xml version="1.0" encoding="utf-8"?>
<brutoPrices>
    <brutoPrice>
        <productNumber></productNumber>
        <priceListNumber></priceListNumber>
        <brutoPriceExclVat Currency=""></brutoPriceExclVat>
        <vatCode></vatCode>
        <VatPercentage></VatPercentage>
        <EqualizationTaxPercentage></EqualizationTaxPercentage>
        <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.

The EqualizationTaxPercentage element was introduced in the 2024.3.1 release in order to support customers who are subject to different tax regimes in different countries.

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.

Name

Description

Type

Required / Optional

productNumber

The identifier of a product

Text

Required

priceListNumber

The identifier of a pricelist. This legacy field is no longer in use.

Text

Optional

brutoPriceExclVat

Manufacturer's suggested retail price

Decimal

Required

vatCode

Legacy field still available for backwards compatibilty reasons.

HIGH = 21 % LOW = 6%

ZERO = 0%

Text

Required when the shop is using multiple price regions with different VAT percentages.

VatPercentage

VAT Percentage (%)

Decimal

Required

EqualizationTaxPercentage

Equalization tax percentage (%)

Decimal

Optional

PriceInclVat

Retail price including vat (for future use)

Decimal

Optional

SuggestedRetailPriceInclVat

Suggested retail price including VAT

Decimal

Optional

DiscountPriceExclVat

Discount price excluding vat

Decimal

Optional

MinimumOrderQuantity

Minimum order quantity

Decimal

Required

AdditionQuantity

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.

Decimal

Optional

BaseUnit

The base unit of the product, eg. ST, stuk, meter, etc.

Text

Required

PriceUnit

The quantity on which price is based

Decimal

Required

DiscountMinimumQuantity

The minimum quantity for which the discount will apply

Decimal

Optional

Currency

Attribute on brutoPriceExclVat, PriceInclVat or DiscountPriceExclVat. Must contain the ISO 4217 3-letter currency code. Default is EUR.

Char[3]

Optional

TypeValues

Decimal

Number with point (.) as decimal separator character. Other separators are not allowed.