Inventory Movement History

Overview

Sellercloud logs all product inventory movements across Warehouses and warehouse Bins in real-time, ensuring that your quantities are always accurate and up to date. You can easily view and even export each product’s complete movement history on its Inventory Movement page. This page also shows detailed statistics related to inventory changes and the currently available and unavailable quantities, all in one place.

View Inventory Movements

To view all recent inventory movement details for a specific product:

Go to the Product Details Page.
Click Toolbox and select Inventory Movement.
There are three panels on the page:
1. Stats - Shows the current aggregated inventory data.
2. Warehouse Inventory Movements - Shows warehouse movements.
3. Bin Inventory Movements - Shows bin movements.

Refer to the following sections for details about each panel.

This page only displays movement going back to the last time its physical inventory was set. Use the View All Movement action to see the complete history.

Stats

Statistic	Description
Last Physical Inventory	The last recorded change in the physical inventory quantities that have been set Manually or In Bulk across all warehouses. For example: You Set the Physical for Warehouse A to 10. The Last Physical Inventory is 10. You Set the Physical for Warehouse B to 10. The Last Physical Inventory is 20. You Set the Physical for Warehouse A to 5. The Last Physical Inventory is 15.
Total Inventory Change	The cumulative change in the product's inventory caused by Inventory Adjustments, considering all additions and subtractions. For example: You Adjust Warehouse A’s inventory by adding 10. The Total Inventory Change is 10. You Adjust Warehouse B’s inventory by adding 10. The Total Inventory Change is 20. You Adjust Warehouse A’s inventory by adding 5. The Total Inventory Change is 25. You Adjust Warehouse A’s inventory by subtracting 10. The Total Inventory Change is 15.
Calculated Physical Inventory	The sum of the Last Physical Inventory and the Total Inventory Change. It shows the final physical inventory across all warehouses after manual physical updates and adjustments.
Total Reserved	The quantity of the product Reserved for pending orders or other purposes.
Non-Sellable Qty	The quantity of the product stored in Unsellable Warehouses.
Calculated Available Inventory	The current quantity available for sale, calculated by subtracting the Total Reserved and Non-Sellable Qty from the Calculated physical inventory. The calculation is based on the movements shown on this page.
Aggregate Qty (Sellable)	Same as the above, this is also the combined quantity of the product available for sale. However, this quantity is pre-calculated and stored in the system.

Warehouse Inventory Movements

You can use the following filters to show only specific movements:

Filter	Description
Date on	Show only movements that occurred within a specific time range.
SKU	Show only movements of a specific SKU. If the product has Shadows, you can select them here.
Warehouses	Show only movements related to a specific warehouse.
Movement Type	Show only specific movement types.

The panel’s columns show the following data:

Column	Description
SKU	The SKU whose inventory has been moved.
Date	The timestamp of the movement.
Vendor	The vendor associated with the movement.
Company	The company the movement relates to.
Type	The movement type (e.g., Order, PO, Inventory Adjustment).
Qty	The number of units that have been moved.
Details	The ID of the associated entity.
Reason	The reason for the movement.
Warehouse	The warehouse where inventory has been moved.

The panel also includes the following actions on the top right:

Action	Description
Export	Export the product’s inventory movement history to an Excel spreadsheet. The spreadsheet includes one column that the user interface doesn’t - the User column, which shows the email address of the user who performed the movement.
Recalculate Inventory	Sellercloud automatically runs calculations in the background to adjust inventory based on the current orders, POs, and other events that reserve inventory. With this action, you can run this calculation manually instead of waiting for the automatic calculations to take place.
View All Movement	Open the Manage Inventory Movements page, showing all movements associated with the product.
View FBA Movement	Opens the Manage Inventory Movements page, showing all FBA Shipment movements of the product.
View Available Serials	Opens the product’s Serial Numbers page.

Bin Inventory Movements

The bin inventory movements panel only has one action on the top right: Export - Exports the product’s bin movement history to an Excel spreadsheet. The spreadsheet includes four columns that the user interface doesn’t:

Column	Description
Warehouse ID	The unique identification number of a warehouse.
Bin ID	The unique identification number of a bin.
User ID	The unique identification number of a user.
Reference URL	The unique URL pointing to the page where the movement occurred.

You can use the following filters to show specific movements:

Filter	Description
Warehouses	Show only movements related to a specific warehouse.
Warehouse Bin	Show only movements related to a specific bin.
Movement Type	Show only movements of a specific type.
User	Show only movements initiated by a specific user.
Keyword	Show only movements with specific text in the ID, Type, Reference or Notes columns.
Movement Date on	Show only movements that occurred within a specific time range.
Expiration Date on	Show only movements of products whose expiration date is within a specific time range.

The columns show the following data:

Column	Description
ID	The unique identification number of the inventory movement.
Date	The timestamp of the movement.
Type	The movement type (e.g., OrderPicked, PutAway, BinTransfer).
SKU	The SKU whose inventory has been moved.
Qty	The number of units that have been moved.
Total Qty	The number of units currently stored in the bin.
Warehouse	The warehouse where the bin is located.
Bin	The bin involved in the movement.
Reference	The ID of the associated entity.
By	The user who performed the movement.
Notes	Additional information about the movement.
Lot Number	The Lot Number of the moved inventory.
Expiration Date	The expiration date of the product lot.