Premium Report - Inventory Value by Location

Inventory Value by Location

Inventory Value Reports are used by merchants to see how much the amounts and value of their current stock. 

For merchants who store inventory at multiple locations however, sometimes it's important to see your stock on a per-location basis, rather than simply seeing the totals. 

This report follows a similar format to the Inventory Value report, but displays your total available, price, and cost of each item broken down by each inventory location you have setup in your Shopify store. 

As a Premium Report, this is available on all Paid Plans of Report Toaster. If you aren't signed up, follow these steps here to upgrade your account. 

Here are a few terms to be familiar with in order to understand the Inventory Value by Location Report:

1.) Inventory item/Tracked, equal to, true (FILTER): This filter ensures that only tracked inventory shows in the report. It's best to leave this alone.

2.) Location ID/ Location Name: The Location ID and the Name of the Location where the Inventory is stored. 

3.) Available: The amount of stock for that SKU at this particular location. 

For example, if I have 11 of the 12-Pack Drink Floaties stored at the Pontiac Warehouse, the Available column will display 11.

4.) Total Price: The price of that particular SKU multiplied by the available quantity at that location. 

For example, if the 12-Pack Drink Floaties product has a Price of $10.91 and I have 11 of them available, then Total Price would be $10.91 x 11 = $120.01

5.) Total Cost: The cost of that particular SKU multiplied by the available quantity at that location. 

For example, if the 12-Pack Drink Floaties product has a Cost of $5.14 and I have 11 of them available, then Total Cost would be $5.14 x 11 = $56.54

Like all Report Toaster reports, these reports are fully customizable - so you can adjust the date range, add/remove columns, introduce a filter or change the sort to suit your individual needs. See our basic guides here for more info.

For other premium reports you can be added to your account, check out our main guide here. 

• Related Articles

• Premium Reports - Inventory History

  Inventory History Inventory history reports are used for tracking changes to inventory at either a given point in time (e.g. Today) or over a select period (e.g. Last 30 Days). You can customize this time period via the date range (top right). ...

• Premium Report - Stock Report

  Stock Reports Stock Reports are used to compare how much of something has been sold vs how much you have in stock at each of your different locations. These reports follow a similar format to the Sell Through Reports, but display the stock that's ...

• Premium Reports - Inventory Turnover

  Inventory Turnover These reports are used for measuring how much inventory has been sold and replaced over a given period of time. You can customize this time period via the date range (top right). Inventory History needs to be enabled by our Report ...

• Premium Report - Month-end Inventory Snapshot

  Month-end Inventory Snapshot Included as part of our Inventory History suite, this report is designed to replicate the Shopify report and give you a point-in-time snapshot of your historical inventory. Inventory History needs to be enabled by our ...

• Premium Report - Dead Stock Products/Variants

  Dead Stock Products/Variants Dead Stock reports are useful to see which items have not been selling over a given time period. This report follows a similar format to our other Product and Variant reports, but has a number of filters and settings to ...