Order Details Between Dates

Overview
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, 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
  • ReferenceNum: This is the reference number assigned by the sales channel for the order
  • ExternalReference: This is an additional reference number from the sales channel, typically used by eBay
  • Company: Company name used for despatching purposes
  • 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
  • dReceievedDate: The date and time at which the order was placed on the sales channel
  • 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
  • ProcessedDate: The date and time at which the order was 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 as defined in Application Settings > Manage Country List
  • 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
  • OrderItemSKU: The SKU / Item number for the Linnworks inventory item
  • OrderItemId: The SKU / Item number for the Linnworks inventory item that was ordered
  • OrderItemTitle: The title for the Linnworks inventory item (found on the General tab)
  • ItemCategory: The Linnworks category assigned to the Linnworks inventory item (found on the General tab)
  • OrderItemQuantity: This is the quantity of this SKU on the order
  • OrderItemSalesTax: This is the amount of tax paid on the item in the order
  • OrderItemTaxRate: This is the tax rate for this time
  • OrderItemCostExTax: This is the quantity of the order item multiplied by the unit cost of the item
  • OrderItemCostIncTax: This is the retail price for this item, including tax, multiplied by the quantity ordered
  • DispatchStockUnitCost: This is a purchase price that is calculated based on the average of purchase orders raised for the item through Linnworks
  • TotalWeight: This is the total weight of the order, including packaging
  • PurchasePrice: The purchase price defined for the Linnworks inventory item (found on the General tab). Please Note! If Default Supplier is selected for the item then the price will be taken from the Default Supplier.
  • TrackingNumber: This is the tracking number that has been associated with the order
  • PostalService: This is the Linnworks Postal Service that has been assigned to the order
  • Payment Method: This is the Linnworks payment method that has been applied to the order