Author Topic: Serching: Inventory Management with history  (Read 172 times)

FDE68

  • Beginner
  • *
  • Posts: 3
  • A beginner
  • Skype Name: quintact
Serching: Inventory Management with history
« 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8002
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Serching: Inventory Management with history
« Reply #1 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

GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3334
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Serching: Inventory Management with history
« Reply #2 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.

FDE68

  • Beginner
  • *
  • Posts: 3
  • A beginner
  • Skype Name: quintact
Re: Serching: Inventory Management with history
« Reply #3 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.

kishoreonwork

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 47
    • virtuemart expert
  • Skype Name: kishore2607
  • VirtueMart Version: 3
Re: Serching: Inventory Management with history
« Reply #4 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
I am available for paid joomla and virtuemart consulting.
http://www.kishoreweblabs.com/
skype kishore2607

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8002
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Serching: Inventory Management with history
« Reply #5 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3334
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Serching: Inventory Management with history
« Reply #6 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.