Product Serials Report

Overview

In this article, you will learn about Sellercloud’s Product Serials Report. This report allows you to track the history of product activity (POs, orders, and FBA inbound shipments) associated with specific Serial Numbers. The report consists of data columns that display the following information:

  • Product Details: SKU, Serial Number, History, Status, and Last Cycle Count Date.
  • PO Details: PO Number, Date Ordered, Vendor Name, Purchase Price, *PO Receive ID, *Vendor ID, Receiving Warehouse, *Receiving Warehouse ID, Bin Name, and Credit Memo Number. 
  • Order Details: Order Number, Order Date, and *Unit Price.
  • FBA Shipment Details: FBA Shipment Number, Ship From Warehouse, and *Ship From Warehouse ID.
The report’s grid can display up to 13 data columns at a time. However, Spreadsheet Exports always contain all data columns, including ones that may not appear in the grid by default. The spreadsheet-only columns are marked with an asterisk in the list above. Refer to the Data Columns section for more details.

Product Serials Report

Client Setting Enable Serial Number Validation must be enabled for this workflow! Enabling this setting ensures that serial numbers are properly tracked and managed within the Sellercloud UI.

To access the report:

  1. Go to Inventory > Tools > Product Serial Report.
  2. Optionally, set up the Default filters. See the Filters section of this article for details.
  3. Click Search. Each filter you apply gets highlighted in a distinct green color. If a filter is gray or not displayed at all, it’s not active.
  4. Click on a PO # to be directed to the PO Details page where it was received and History to view the serial number’s history.

Customize Columns

To manage the data columns in the report: 

  1. Click the three dots icon on the top right.
  2. Select Customize Columns.
  3. Now you can manage the report’s data columns:

    1. To reorder columns, drag them up or down in the list.
    2. To hide columns, click the Trash icons.
    3. To add columns, click Add column.

Sort Data

By default, the report is sorted by Date Ordered, which is the date when the associated PO was placed. To sort the report data differently: 

  • Click the Sort by menu on the right and select another data column.
  • Click the icon next to the Sort by menu to switch the sorting order.

Save View

To save your filter, columns, and sorting setups:

  1. Set up the filters and customize the columns on the page.
  2. Click Save view.
  3. Type a Name and click Save.
  4. You can now access your saved view by selecting it on the top right.

Export

To export the report to a spreadsheet: 

  1. Select your desired serial number/s from the grid.
  2. Access the Actions menu in the bottom right.
  3. Select Export to Excel.

Filter and Column Definitions

This section defines the filters and data columns that let you tailor the report according to your needs. 

Filters

The report can be customized to show specific data with these filters:

ThingDescription
SKUShow only one or more SKUs.
SerialShow only one or more Serial Numbers.
Bin NameShow only serial numbers in a specific Warehouse Bin.
In Stock OnlyShow only serial numbers that are in stock.
On Cycle Count StatusShow only serial numbers included in a Cycle Count report.
WarehouseShow only products stored in one or more Warehouses.
Cycle Count DateShow only serial numbers included in a Cycle Count report within a specified date range.

Data Columns 

The report’s web interface can display the following data columns:

ThingDescription
SKUThe product’s unique SKU.
Serial NumberThe product’s Serial Number.
PO #The number of the PO where the product was ordered.
Date OrderedThe date when the PO was ordered.
Vendor NameThe associated Vendor’s name.
Purchase PriceThe SKU’s Unit Price on the PO.
Receive WarehouseThe warehouse where the product was received.
Ship WarehouseThe warehouse from which the product was shipped.
Bin NameThe specific location or bin within a warehouse where the product was received.
StatusThe status of the product: In Stock, Returned To Vendor, or Shipped To Client.
HistoryThe records of the serial number’s movement history over time.
Credit Memo #The reference number of the associated credit memo issued for the product.
FBA Shipment #The reference number of the associated FBA Inbound Shipment.
Last Cycle Count DateThe date of the most recent cycle count for the product.
Order #The associated order number.
Order DateThe date when the order was placed.

When you export to a spreadsheet, you also get the following columns:

ThingDescription
PurchaseReceiveIDThe reference number of the associated PO Receiving.
VendorIDThe reference number of the associated Vendor.
SaleOrderTimeThe date when the associated order was placed.
SaleOrderPriceThe unit price of the product on the associated order.
SerialReceiveWarehouseIDThe unique ID number associated with the receiving warehouse.
ShipFromWarehouseIDThe unique ID number associated with the Ship From warehouse.
See Serial Numbers to learn how to manage serial numbers with Skustack.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support