How to Calculate Inventory on Hand

Please follow these 3 easy steps to calculate how much Inventory on Hand you currently have in your store(s):

1. Please go to your POS Web App and select "Variants" under "Products" tab or simply click here.

2. Please scroll to the bottom of the page and please select: "Export All" button. 

3. Once all of your Products are exported into Excel, multiply columns H ("Stock") by column L ("Wholesale Price"). The result is your Inventory Cost on Hand for that particular variant. Copy the cell and Paste into the rest of the cells in that column. At the bottom of that column, select "=Sum" and select all of the cells in that column. 

Please note: If you have a negative inventory of certain stock, it will subtract from your total inventory, unless you make that total inventory to be 0. 

Please watch the video below for visual instructions:

Multiple Stores? No problem!

Please click "Sort & Filter" option at the top right corner and select the location for which you are calculating the Inventory on Hand in column I ("Location)".

Please watch the video below for visual instructions:

If you need help navigating excel or calculating this metric, please don't hesitate to reach out to us at [e-mail]