Order Cancellation - Detailed

Overview
This report shows any orders that have been marked as Cancelled in Linnworks between the dates specified. This includes any refunded amounts.

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

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

  • Any order that was cancelled and falls between the given dates, based on received date, will be included in this report

Reported Values

The following values are returned by the report

Values - Column names and description

  • nOrderId: This is the Linnworks OrderID
  • 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
  • Reference Number: This is the reference number assigned by the sales channel for the order
  • External Reference Number: This is an additional reference number from the sales channel, typically used by eBay
  • cEmailAddress: Email used for despatching purposes
  • cFullName: This is the name of the customer, as entered on the order
  • cCountry: Country of the address used when the order was despatched
  • OrderDate: The date and time at which the order was placed on the sales channel
  • CancelDate: The date on which the order was cancelled
  • TotalCost: This is the total cost of the order including tax and postage
  • Currency: This is the currency used on the order or set in the channel config for that sales channel
  • Refunded: This is the amount to be refunded to the customer
  • Note: This is a text note that was added at the point the item was cancelled