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 R

• ecommended 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 Currrency=""></brutoPriceExclVat>
        <vatCode></vatCode>
        <PriceInclVat Currrency=""></PriceInclVat>
        <SuggestedRetailPriceInclVat Currrency=""></SuggestedRetailPriceInclVat>
        <MinimumOrderQuantity></MinimumOrderQuantity>
        <DiscountPriceExclVat Currrency=""></DiscountPriceExclVat>
        <BaseUnit></BaseUnit>
        <PriceUnit></PriceUnit>
        <AccumulativeDiscounts>
            <AccumulativeDiscount>
                <DiscountMinimumQuantity></DiscountMinimumQuantity>
                <brutoPriceExclVat Currrency=""></brutoPriceExclVat>
                <PriceInclVat Currrency=""></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.

Name	Description	Type	Required / Optional
productNumber	The identifier of a product	Text	Required
priceListNumber	The identifier of a pricelist.	Text	Required
brutoPriceExclVat	Manufacturer's suggested retail price	Decimal	Required
vatCode	HIGH = 21 % LOW = 6% ZERO = 0%	Text	Required
PriceInclVat	Retail price including vat	Decimal	Required
SuggestedRetailPriceInclVat	Suggested retail price including VAT	Decimal	Optional
DiscountPriceExclVat	Discount price excluding vat	Decimal	Optional
MinimumOrderQuantity	Minimum order quantity	Positive Integer	Required
BaseUnit	The base unit of the product, eg. ST, stuk, meter, etc.	Text	Optional
PriceUnit	The quantity on which price is based	Decimal	Optional
DiscountMinimumQuantity	The minimum quantity for which the discount will apply	Positive Integer	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.