Insights Reports: Inventory

The Inventory Reports pull data specific to ShipStation internal inventory solution. These reports do not reference inventory levels maintained by connected marketplaces, selling channels, or other third-party services.

The inventory reports are marked.

Inventory Low Stock Report

The Inventory Low Stock Report will provide you with a list of products whose stock count is at or below the reorder threshold set in the product defaults.

Required Filters:

  • Group Products By Parent SKU

Field

What does it mean?

SKU

Item SKU for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead.

Product Name

Item Name for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead.

Stock

Total Stock count for the product or Parent product.

Allocated

Amount of the product or Parent product placed in orders that are currently Allocated.

Available

Total Stock count minus Allocated.

Re-Order Threshold

The Reorder Threshold set in the product defaults for the product or Parent product.

Shortage

Available divided by Re-Order Threshold as a percentage.

Run an Inventory Low Stock Report

Inventory Audit Report

The Inventory Audit Report provides a list of any stock changes that occurred within a selected time frame.

Required Filters:

  • Date Range (Action Date) (Start Date and End Date)

Optional Filters:

  • Specific SKU

Field

What does it mean?

SKU

Item SKU for the product.

Product Name

Item Name for the product.

Event Date/Time

Date and time when the action occurred.

Type

Action that occurred.

Quantity

Amount to which total stock count changed.

Stock

Total stock count after action occurred.

User

User who initiated the action.

Description

The Note entered during the action. Only available when adjusting stock manually through product defaults.

Run an Inventory Audit Report

Inventory Out-of-Stock Shipments

The Inventory Out-of-Stock Shipments report lists shipments created with out-of-stock products in the order.

Required Filters:

  • Date Range (Action Date) (Start Date and End Date)

Optional Filters:

  • Specific SKU

Field

What does it mean?

Tracking #

Tracking Number for the shipment.

Order #

Order Number for the order linked to the shipment.

Ship Date

Ship Date for the shipment.

User

Full Name of the user who created the shipment.

Action

Action(s) taken by the user when creating the shipment.

SKU

Item SKU for the out-of-stock product.

Name

Item Name for the out-of-stock product.

Qty

Line Item Quantity of the out-of-stock product.

Run an Inventory Out-of-Stock Shipments Report

Inventory Status Report

The Inventory Status Report provides inventory stock counts for a list of products that have an assigned inventory location.

Required Filters:

  • Group Products By Parent SKU

Field

What does it mean?

SKU

Item SKU for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead.

Product Name

Item Name for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead.

Last Cost

Cost amount entered the last time stock count was adjusted.

Avg Cost

Average Cost amount when stock count is adjusted.

Stock

Total Stock count for the product or Parent product.

Allocated

Amount of the product or Parent product in currently Allocated orders.

Available

Total Stock count minus Allocated

Re-Order Threshold

Reorder Threshold set in product defaults for the product or Parent product.

Run an Inventory Status Report