Inventory

The OMS inventory management functionality provides powerful fulfilment and inventory capabilities, including an easy-to-use interface that allows you to track and understand stock movements across all sources (warehouses and physical stores).

Inventory menu in Admin

Inventory menu in Admin

More information on inventory and stock snapshots can be found in the stock-sourcing section .

Source Stock

This page displays an overview of the current available quantities of a specific stock keeping unit (SKU) for each source:

Source Stock

Source Stock

The only options that appear in this page are the ones which have received stock information (at least once).

Keep in mind that you can filter this list by the SKU, as well as order the columns by pressing each column header. In this view, you can see the different quantities and specific history of each SKU in a source:

Field Description
SKU Refers to the Stock Keeping Units of an item. A single product with lists of options for each variation. However, each option represents a separate, simple product with a distinct SKU, which makes it possible to track inventory for each variation.
On Hands Quantity Available quantity of an item physically in a source.
Hard In-flights Quantity Stock reserved by orders already sourced but not yet confirmed as acknowledged by the logistic provider.
History specific history of each SKU in a source.

In this history field, a link shows you the history of all stock changes in that specific SKU:

Item History

Item History

An important functionality in this page is the ability to export all the details of your Source stock to a CSV or XML file by clicking Export:

Export Source stock

Item History

Keep in mind that this export is automatically sent to the email of the logged-in user.

Aggregate Stock

This page displays the result of the stock aggregation by source. This page shows the full aggregation of the different sources for a store:

Stock Aggregate view

Stock Aggregate

Your OMS needs to run a reindex every time new stock quantities are received from the logistics provider, so that the stock available to sell is correctly calculated and exported to the selling platforms. This process executes the following steps:

  1. Quantities imported with the inventory message magento.inventory.source_stock_management are saved in the source stock repository as On Hand quantities.
  2. Aggregation of stock for each one of the sources associated to the stock aggregate (for example, WEB1 is associated to SOURCE1 and SOURCE2. The quantities for both sources are aggregated).
  3. All in-flight orders for the stock aggregate are decreased. IN-FLIGHT: all lines that are in between the stock allocation and the LSP confirmation (for clients not sending the received by LSP then is once the line is shipped).
  4. The safety stock quantity for all the sources associated to the stock aggregate are summed and decreased from the quantity to be exported.
  5. Quantities available to sell are exported via the message magento.inventory.aggregate_stock_management.updated

In this view, you can see the different quantities and specific history of each SKU in a source:

Field Description
Item style code Refers to the code for that product.
Option client SKU A single product with lists of options for each variation. However, each option represents a separate, simple product with a distinct SKU, which makes it possible to track inventory for each variation.
Status State of the item.
Name Name in store of the item.
Soft in-flight quantity Stock reserved by orders not yet sourced.
Available quantity Available quantities of that item.
Stock trace Traces the stock quantities for that specific Option client SKU.
History specific history of each SKU in a source.

In this history field, a link shows you to the history of all stock trace for that specific item code:

Item History

Item History

Same as in the Aggregate stock view, you can view the trace for that specific item by clicking View Trace.

Stock Trace View

Either from this History view or from the stock aggregate page, you can access the Stock trace view of a specific item by clicking View in the Stock trace column. Once you access the Stock trace page, you can see the following Stock trace details for that specific item in the desired Store (and related sources):

Stock trace

Item History

  • Source
  • Warehouse quantity
  • Safety Stock
  • In-flight
  • Available from Source

In this view, it is important to highlight that you can see a header which recaps the following details:

  • Total aggregate quantities: This is the total amount of stock available for each source.
  • Aggregate safety stock: Safety stock at aggregate level.
  • Soft allocated in-flight: All lines that are in between the stock allocation and the LSP confirmation. Stock reserved by orders not yet sourced.
  • Available for sale: Total available for sale.

Manual Stock Update

The manual stock update will trigger a reindex for the modified sku and will generate a magento.inventory.aggregate_stock_management.updated message. Take into account that the next stock snapshot is updated automatically by your OMS, and overwrites the values previously edited manually.

You have to select Source to Update, then describe the reason, and indicate the SKU and the quantity. Finally, press Update.

Manual Stock Update

Alt Text