pixi
Ask AI
What's an 'Ideas Portal'?
DE

Order Export

This documentation describes the structure of the XML file for exporting customer orders from pixi* to your shop or other sales channels.

See also: Orders - Data Communication


Structure of the XML

An order export XML always contains one orderline in an <ORDER_ITEM> element, which contains the orderline attributes.

<ORDER_ITEM>
    <LINE_ITEM_ID>12871287329_2</LINE_ITEM_ID>
    <QUANTITY>1</QUANTITY>
    <FULL_PRICE>121.6800</FULL_PRICE>
    <DISCOUNT_PERC>5.00</DISCOUNT_PERC>
    <DISCOUNT_VALUE>6.0800</DISCOUNT_VALUE>
    <PRICE_AMOUNT>115.6000</PRICE_AMOUNT>
    <ITEM_NOTE>Item note</ITEM_NOTE>
    <STATUS>AUS</STATUS>
    <TRACKINGID>41201245456478</TRACKINGID>
    <ORDER_NR_EXT>238474842</ORDER_NR_EXT>
    <INVOICE_NR>DEM0000021</INVOICE_NR>
    <SHIPPING_VENDOR>DHL</SHIPPING_VENDOR>
    <ORDER_STATUS>CLOSED</ORDER_STATUS>
    <RET_TRACKINGID>50312154274560;32112163274651</RET_TRACKINGID>
</ORDER_ITEM>

Name of the XML Tag

Description

 
LINE_ITEM_ID

Every order line needs to be imported to pixi* with a unique identifier within this tag. This value is used as internal reference for the shop orderline in pixi* database, not visible in GUI and is also used for the export.

 
QUANTITY

contains the orderline quantity

 
FULL_PRICE

contains the orderlines selling price without discount

 
DISCOUNT_PERC

contains the orderlines discount in percent (e.g. 5.00)

 
DISCOUNT_VALUE

contains the orderlines discount amount (e.g. 6.0800)

 
PRICE_AMOUNT

contains the orderlines selling price incl. discount

PRICE_AMOUNT = FULL_PRICE - DISCOUNT_VALUE

 
ITEM_NOTE

contains the orderlines item note

The XML only contains this tag, if an item note exists for the orderline.

 
STATUS

contains the orderlines status (ANG, HAL, EIN, AUS, STO, NLB, RET, MIN)

 
TRACKINGID

contains the tracking ID of the related invoice

The XML only contains this tag, if a tracking ID is set for an invoice.

 
ORDER_NR_EXT

contains the shop order number

 
INVOICE_NR

contains the invoice number of the related orderline

The XML only contains this tag, if an invoice or a credit was already created for the orderline.

 
SHIPPING_VENDOR

contains the shipping vendor of the related orderline

The XML only contains this tag, if an invoice was already created for the orderline. In case of a credit, this tag is empty. 

ORDER_STATUS

contains the status of the customer order (OPEN/HOLD/CLOSED)

 
RET_TRACKINGID

contains the tracking ID of the related invoice (max. 512 characters)


Back to top