Free/Open-source ERP Software For Managing Inventory, Project Builds

Does anyone use an ERP software to manage their projects?

Personally I’m interested in managing my inventory of electronics parts + BOMs, as well as tracking all built units with e.g. build notes, calibration/test results, repair logs (PLM).

My ideal workflow (which I may have to build slowly/some day), would be uploading a Digikey order, existing inventory gets incremented. Then when building a project, it will decrement all the relevant parts (and/or tell me what I need to order). Ideally it would also store e.g. DXF/STL files so I know what things I also need to build. Barcode scanning/printing support is a definite nice-to-have.

In all my design software I would just reference the ERP part ID, and can e.g. make changes to suppliers/pricing info without having to update project files.

So far I’ve looked at the following 3 open-source choices (having a free core/community edition, at least. I would be most comfortable with a lightweight self-hosted version rather than a cloud/SaaS):

ERPNext:
https://erpnext.com / https://github.com/frappe/erpnext
Python, GPLv3. Fully open-source.

Tryton:
http://www.tryton.org / https://github.com/tryton/trytond
Python, GPLv3. Fully open-source.

Odoo
https://www.odoo.com / https://github.com/odoo/odoo
Python, LGPLv3. Has self-hosted open-source community edition (but features such as barcodes, and product upgrades, are proprietary + paid).

I’m super curious about what everyone else is using, how your workflow is organized, and any other suggestions you may have!

4 Likes

Suggestions from Slack conversation on #random-projectry thread:

Courtesy of @mike:
Shotgun
https://www.shotgunsoftware.com
Proprietary, Cloud/SaaS.

Courtesy of @rsim (his custom software!):
HardInventory
https://github.com/ProxxiTech/HardInventory
Javascript, MIT. Fully open-source.

Courtesy of @jarrett:
PartsBox
https://partsbox.io
Proprietary, Cloud/SaaS.

3 Likes

I reviewed all the options that I had found at one point:

https://talk.vanhack.ca/t/home-parts-inventory/5557?u=jarrett

But since then, I’ve stuck with @rsim’s HardInventory, because I’m pretty into the Google Sheets backend for when I don’t actually feel like dealing with a front end, and it’s simple enough

2 Likes

I ended up going with Tryton:

Pros:

  • Open-source (and always has been, no premium or proprietary features), self-hosted. GPL as a license isn’t too bad although I personally prefer the MIT license (such as HardInventory uses). Eliminates Shotgun, PartsBox, and Odoo.
  • Supports postgresql, which I am already using. Eliminates ERPNext.
  • ERPNext (my second choice) seemed a bit unpolished, perhaps because it is from non-English speakers, but it still impacted my experience.
  • Tryton has a clear module/plugin system, and a scripting API. I added a barcode plugin and it worked.
  • Has a multi-platform desktop client app
  • The “GNU Health” project is based on it and extends it for FOSS hospital management, and I support the intent and scale of that project and their choices for building it on Tryton.

Cons:

  • Doesn’t have a iOS / Android app.
  • No integration with e.g. Digikey, Mouser.
  • Quite a lot of initial setup – it started with almost nothing and you need to add the modules you want, then configure the details (basic Business/Employee/Accounting info just to start, but may be useful later)

I can share the infrastructure / setup details with anyone who is interested.

And now, I’ve got a barcode scanner and boxes of old digikey parts to go through!

2 Likes

This looks interesting, too:

1 Like