Viewing inventory

You can view, search, sort, manage, and filter your inventory on the Inventory page of your Shopify admin, and display, hide, and reorder the columns. You can track your Available, Unavailable, and On hand inventory states across all your locations.

Every product variant is listed at each of your active locations, even those locations that don't fulfill the variant. A variant can have stock at a location even when you don't fulfill orders from there. At those locations, you can still view and update the On hand quantity, but the Available quantity displays a dash because the location isn't used for new orders. The on hand stock can still fulfill orders that were already committed to the location. To change which locations fulfill a variant, you can assign inventory to locations.

Filtering product inventory

You can filter your product inventory on the Inventory page of your Shopify admin. Filtering your inventory list can help you find the specific inventory that you need to review or update.

All filters display in-line in the search bar, so you get a full view of the criteria influencing your search results. You can also use is/is not and or/and logical operators to create more advanced views with specific filter criteria.

Product inventory filters

By default, all of your inventory displays on the Inventory page of your Shopify admin. You can filter this list to display a smaller subset of inventory.

Review the following table to learn more about the available inventory filters.

Inventory filters and their descriptions
FilterDescription
Sales channelFilter inventory by the sales channels where products are available.
Product typeFilter inventory by product category or type.
Product vendorFilter inventory by the supplier or manufacturer of the product.
Bin nameFilter inventory by bin location name where products are stored.
Tagged withFilter inventory by product tags.
IncomingFilter inventory by incoming quantity amounts.
CommittedFilter inventory by committed quantity amounts.
AvailableFilter inventory by available quantity amounts.
On handFilter inventory by on hand quantity amounts.
UnavailableFilter inventory by unavailable quantity amounts.

Filter product inventory

  1. From your Shopify admin, go to Products > Inventory.

  2. Optional: Click All to open the view menu, and then select the view that you want to filter.

  3. Select an operator and value for your filter. The available values are different depending on the filter that you select.

  4. Optional: Continue typing keywords to continue adding different filters and values to refine your search:

    • To include an additional filter with an and operator to your search, click Plus Circle Icon or add a space, and then start typing the name of the additional filter that you want to include.
    • To include an additional value with an or operator to a filter, add a comma, and then start typing the name of the additional value that you want to include.
  5. Optional: Click the filter tags of any filter in the search bar to edit the filter.

  6. Optional: To save your current sequence of filters as a new view, click Save > Save as new view.

Searching product inventory

You can search for inventory based on words in the product details, such as product title, description, or options. To search on the Inventory page, use the search bar to enter the specific search terms.

Saving an inventory search or filtered inventory list

When you filter or search for inventory, you can save the filter or search to use it again later.

After you set up your filters or search for words, click Save as to give your search a name, and then click Save view.

The next time that you need to perform the same filter or search, click or tap the tab that's labeled with the search view name. The inventory list will immediately update with the subset of inventory.

Customizing your inventory page using columns

You can customize your Inventory page by choosing which columns you want to display or hide. For example, if you don't use SKUs in your inventory, then you can hide the SKU column. You can't edit the Product column.

Product inventory columns

By default, all inventory columns display on the Inventory page of your Shopify admin. You can choose to display, hide, and reorder columns.

Review the following table to learn more about the inventory transfer columns.

Inventory page columns and their descriptions
ColumnDescription
ProductDisplays the product name and variant details.
SKUDisplays the stock keeping unit (SKU) for the variant.
UnavailableDisplays the quantity of inventory that's on hand but not available for sale.
CommittedDisplays the quantity of inventory that's reserved for orders.
AvailableDisplays the quantity of inventory that's available for sale. Click this field to adjust inventory by specifying origin and destination.
On handDisplays the total quantity of physical inventory at the location. Click this field to adjust inventory by specifying origin and destination.
IncomingDisplays the quantity of inventory that's expected to arrive from transfers or purchase orders.
Bin nameDisplays the bin location name where the inventory is stored at the selected location.

Adjust product inventory columns

  1. From your Shopify admin, go to Products > Inventory.

  2. Optional: Click All to open the view menu, and then select the custom view that you want to edit the columns for.

  3. Click the Layout Columns 3 icon to open the display option panel.

  4. In the Columns section, customize your view's columns by doing any of the following actions:

    • To hide a column, click View.
    • To unhide a column, click Hide.
    • To rearrange a column, click Drag handle and drag the column up or down.
  5. Optional: To permanently apply the column order to your custom view, click Save > Update view.

Sorting inventory

You can sort your inventory listed on the Inventory page of your Shopify admin. You can choose from different sort options.

Product inventory sort options

By default, product inventory is sorted by product title.

You can change the sort order of your inventory list to any of the following options:

Inventory page sorting options
Sorting optionSort orderDescription
Product titleA-Z or Z-ASorts products alphabetically by product name.
SKUAscending or DescendingSorts products by SKU in alphanumeric order.
Bin nameA-Z or Z-ASorts products alphabetically by bin location name.
IncomingLowest to highest or Highest to lowestSorts products by incoming inventory quantity.
UnavailableLowest to highest or Highest to lowestSorts products by unavailable inventory quantity.
CommittedLowest to highest or Highest to lowestSorts products by committed inventory quantity.
AvailableLowest to highest or Highest to lowestSorts products by available inventory quantity.
On handLowest to highest or Highest to lowestSorts products by on hand inventory quantity.

Sort your product inventory

  1. From your Shopify admin, go to Products > Inventory.

  2. Optional: Click All to open the view menu, and then select the custom view that you want to review the sort order for.

  3. Click the Layout Columns 3 icon to open the display option panel.

  4. Click the Sort Sort by menu, and then select a sort criteria option, as well as a sort order.