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

Item Export


This documentation describes the structure of the XML file for exporting items from pixi* to your shop or PIM system.

See also: Items - Data Communication


Structure of the XML

Every item export XML starts with an <ARTICLES> element and consists of at least one <ARTICLE_ITEM> element, which contains item properties.


<ARTICLES>
    <ARTICLE_ITEM>
        <ARTICLE_ITEM_ID>18201-180160-bl</ARTICLE_ITEM_ID>
        <QUANTITY>12</QUANTITY>
        <DELIVERY_DATE>2016-01-01T00:00:00</DELIVERY_DATE>
        <MIN_STOCK_QTY>25</MIN_STOCK_QTY>
        <ACTIVE>True</ACTIVE>
        <EAN>2500000000097</EAN>
        <OPENSUPPLORDERS>12</OPENSUPPLORDERS>
        <TARGET_STOCK>50</TARGET_STOCK>
    </ARTICLE_ITEM>
    <ARTICLE_ITEM>
        ...
    </ARTICLE_ITEM>
</ARTICLES>


Name of the XML Tag

Description

ARTICLE_ITEM_ID

contains the items shop item number

QUANTITY

contains the items stock quantity

If the database setting Export available stock - reservations are enabled (pixi* Control Center > Database Settings > Imports 2.0 > Export) is activated, the available stock will be exported instead of the available stock (Res.) if reservations are enabled.

If the database setting Export Physical Stock for items (pixi* Control Center > Database Settings > Import / Export > Item Import) is activated, the physical stock will be exported instead of the available stock.

See also: Stock Export

DELIVERY_DATE

contains the items delivery date, which is calculated due to the database setting Method for delivery date calculation (pixi* Control Center > Database Settings > Customer Service)

Format: YYYY-MM-DD"T"hh:mm:ss
Example: 2016-01-01T00:00:00 (January 1st 2016, 00:00 a.m.)

Caution: If Method for delivery date calculation is set to "FIFO", the delivery date is calculated every night and a full item export is performed.

MIN_STOCK_QTY

contains the items reorder level

If the database setting Item Export - Status or Reorder Level on Location (pixi* Control Center > Database Settings > Imports 2.0 > Export) is empty, the reorder level should only be used to transfer the status of an item (available / unavailable).
In case it contains a value (e.g. "001"), the reorder level of the entered location is exported.

ACTIVE

contains the items status - active ("True") or inactive ("False")

EAN

contains the items barcode

If the database setting Show Item Nr. Suppl. from MGS supplier (pixi* Control Center > Database Settings > General) is activated, the default suppliers barcode will be exported.
If the setting is deactivated, the barcode of the last updated supplier is exported.

OPENSUPPLORDERS

contains the ordered quantity of items in open supplier orders (status NEW, ORD and CON) in all locations

TARGET_STOCK

Item's target stock, only integer or empty if no value available.

To export the target stock of a specific location, enter a Location ID value (e.g. 001) in the Item Export - Target Stock on Location setting (pixi Control Center > Database Settings > Imports 2.0 > Export). Not exported when location is undefined or invalid.


Back to top

Batchexport - Export several Items in one XML

An item export XML only then contains several <ARTICLE_ITEM> elements, if Batch item export enabled is enabled (=1) for the related channel.



See also: Description of the Channel Settings


Back to top