View: Current Inventory Levels

This article will help you learn about the fields available in the Current Inventory Level view, the field types, descriptions and how the fields are calculated

Key Topics

Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

View Definition

This view is linked to the [uos.inventory_levels] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.


Field Name Field Type Description Source / Calculation
Inventory Location Dimension Name from the Location table where the inventory is location location_name
Inventory Quantity Dimension Total item inventory in the store(s) inventory_quantity
Listing SKU Dimension The SKU in the store listing_sku
SKU Dimension The normalized SKU across all stores sku
Count Inventory Locations Measure Count of the unique locations where inventory is tracked COUNT(DISTINCT location_id)
Count Item Inventory Measure Count of the unique items + inventory location combinations COUNT(DISTINCT inventory_level_id)
Total Current Inventory Cost Value Measure Inventory quantity * sku cost SUM(inventory_quantity * product_variants.sku_cost)
Total Current Inventory Retail Value Measure Inventory quantity * product price SUM(inventory_quantity * product_variants.price)
Total Inventory Quantity Measure Total current inventory quantity from ALL locations SUM(inventory_quantity)


This view is part of the following explores:

  • Current Inventory Level

Transformation Code

This view is a part of the Daasity Unified Order Schema (UOS) that enables Daasity to combine different order sources into a single data model.

Growth & Pro support the following code:

  • [0525_UOS_BAS_SHOPIFY_current_inventory_levels.sql]
  • [0553_UOS_BAS_AMAZON_current_inventory_levels.sql]
  • [0585_UOS_BAS_SKUBANA_current_inventory_levels.sql]

Pro supports the following code if the optional code is enabled:

  • [0523_UOS_BAS_SFCC_current_inventory_levels.sql] (Salesforce Commerce Cloud)
  • [0615_UOS_PRO_LIGHTSPEED_current_inventory_levels.sql]