The following list contains all data transferable via the pixi* Shop interface (Imports 2.0). The data doesn't always have to be exported. Which data is synchronized with your shop system depends on the interface used and on the shop system.
See also: BMEcat Syntax Specifications for Transfer in XML Format, OPENtrans Syntax Specifications for Transfer in XML Format
Item import to pixi*
Item Number Shop (unique identification) can't be amended (or creates a new item in pixi*, if the number changes)
Item Name
Manufacturer
Any number of suppliers with item number, net purchase price and barcode
Minimum order quantity (from pixi* ELI no longer supported)
Minimum Stock
Packaging Unit
-
Price information:
up to pixi* LOU: only the gross selling price of an item can be imported.
from pixi * ELI: The XML file of the item import can contain the net price, gross price or both. If only one of the two prices is transferred to pixi*, the other one will be calculated automatically. If both prices are imported, they are validated to ensure correct values. See net prices in pixi*
VAT Rate (normal / reduced / no tax rate)
Item Weight
Internal Item Number - new from pixi* AVA Milestone 1 for the selection of own number ranges for items.
Hierarchically lowest category in which the item is located.
DATEV Account Numbers
Flag to activate the serial number check
Customs tariff number, country of origin of the item and product group
References to additional multimedia documents (item images, MIME information)
Definition of an item as a bundle as well as transfer of the items contained in the bundle
Item export to the shop
1 Item Number Shop (unique identifier)
1 Barcode (EAN) (from the item overview)
1 stock (if reservations are active: available stock = [physical stock - reservations], if reservations are not active: available stock = [physical stock - orders that are temporarily "reserved" by the prepayment method)], always >= 0
Number of Open Supplier Orders for the item
Delivery date (if specified in a supplier order)
Article Status (possibly connection adaptation required)
Order import to pixi*
1 Billing Address: company name, name of the customer, street and house number, zip code, city, country, telephone, email, fax, VAT ID.
1 Delivery Address consisting of: company name, name of customer, street and house number, zip code, city, country, telephone, email, fax, VAT ID.
Calculate VAT yes / no
Order Number
Client (3-digit character combination)
Order Date
Customer Lock
Order/Ship Lock
Currency
-
Payment Type:
Credit Card Authorization
Credit Card Merchant
Account Holder
Account No.
Bank Branch Sort Code
Bank Name
IBAN
BIC
Shipping Service Provider
Additional features of the particular shipping service provider (DHL specific)
Delivery Date
Gift Note
Voucher Code (must be unique for any of the orders)
Voucher Sum
Shipping Costs (incl. payment type fee)
Location of the order
Type of partial delivery
Subshopname
Sub shop logo
Referrer
-
Item positions:
a maximum of 250 item positions can be imported
Item ID (see Item Number Shop)
Order Line ID
Differing Item Name (e.g. in case of orders in a foreign language)
Personalisation
Direct Fulfillment Type
-
Price Information:
Item Gross Price, No Discount
Discount %
Discount Absolute Gross
Item Gross Price, ncl. Discount
from pixi* ELI: The base price of the respective order type is imported - this is net for B2B orders, gross for B2C orders. See net prices in pixi*
Order export to the shop
ID for the external order line (N for manually created order lines)
Number of ordered items
Normal price (gross)
Discount in %
Discount total (gross)
Price (gross)
Status of the order line (pixi* status)
Tracking ID of the complete order