Order Totals Between Dates

This report lists the Orders placed between the 2 specified Dates. This includes Selling Channel details, if it is processed and Postal Information if it has been shipped.

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 falls between the given dates, based on received date (date placed on originating sales channel), will be included in this report

Reported Values

The following values are returned by the report

Values - Column names and description

  • Country: Country of the address used when the order was despatched
  • status: This is the status of an order, which can be: Unpaid, Paid, Return, Pending or Resend
  • Processed: This shows whether the order has been processed in Linnworks
  • 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
  • Currency: This is the currency used on the order or set in the channel config for that sales channel
  • PostageCosts: The shipping cost, as downloaded from the channel
  • Subtotal: This is the sum of all the line costs for the order, exclusive of tax
  • PostageCostExTax: This is the shipping cost excluding tax
  • CountryTaxRate: This is the tax rate specified in the country list (Settings > Application Settings > Manage Country List). If no tax rate is given for the order country then the system default rate is used
  • Total: This is the total cost of the order including tax and postage
  • Tax: This is the total amount of tax paid on the order

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

  • Country
  • status
  • Processed
  • Source
  • SubSource
  • Currency
  • CountryTaxRate