Fulfilment Centre Order Export

Overview
This export is specifically used for fulfilment centres and can only be created using FC Automation functionality. However, it can be configured and deleted from the Export Data screen

Table of Contents

Export Types

There are 2 types of Order export available to be selected

  • Fulfilment Center Order Export (All) - Exports all paid orders assigned to a given fulfilment centre every time it runs. Append is not allowed to avoid duplicates.
  • Fulfilment Center Order Export (Only Once) - Exports orders assigned to a given fulfilment centre 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 fulfilment centre 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
  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 order 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