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.