Inventory Movement History


Overview

Sellercloud stores all activities associated with any inventory movement across warehouses. All movements of the product’s inventory are available from the related product’s Inventory Movement page.


Access Inventory Movement Page

  1. Go to Inventory > Manage Inventory.
  2. Open the SKU whose inventory movement history you want to display.
  3. Click Toolbox and select Inventory Movement.
  4. There are three panels:
    1. STATS
    2. Warehouse Inventory Movements
    3. Bin Inventory Movements

STATS

  1. The STATS panel reflects the current aggregated data of the selected product.
    Stats Panel of Inventory Movement Page

Warehouse Inventory Movements

  1. The Warehouse Inventory Movements panel lists all the movements of the selected product for non-bin warehouses, including those related to Orders, Purchase Orders, FBA Shipments, Inventory Adjustments, etc.Warehouse Inventory Movements
  2. Refer to the table below for details.
    COLUMN HEADER DEFINITION
    SKU Displays the SKU of the selected product
    Date The timestamp of the particular movement
    Vendor Displays the vendor with which the movement is associated.
    Company The name of the company the inventory movement relates to.
    Type Reflects the movement type (e.g., Order, PO, Inventory Adjustment).
    Qty Shows how many product units have been moved.
    Details Displays the ID of the associated entity (e.g., Order, PO, Shipment).
    Reason Shows the cause(s) of inventory movement.
    Warehouse Reflects the affected warehouse for this inventory movement.
  3. You can filter out the records using the top filter options.
  4. Alternatively, you can access details on movement operations by clicking the three dots icon and selecting the relevant option.
    Movements Filter Options
    Clicking View All Movement will yield the Manage Inventory page, adjusted specifically to the product with all associated movements displayed.
    Clicking View FBA Movement will yield the Manage Inventory page, adjusted specifically to the product with all associated FBA Shipments displayed.
    Clicking View Available Serials will yield the product’s Serial Numbers page.

Bin Inventory Movements

  1. The Bin Inventory Movements panel reflects all the movements in each warehouse bin.
    Bin Inventory Movements
  2. Refer to the table below for details.
    COLUMN HEADER DEFINITION
    ID The identifier of inventory movement
    Date The timestamp of the movement.
    Type Reflects the movement type (e.g., OrderPicked, PutAway, BinTransfer).
    SKU Displays the SKU of the selected product.
    Qty Shows how many units have been moved.
    Total Qty Shows the total number of units that are currently stored in the warehouse bin.
    Warehouse Reflects the affected warehouse for this inventory movement.
    Bin Reflects the affected warehouse bin for this inventory movement.
    Reference Displays other external documents associated with inventory movement.
    By Displays the username who performed the inventory movement.
    Notes Contains additional information on inventory movement.
  3. You can filter out the records using the top filter options.

The Inventory Movement Page shows any changes to the inventory of a product including quantities subtracted or added by orders, purchase orders, FBA shipments, inventory adjustments, etc… This is an easy way to track your quantities and check if some of them are reserved or not sellable.

Details

When opening the SKU’s Summary Page you can find the View Movement link next to the Aggregate Qty.

  • ProductID – This list will include the SKU and its shadows
  • Warehouse – You can filter per warehouse, all warehouses are included
  • Type – You can filter inventory change by PO, Order… etc.
  • Date – Set the date range
  • Columns on the right – Those columns will display the reserved, non sellable, available quantities. It is important to mention the Last Physical Inventory record. Hovering over this number will show you the last date when the physical inventory was reset. Resetting the physical inventory clears all the movement data for this SKU and starts a new record. Every change you see is based on that starting quantity that was entered when the physical inventory was reset.
  • List of records – This list shows all 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.
  • Action Menu – The Action Menu has some useful options like exporting the records or showing Reserved Orders. It is important to mention the Recalculate Inventory option. Inventory recalculations run in the background of SellerCloud and adjusts the inventory based on the current orders, POs…etc. that may reserve inventory. If you notice any dependencies to your quantities you can run this calculation manually from here instead of waiting for the background calculations to take place.

FBA Movement

Product that are Fulfilled by Amazon will have separated movement history. The link to that page is on the top of the Inventory Movement Page. The fields are similar to the one described above and the info comes from the Amazon FBA inventory reports.

View All Movement

View All movement can be accessed at the link on top of the Inventory Movement Page. This will include all inventory changes from the point this SKU was created, ignoring the Last Physical Inventory Set. This page is useful to check for older records, but it will not show you the accurate current calculations since they are based on the Last Physical Inventory Set.

Product Warehouse

The Product Warehouse link shows all the warehouses you have set in SellerCloud 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.

Additional options available in the Product Warehouse page:

  • Adjust Inventory – A detailed article can be found here.
  • Transfer Inventory – A detailed article can be found here.
  • Set Physical Inventory – A detailed article can be found here.

Was this article helpful?

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