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
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
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 |
---|---|
![]() |
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 |