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 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: 26/08/2024

Was this article helpful?

Thank you!