All Collections
Manage Your Reports
Inventory reports
How can I see the total value of my inventory?
How can I see the total value of my inventory?

Here's how you can use Attributes and the Inventory Download to see the total value of your inventory.

Colin Connor avatar
Written by Colin Connor
Updated over a week ago

First, ensure you have Original Cost as a Attribute on your items (Article w. video).
It'll also help if you have this Attribute on your Inventory List as a Custom Column (Article).

Then, select all your products and download the inventory to an excel document (Article).

From here, let's open the download in Google Sheets (I find this the easiest to use)

Next, let's remove the top three rows (for ease of navigation)

Then, add in a new column for 'TOTAL VALUE'

After, add in a command to multiple Original Cost by Quantity Posted. =MULTIPLY(cell with original cost, cell with quantity posted)

Apply this calculation to all cells.

Finally, sum together all those rows.

And there you have it! your total for all items in your inventory.

Did this answer your question?