Skip to main content

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.

Table 1. Data fields of the data format OrderComplete
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.
You can find the country IDs by going to System » Orders » Shipping » Settings » Tab: Countries of delivery.

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
male = 1
female = 2

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
If multiple packages were sent, then multiple package numbers can be in this field. The package numbers are separated by comma. + Multiple package numbers can only be entered in the order if the service provider is DHL.

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
0 = unpaid
1 = paid
2 = partial payment
3 = overpaid
4 = payment in foreign currency

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
order = order
delivery = delivery order
credit note = credit note
returns = return
warranty = warranty

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
You can choose a barcode after you have saved the data format. You need to select a barcode before every export.

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

To top