OrderItems
The data format OrderItems allows you to export and to edit existing order item positions as well as to add new positions to an order. Create and export the data format in the Data » Dynamic export menu. The Exporting data page of the manual describes how you export the data format.
Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.
1. Overview of the data fields
Table 1 explains the data fields for the OrderItems data format in alphabetical order as well as filter options that you set in the Filter tab of the data format. The data format may vary depending on your PlentyONE version.
-
data fields of the data format OrderItems
| Field name | Explanation | Filter |
|---|---|---|
ItemProducer |
Item manufacturer |
|
ItemProducerID |
Manufacturer ID |
Activate the filter, select the operator and enter the value. |
ItemVariationNo |
Variation number |
|
OrderDoneTimestamp |
Date when outgoing items were booked |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderExternalID |
External order number, e.g. the external market’s item ID |
|
OrderInsertTimestamp |
Date when the order was created |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderPaidTimestamp |
Date of payment |
|
OrderReferrerID |
Order referrer ID |
Activate the filter and select the order referrer from the drop-down list. |
OrderReferrerName |
Name of the order referrer |
|
OrderStatus |
Order status |
Activate the filter and select the order status from the drop-down list. |
OrderUpdateTimestamp |
Order timestamp; the date of the last change |
|
OrderUser |
Owner |
|
VariationNumber |
Item number |
|
Row = Stock units within an order |
||
RowAttributeSelection |
Attribute selection |
|
RowItemExternalID |
The stock unit’s external order number, e.g. the eBay ID |
|
RowItemID |
Item ID |
Activate the filter, select the operator and enter the value. |
RowItemPrice |
Price per item The price will be taken from the variation data if the price column is not included in the import format. The price will be saved as 0 if either the price in the price column is 0 or no price is given in the price column. The price will also be saved as 0 if no quantity is imported. |
|
RowItemText |
Name of the item |
|
RowLastUpdateTimestamp |
Date when the stock unit was last changed |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
RowOrderID |
Order ID of the order that the item belongs to, that you wish to edit the item in or that you want to add the item to. Required when importing. |
Activate the filter, select the operator and enter the value. |
RowPositionID |
The stock unit’s position number; consecutive. An ID will be assigned automatically if the position ID is not imported. |
|
RowPositionReferrerID |
The stock unit’s referrer ID |
Activate the filter and select the order referrer from the drop-down list. |
RowPositionReferrerName |
The name of the stock unit’s referrer |
|
RowPurchasePrice |
Net purchase price. Average net purchase price at the time of order generation. If no average purchase price could be calculated at this point, then the net purchase price which was saved in the item data at the time of the order generation will be displayed. |
|
RowQuantity |
Quantity purchased. Without quantity information the price that will be saved is 0. |
|
RowSize |
Unit |
|
RowVariationID |
Variation ID |
|
RowVAT |
VAT rate |
|
RowWarehouseID |
The stock unit’s warehouse ID |
Activate the filter, select the operator and enter the value. |
RowWeight |
Weight |
|
Export for customer class |
Note: filter setting only |
Activate the filter and select the customer class. In order to export data for all customer classes, do not activate the filter. Go to Setup » CRM » Classes to set up customer classes. |
2. Overview of the synchronisation fields
The following data field is available for data synchronisation and is a mandatory if you carry out a data synchronization. For mandatory synchronisation fields, select the option Synchronisation as Import procedure.
-
RowPositionID = The order item’s position number; consecutive