Inventory Export

Overview
The Inventory Export allows you to export information relating to stock items held in the Linnworks inventory. 

Table of Contents

Available Columns

The available columns below have been grouped by similar fields for 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
Additional Additional fields are recommended to be included with field to improve the integrity of the exported data

Columns - SKU Details

Key Column Description Additional fields
  SKU The SKU / Item number for the Linnworks inventory item  
  Item Title The title for the Linnworks inventory item (found on the General tab)  
  Short Description The Metadata for the Linnworks inventory item (found on the General tab)  
  Retail Price The retail price defined for the Linnworks inventory item (found on the General tab)  
  Purchase Price The purchase price defined for the Linnworks inventory item (found on the General tab)  
Filter Category The Linnworks category assigned to the Linnworks inventory item (found on the General tab)  
  Weight The defined weight for the Linnworks inventory item (found on the Postage definition tab)  
  Height The defined height for the Linnworks inventory item (found on the Postage definition tab)  
  Dim Width The defined width for the Linnworks inventory item (found on the Postage definition tab)  
  Depth The defined depth for the Linnworks inventory item (found on the Postage definition tab)  
  Tax Rate The defined tax rate for the Linnworks inventory item (found on the General tab). This overides the system default. If the value is -1, the item uses the system default Tax Rate  
  Default Postal Service The preferred postal service for the Linnworks inventory item (found on the Postage definition tab)  
  Default Packaging Group The preferred packaging group for the Linnworks inventory item (found on the Postage definition tab)  
Filter Is Variation Parent Highlight if a SKU is a Variation parent or not (TRUE/FALSE)  
Filter Is Archived Highlight if a SKU is a Archived or not (TRUE/FALSE)  
  Barcode Number The barcode number for the Linnworks inventory item (found on the General tab)  

Columns - Location Details

Key Column Description Additional fields
Filter Stock Location The name of the Linnworks location, used for stock levels and values  
Additional Stock available level at location Stock level less any assigned in Open Orders Stock Location
Additional Stock in orderbook at location Stock quantity in Open Orders Stock Location
Additional Stock level at location Stock level including stock assigned to Open Orders Stock Location
Additional Stock value at location This is the stock value at this location, based on amount of stock in this location and purchase price Stock Location
Additional Stock minimum level at location Used for reordering stock when level drops to this level Stock Location
Additional Stock due at location Quantity that is awaiting delivery through Linnworks purchase ordering Stock Location

Additional Columns

Additional columns are used to export extra parameters that rely on linking to further parameters stored with the inventory, such as Extended Properties, Channel Pricing or Bin Rack Locations. More details on the additional columns available can be found here