This documentation describes important information to consider when connecting a shop or PIM system to pixi.

See also: BMEcat syntax specifications for transfer in XML format, OPENtrans syntax specifications for transfer in XML format

Primary key

Each item requires a unique primary key, which under no circumstances may change during the "lifetime" of the item. Under no circumstances may the primary key be used again after deleting the item in the shop system. The primary key has the following syntax in the XML structure for the so-called BMECat export:

 <SUPPLIER_AID> 

An ambiguous primary key causes serious errors when assigning items to a purchase order and when exporting inventory. Items are imported twice, etc.

Basically, the item management is still done in the shop system (maintenance of item description, prices, etc.). Only the stock of each item is managed by pixi and exported back to the shop system accordingly. This means, all items must be available in the shop system and provided accordingly for export.

Item variants

Each variant of an item (color, size, etc.) is to be transferred to pixi in the shop system as an independent item with independent primary key ("SUPPLIER_AID").

Example with two-dimensional variants:

An item with the name "Mattress Comfort Plus" is available in different colors and sizes (variants), the main item in the shop system has the following product names: "Mattress Comfort Plus"

The item is available in the following sizes: 120 x 180 cm, 180 x 160 cm, 180 x 180 cm

The item is also available in three different colors: white, blue, red

This results in the following variant items, which as such must be transferred individually to pixi:

The item with the two different attributes with 3 variants each has to be handed over to pixi as 9 different items:

• Mattress Comfort Plus, size: 120 x 180 cm, color: white

• Mattress Comfort Plus, size: 120 x 180 cm, color: blue

• Mattress Comfort Plus, size: 120 x 180 cm, color: red

• Mattress Comfort Plus, size: 180 x 160 cm, color: white

• Mattress Comfort Plus, size: 180 x 160 cm, color: blue

• Mattress Comfort Plus, size: 180 x 160 cm, color: red

• Mattress Comfort Plus, size: 180 x 180 cm, color: white

• Mattress Comfort Plus, size: 180 x 180 cm, color: blue

• Mattress Comfort Plus, size: 180 x 180 cm, color: red

With which item name, or in which order the individual variant in the item name is called, is freely selectable.

Tip: Please also think of the individual variant items to the unique primary key!

The procedure for items with one-dimensional variants is congruent to the above example.

Back to top

Product prices

Prices are to pixi LOU basically gross and in the currency Euro (€) to pixi to pass, exception is only the purchase price in the article export (BMEcat). From pixi ELI the import of net prices is possible, please note the net prices in pixi.

Prices and / or value specifications are always to be specified in the XML files with a dot instead of a comma and, depending on the order type, with 2 or 4 decimal places. If the corresponding value is equal to zero, the field value is 0.00.

Example: 0.01 € -> 0.01 or 12.34 € -> 12.34

Pixi /pixi only supports one price per item in the item master. No scale prices or different price lists are supported. However, with each order an individual price can be given for the customer, which does not change the price in the item master.

Multilingualism

If a multi-lingual shop system is used, in the item import to pixi (BMEcat) all item names are always to be handed over in German, the language of the item name in the order import to pixi (OPENtrans) is freely selectable.

Settlement with payment method "credit card"

The shop system already takes over the authorization of the order amount and transfers to pixi only the required so-called transaction ID. This type of transfer is only possible if the technical processing takes place via the service provider "iPayment" or "Computop".

Cash discounts and discounts

• Option 1: You hand over all discounts, cash discount totaled in a value in the order.

• Option 2 (recommended): You transfer cash discount and discount per order line either in absolute terms or as a percentage of the value of the respective order line. Additional value and promotional vouchers to be deducted are handed over per order.

Connection of so-called multi & sub shop systems

pixi is able to manage several clients per customer (per database). For each client, the unique one is to be transferred in the order export (OPENtrans), the item master is kept independent of the client and exists globally for all clients. For each client, a separate URL can be called up with the respective functions (e.g. if it is the same shop system with several databases and different URLs) or the function calls are made for all clients via the same URL (mainly for subnetworks). Shop systems used).

XML coding

Please use for the XML an ISO coding for umlauts etc. A coding according to UTF / Unicode is not supported at the moment.

Back to top