Skip to main content

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. Import the data format in the Data » Dynamic import menu. The Exporting data and Importing data pages of the manual describe how you export and import 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 plentymarkets version.

  1. 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 System » 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

To top