Inventory across locations in a single view/report

[OWevents]

Hi!  I am trying to find a way to see a list of all of my products, and how many of each is at each location, in one screen.  Essentially a screen or report that shows something like this:

Product Name	Location 1 QTY	Location 2 QTY	Location 3 QTY	Location 4 QTY
Product 1	234	654	3	15
Product 2	774	453	99	45
etc...

Open to apps that provide this view/report also.

Any help is appreciated!

Thank you!

[mipler]

Hi,

Please check Mipler Advanced Reports app. This report is pre-created by default. (Locations overview by product)

[CloudlabSam]

Hi There - our Report Toaster app can do this. Please see our Inventory Value By Location report and let us know if you have any questions.

[BetterReports-C]

Hi @OWevents 

Claudia here from Better Reports.

I would recommend our app Better Reports for this.

We have a series of built-in reports showing inventory by location (by product, product type, vendor, etc.) that can easily be formatted as a matrix (as per your example).

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use-cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?

[Report-Pundit]

Hi @OWevents ,

If you are still looking for a solution, Report Pundit has the option to show Inventory for each location. The report can be sorted and filtered by Inventory location, quantity, SKU, and many other fields.

We also have Inventory level indicator, Inventory re-order point report, and much more.

You can reach us at support@reportpundit.com

Thanks!