Order history

Short description

The ERP Cache Order interface is used to keep a record of the orders in the ERP system. The Orders in the ERP Cache are used to show order history to the user.

Delivery method

Update Frequency: Batch at least once a day Incremental or complete set: Incremental

Filetype: Zipped XML

Filename: [SHOPNAME]_ErpCache_Order_[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: \ErpCache\

Structure XML

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>ErpCache_Orders</Importer>
        <Version>1.0</Version>
    </ImportSettings>
    <Orders>
        <Order>
            <OrderNumber></OrderNumber>
            <JobNumber></JobNumber>
            <BillingAddress1></BillingAddress1>
            <BillingCity></BillingCity>
            <BillingCountry></BillingCountry>
            <BillingName1></BillingName1>
            <BillingName2></BillingName2>
            <BillingPostalCode></BillingPostalCode>
            <ExternalOrderNumber></ExternalOrderNumber>
            <OrderedBy></OrderedBy>
            <OrderDate></OrderDate>
            <OrderState></OrderState>
            <PaymentMethodCode></PaymentMethodCode>
            <Reference></Reference>
            <ShipmentMethodCode></ShipmentMethodCode>
            <ShippingAddress1></ShippingAddress1>
            <ShippingCity></ShippingCity>
            <ShippingCountry></ShippingCountry>
            <ShippingName1></ShippingName1>
            <ShippingName2></ShippingName2>
            <ShippingPostalCode></ShippingPostalCode>
            <ShippingTransportInstruction></ShippingTransportInstruction>
            <TotalPriceExclVat></TotalPriceExclVat>
            <TotalPriceInclVat></TotalPriceInclVat>
            <TotalVat></TotalVat>
            <OrderLines>
                <OrderLine>
                    <LineNumber></LineNumber>
                    <Carrier></Carrier>
                    <DiscountAmountExclVat></DiscountAmountExclVat>
                    <DiscountDescription></DiscountDescription>
                    <DiscountPercentage></DiscountPercentage>
                    <IsExternal></IsExternal>
                    <GrossPriceExclVat></GrossPriceExclVat>
                    <NettoPriceExclVat></NettoPriceExclVat>
                    <OrderLineStatus></OrderLineStatus>
                    <ProductDescription></ProductDescription>
                    <ProductNumber></ProductNumber>
                    <Quantity></Quantity>
                    <RemainingQuantity></RemainingQuantity>
                    <SubTotalPriceExclVat></SubTotalPriceExclVat>
                    <TrackAndTraceReference></TrackAndTraceReference>
                    <VatCode></VatCode>
                    <NettoPriceInclVat></NettoPriceInclVat>
                    <SubTotalPriceInclVat></SubTotalPriceInclVat>
                    <BaseUnit></BaseUnit>
                    <PriceUnit></PriceUnit>
                </OrderLine>
            </OrderLines>
        </Order>
    </Orders>
</Import>

Fields XML

Import element:

Name	Description	Type	Required/Optional
ImportSettings	Container element for importsettings	Element	Optional
Orders	Container element for Order data	Element	Required

ImportSettings element:

Order element:

OrderLine element:

Types: