Sold Stock Between Dates (by Location and Source)

Overview
The report gets all sold and despatched (only processed orders are included in the report) stock between start and end date specified in the parameters aligns it with the current stock data, the data is also grouped by Location, Source and SubSource.

Selection Criteria

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

Parameters - settings to be applied by user prior to generating report

  • Date Range: inclusive range based on the date the order was placed on the sales channel
    • Start date: From the start of the day for the specified date
    • End date: To the end of the day for the specified date

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

  • Only processed are included
  • Order Item must be linked to a Linnworks stock item at the time of Processing. Unlinked order items will be excluded from the report

Reported Values

The following values are returned by the report

Values - Column names and description

  • Location: the Location the order item was processed from, if not know 'UNKNOWN' will be displayed
  • Source: the name of the Channel source, eg 'EBAY'
  • SubSource: the name of the Channel sub source, eg 'EBAY0'
  • ItemTitle: the Title of the Linnworks stock item that was linked to the order item at the time the order was processed
  • ItemNumber: the Item Number of the Linnworks stock item that was linked to the order item at the time the order was processed
  • Category: the Linnworks Category assigned to the Linnworks stock item that was linked to the order item at the time the order was processed
  • SoldQuantity: the sum of items that were sold in the specified date range
  • SoldValue the sum of the order item sold price multiplied by the quantity sold
  • StockValueSold the sum of the Linnworks Item Stock value (at time of order process) multiplied by the quantity sold
  • PostageCharged: the sum of the postage charged
  • Currency: This is the currency the SKU was purchased in
  • StockLevel: the current Linnworks stock level the inventory item
  • StockValue: the current Linnworks stock value of the inventory item
  • StockMinLevel: the current Linnworks minimum level the inventory item (used for Purchase order functionality)
  • InOrderBooks: the current number of items in Open Orders 
  • StockAvailable: the current numbers of items that are available to sell (StockLevel - InOrderBooks) 

Grouping - Items that match across the following criteria will be grouped on a single row in the report

  • Location
  • Source
  • SubSource
  • ItemNumber