Sold Granular - Between Dates

Overview
This report returns a list of all SKUs (excluding composite parents) that have been sold either individually or as the child of a composite parent item between a date range

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

  • 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

  • Stock items that are composite parents will not be included
  • Order Item quantity must be greater than 0
  • Order Item must be linked to a Linnworks stock item at the time of processing

Reported Values

The following values are returned by the report

Values - Column names and description

  • SKU = The Linnworks stock item number
  • Item Title = The Linnworks stock item title
  • Purchase Price = The value currently saved against in the Purchase Price field for the Linnworks stock item
  • Total Qty Sold = The sum of the quantity items sold during the defined date range either individually or as a composite child
  • Avg Sold Price Ex VAT = The average sold order item price during the defined date range. Each child item in the composition will get an equal share of parent's item price