get a list of products per warehouse

Hi All

How do i get a list of the products per warehouse?

Thanks in advance

Regards
Antonio

Hi,
I use an addon called mylist from the Dolistore:
myList
However MyList requires the knowledge of SQL queries and of Dolibarr database.
See screenshot of how I’ve done this:

1 Like

/product/stock/card.php?id=1 will give you a list of the products in that warehouse.

Got to: Products/Services > Warehouses > (select warehouse)

1 Like

Aljawaid,
That may not be practical because for example when the product is in multiple warehouses I want to know in one list the quantities in each warehouse e.g
Ref. Label Warehouse Quantity
A1 Product A W1 2
A1 Product A W2 3
A1 Product A W3 1

1 Like

That would show under the product stock tab? Maybe I have misunderstood the post.

1 Like

Aljawaid,
Let me give you another scenario. Say I want a report of all items which have negative quantities in each warehouse. Also after the report displays on screen I want to export it to MS Excel or PDF and not go through Tools-> Export
Another report: Sales per Warehouse
Dolibarr is very weak in Reports and easy creation of reports on the fly.

1 Like

thanks for your reply

Althought my knolledge in sql isnt so go as i would like .
Is there a simple way to have the stock per warehouse ?
Thanks in advance

Just my two cents…

This report system is the best that I know of: http://www.reportico.org/site/index.php

For someone who can write modules for Doli, this would be a good one. :happy:

1 Like