Describes the reports available in the Inventory section of the Insights > Reports page in ShipStation.
The Inventory Reports pull data specific to ShipStation's internal inventory solution. These reports do not reference inventory levels maintained by connected marketplaces, selling channels, or other third-party services.
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. |
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. |
-
Scroll down to the Inventory Reports section and choose Inventory Audit Report.
-
Choose Inventory Warehouse from the drop-down menu, set Date Range ShipDate) , and enter the Specific SKU.
-
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).
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. |
-
Scroll down to the Inventory Reports section and choose Inventory Out-of-Stock Shipments Report.
-
Choose Inventory Warehouse from the drop-down menu, set Date Range ShipDate) , and enter the Specific SKU .
-
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).
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. |
-
Scroll down to the Inventory Reports section and choose Inventory Status Report.
-
Select which Inventory Warehouse(s) and choose Yes or No for the Group Products By Parent SKU drop-down menu.
-
Select your preference for how to receive the report (Run Report, Export to PDF, Export to Excel, Export to Text).