Customers who bought an item (search)

Overview
This report returns a list of all customers details that ordered items that match the SKU or Title given for the date range given.

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

  • Search Item: This can be either a whole or partial SKU or Item title
  • Date Range:
    • 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

  • The report searches based on order received date for the date range given
  • The search term will match based on a whole or partial match on either the SKU or the Item Title

Reported Values

The following values are returned by the report

Values - Column names and description

  • nOrderId: This is the Linnworks OrderID
  • cFullName: This is the name of the customer, as entered on the order
  • cEmailAddress: Email used for despatching purposes
  • dReceievedDate: The date and time at which the order was placed on the sales channel
  • dProcessedOn: The date and time at which the order was processed in Linnworks
  • cPostCode: This is the shipping postcode or ZIP code entered on the order
  • 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
  • cCountry: Country of the address used when the order was despatched
  • Address1: Address line 1 used when the order was despatched
  • Address2: Address line 2 used when the order was despatched
  • Address3: 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
  • BuyerPhoneNumber: This is the customer phone number that is associated with the order
  • Company: Company name used for despatching purposes
  • OrderItemNumber: This is the SKU used on the channel for this order item, which may differ from the standard Linnworks Item Number
  • SKU: The SKU / Item number for the Linnworks inventory item
  • ItemTitle: The title for the Linnworks inventory item (found on the General tab)
  • OriginalItemTitle: This is the title of the item that the order has been downloaded with
  • Quantity: This is the quantity of the order item on the order