OrderListForFulfillment
The data format OrderListForFulfillment is used to export order data for fulfillment processes, e.g. for lists of delivery addresses. 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 OrderListForFulfillment 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 |
|---|---|---|
CompanyCEO |
Chief executive officer |
|
CompanyCity |
City in which the company is located |
|
CompanyCountry |
Country in which the company is located |
|
CompanyEmail |
The company’s email address |
|
CompanyFax |
The company’s fax number |
|
CompanyHotline |
The company’s hotline |
|
CompanyName |
Company name |
|
CompanyPhone |
The company’s phone number |
|
CompanyStreet |
Street in which the company is located |
|
CompanyVATNumber |
The company’s VAT number |
|
CompanyZIP |
The company’s postcode |
|
CustomerAccountingID |
Debtor account for accounting |
|
CustomerCity |
City in which the customer lives |
|
CustomerCompany |
The customer’s company |
|
CustomerCountry |
Country in which the customer lives |
|
CustomerEbayName |
The customer’s eBay name |
|
CustomerEmail |
The customer’s email address |
|
CustomerFax |
The customer’s fax number |
|
CustomerFirstname |
The customer’s first name |
|
CustomerGroup |
Customer class |
Activate the filter and select the operator and the class from the drop-down list. |
CustomerHouseNo |
The customer’s house number |
|
CustomerID |
Customer ID |
Activate the filter, select the operator and enter the value. |
CustomerLang |
The customer’s language |
|
CustomerLastName |
The customer’s surname |
|
CustomerPhone |
The customer’s telephone number |
|
CustomerSalutationID |
Form of address |
|
CustomerStreet |
Street in which the customer lives |
|
CustomerZIP |
The customer’s postcode |
|
DeliveryCity |
City in the delivery address |
|
DeliveryCompany |
Company 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 |
|
DeliveryLand |
Country in the delivery address |
|
DeliveryLastName |
Surname in the delivery address |
|
DeliveryPhone |
Telephone number in the delivery address |
|
DeliveryStreet |
Street in the delivery address |
|
DeliveryZIP |
Postcode in the delivery address |
|
OrderComments |
Comments about the order |
|
OrderCurrency |
Order currency |
|
OrderCustomerSign |
Customer identification sign |
|
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. |
OrderExchangeRatio |
Exchange rate in the main currency |
|
OrderExternalInvoiceNo |
The order’s external invoice number |
|
OrderExternalOrderID |
External order ID |
|
OrderID |
Order ID |
Activate the filter, select the operator and enter the value. |
OrderInvoiceDate |
Date when the invoice was created for the order |
|
OrderInvoiceNo |
The order’s invoice number |
|
OrderIsNet |
Net invoice (export delivery or EU with VAT number) |
|
OrderLang |
Order language |
|
OrderLastUpdateTimestamp |
Date and time when changes were last made to the order |
|
OrderMarking |
Order flag |
|
OrderMethodOfPaymentID |
Payment method ID |
Activate the filter and select the payment method from the drop-down list. |
OrderOwnerID |
ID of the order owner |
|
OrderPaidAmount |
Paid order total |
|
OrderPaidTimestamp |
Date and time when payment was received |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderPaymentStatus |
Payment status |
Activate the filter and select the payment status from the drop-down list. |
OrderReferrerID |
The order referrer ID, i.e. the internal ID |
Activate the filter and select the order referrer from the drop-down list. |
OrderRowData1 - 5 |
Data fields that can be individually allocated |
|
OrderSellerAccountID |
The seller’s eBay account |
|
OrderShippingCosts |
The order’s shipping costs |
|
OrderStatus |
Order status |
Activate the filter and select the operator and a status from the drop-down list. |
OrderStoreID |
ID of the online store in which the order was made |
Activate the filter, select the operator and enter the value. |
OrderTimestamp |
Date and time when the order was placed |
Activate the filter and select the operator and date. Use the operator Period to select a range of dates. |
OrderTotalGross |
Gross order total |
|
OrderTotalNet |
Net order total |
|
OrderTotalVAT |
VAT |
|
OrderType |
Order type |
|
OrderWarehouseID |
Warehouse ID |
Activate the filter, select the operator and enter the value. |
OrderWeight |
Order weight |
|
ParcelServiceID |
Shipping service provider ID |
Activate the filter and select the shipping service provider from the drop-down list. |
ParcelServiceName |
Name of the shipping service provider |
|
ParcelServicePresetCategory |
The shipping profile’s category |
|
ParcelServicePresetDispatchIdentifier |
The shipping profile’s shipping identification |
|
ParcelServicePresetID |
Shipping profile ID |
|
ParcelServicePresetMarking |
The shipping profile’s flag |
|
ParcelServicePresetName |
The shipping profile’s name |
|
ParcelServicePresetPriority |
The shipping profile’s priority |
|
ParcelServiceShippingGroup |
The shipping profile’s shipping group |
Table 1: data fields of the data format OrderListForFulfillment
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.