Linnworks Desktop Documentation

Fulfillment Center Order Export

Overview
This export is specifically used for fulfillment centers and can only be created using FC Automation functionality. However, it can be configured and deleted from the Export Data screen
Fulfilment Centre Order Export (All)

Table of Contents

Export Types

There are 2 types of Order export available to be selected

  • Fulfillment Center Order Export (All) - Exports all paid orders assigned to a given fulfillment center every time it runs. Append is not allowed to avoid duplicates.
  • Fulfillment Center Order Export (Only Once) - Exports orders assigned to a given fulfillment center only once. It is recommended to clean up the file often as the bigger the file is the slower the export will run.

Note! These exports will start running and exporting orders only when there are new orders assigned to the fulfillment center location.

Available Columns

Legend

Key Description
Filter This field supports filtering

Columns - Order Reference Numbers

Key Column Description
  Order Id This is the Linnworks OrderID
  Channel 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 and Hitmeister

Columns - Order Details

Key Column Description
  Source This is the channel the order has been downloaded or imported from. Orders placed within Linnworks will display as DIRECT
  SubSource The SubSource shows the specific integration the order was downloaded from
  Order total This is the total cost of the order including tax and postage
  Total Discount This is the total amount of discount applied to the order
  Order tax This is the total amount of tax paid on the order
  Tax Id This is the Tax Id of the buyer. Currently, it is supported for Amazon orders only.
  Shipping cost The shipping cost, as downloaded from the channel
  Currency This is the currency used on the order or set in the channel config for that sales channel
  Unit cost The individual sold price for the item that has been purchased
  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
  Line discount This is the discount applied to the item, as a percentage
  Order Notes This is a list of notes appended to an order

Columns - SKU Details

Key Column Description
  SKU The SKU / Item number for the Linnworks inventory item. If the item is unlinked, the Channel SKU will be displayed
  Channel SKU The SKU / Item number that has been set on the sales channel. Please note that this may not be the same as the Linnworks SKU
  Item title The title for the Linnworks inventory item (found on the General tab). If the item is unlinked, the Channel Title will be displayed
  Original title The title for the item as defined in the sales channel. Please note that this may not be the same as the Linnworks Item Title
  Quantity This is the quantity of an order item that has been placed in the order
  Product Tax rate The defined tax rate for the Linnworks inventory item (found on the General tab). This overrides the system default. If the value is -1, the item uses the system default Tax Rate

Columns - Order Dates

Key Column Description
  Received date The date and time at which the order was placed on the sales channel

Columns - Shipping and Packaging

Key Column Description
  Customer name This is the name of the customer, as entered on the order
  Customer company Company name used for despatching purposes
  Address 1 Address line 1 used when the order was despatched
  Address 2 Address line 2 used when the order was despatched
  Address 3 Address line 3 used when the order was despatched
  Town Town of the address used when the order was despatched
  Region This is the region, such as county or state, used when the order was despatched
  Postcode This is the shipping postcode or ZIP code entered on the order
  Country Country of the address used when the order was despatched
  Country code This is the ISO country code for the shipping address
  Buyer phone number This is the customer phone number that is associated with the order
  Customer email address Email used for despatching purposes
  Shipping service name This is the Linnworks Postal Service that has been assigned to the order
  Shipping service vendor This is the name of the courier associated with the Linnworks Postal Service that has been assigned to the order
  Shipping service code This is the code that is defined by the courier to identify the courier's shipping service

Columns - Additional Columns

Key Column 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 This column allows you to display any extended property that is associated with an order. For more information on order extended properties see here.