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.) Title, Variant Title, Variant SKU: The name of the product, name of the variant and the associated SKU.

2.) Location ID, Location Name: The 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 5 of the Sail on a Slice Product (FLT-00003) stored at the Pontiac Warehouse, the Available column will display 5.

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

For example, if the Sail on a Slice product has a Price of 16.99 and I have 5 of them available, then Total Price would be 16.99 x 5 = 84.95

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

For example, if the Sail on a Slice product has a Cost of 8.00 and I have 5 of them available, then Total Cost would be 8.00 x 5 = 40.00

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.

If you want to see your Inventory and corresponding sales broken out by individual locations, check out our Stock Report here.

• Related Articles

• 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 the available quantity ...

• 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 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 - Dead Stock Products/Variants

  Dead Stock Products/Variants For merchants who are wanting to tidy up their inventory or perhaps work out which items to discount, Dead Stock reports are useful to see which items have not been selling over a given time period. This report follows a ...

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...