Stock Items (with levels)

Overview
The report outputs all stock items in the Linnworks database with stock levels, including archived SKUs, for a specified location.

Selection Criteria

Linnworks will select the items to be included in the report based on the following criteria

Parameters - The following parameters can be used to configure this report

  • Location: The name of the Linnworks location, used for stock levels and values

Rules - internal logic applied to extract only those records that fulfil the specified criteria

  • All inventory items are included in the report
  • Items that have been previously deleted are not included in this report
  • Bin/rack values are not displayed for batched items.

Reported Values

The following values are returned by the report

Values - Column names and description

  • SKU: The SKU / Item number for the Linnworks inventory item
  • ItemTitle: The title for the Linnworks inventory item (found on the General tab)
  • ItemDescription: The Metadata for the Linnworks inventory item (found on the General tab)
  • RetailPrice: The retail price defined for the Linnworks inventory item (found on the General tab)
  • Weight: The defined weight for the Linnworks inventory item (found on the Postage definition tab)
  • PurchasePrice: The purchase price defined for the Linnworks inventory item (found on the General tab)
  • BarcodeNumber: The barcode number for the Linnworks inventory item (found on the General tab)
  • DimHeight: The defined height for the Linnworks inventory item (found on the Postage definition tab)
  • DimWidth: The defined width for the Linnworks inventory item (found on the Postage definition tab)
  • DimDepth: The defined depth for the Linnworks inventory item (found on the Postage definition tab)
  • TaxRate: 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
  • CategoryName: The Linnworks category assigned to the Linnworks inventory item (found on the General tab)
  • DefaultPostalService: The preferred postal service for the Linnworks inventory item (found on the Postage definition tab)
  • DefaultPackagingGroup: The preferred packaging group for the Linnworks inventory item (found on the Postage definition tab)
  • Level: Stock level including stock assigned to Open Orders
  • StockValue: This is the stock value at this location, based on the amount of stock in this location and unit cost
  • MinimumLevel: Used for reordering stock when the level drops to this level
  • InOrderBook: Stock quantity in Open Orders
  • OnOrder: Stock quantity in Purchase Orders (Column Due in the Inventory Screen)
  • Available: Stock level less any assigned in Open Orders
  • Location: The name of the Linnworks location, used for stock levels and values
  • BinRack: The identifier for the physical location in the warehouse used to store the inventory item
    NB!  BinRack values are not displayed for batched items.