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. You can access it by logging in to your account and then signing up here at any time.

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 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 ...

• How to Create Inventory History

  A popular request among Shopify merchants, many of you have asked us about the best way to keep a historical record of your inventory over time for tracking purposes. This has all sorts of useful applications, from being able to monitor stock levels ...

• Premium Report - Sales Velocity

  Sales Velocity - Days of Inventory Available Sales Velocity reports are used to see how quickly something has been selling so you can plan your inventory accordingly. As a Premium Report, this is available on all Paid Plans of Report Toaster. You can ...