For this data format, you have to select one of the mandatory fields in the table for the synchronization. However, you can select both fields if desired.
Order
Data » Dynamic export
1. General information about the data format Order
Use the data format Order to export or edit orders.
2. Important notes
Spell the field names correctly!
Pay close attention to the exact spelling of the data fields (upper/lower case letters). The data can not be processed if the data field is spelled incorrectly. |
3. Overview of the data fields
The following table explains the data fields for the data format Order. The data fields are listed in alphabetical order:
Field | Description | Filter options (tab: Filter)* |
---|---|---|
AccountingID |
Debtor account (field of accounting) |
|
AdditionalName |
Additional address information |
|
City |
The customer’s city |
|
Company |
The customer’s company |
|
Country |
The customer’s country. The ID needs to be imported here. |
|
Currency |
Order currency |
|
CustomerGroup |
Customer class |
Select the operator and the customer class. |
CustomerID |
Customer ID |
Select the operator and enter the value for the customer ID. |
CustomerInfo |
Customer information |
|
CustomerLang |
The customer’s language |
|
CustomerSign |
Customer identification sign |
|
DeliveryAdditionalName |
Delivery address: Additional address information |
|
DeliveryAddressID |
Delivery address ID |
|
DeliveryCity |
Delivery address: City |
|
DeliveryCompany |
Delivery address: Company |
|
DeliveryEmail |
Delivery address: email address |
|
DeliveryFax |
Delivery address: Fax number |
|
DeliveryFirstName |
Delivery address: First name |
|
DeliveryHouseNo |
Delivery address: House number |
|
DeliveryLand |
Delivery address: Country. The ID needs to be imported here. |
|
DeliveryLastName |
Delivery address: Last name |
|
DeliveryPhone |
Delivery address: Phone number |
|
DeliveryStreet |
Delivery address: Street |
|
DeliveryVATNumber |
The VAT number listed in the delivery address |
|
DeliveryZIP |
Delivery address: ZIP code |
|
DiscountDays |
Early payment discount (days), i.e. a number of days starting when the invoice is created. The customer can pay the pending amount at a discounted price during this time period. |
|
DiscountPercent |
Early payment discount (%), i.e. the value in percent that the customer may subtract if they make the payment within the time period Early payment discount (days). |
|
DoneTimestamp |
Items shipped on |
Select the operator and enter the value. Use the operator Period to select a range of dates. |
EbayGetItFast |
eBay express shipping |
|
EbayName |
eBay name |
|
Email address |
||
ExchangeRatio |
Exchange rate in the main currency |
|
ExternalOrderID |
External order ID, e.g. from an external market |
|
Fax |
The customer’s fax number |
|
FirstName |
The customer’s first name |
|
HouseNo |
The customer’s house number |
|
InvoiceNo |
Invoice number |
|
IsNet |
Net invoice (export delivery or EU with VAT number) |
|
LastName |
The customer’s surname |
|
LastUpdateTimestamp |
Date of the last change |
|
Marking |
Order flag (0-6) |
|
MethodOfPaymentID |
Payment method (internal ID) |
Select the payment method from the drop-down list. |
Mobile |
The customer’s cell phone number |
|
OrderID |
Order ID |
Select the operator and enter the order ID. |
OrderStatus |
Order status |
Select the status from the drop-down list. |
OrderTimestamp |
Ordered on |
Select the operator and enter the value. Use the operator Period to select a range of dates. |
OrderType |
Order type |
|
OwnerID |
ID of order owner |
|
PackageNo |
Package number |
|
PaidAmount |
Amount paid |
|
PaidTimestamp |
Date of payment |
Select the operator and enter the value. Use the operator Period to select a range of dates. |
ParcelServiceID |
Shipping service provider ID |
Select the shipping service provider from the drop-down list. |
ParcelServicePresetID |
Shipping configuration ID |
|
ParentOrderID |
ID of the higher-ranking order, e.g. the original order ID for credit notes |
|
PaymentStatus |
Payment status |
Select the payment status from the drop-down list. |
Phone |
The customer’s telephone number |
|
ReferrerID |
Order referrer ID (internal ID) |
Select the order referrer from the drop-down list. |
ReferrerName |
Name of the order referrer |
|
SalesAgent |
Trade representative |
|
SalutationID |
Form of address |
|
SellerAccountID |
The seller’s market account |
|
ShippingCosts |
Shipping costs |
|
StoreID |
Online store ID |
|
Street |
The customer’s street |
|
TotalGross |
Gross order total |
|
TotalInvoice |
Invoice total |
|
TotalNet |
Net order total |
|
TotalVAT |
VAT |
|
TotalVATShipping |
VAT for the shipping costs |
|
Valuta |
Time period that starts when the invoice is created and is before the payment due time period begins. |
|
VATNumber |
VAT number |
|
WarehouseID |
Warehouse ID |
Select the operator and enter the warehouse ID. |
ZIP |
The customer’s ZIP code |
Table 1: data fields of the data format Order
4. Synchronization fields
The data fields that are listed in the following table are available for data synchronization:
Field | Description | Mandatory synchronization fields (M*) |
---|---|---|
ExternalOrderID |
External order ID, e.g. from an external market |
M* |
OrderID |
Order ID |
M* |
* = One data field is sufficient for the synchronization |
Table 2: data fields that can be used for the synchronization
. |