Orders

This page describes the data fields and filters that are available when exporting order and order item data with the catalogue tool. This page serves purely as a reference and it assumes that you already have a basic understanding of the catalogue tool.

You can find a practical example how to export orders and order items on the manual page Practical example: orders and order items.

Limit for order export

The order export via the catalogue is limited to 60,000 lines.

Format type: Order

The format type described on this page is found in the menu Data » Catalogues. When creating a new catalogue, you’ll select the standard format from the upper drop-down list. Then you can select the format type Order from the middle drop-down list.

catalogue order

1. Available actions for the format type Order

In the Actions section of the basic settings, you can select actions that should be carried out after the export. The following table lists the available actions.

Table 1. Actions after the export
Action Explanation

Change order status

Select whether a status change should be carried out after the export. If so, select the status to which the order should be changed.

Add order tag

Select whether a tag should be added to the order after the export. If so, select the tag from the drop-down list.
*What’s a standard format?

  • Definition: A standard format is used to export specific data from your PlentyONE system. Afterwards, you can revise the data and import it again.

  • Example: Imagine you want to get an overview of orders with a specific referrer and for a certain period of time. Then you can export the information you need and add them to your records.

  • Differentiation: Note that standard formats only export data from your system. They do not transmit this data to marketplaces.

Adapting export keys

To the left of newly added data fields, you can enter an Export key. The export key is the name under which the values of a data field are grouped in your export file. The export keys can be adapted.
Always make sure that the export key is unique especially when you add the same data field several times and select different options. If the same export key is used more than once only the data field which was added last with this export key is exported.
Find more information on data fields in general in the manual chapter Adding data fields to export.

2. Data fields

This chapter lists all of the order data fields that can be exported with the catalogue tool.

Data fields are grouped by topic in folders and subfolders. All data fields of one folder are shown in one table. Thus, the structure of the chapters mirrors the folder structure.

2.1. Order

The data field folder Order contains all data fields with basic order data. Some of these data fields are grouped in subfolders These subfolders structured by topic:

  • Amounts

  • References

  • Configuration

  • Payment terms

  • Order items

The subfolder Amounts contains a further subfolder called Vat. The subfolder Order items contains two further subfolders called Order item references and Order item amounts. Thus, the folder structure has three levels.

Table 2. Data fields in the folder Order
Field Explanation

Order ID

Exports the ID of the order. The automatically generated export key for this data field is order.id.

PlentyID

Exports the by PlentyONE allocated ID of the client to which the order belongs. The automatically generated export key for this data field is order.plentyId.

Client name

Exports the name of the client to which the order belongs. The automatically generated export key for this data field is order.clientName.

Location

Exports the ID of the location to which the order belongs. The automatically generated export key for this data field is order.locationId.

Location name

Exports the name of the location to which the order belongs. The automatically generated export key for this data field is order.locationName.

Contact ID

Exports the ID of the contact. The automatically generated export key for this data field is order.contactId.

Order type

Exports the order type. The automatically generated export key for this data field is order.typeId.
In the export file, the value is given in form of the ID of the order type.

Status

Exports the order status of the order at the time of the export. The automatically generated export key for this data field is order.statusId.
In the export file, the value is given in form of the ID of the order status.

Status name

Exports the order status of the order at the time of the export. The automatically generated export key for this data field is order.statusname.
In the export file, the name and not the ID of the status is given.

Date

Exports an order date. After adding the data field you can select the date to be exported. If you want to export several dates, you can add the data field several times and then select the required date.
The automatically generated export key for this data field is order.dates. Adapt the export key when you use the data field more than once. You can select the following dates:
- Created on = Date when the order was created.
- Last update = Date of the last update of the order.
- Deleted on = Date of order deletion.
- Paid on = Date on which the last payment for the order was received.
- Outgoing items booked on = Date on which outgoing items were booked for the order.
- Return date = Date on which a return was created from the order.
- Payment due date = Date on which the order is to be paid at the latest.
- Estimated shipping date = Date on which the order items are estimated to be shipped.
- Estimated delivery date = Date on which the order items are estimated to be delivered.
- Latest shipping date = Latest date on which the order items are to be shipped. This date is required by the marketplace eBay.
If you don’t make a selection, this field remains empty in the export file.

Property

Exports a property belonging to the order. Meant here are the order properties which are data of the order and not order properties you create for variations. If you want to export several properties, you can add the data field several times and then select the required property.
The automatically generated export key for this data field is order.properties. Adapt the export key when you use the data field more than once. You can select the following properties. Note that more properties than listed here can be available. These are contingent on the plugins you integrated and thus different from system to system:
- Warehouse
- Shipping profile
- Payment method
- Payment status
- External shipping profile
- Document language
- External order ID
- Customer sign
- Dunning level
- Seller account
- Flag
- Document number
- Sales tax identification number
If you don’t make a selection, this field remains empty in the export file.

Relation

Exports order relations. The automatically generated export key for this data field is order.relationReferences.
Choose between Sender and Receiver for the Relation type.
Choose between Contact and Warehouse for Reference type.
These relations are mostly used for redistributions and reorders. But you can also use them for other order types.
If you don’t make a selection, this field remains empty in the export file.

Order comments

Exports the notes of an order. The automatically generated export key for this data field is order.orderComment.
Select a delimiter that separates the notes from each other if several notes are saved in an order. You can select any character and also enter several characters.

Order tags

Exports the tags of an order. The automatically generated export key for this data field is order.orderTag.
Select a delimiter that separates the order tags from each other if several tags are saved in an order. You can select any character and also enter several characters.

2.1.1. Amounts

In this subfolder, data fields for order amounts and sums are grouped. Also, it contains the thematic subfolder VAT.

Note: You have to select for every data field of this subfolder, whether the amount should be exported in your system currency or the currency of the order. This also applies to the VAT subfolder. Moreover, it makes sense to always add the data fields Currency and Exchange rate. This way, you ensure that you always have all the needed data and information, no matter which currency they are in.

Table 3. Data fields in the folder Amounts
Field Explanation

Is net

Exports the information whether the order is a net or a gross order. The automatically generated export key for this data field is orderAmount.isNet.

Is system currency

Exports the information whether the order amounts are in system currency or another currency. The automatically generated export key for this data field is orderAmount.isSystemCurrency.

Currency

Exports the order currency. The automatically generated export key for this data field is orderAmount.currency.

Exchange rate

Exports the exchange rate of the order. The automatically generated export key for this data field is orderAmount.exchangeRate.

Net amount

Exports the net total amount of the order. The automatically generated export key for this data field is orderAmount.netTotal.

Gross amount

Exports the gross total amount of the order. The automatically generated export key for this data field is orderAmount.grossTotal.

Invoice total

Exports the invoice amount as given on the invoice document of an order. The automatically generated export key for this data field is orderAmount.invoiceTotal.

VAT total

Exports the total amount of VAT of the order. The automatically generated export key for this data field is orderAmount.vatTotal.

Paid

Exports the already paid amount of the order. The automatically generated export key for this data field is orderAmount.paidAmount.

Coupon payment

Exports the redeemed coupon amount (multipurpose coupon) of the order. The automatically generated export key for this data field is orderAmount.giftCardAmount.

Gross shipping costs

Exports the gross shipping costs of the order. The automatically generated export key for this data field is orderAmount.shippingCostsGross.

Net shipping costs

Exports the net shipping costs of the order. The automatically generated export key for this data field is orderAmount.shippingCostsNet.

Taxless amount

Exports taxless amounts of the order. The automatically generated export key for this data field is orderAmount.taxlessAmount.
2.1.1.1. VAT

In this subfolder, data fields for order amounts and VATs are grouped.

Note: You have to select for every data field of this subfolder, whether the amount should be exported in your system currency or the currency of the order. In a further drop-down list, you also have to select the VAT rate. The values for the selected VAT rate are then exported in the export file.

Example:
You export two orders. One has tax rate A with the corresponding values: tax rate, tax rate in % and the amounts calculated with this. The other has tax rate B with the corresponding values: tax rate, tax rate in % and the amounts calculated with this.
You add every data field of the VAT subfolder once. In the selection for the data fields of the VAT subfolder you then select Rate A.
In the export file, all values for the first order with tax rate A are exported. For the second order with tax rate B, no values are exported.
If you want to export values for both orders with the different tax rates (A and B), you have to add the data fields twice. In the drop-down list Select tax rate you then select Rate A for the first data field and Rate B for the second data field. This way, all values are exported in the export file.
Don’t forget to adapt the Export keys when you add the same data field several times.

Table 4. Data fields in the folder VAT
Field Explanation

Tax rate (A, B, C etc.)

Exports the tax rate of the order. The automatically generated export key for this data field is orderAmountVat.vatField.
0 = A
1 = B
2 = C
3 = D
5 = E
6 = F

Tax rate in %

Exports the tax rate in % of the order. The automatically generated export key for this data field is orderAmountVat.vatRate.

VAT

Exports the VAT amount of the order. The automatically generated export key for this data field is orderAmountVat.value.

Net amount

Exports the net total amount of the order. The automatically generated export key for this data field is orderAmountVat.netTotal.

Gross amount

Exports the gross total amount of the order. The automatically generated export key for this data field is orderAmountVat.grossTotal.

2.1.2. References

In this subfolder, data fields for order references are grouped. For example, an order reference is created when a return is created from an order. Or a credit order from a return. Another reference exists between main order and delivery order, for example.

After adding a data field from this folder, the following selection is available to you:

  • Parent = The parent order. The order from which the exported order was created.
    Example: If the exported order is a delivery order, the order ID of the original order, from which the delivery order was created, is exported.

  • Reorder = If the exported order is a reorder which was created directly in another order, the order ID of this order from which it was created is exported.

  • Grouped = When an order was created by grouping other orders, several references of the type Grouped exist. These are references to the original orders. By this, you can easily see of an order was created by grouping several original orders. If it is a grouped order, the order IDs of the original orders are exported.

  • Split = When an order is split into two new orders, each of the two new orders has a reference to the original order from which they were created. In this case, the order ID of the original order which was split is exported.

Note: The selection for Order reference has to be made for every data field in this folder.

Table 5. Data fields in the folder References
Field Explanation

Origin order

Exports the order ID of the original order from which the exported order was created. The original order, also called main order, is the order which was not created from another order and was neither grouped nor split. The automatically generated export key for this data field is orderReference.originOrderId.

Referenced order

Exports the order ID of the order from which the exported order was created. The order one level higher can be the origin order but doesn’t have to be. For example, if a return was created from an original order and then a credit note was created from this return, the order ID of the return is exported.
The automatically generated export key for this data field is orderReference.referenceOrderId.

Reference type

Exports the type of reference the exported order has to another order. The automatically generated export key for this data field is orderReference.referenceType.

2.1.3. Configuration

In this subfolder data fields for settings for saving and rounding prices are grouped.

Table 6. Data fields in the folder Configuration
Field Explanation

Round total only

Exports the rounding settings for the order.
0 = No rounding.
1 = Rounding.
The automatically generated export key for this data field is orderConfig.roundTotalsOnly.

Number of decimals

Exports the selected setting for the number of decimals for the order.
2 = The prices in an order are saved with two decimal places.
4= The prices in an order are saved with four decimal places.
The automatically generated export key for this data field is orderConfig.numberOfDecimals.

2.1.4. Payment terms

In this subfolder data fields for payment terms are grouped.

Table 7. Data fields in the folder Payment terms
Field Explanation

Payment due date (days)

Exports the payment due date in days of an order. The automatically generated export key for this data field is order.paymentTerms.payment.AllowedDays.

Discount (days)

Exports the discount in days of an order. The automatically generated export key for this data field is order.paymentTerms.valutaDays.

Discount (days)

Exports the discount in days of the order. The automatically generated export key for this data field is order.paymentTerms.earlyPaymentDiscountDays.

Discount (%)

Export the discount in % of an order. The automatically generated export key for this data field is order.paymentTerms.earlyPaymentDiscount.

2.1.5. Order items

In this subfolder, data fields for order items are grouped. Additionally, there are the two subfolders Order item references and Order item amounts.

Table 8. Data fields in the folder Order items
Field Explanation

Referrer ID

Exports the order item referrer. The referrer is exported as ID. The automatically generated export key for this data field is orderItem.referrerId.

Order item ID

Exports the ID of the order item. The automatically generated export key for this data field is orderItem.Id.

Quantity

Exports the quantity of the order item. The automatically generated export key for this data field is orderItem.quantity.

Type ID

Exports the type of the order item. The type is exported as ID. The automatically generated export key for this data field is orderItem.typeId.

Attribute values

Exports the attributes of the order item. The automatically generated export key for this data field is orderItem.attributeValues.

Variation ID

Exports the variation ID of the order item. The automatically generated export key for this data field is orderItem.variationId.

Item name

Exports the item name of the order item. The automatically generated export key for this data field is orderItem.itemName.

VAT rate ID

Exports the VAT rate ID of the order item. The automatically generated export key for this data field is orderItem.countryVatId.

Tax rate (A, B, C etc.)

Exports the tax rate of the order item. The automatically generated export key for this data field is orderItem.VatField.
0 = A
1 = B
2 = C
3 = D
5 = E
6 = F

Tax rate in %

Exports the tax rate in % of the order item. The automatically generated export key for this data field is orderItem.VatRate.

Position date

Exports a date of the order item. After adding the data field you can select the date to be exported. If you want to export several dates, you can add the data field several times and then select the required date.
The automatically generated export key for this data field is orderItem.dates. Adapt the export key when you use the data field more than once. You can select the following dates:
- Return date = Date on which the order item was sent back as a return.
- Estimated shipping date = Date on which the order item is estimated to be shipped.
- Estimated delivery date = Date on which the order item is estimated to be delivered.
- Transfer date marketplace = Date on which the order item was transferred to a marketplace.
- Latest shipping date = Latest date on which the order item is to be shipped. This date is required by the marketplace eBay.
If you don’t make a selection, this field remains empty in the export file.

Position property

Exports a property of the order item. If you want to export several properties, you can add the data field several times and then select the required property.
The automatically generated export key for this data field is orderItem.properties. Adapt the export key when you use the data field more than once. You can select the following properties. Note that more properties than listed here can be available. These are contingent on the plugins you integrated and thus different from system to system:
- Warehouse
- Shipping profile
- Weight
- Width
- Length
- Height
- External token ID
- External item ID
- Coupon code
- Coupon type
- External shipping item ID
- Return reason
- Item status
- External order item ID
- Order property ID
- Order property value
- Order property group ID
- Return key ID
If you don’t make a selection, this field remains empty in the export file.
2.1.5.1. Order item references

In this subfolder, data fields for order item references are grouped.
A reference to another order item exists in a delivery order, for example. The order items of a delivery order are connected to the order items of the main order because they were created from them. In this case, the order items in the main order are the parent.
We recommend to add both data fields from this subfolder because the data complement each other.

After adding a data field from this folder, the following selection is available to you:

  • Parent = The superordinate item position.

  • Order property = An order property references the variation in the main order to which the order property belongs. This selection is useful, for example, of an order has several order items with the same variation ID which were then customised with order properties. An order property is referenced.

  • Bundle = The order item as a reference to a bundle.

  • Set = The order item as a reference to a set.

Note: The selection for Order item reference has to be made for every data field in this folder.

Table 9. Data fields in the folder Order item references
Field Explanation

Referenced order item

Exports the ID of the order item to which the exported order item has a reference. If you want to export several references, you can add the data field several times and then make the required selection. The automatically generated export key for this data field is orderItemReference.referenceOrderItemId. Adapt the export key when you use the data field more than once.

Reference type

Exports the type of reference of the order item. If you want to export several references, you can add the data field several times and then make the required selection. The automatically generated export key for this data field is orderItemReference.referenceType. Adapt the export key when you use the data field more than once.
2.1.5.2. Order item amounts

In this subfolder, data fields for order item amounts and sums are grouped.

Note: You have to select for every data field of this subfolder, whether the amount should be exported in your system currency or the currency of the order. Moreover, it makes sense to always add the data fields Currency and Exchange rate. This way, you ensure that you always have all the needed data and information, no matter which currency they are in.

Table 10. Data fields in the folder Order item amounts
Field Explanation

Is net

Exports the information whether the order is a net or a gross order. The automatically generated export key for this data field is orderItem.amounts.isNet.

Is system currency

Exports the information whether the order item amounts were saved in system currency. The automatically generated export key for this data field is orderItem.amounts.isSystemCurrency.

Currency

Exports the currency of the order item. The automatically generated export key for this data field is orderItem.amounts.currency.

Exchange rate

Exports the exchange rate. The automatically generated export key for this data field is orderItem.amounts.exchangeRate.

Purchase price

Exports the purchase price of the order item. The automatically generated export key for this data field is orderItem.amounts.purchasePrice.

Price original gross

Exports the original price in gross of the order item. The automatically generated export key for this data field is orderItem.amounts.priceOriginalGross.

Price original net

Exports the original price in net of the order item. The automatically generated export key for this data field is orderItem.amounts.priceOriginalNet.

Price gross

Exports the gross price of the order item. The automatically generated export key for this data field is orderItem.amounts.priceGross.

Price net

Exports the net price of the order item. The automatically generated export key for this data field is orderItem.amounts.priceNet.

Surcharge

Exports surcharges of the order item. The automatically generated export key for this data field is orderItem.amounts.surcharge.

Discount

Exports discounts of the order item. The discount is exported as an amount. The automatically generated export key for this data field is orderItem.amounts.discount.

Discount procentuals

Exports discounts in % of the order item. The automatically generated export key for this data field is orderItem.amounts.isPercentage.

2.2. Shipping package

In this folder, data fields for Shipping package are grouped.

Note: You have to select a delimiter for each data field in this folder. This delimiter separates the exported values in case there is more than one package for an order. You can select every character. You can enter several characters.

Table 11. Data fields in the folder Shipping package
Field Explanation

Package ID

Exports the package IDs of the shipping packages. The automatically generated export key for this data field is shippingPackage.packageId.

Package number

Exports the package numbers of the shipping packages. The automatically generated export key for this data field is shippingPackage.packageNumber.

Return package number

Exports the numbers of return packages. The automatically generated export key for this data field is shippingPackage.returnPackageNumber.

Packing unit type

Exports the packing type of the shipping packages as ID. Find a list with all packing units and IDs in the manual chapter Packing units. The automatically generated export key for this data field is shippingPackage.packageType.

Weight (g)

Exports the weight of the shipping packages. The value is exported in gram (g). The automatically generated export key for this data field is shippingPackage.weight.

Volumes (cm³)

Exports the the volume of the shipping packages. The value is exported in cubic centimetres (cm³). The automatically generated export key for this data field is shippingPackage.colume.

Pallet ID

Exports the pallet IDs of the shipping packages. The automatically generated export key for this data field is shippingPackage.palletId.

Tracking URL

Exports the tracking URLs of the shipping packages. The automatically generated export key for this data field is shippingPackage.trackingUrl.

2.3. Shipping profile

In this folder, data fields for the Shipping profile are grouped.
Further information about shipping profiles can be found in the chapter Creating a shipping profile.

Table 12. Data fields in the folder Shipping profile
Field Explanation

Name

Exports the name of the shipping profile. The name exported with this data field is the one which is displayed in the online shop to your customers. The automatically generated export key for this data field is parcelServicePreset.name.
Select the language of the shipping profile. Adapt the export key if you add the data field more than once.

Back end name

Exports the back end name of the shipping profile. The name as displayed in the system is exported. This is not the name displayed to your customers in the online shop. The automatically generated export key for this data field is parcelServicePreset.backendName.

Priority

Exports the set property of the shipping profile. The automatically generated export key for this data field is parcelServicePreset.priority.

2.4. Shipping service provider

In this folder, data fields for the Shipping service provider are grouped.
Further information about shipping service providers can be found in the chapter Creating a shipping service provider.

Table 13. Data fields in the folder Shipping service provider
Field Explanation

Name

Exports the name of the shipping service provider. The name set for Name in the menu Setup » Orders » Shipping » Settings in the tab Shipping service provider is exported. Thus, exported is the name displayed in the online shop or on invoices. The automatically generated export key for this data field is parcelService.name.
Select the language of the shipping provider name. You can add this data field more than once and select a different language every time. Adapt the export key if you add the data field more than once.

Back end name

Exports the back end name of the shipping service provider. The name set for Name (backend) in the menu Setup » Orders » Shipping » Settings in the tab Shipping service provider is exported. Thus, exported is the name as displayed back end in the system. The automatically generated export key for this data field is parcelService.backendName.

ID

Exports the ID of the shipping service provider from the Setup » Orders » Shipping » Setting menu. There, the ID is saved in the tab Shipping service provider in the table column ID. The automatically generated export key for this data field is parcelService.Id.

Shipping service provider ID

Exports the shipping service provider ID. This ID is used by default in the PlentyONE system. Find a list of these IDs in the chapter Shipping service providers. The automatically generated export key for this data field is parcelService.shippingServiceProviderId.

Tracking URL

Exports the tracking URL of the shipping service provider as saved in the tab Shipping service provider in the Setup » Orders » Shipping » Settings menu. The automatically generated export key for this data field is parcelService.trackingUrl.

2.5. Documents

In this folder, data fields for Documents are grouped.

Note: Each of these data fields can be used for every document type. Therefore, make a selection for the drop-down list Select document type when you add a data field. Adapt the export keys accordingly.

Table 14. Data fields in the folder Documents
Field Explanation

Number

Exports the number of the order document. The automatically generated export key for this data field is document.number.

Document number

Exports the document number with prefix. The automatically generated export key for this data field is document.numberWithPrefix.

Display date

Exports the date as displayed on the order document. The automatically generated export key for this data field is document.displayDate.

Document type

Exports the document type of the order document. The automatically generated export key for this data field is document.type.

User ID

Exports the ID of the user who created the order document. The automatically generated export key for this data field is document.userId.

2.6. Addresses

In this folder, data fields for the Addresses are grouped.
Find more information on addresses in general in the manual chapter Addresses.

Note: Each of these data fields can be used for the invoice as well as the delivery address. Therefore, make a selection for the drop-down list Address type when you add a data field. Adapt the export keys accordingly.

Table 15. Data fields in the folder Addresses
Field Explanation

Address ID

Exports the ID of the address as it is saved in the contact data set. The automatically generated export key for this data field is address.id.

Gender

Exports the form of address. The automatically generated export key for this data field is address.gender.

Name 1

Exports name 1 (company) of the address. The automatically generated export key for this data field is address.name1.

Name 2

Exports name 2 (first name) of the address. The automatically generated export key for this data field is address.name2.

Name 3

Exports name 3 (last name) of the address. The automatically generated export key for this data field is address.name3.

Name 4

Exports name 4 (additional information) of the address. The automatically generated export key for this data field is address.name4.

Address 1

Exports the address 1 (street). The automatically generated export key for this data field is address.address1.

Address 2

Exports the address 2 (house number). The automatically generated export key for this data field is address.address2.

Address 3

Exports the address 3 (additional address information). The automatically generated export key for this data field is address.address3.

Address 4

Exports the address 4 (free). The automatically generated export key for this data field is address.address4.

Postcode

Exports the postcode of the address. The automatically generated export key for this data field is address.postalCode.

Town

Exports the town of the address. The automatically generated export key for this data field is address.town.

Country ID

Exports the country ID of the address. The automatically generated export key for this data field is address.countryId.
The IDs are listed in the manual chapter Countries.

Country ISO code 2

Exports the country as ISO code 2. The automatically generated export key for this data field is address.countryIso2.

Country ISO code 3

Exports the country as ISO code 3. The automatically generated export key for this data field is address.countryIso3.

Country name

Exports the name of the country. The automatically generated export key for this data field is address.countryName.

State ID

Exports the ID of a state or region. The automatically generated export key for this data field is address.stateId.
The IDs are listed in the manual chapter Federal states, regions and districts.

State ISO code

Exports the ISO code of a state or region. The automatically generated export key for this data field is address.stateIso.

State ISO code 3166

Exports the ISO code 3166 of a state or region. The automatically generated export key for this data field is address.stateIso3166.

State name

Exports the name of a state or region. The automatically generated export key for this data field is address.stateName.

Address option

Exports further address options such as telephone number or date of birth. After adding the data field, select from the Type drop-down list which address option you want to export. Don’t forget to also select the address type.
The automatically generated export key for this data field is address.options. Add this data field several times if you want to export more than one address option. Adapt the export key if you add this data field more than once. The following address options are available:
- VAT number
- External address ID
- Entry certificate
- Telephone
- Email
- Post number
- Personal id
- BBFC
- Birthday
- Session ID
- Title
- Contact person
- External customer ID

2.7. Contact

In this folder, data fields for the Contact of the order are grouped.
Find more information on contacts in general on the manual page Editing a contact.

Table 16. Data fields in the folder Contact
Field Explanation

Contact ID

Exports the ID of the contact. The automatically generated export key for this data field is contact.id.
If the order is a guest order, this field remains empty in the export file or null is displayed.

External ID

Exports the external contact ID. The automatically generated export key for this data field is contact.externalId.

Number

Exports the contact number (previously the customer number). The automatically generated export key for this data field is contact.number.

Type ID

Exports the type of the contact as ID. The IDs and names of the types created by default in the system or by you can be found the menu Setup » CRM » Types. The automatically generated export key for this data field is contact.typeId.
Find more information on types in general in the manual chapter Creating a type.

Type name

Exports the type of the contact as name. The IDs and names of the types created by default in the system or by you can be found the menu Setup » CRM » Types. The automatically generated export key for this data field is contact.typeName.
Find more information on types in general in the manual chapter Creating a type.

First name

Exports the contact’s first name. The automatically generated export key for this data field is contact.firstName.

Last name

Exports the contact’s last name. The automatically generated export key for this data field is contact.lastName.

Gender

Exports the form of address. The automatically generated export key for this data field is contact.gender.

Title

Enter the title of the contact. The automatically generated export key for this data field is contact.title.

Form of address

Exports the contact’s form of address. The automatically generated export key for this data field is contact.formOfAddress.

Customer class ID

Exports the ID of the customer calls assigned to this contact. The automatically generated export key for this data field is contact.classId.
Find more information on customer classes in general in the manual chapter Creating a customer class.

Rating

Exports the contact’s rating. The automatically generated export key for this data field is contact.rating.

Booking account

Exports the contact’s booking or debtor account. The automatically generated export key for this data field is contact.bookAccount.
Find more information on contacts and debtor accounts in the manual chapter Contact details.

Language

Exports the contact’s language. The automatically generated export key for this data field is contact.lang.

Date of birth

Exports the contact’s date of birth. The automatically generated export key for this data field is contact.birthdayAt.

Sales representative ID

Exports the ID of the sales representative assigned to the contact. The automatically generated export key for this data field is contact.salesRepresentativeContactId.

Contact option

Exports further contact options such as telephone number or payment method. After adding the data field, select from the Type drop-down list which contact option you want to export. After doing so, also select a subtype for the chosen contact option. The automatically generated export key for this data field is contact.options.
Add this data field several times if you want to export more than one contact option. Adapt the export key if you add this data field more than once. The following contact options are available:
- Telephone
- Email
- Telefax
- Web page
- Marketplace
- Identification number
- Payment
- User name
- Group
- Access
- Additional
- Salutation
- Converted by

2.8. Variation

In this folder, data fields for Variation contained in the order are grouped. It also contains the subfolder Item.

Table 17. Data fields in the folder Variation
Field Explanation

Variation ID

Exports the ID of the variation. The automatically generated export key for this data field is variation.id.

Taric code

Exports the variation’s taric code. The automatically generated export key for this data field is variation.customsTariffNumber.

External variation ID

Exports the external variation ID. The automatically generated export key for this data field is variation.externalId.

Height mm

Exports the variation’s height in mm. The automatically generated export key for this data field is variation.heightMM.

Length in mm

Exports the variation’s length in mm. The automatically generated export key for this data field is variation.lengthMM.

ID of main variation

Exports the ID of the variation. The automatically generated export key for this data field is variation.mainVariationId.

Main warehouse

Exports the ID of the variation’s main warehouse. The automatically generated export key for this data field is variation.mainWarehouseId.

Model

Exports the variation’s model. The automatically generated export key for this data field is variation.model.

Moving average purchase price

Exports the variation’s net moving average purchase price. The automatically generated export key for this data field is variation.movingAveragePrice.

Net purchase price

Exports the variation’s net purchase price. The automatically generated export key for this data field is variation.purchasePrice.

Variation name

Exports the variation’s name. The automatically generated export key for this data field is variation.name.

Variation number

Exports the variation number. The automatically generated export key for this data field is variation.number.

Release date

Exports the variation’s release date. The automatically generated export key for this data field is variation.releasedAt.

VAT rate

Exports the variation’s VAT rate. The automatically generated export key for this data field is variation.vatId.

Gross weight g

Exports the variation’s gross weight in grams. The automatically generated export key for this data field is variation.weightG.

Net weight g

Exports the variation’s net weight in grams. The automatically generated export key for this data field is variation.weightNetG.

Width mm

Exports the variation’s width in mm. The automatically generated export key for this data field is variation.widthMM.

Units contained

Exports the variation’s contained units. The automatically generated export key for this data field is variation.units contained.

Barcode

Exports the variation’s barcode. After adding the data field, select the Barcode type from the drop-down list. The automatically generated export key for this data field is variation.barcode.

2.8.1. Item

In this subfolder, data fields for Item data are grouped.

Table 18. Data fields in the folder Item
Field Explanation

Age rating

The item’s age rating. The automatically generated export key for this data field is variation.item.ageRestriction.

Item ID

Exports the ID of the item. The automatically generated export key for this data field is variation.item.id.

Type

Exports the item type. The automatically generated export key for this data field is variation.item.itemType.

Manufacturer ID

Exports the ID of the item’s manufacturer. The automatically generated export key for this data field is variation.item.manufacturerId.

Manufacturer name

Exports the name of the item’s manufacturer. The automatically generated export key for this data field is variation.item.manufacturerName.

Manufacturer country ID

Exports the ID of the item’s manufacturer country. The automatically generated export key for this data field is variation.item.producingCountryId.
The IDs are listed in the manual chapter Countries.

Revenue account

Exports the item’s revenue account. This revenue account is saved under Item » Edit item » [Open item] » Tab: Global » Entry field: Revenue account. The automatically generated export key for this data field is variation.item.revenueAccount.

3. Filters

This chapter lists all of the filters that you can use to limit which orders and order items are included in the export file.

Table 19. Filters for order export
Filter Explanation

Order status

Limits the export to orders with the selected order status. You can select more than one order status for this filter.

Order type

Limits the export to orders of the selected order types. You can select more than one order type for this filter.

Client

Limits the export to orders of the selected client. You can select more than one client for this filter.

Location

Limits the export to orders of the selected location. You can select more than one location for this filter.

Order ID

Limits the export to the order with the entered order ID. It is not possible to enter more than one ID.

Payment status

Limits the export to orders with the selected payment status. You can only select one payment status for this filter. The following payment statuses are available:
- Overpaid
- Paid
- Partially paid
- Prepaid
- Not paid

Payment method

Limits the export to orders with the selected payment methods. You can select more than one payment method for this filter.

Owner

Limits the export to orders with the selected owner. You can select more than one owner for this filter.

Tag

Limits the export to orders with one of the selected tags. You can select more than one tag for this filter.

Order referrer

Limits the export to orders from the selected order referrers. You can select more than one order referrers for this filter.

Contact ID

Limits the export to orders with the entered contact ID. It is not possible to enter more than one ID.

Warehouse

Limits the export to orders with one of the selected warehouses. You can select more than one warehouse for this filter.

Shipping profile

Limits the export to orders with one of the selected shipping profiles. You can select more than one shipping profile for this filter.

Invoice country

Limits the export to orders with one of the selected invoice countries. You can select more than one invoice country for this filter.

Country of delivery

Limits the export to orders with one of the selected delivery countries. You can select more than one delivery country for this filter.

Creation on

Limits the export to orders that were created on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders that were created today will be exported.

Yesterday

Only orders that were created yesterday will be exported.

Last

Enter a number of days into the field on the right. Only orders that were created within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only orders that were created during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only orders that were created on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right. Only orders that were not created on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only orders that were created after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only orders that were created on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only orders that were created before this date will be exported.

⇐

Last update on

Limits the export to orders that were updated on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders that were updated today will be exported.

Yesterday

Only orders that were updated yesterday will be exported.

Last

Enter a number of days into the field on the right. Only orders that were updated within the last [number] days will be exported.

Period

Enter a time period into the field on the right. Only orders that were updated during this time period will be exported.

=

Is equal to. Enter a date into the field on the right. Only orders that were updated on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right. Only orders that were not updated on this date will be exported.

>

Greater than. Enter a date into the field on the right. Only orders that were updated after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right. Only orders that were updated on or after this date will be exported.

<

Less than. Enter a date into the field on the right. Only orders that were updated before this date will be exported.

⇐

Paid on

Limits the export to orders which were paid on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders that were paid today will be exported.

Yesterday

Only orders that were paid yesterday will be exported.

Last

Enter a number of days into the field on the right.

Only orders that were paid within the last [number] days will be exported.

Period

Enter a time period into the field on the right.

Only orders that were paid during this time period will be exported.

=

Is equal to. Enter a date into the field on the right.

Only orders that were paid on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right.

Only orders that were not paid on this date will be exported.

>

Greater than. Enter a date into the field on the right.

Only orders that were paid after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right.

Only orders that were paid on or after this date will be exported.

<

Less than. Enter a date into the field on the right.

Only orders that were paid before this date will be exported.

⇐

Less than or equal to. Enter a date into the field on the right.

Outgoing items booked on

Limits the export to orders for which the outgoing items were booked on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders for which the outgoing items were booked today will be exported.

Yesterday

Only orders for which the outgoing items were booked yesterday will be exported.

Last

Enter a number of days into the field on the right.

Only orders for which the outgoing items were booked within the last [number] days will be exported.

Period

Enter a time period into the field on the right.

Only orders for which the outgoing items were booked during this time period will be exported.

=

Is equal to. Enter a date into the field on the right.

Only orders for which the outgoing items were booked on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right.

Only orders for which the outgoing items were not booked on this date will be exported.

>

Greater than. Enter a date into the field on the right.

Only orders for which the outgoing items were booked after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right.

Only orders for which the outgoing items were booked on or after this date will be exported.

<

Less than. Enter a date into the field on the right.

Only orders for which the outgoing items were booked before this date will be exported.

⇐

Less than or equal to. Enter a date into the field on the right.

Estimated shipping date

Limits the export to orders that are expected to be shipped on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders with a shipping date expected to be today will be exported.

Yesterday

Only orders with a shipping date expected to be yesterday will be exported.

Last

Enter a number of days into the field on the right.

Only orders with a shipping date expected to be within the last [number] days will be exported.

Period

Enter a time period into the field on the right.

Only orders with a shipping date expected to be during this time period will be exported.

=

Is equal to. Enter a date into the field on the right.

Only orders with a shipping date expected to be on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right.

Only orders with a shipping date expected to be not on this date will be exported.

>

Greater than. Enter a date into the field on the right.

Only orders with a shipping date expected to be after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right.

Only orders with a shipping date expected to be on or after this date will be exported.

<

Less than. Enter a date into the field on the right.

Only orders with a shipping date expected to be before this date will be exported.

⇐

Less than or equal to. Enter a date into the field on the right.

Order item type

Limits the export to order items of the selected order types. You can select more than one order type for this filter.

Order item referrer

Limits the export to order items with one of the selected referrers. You can select more than one referrer for this filter.

Variation ID

Limits the export to order items with the entered variation ID. It is not possible to enter more than one ID.

Variation number

Limits the export to order items with the entered variation number. It is not possible to enter more than one number.

Manufacturer

Limits the export to order items of the selected manufacturers. You can select more than one manufacturer for this filter.

Order item warehouse

Limits the export to order items assigned to one of the selected warehouses. You can select more than one warehouse for this filter.

Guest order

Decide whether the export should include guest orders or not.
Yes = Guest orders are exported.
No = Guest orders are not exported.

Exclude main orders if delivery orders exist

Decide whether the export should include main orders of delivery orders or not.
Yes = Main orders are not exported.
No = Main orders are exported.

Payment due date

Limits the exports to orders with payment due on a specific date.

Formatting: Enter the date in the format DD.MM.YYYY. Alternatively, click on the calendar symbol (today) if you would prefer to choose the date from the calendar.

Operators in the left drop-down list
Operator Explanation

Today

Only orders with a payment due date today will be exported.

Yesterday

Only orders with a payment due date yesterday will be exported.

Last

Enter a number of days into the field on the right.

Only orders with a payment due date within the last [number] days will be exported.

Period

Enter a time period into the field on the right.

Only orders with a payment due date during this time period will be exported.

=

Is equal to. Enter a date into the field on the right.

Only orders with a payment due date on this date will be exported.

*

=*

Is not equal. Enter a date into the field on the right.

Only orders with a payment due date not on this date will be exported.

>

Greater than. Enter a date into the field on the right.

Only orders with a payment due date after this date will be exported.

>=

Greater than or equal to. Enter a date into the field on the right.

Only orders with a payment due date on or after this date will be exported.

<

Less than. Enter a date into the field on the right.

Only orders with a payment due date before this date will be exported.

⇐

Less than or equal to. Enter a date into the field on the right.