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 inventory movement details for a specific product:

  1. Go to the Product Details Page.
  2. Click Toolbox and select Inventory Movement.
  3. 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.

Stats

StatisticDescription
Last Physical InventoryThe 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 ChangeThe 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 InventoryThe 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 ReservedThe quantity of the product Reserved for pending orders or other purposes.
Non-Sellable QtyThe quantity of the product stored in Unsellable Warehouses.
Calculated Available InventoryThe 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:

FilterDescription
Date onShow only movements that occurred within a specific time range.
SKUShow only movements of a specific SKU. If the product has Shadows, you can select them here.
WarehousesShow only movements related to a specific warehouse.
Movement TypeShow only specific movement types.

The panel’s columns show the following data:

ColumnDescription
SKUThe SKU whose inventory has been moved.
DateThe timestamp of the movement.
VendorThe vendor associated with the movement.
CompanyThe company the movement relates to.
TypeThe movement type (e.g., Order, PO, Inventory Adjustment).
QtyThe number of units that have been moved.
DetailsThe ID of the associated entity.
ReasonThe reason for the movement.
WarehouseThe warehouse where inventory has been moved.

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

ActionDescription
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 InventorySellercloud 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 MovementOpens the Manage Inventory Movements page, showing all FBA Shipment movements of the product.
View Available SerialsOpens 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:

ColumnDescription
Warehouse IDThe unique identification number of a warehouse.
Bin IDThe unique identification number of a bin.
User IDThe unique identification number of a user.
Reference URLThe unique URL pointing to the page where the movement occurred.

You can use the following filters to show specific movements:

FilterDescription
WarehousesShow only movements related to a specific warehouse.
Warehouse BinShow only movements related to a specific bin.
Movement TypeShow only movements of a specific type.
UserShow only movements initiated by a specific user.
Keyword Show only movements with specific text in the ID, Type, Reference or Notes columns.
Movement Date onShow only movements that occurred within a specific time range.
Expiration Date onShow only movements of products whose expiration date is within a specific time range.

The columns show the following data:

ColumnDescription
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 QtyThe number of units currently stored in the bin.
WarehouseThe warehouse where the bin is located.
BinThe bin involved in the movement.
ReferenceThe ID of the associated entity.
ByThe user who performed the movement.
NotesAdditional information about the movement.
Lot NumberThe Lot Number of the moved inventory.
Expiration DateThe expiration date of the product lot.

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 inventory movement details for a specific product:

  1. Go to the Product Details Page.
  2. Next to the product’s Aggregate Qty field, click the View Movement link.
  3. Clicking the link opens the product’s Inventory Movement history page.
  4. The page consists of four key parts:
    1. The Links to other pages on top, above the filters and stats.
    2. The Stats on the right show the current aggregated inventory data.
    3. The Filters on the left control what the grid below shows.
    4. The Grid at the bottom shows the movement data since the Last Physical Inventory. You can check the date, channel, type of movement, warehouses, and quantities. Any orders, POs, or Shipments will have a direct link.

The following links are at the top of the page:

LinkDescription
Product WarehouseShows all warehouses and the current quantities this SKU has in any of them. Here, you can also see all the shadows of this SKU and their quantities. At the bottom of the Product Warehouses page, there are the options to Adjust Inventory, Transfer Inventory, and Set Physical Inventory.
View All MovementSee all inventory changes from when this SKU was created, ignoring the Last Physical Inventory. This page is useful for checking older records, but it will not show you the current calculations since they are based on the Last Physical Inventory.
View FBA MovementOpens the FBA Movement page, showing all FBA Shipment movements of the product.
View WFS MovementOpens the WFS Movement page, showing all WFS Shipment movements of the product.
View Available SerialsOpens the product’s Serial Numbers page.

Stats

The following inventory statistics about the product are available on the page:

StatisticDescription
Last Physical InventoryThe 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 ChangeThe 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 InventoryThe 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.
Reserved (Unshipped)The quantity of the product Reserved for pending orders or other purposes.
Non-Sellable QtyThe quantity of the product stored in Unsellable Warehouses.
Calculated Available InventoryThe 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.

Filters

You can apply the following filters to narrow down the results in the grid:

FilterDescription
ProductIDShow only the movements of a specific SKU. If the product has Shadows, you can select them here.
WarehouseShow only movements related to a specific warehouse.
TypeShow only specific movement types.
DateShow only movements that occurred within a specific time range.

Grid

The grid’s columns show the following data:

ColumnDescription
SKUThe SKU whose inventory has been moved.
DateThe timestamp of the movement.
VendorThe vendor associated with the movement.
ChannelThe channel associated with the movement.
CompanyThe company the movement relates to.
TypeThe movement type (e.g., Order, PO, Inventory Adjustment).
DetailsThe ID of the associated entity.
QtyThe number of units that have been moved.
Parent SKUThe parent SKU associated with the movement.
PriceThe SKU’s price associated with the movement.
CostThe SKU’s cost associated with the movement.
Adjustment ReasonThe reason for the movement.
WarehouseThe warehouse where inventory has been moved.

The panel also allows you to perform the following actions:

ActionDescription
ExportExport the product’s inventory movement history to an Excel spreadsheet.
Recalculate InventorySellercloud 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 the calculation manually.
View Reserved OrdersView a list of open orders currently reserving some of the product’s inventory.

Was this article helpful?

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