Customers

Overview
Returns list of all customers with email addresses who placed orders between start and end date specified in the paramaters. You can also specify source and subsource of order to include (to include all leave blank).

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:
    • Start date: From the start of the day for the specified date
    • End Date: To the end of the day for the specified date
  • Source of the order: The channel you wish to display orders from
  • SubSource: This is the specific channel integration you wish to display orders from

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

  • The report searches for customer details 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

  • cFullName: This is the name of the customer, as entered on the order
  • cEmailAddress: Email used for despatching purposes
  • cPostCode: This is the shipping postcode or ZIP code entered on the order
  • BuyerPhoneNumber: This is the customer phone number that is associated with 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
  • TotalSpent: This is the calculated as the sum of all orders made by this customer on this channel
  • Currency: This is the currency of the customer has purchased their orders in
  • cShippingAddress: This is the shipping address, given as a single string
  • Customer ID: This is a Linnworks internal unique ID number for the customer

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

  • cFullName
  • cEmailAddress
  • BuyerPhoneNumber
  • cPostCode
  • Source
  • SubSource
  • cShippingAddress
  • Company
  • Address1
  • Address2
  • Address3
  • Town
  • Region
  • cPostCode
  • cCountry
  • Customer ID