OrderComplete
The data format OrderComplete is used to export orders. This data format can only be used for the export. 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 OrderComplete data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.
Field name | Explanation | Filter |
---|---|---|
CustomerAccountingID |
Debtor account according to your settings in the Accounting menu |
|
CustomerAdditionalName |
Additional address information in the customer data |
|
CustomerCity |
The customer’s town |
|
CustomerCompany |
The customer’s company |
|
CustomerCountry |
The customer’s country. The ID needs to be imported here. |
|
CustomerEbayName |
The customer’s eBay name |
|
CustomerEmail |
The customer’s email address |
|
CustomerFax |
The customer’s fax number |
|
CustomerGroup |
The customer’s group |
|
CustomerHouseNo |
The customer’s house number |
|
CustomerID |
Customer ID |
|
CustomerLang |
The customer’s language |
|
CustomerMobile |
The customer’s mobile phone number |
|
CustomerPhone |
The customer’s telephone number |
|
CustomerSign |
Customer reference in the order data |
|
CustomerState |
State, county or province where the customer lives |
|
CustomerStreet |
The customer’s street |
|
CustomerVATNumber |
The customer’s VAT number |
|
CustomerGender |
The customer’s gender |
|
CustomerZIP |
The customer’s postcode |
|
DeliveryAdditionalName |
Additional address information in the delivery address |
|
DeliveryCity |
Town in the delivery address |
|
DeliveryCompany |
Company in the delivery address |
|
DeliveryCountry |
Country in the delivery address |
|
DeliveryEmail |
Email address in the delivery address |
|
DeliveryFax |
Fax number in the delivery address |
|
DeliveryFirstName |
First name in the delivery address |
|
DeliveryHouseNo |
House number in the delivery address |
|
DeliveryLastName |
Surname in the delivery address |
|
DeliveryPhone |
Telephone number in the delivery address |
|
DeliveryPostident |
PostNumber in the delivery address |
|
DeliveryStreet |
Street in the delivery address |
|
DeliveryState |
State, county or province in the delivery address |
|
DeliveryZIP |
Postcode in the delivery address |
|
FirstName |
The first name of the customer |
|
ItemCustomsTariffNumber |
Customs tariff number of a variation |
|
ItemProducer |
Name of the manufacturer |
|
ItemProducerID |
Manufacturer ID |
|
LastName |
The surname of the customer |
|
OrderComments |
Customer comments about the order |
|
OrderCurrency |
Order currency |
|
OrderDiscountDays |
Time period in days during which the customer receives an early payment discount |
|
OrderDiscountPercent |
The early payment discount as a percentage |
|
OrderDoneTimestamp |
Date and time when outgoing items were booked |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderEbayGetItFast |
eBay express shipping |
|
OrderEstimatedTimeOfShipment |
The estimated shipping date will only be filled if a reorder was placed for the order and if a delivery date is set in the reorder. |
|
OrderExchangeRatio |
Exchange rate in the main currency |
|
OrderExternalOrderID |
External order ID |
|
OrderID |
Order ID |
|
OrderInvoiceNo |
The order’s invoice number |
|
OrderIsNet |
Net invoice (export delivery or EU with VAT number) |
|
OrderLastUpdateTimestamp |
Date and time when changes were last made to the order |
|
OrderMarking |
Order flag |
|
OrderMethodOfPaymentID |
Payment method ID |
|
OrderOwnerID |
ID of the order owner |
|
OrderPackageNo |
Package number |
|
OrderPaidAmount |
Paid order total |
|
OrderPaidTimestamp |
Date and time when the incoming payment was received |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderParcelServiceID |
Shipping service provider ID |
|
OrderParcelServicePresetID |
Shipping profile ID |
|
OrderParentOrderID |
ID of the main order, e.g. the original order ID for credit notes |
|
OrderPaymentStatus |
Payment status |
|
OrderReferrerID |
Order referrer ID (internal ID) |
Activate the filter and select the order referrer from the drop-down list. |
OrderReferrerName |
Name of the order referrer |
|
OrderSalesAgent |
Sales representative ID |
|
OrderSellerAccountID |
The seller’s eBay account |
|
OrderShippingCosts |
The order’s shipping costs |
|
OrderStatus |
Order status |
Activate the filter and select the operator and status. |
OrderStoreID |
ID of the online store in which the order was made |
Activate the filter, select the operator and enter the value. |
OrderTimestamp |
The date and time when the order was received |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderTotalGross |
Gross value of items in the order |
|
OrderTotalInvoice |
Invoice amount. This amount is either gross or net depending on the customer. |
|
OrderTotalNet |
Net value of items in the order |
|
OrderTotalVAT |
VAT amount of the order total |
|
OrderTotalVATShipping |
VAT amount of the shipping costs |
|
OrderType |
Order type |
|
OrderValuta |
Valuta is the time period that starts when the invoice is created but ends before the payment due time period begins. For further information, refer to Managing contacts. |
|
OrderWarehouseID |
Warehouse ID |
Select the operator and enter the warehouse ID. |
VariationNumber |
Variation number |
|
VariationExternalId |
External variation ID |
|
Row = Stock units within an order |
||
RowAttributeSelection |
Attribute selection |
|
RowBarcode |
Barcode of the order item |
|
RowBundleVariationID |
Item bundle ID |
|
RowItemExternalID |
The stock unit’s external item ID, e.g. the eBay ID |
|
RowItemID |
Item ID |
Select the operator and enter the item ID. |
RowItemPrice |
Price per item |
|
RowItemText |
Name of the item |
|
RowLastUpdateTimestamp |
Date when the stock unit was last changed |
Select the operator and the date from the calendar. Use the operator Period to select a range of dates. |
RowOrderID |
The stock unit’s order ID |
Select the operator and enter the order ID. |
RowPositionID |
The stock unit’s consecutive position number |
|
RowPositionReferrerID |
The ID of the stock unit’s referrer |
|
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 |
Item quantity |
|
RowSize |
Unit |
|
RowVAT |
VAT rate |
|
RowVariationID |
ID of a variation |
|
RowWarehouseID |
ID of the stock unit’s warehouse |
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. Do not activate the filter if you want to export data for all customer classes. Go to Setup » CRM » Customer classes to set up customer classes. |
2. Overview of the procedures
In the Procedures tab, select which procedures you want to be carried out during the data export. Activate the OrderStatus procedure and select an order status from the drop-down list. The orders will then be set to this order status during the import.