Author Topic: Open source stock tracking / cost per project software?  (Read 502 times)

0 Members and 1 Guest are viewing this topic.

Offline gmcTopic starter

  • Regular Contributor
  • *
  • Posts: 136
  • Country: gb
Open source stock tracking / cost per project software?
« on: April 07, 2022, 06:07:34 pm »
Is there any decent open source stock tracking software I  can use for a hobbyist?

I've been using excel to keep track of quantities and have a tab listing all of the components to work out cost per piece taking into account cost/tax/shipping.

I then have a tab for each project listing all the components and quantities required and the costs/stock is looked up from the components tab.

This has been working well but its becoming unmanageable with the now 100's of components I  have.
I've started selling some of these projects so when building the PCB's I then update the stock as I use them and can easily see what it costs to build.

Is there some open source software that will do the job better than this?  Stock + tracking cost per component as well as costs of projects.
 

Offline cdev

  • Super Contributor
  • ***
  • !
  • Posts: 7350
  • Country: 00
Re: Open source stock tracking / cost per project software?
« Reply #1 on: April 07, 2022, 06:31:38 pm »
For stuff like that that involves a web hybrid component I like to use regular Zope. Not Plone, but you can install Plone and use the Zope in Plone which gets frequent bug fixes.. Zope. its a templating and web dev toolkit written in Python. You can use it to do web-database stuff, and each stock lookup is basically a http get which you can implement as a loop in a web page.  Its very easy. And very useful. You can make very simple interfaces to all sorts of hardware.

Its really a personal choice. I prefer Zope, but its similar to PHP where it sits. Its very secure and has very fine grained security features.
"What the large print giveth, the small print taketh away."
 

Offline phs

  • Contributor
  • Posts: 28
Re: Open source stock tracking / cost per project software?
« Reply #2 on: April 07, 2022, 06:49:27 pm »
You might want to check out InvenTree and Ki-nTree, especially if you use KiCad:

https://github.com/sparkmicro/Ki-nTree/
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf