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

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