Search Serial Number

Overview
This report will return all orders that contain items that had serial numbers associated with the order item when the order was despatched.

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

  • Serial Number: This is the serial number entered during the dispatch process
    • For more information on requiring serial numbers during despatch, please see our documentation

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

  • Only order items that contain serial numbers will be included in the report
  • Orders for composite items that contain items that required serial numbers will display information for the composite item with the serial number column displaying the child item's serial number
  • If an order had a quantity of more than 1 for an SKU with serial number requirement, there will be a line for each on the 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 a secondary reference number from the sales channel, typically used by eBay
  • cFullName: This is the customer's full name for the purposes of shipping
  • cEmailAddress: This is the email address as entered on the order
  • 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: This is the shipping destination country
  • status: 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
  • ProcessedDate: This is the date and time at which the order was processed in Linnworks
  • Source: This is the sales channel the order was placed on
  • SubSource: This is the specific integration the order was placed on
  • Currency: This is the currency the order was made in
  • PostageCosts: This is the postage cost paid by the customer for the order
  • Subtotal: This is the total of all the order items, before discounts and postage costs
  • PostageCostExTax: This is the postage cost excluding the tax
  • CountryTaxRate: This is the tax rate applied to the order
  • Total: This is the final total of the order, including taxes and applicable discounts
  • Tax: This is the total amount of tax paid on the order
  • OrderItemSKU: This is the Linnworks stock item SKU or the Channel SKU if the order is for an unlinked item
  • OrderItemId: This is the Item Id that was specified in the order
  • OrderItemTitle: This is the title of the Linnworks stock item
  • ItemCategory: This is the Linnworks category associated with the order item
  • OrderItemQuantity: This is the quantity of the order item on the order
  • OrderItemSalesTax: This is the tax associated with the order item
  • OrderItemTaxRate: This is the tax rate applicable to the order item
  • OrderItemCostExTax: This is the line cost on the order excluding tax
  • OrderItemCostIncTax: This is the line cost on the order including taxes
  • DispatchStockUnitCost: This is the unit cost at the time of despatch
  • Serial Number: This is the serial number of the order item in the order that required a serial number