Inventory is the stock of goods across locations. This article shows you how to manage Inventory in Fabric OMS.

OMS Inventory Screen

  • Stock-Keeping Unit ID (SKU ID) is the unique, alphanumeric ID associated with each individual product. This is often captured as a scannable barcode.

  • A product is "in stock" when there is available inventory, which can be delivered to a customer from an eligible warehouse.

  • A product is "in transit" when it is ordered and fulfilled but not yet arrived at an eligible warehouse. In transit product does not count as an in stock inventory.

  • A product is "out of stock" when there is no available inventory that a customer can receive from an eligible warehouse.

  • A product is "reserved" when it is allocated to an order.

  • Available stock is calculated by removing "reserved" stock from "in stock" stock.

The Inventory Overview page is populated with a list of all items in inventory.  Use the search field to easily find the items you want to check. 

Available stock and In transit counts are available on the Inventory Overview page.

Inventory overview
Inventory overview

Click on an Item to view the Item detail screen.  Inventory details are available by channel, status, and warehouse. 

Inventory details
Inventory details

Update or add inventory using OMS CSV import

  1. Click Import in the upper left of the Inventory Overview page.
  2. Download a template to view an example of a CSV file where the columns are defined.
    • In the CSV file, make sure all the following fields are filled in the template.
    • Only alphanumeric characters and numbers are allowed; no blank spaces, returns, line breaks or other characters.
    • Always save the file as a CSV format. Make sure the name of the file does not contain any spaces.
  3. Attach the CSV file in the OMS Inventory page
  4. Click Upload file.

Note: Inventory cannot be updated manually in Copilot at this time.  Inventory must be added through csv file import.

Inventory Import CSV file module
Inventory Import CSV file module

AttributeData TypeDescriptionRequirement

SKU

String

Unique identifier for the product or item.

Required

Total Quantity

Integer

The total amount of product.

Required

Reserved Quantity

Integer

For first upload, this must be zero "0".

For subsequent updates, use the reserved number from the inventory item details page.

Required

Location ID

Integer

Warehouse ID.

Required

Type

String

This can be either "Stock" or “Transit” if the inventory is in transit.

Required

Channel ID

Integer

The channel ID must be either "12" (USA Web) or "13" (Canada Web).

Required

Transit Ref

Integer

The transit reference number

Optional

Transit Order Date

Date

The transit order date in UTC Format yyyy-mm-ddThh:mm:ss.sssZ

This date has to be prior than Transit Stock Date

Required if the Type = Transit

Not required when Type = Stock

Transit Stock Date

Date

The transit stock date in UTC Format yyyy-mm-ddThh:mm:ss.sssZ

Required if the Type = Transit

Not required when Type = Stock

 

Example:

SKUTotal QuantityReserved QuantityLocation IDTypeChannel ID

CERT-ET

105

0

109

Stock

12

1. Navigate to Inventory Overview page.

2. Click on the History link.

3. Click Import History.

4. Check Inventory History.

Note: Click an import ID with an error for information on why the inventory was not uploaded properly.

 

Inventory history
Inventory history

Last update: Aug 30, 2021

Have any questions?
Let's Talk.