VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: FDE68 on September 13, 2018, 14:44:29 PM

Title: Serching: Inventory Management with history
Post by: FDE68 on September 13, 2018, 14:44:29 PM
Hallo,
for professional use we are searching for a functionality for managing inventory.

If new products come to the office, we need to add them to the shop.
But not only editing the quantity.
It needs to be a field for adding the quantitiy of goods. Also need to fill in the price of this delivery.

If an item is sold, this also needs to enter automatically - at the and, you have the history of the product - when delivered, wehn how many sold, when how many coming also in stock.
Loke a professional enterprise resource management software.

Any idea, if there is an extension on the mrket, which can do this?
Thanks a lot for info or help
Best regards
Frank
Title: Re: Serching: Inventory Management with history
Post by: GJC Web Design on September 13, 2018, 14:51:28 PM
My clients use 3rd party web based products for this and use api plugins to keep everything in sync

4 I know are

https://dearsystems.com/inventory-software/

https://www.unleashedsoftware.com/

https://www.odoo.com/page/warehouse

Dutch only

https://www.snelstart.nl/

not for the faint hearted .. but have done connectors for all these

Title: Re: Serching: Inventory Management with history
Post by: Studio 42 on September 13, 2018, 15:59:21 PM
Why not using directly Virtuemart ?
If you want, you can restrict acces and display in front the form.
If you need more restriction, you can code a simplified form (using vmextended plugin for eg.), so restricted managers can only modify basic product informations. Eg, a form with name,sku,stock,category, price , product unpublished by default... In this case, all user that have rights can add new products(even outside from your office), but have no access to the whole shop settings.
Title: Re: Serching: Inventory Management with history
Post by: FDE68 on September 14, 2018, 07:34:17 AM
Thanks a lot fory your replies.

First we want to find a solution inside Virtuemart, not external.
An external Software is in usage, but we want to do all inside virtuemart in the future.
So neet to search.

@studio42 - we nee no restrictions. we need a functionalitiy to get the history of every product. When how many to which price are coming in. Then one is solt today, then is solt one tomorrow. Then there comes a new deliviery - that i always can see these in´s and out´s with date and price - the history og a product. Basic in an enterprise management system ...

An i hoped, there is an extension somebody built for virtuemart.

Thanks a lot.
Title: Re: Serching: Inventory Management with history
Post by: kishoreonwork on September 14, 2018, 14:48:16 PM
I am not sure if any extension available for virtuemart to fulfill  your requirement.
As  you need a reporting based on the product order and  the data for product sold can be easily pulled from databases.

But for adding product and maintaining price history require storing prices in separate tables, you will require a custom plugin , which  help you in
maintaining the product price histroy data. This all will  require custom coding.

You can also post a requirement in commercial forum or can contact me.


Thanks
Kishore
Title: Re: Serching: Inventory Management with history
Post by: GJC Web Design on September 14, 2018, 15:37:09 PM
I agree - to record the history etc you will need a plugin/extension that maintains its own tables
Title: Re: Serching: Inventory Management with history
Post by: Studio 42 on September 15, 2018, 15:35:42 PM
About solded product and price, this can get from order items table.
You dont need a plugin to manage this and no special table, only a view to display it as you need(and perhaps an export to csv for eg.).
The main development should be about the stock history/control because Virtuemart use only a simple field in the product itself.
I can code it or GJC Web Design or some other devs in the forum as a plugin to save this history in a table and display the stock history.
Title: Re: Serching: Inventory Management with history
Post by: FDE68 on December 06, 2018, 12:12:38 PM
Hallo, thank you for the replys ant the offers.
We will discuss this and a solution need to coded, i will come back to you.
Thanks and best
FDE