Sales Totals by SubSource (Processed)

This report shows sales totals including postage, grouped by SubSource and Currency for processed orders

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

  • This report returns all orders that are processed between the given dates

Reported Values

The following values are returned by the report

Values - Column names and description

  • 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
  • OrderCount: This is the number of orders from this SubSource
  • nstatus: This is a number between 0 and 4 that represents the state of an order:
    • 0 = Unpaid
    • 1 = Paid
    • 2 = Return
    • 3 = Pending
    • 4 = Resend
  • RevenueIncPostage: This is the sum of all order totals between the given dates
  • RevenueExcPostage: This is the sum of all order totals, with the total postage cost subtracted, between the given dates
  • Postage: The shipping cost, as downloaded from the channel
  • Currency: This is the currency used on the order or set in the channel config for that sales channel

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

  • Source
  • SubSource
  • Currency
  • nStatus