How do we calcualte the inventory report?

Terms & Formula

• SKU: Stock Keeping Unit, a unique identifier for your product variants.

• Inventory quantity: the available quantity of products in Shopify.

• Incoming inventory: the ordered stock that is yet to be received ( learn more).

• Committed quantity: quantity of products has been sold by not shipped yet.

• Inventory value: the current inventory at the cost of each product.

[Inventory Quantity] x [Unit Cost]

• Retail value: the current inventory at selling price of each product.

[Inventory Quantity] x [Selling Price]

• Inventory quantity percent: % inventory quantity per total.

[Inventory Quantity of specific product/ collection] / [Total Inventory Quanitty] * 100%

• Inventory value percent: % inventory value per total.

[Inventory Value of specific product/ collection] / [Total Inventory Value] * 100%

Updated on: 11/02/2025