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?