Skip to main content

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
0 = Mr
1 = Ms
2 = Company

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
The following template variables can be used for these fields:
[OrderRowQuantity]
[OrderRowItemID]
[OrderRowItemExternalID]
[OrderRowItemTitle]
[OrderRowVariation]
[OrderRowItemEAN1]
[OrderRowItemNumber]
[OrderRowItemFreeTextField1], [OrderRowItemFreeTextField2], …​ 20
[OrderRowVariationEAN1]
[OrderRowVariationCustomNumber]
[OrderRowStorageLocationsWithQuantity]

Multiple template variables can be used in an OrderRowData data field.

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.

To top