Processed Orders Export

The Processed Orders Export allows you to export information associated with all processed orders in Linnworks.

ExportData ProcessedOrders

Table of Contents

Date Ranges

When building a data export for processed orders if no date range (Processed / Received) is specified in the filters, Linnworks automatically applies a default range starting 31 days prior to the date the report is executed using Processed Date as the criteria.

Note! It is not possible to export orders for a period longer than 31 days in one go. This is implemented to ensure there is not excessive loading on the database by exporting all processed orders for all time every time the export is executed.

The alternative method for retrieving order data for all time is through Dashboards > Query Data and running reports such as Order details between dates, Orders between dates, or Order Totals between dates.

Available Columns

The available columns below have been grouped by similar fields for your convenience. They may appear in a different order when exported. The order can be changed on the Column Mapping screen of the export configurations. For more information on this, please see our Column Mapping documentation.

Legend

Key Description
Filter This field supports filtering

Columns - Order Reference Numbers

Key Column Description
  Order Id This is the Linnworks OrderID.
  Reference Number This is the reference number assigned by the sales channel for the order.
  External Reference This is an additional reference number from the sales channel, typically used by eBay.
  Channel Reference An additional reference number for the order.

Columns - Order Dates

Key Column Description
Paid Received date The date and time at which the order was placed on the sales channel.
  Created Date This is the date and time at which the order was downloaded into Linnworks.

Columns - Shipping and Packing

Key Column Description
  Customer email address Email used for despatching purposes.
  Customer buyer phone number This is the customer phone number that is associated with the order.
  Customer company Company name used for despatching purposes.
  Shipping customer name This is the name of the customer, as entered on the order.
  Shipping address 1 Address line 1 used when the order was despatched.
  Shipping address 2 Address line 2 used when the order was despatched.
  Shipping address 3 Address line 3 used when the order was despatched.
  Shipping town Town of the address used when the order was despatched.
  Shipping region This is the region, such as county or state, used when the order was despatched.
  Shipping postcode This is the shipping postcode or ZIP code entered on the order.
  Shipping country Country of the address used when the order was despatched.
  Shipping country code This is the ISO country code for the shipping address.
Paid Processed date The date and time at which the order was processed in Linnworks.
  Shipping Service name This is the Linnworks Postal Service that has been assigned to the order.
  Shipping Service tag This is the Linnworks Postal Service tag. Please note this field is only relevant for Postal Services added in Legacy Desktop.
  Shipping Service code This is the code that is defined by the courier to identify the courier's shipping service.
Paid Shipping Service vendor This is the name of the courier associated with the Linnworks Postal Service that has been assigned to the order.
  Packaging Group This is the name of the packaging group that has been assigned to the order.
  Tracking Number This is the tracking number that has been associated with the order.

Columns - Billing Details

Key Column Description
  Billing Name This is the Billing Name associated with the order.
  Billing Company This is the company name, as entered on the order.
  Billing address 1 Line 1 of the address used for billing purposes.
  Billing address 2 Line 2 of the address used for billing purposes.
  Billing address 3 Line 3 of the address used for billing purposes.
  Billing town Town of the address used for billing purposes.
  Billing region Region / State / County of the address used for billing purposes.
  Billing postcode Postcode of the address used for billing purposes.
  Billing country name This is the name of the country used for billing purposes.
  Billing phone number Phone number used for billing purposes.

Columns - Order Details

Key Column Description
  Shipping cost The shipping cost, as downloaded from the channel.
  Order tax This is the total amount of tax paid on the order.
  Order total This is the total cost of the order including tax and postage.
  Currency This is the currency used on the order or set in the channel config for that sales channel.
Paid Paid This is a binary field that shows Paid or Unpaid, based on the information downloaded from the channel.
Paid Status The status of an order, which can be one of the below:
  • Unpaid
  • Paid
  • Return
  • Pending
  • Resend
Paid Source This is the channel the order has been downloaded or imported from. Orders placed within Linnworks will display as DIRECT.
Paid Subsource The Subsource shows the specific integration the order was downloaded from.
  Dispatch By The date and time by which the order must be dispatched to the buyer.
  Channel Buyer Name Channel-specific name used to identify the buyer, such as a username, normally used for eBay.
  Marker This is a number, between 0 and 7, that represents order tags that have been assigned to the order. The exception being 0, which means no tag has been set on the order, and 7 which means the order has been 'Parked'.
  Payment Method This is the Linnworks payment method that has been applied to the order
  On Hold This shows whether the order has been marked as On Hold, for Processed orders if the Order has been canceled On Hold = 1.
Paid Fulfillment Location This is the Linnworks location that the order has been assigned to.
  Order Item The SKU / Item number for the Linnworks inventory item that was ordered.
  Channel SKU This is the SKU used on the channel for this order item, which may differ from the standard Linnworks Item Number.
  Quantity The number of the ordered item.
  Unit cost The individual sold price for the item that has been purchased.
  Line discount This is the discount applied to the item, as a percentage.
  Tax rate This is the tax rate applied to the item, as a percentage.
  Line tax This is the amount of tax paid on the item in the order.
  Line total excluding tax This is the quantity of the ordered item multiplied by the unit cost of the item.
  Line total This is the retail price for this item, including tax, multiplied by the quantity ordered.
  Is service This is either TRUE or FALSE based on whether the line item is a service, such as a gift wrapping. Note: Service items do not have an SKU or channel SKU.
  Item number A unique row identifier for each order item within an order. The identifier can be repeated across different orders, but not within an order.
  Composite Parent SKU If the line item has been ordered as part of a composite, this shows the composite parent's Linnworks SKU.
  Composite Parent order item number This is a unique row identified applied to all child items of a composite SKU on an order.
  Order notes This is a list of notes appended to an order.
  Tax Id This is the Tax Id of the buyer.
  Item Title This is the title of an item as seen in My Inventory.
  Original Title This is the title of an item that the order has been downloaded with.

Additional Columns

The +Additonal Columns button allows you to export additional order information that is not available as preset columns listed above. Click the button and select:

DataExport AdditionalColumns

  • Type: the type of data you wish to export. The available options are:
    • All Item Extended Properties
    • Expression
    • Item Extended Property
    • Order Extended Property
    • Order Item Option
  • Column Name: the name for the column you want to display in the exported file.
  • Property Name: a dropdown menu that displays all relevant properties for the selected type.
Type Description
All item extended properties This option allows you to export all available extended properties of ordered items. The system will calculate the number of all extended properties to be exported. Click this option and confirm that you indeed would like to add the extended properties to the export.
Expression Use this option when you need to export specific information that is not available as a preset column or an additional column. You can write your own expression to export the data you need. For more information on expressions see here.
Item extended property  This column allows you to display any extended property attribute that is associated with an SKU. For example, a pair of shoes were ordered in EU size. If this export is being sent to a UK distributor, an additional column can be added with the UK Size extended property.
Order extended property Order extended properties are most commonly used with open order scripts. The Property dropdown will display available order extended properties.
Order item option This additional column displays information on what variation was ordered. For example, size or color.