News:

Support the VirtueMart project and become a member

Main Menu

Serching: Inventory Management with history

Started by FDE68, September 13, 2018, 14:44:29 PM

Previous topic - Next topic

FDE68

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

GJC Web Design

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

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.

FDE68

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.

kishoreonwork

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
I am available for paid joomla and virtuemart consulting.
http://www.kishoreweblabs.com/
skype kishore2607

GJC Web Design

I agree - to record the history etc you will need a plugin/extension that maintains its own tables
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

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.

FDE68

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