History Report movement for every product

amministrazione

Hi , i would know where i can find the function to print on video the historical logs of single product.
Then i need to know how can get a report of all product where i can see these two factors:
1) the qty available to sell (Available qty)
2) the qty really stock in warehouse in that moment (phisical existing qty in stock)

Thanks

AndreaRebel

Hi amministrazione

But are you using ATUM Multi-Inventory, using one inventory for 'Available qty' and a second inventory for 'phisical existing qty in stock' ?

Best Regards,

Andrea.

amministrazione

Hi Andrea, thanks for you reply.
I'm not using yet ATUM Multi inventory.
Yes i'm looking for the function that let me to see/check the Avalilable qty and Phisical inventory.
But pls , can you explain me why i have to use two inventories ? What you mean for inventory ? May i have a full report with both information in the same report in two columns ?
Thanks
Rgds
Felix

AndreaRebel

Hi amministrazione

Well, you can make it work in different ways and creating two inventories is one of them.

For example, another way to separate the available stock and the stock in warehouse is to use the Out of Stock Threshold feature. When the product reaches the out of stock value, the product will be shown as out of stock. Imagine that you have 10 items in warehouse, and the out of Stock Threshold value you have set is 8. In this way, when 2 of this items will be sold, the product will be displayed. as out of stock.

The way I recommend to do it with our premium add-on ATUM Multi-Inventory, is to create two inventories and use one with the available stock, and use the other one with the stock in warehouse. If you want that the second one not to be displayed on the frontend (you want just to be informative for you) don't put a price, for example.

To see the info in the report, in case you want to do it with Multi-Inventories, you can Export Data from Stock Central (right top corner), but it will not be displayed in two columns.

In any case, I recommend you to read the documentation of the add-on where you will find useful info about how it works: https://forum.stockmanagementlabs.com/t/multi-inventory-documentation

And the link to the demo site in case you want to try the free trial: https://www.stockmanagementlabs.com/addons/atum-multi-inventory/

Hope this helps,

Best Regards,

Andrea.

amministrazione

Thanks Andrea,
sorry for my English, but it's not very clear. May i have a screenshot of this report with both parameters ?

For example i attach to you this link to an image that can show you what i expect for.

https://www.awesomescreenshot.com/image/7138677?key=9e1e8f55aaa5d130ccda1b207a4c6031

Waitng for your feedback

AndreaRebel

Hi amministrazione

Well, if you want a table like this, the most similar thing that comes to my mind, is to go to Screen Options in Stock Central view (right top corner) and just select the following columns to be displayed:

Current Stock = Available qty
Out of Stock Threshold = Existing qty
Inbound Stock = Qty order to the supplier
Stock on Hold = Qty ordered from customers

In this way you will see this info in Stock Central and also you will be able to export it. I guess this is not exactly what you are looking for, but in any case, you may achieve something more accurate with custom development, but as we don't offer this service you will need to hire a developer.

Best Regards,

Andrea.

amministrazione

Hi Andrea,
maybe there is a confusion on the words.
IMHO Out of Stock Threshold IS NOT Existing qty. I mean for Existing quantity the real phisical current qty i have in stock in my warehouse, while i mean for AVAILABLE QTY the qty that i can sell to my customers (so not the phisical count).

Sorry for my poor english, but the Out of Stock Threshold is for me a LIMIT to help me to manage better the qty of my products, but is not a COUNT.

thbaks

AndreaRebel

Hi amministrazione

Well, some users can use it this way. If you have an online and a physical store, and you know that of 10 items that you have in the physical one, 2 of them are for selling online, If you set the out of stock threshold as 8, as a shop owner you make sure that you won't be running items in the physical store, and the online store stock will be also correct.

But I understand that maybe that's not what you need. In any case, as I told you, may you can achieve your needs with custom development.

Best Regards,

Andrea.