Page 1 of 2

Simple parts inventory program? (free or opensource)

Posted: Thu Jul 02, 2009 5:56 pm
by george graves
Can anyone recommend a simple to inventory program?

The reason why I ask is last night it took me 7 hours to figure out what I needed to order from mouser. It was not fun trying to figure out what I had on hand, what was needed, ect..

To give you an idea of my needs - I need to keep track of about 1500 parts, and be able to group them into 30 assembles.

My budget is $0. So, even an old dos program would be fine by me. Just as long as it works.

(BTW - I don't want to roll my own in excel or access)

Any suggestions? Advice?

Posted: Thu Jul 02, 2009 6:29 pm
by macegr
Openoffice.org? It has an Excel-like program.

Posted: Sat Jul 04, 2009 6:07 am
by signal7
I haven't used it, but I recall that Google has some kind of database application out there. If I find some info on it, I'll post it here.

Posted: Sat Jul 04, 2009 6:32 am
by leon_heller
MySQL is free and can be used with Open Office.

Leon

Re: Simple parts inventory program? (free or opensource)

Posted: Mon Aug 31, 2009 12:00 am
by madeinoz
george graves wrote:Can anyone recommend a simple to inventory program?

The reason why I ask is last night it took me 7 hours to figure out what I needed to order from mouser. It was not fun trying to figure out what I had on hand, what was needed, ect..

To give you an idea of my needs - I need to keep track of about 1500 parts, and be able to group them into 30 assembles.

My budget is $0. So, even an old dos program would be fine by me. Just as long as it works.

(BTW - I don't want to roll my own in excel or access)

Any suggestions? Advice?
you could try openerp (www.openerp.org) may be a bit of overkill though. there is an electronics inventory module for it

Re: Simple parts inventory program? (free or opensource)

Posted: Thu Mar 11, 2010 5:28 pm
by pichenettes
What I would do if I had time to work on this:

- Web-based app (AppEngine probably).
- Wiki-like parts database with links to datasheets and references for all component distributors. Links to open hardware projects using the parts ("I want to check how people are using this").
- Each user creates an account on the site and can create their own inventory using their own parts definitions or those from the collaborative wiki. Can flag parts as "general purpose" and specify the optimal quantity for restocking.
- BOM manager to create and publish BOMs + keeping track of how many units of a particular device we have stock for.
- Function to create order csvs automatically for digikey or farnell ("order the parts I need for 10 units of this device" ; "restock the parts I have flagged as general purpose").
- Geo search. Find people around me who might have a part I'm looking for.

I don't think it's that hard... Add to the wishlist... Maybe I might end up doing it :)

Re: Simple parts inventory program? (free or opensource)

Posted: Thu Mar 11, 2010 5:42 pm
by george graves
^Wow. I think you are on to something. I didn't even think of a web based application!

I'll throw in a couple of things I would like:

- slim interface that would load fast and easy on the eyes. My eyes are tried of staring at bright white text feilds.
- bar code support that you could read your own bar codes *AND* mouse/digikey/ect bar codes. I bet on each bag I get from mouser has a lot of data that I wouldn't need to hand enter in.


gg

Re: Simple parts inventory program? (free or opensource)

Posted: Mon Mar 15, 2010 12:02 am
by follower
It looks like Octopart have some tools that might be useful for this: http://octopart.com/tools/

--Philip;

Re: Simple parts inventory program? (free or opensource)

Posted: Sat Jul 03, 2010 7:40 pm
by madeinoz
I just came across this standalone OS inventory specifically for Electronic components.

http://sourceforge.net/projects/zparts/

Re: Simple parts inventory program? (free or opensource)

Posted: Tue Sep 27, 2011 7:35 am
by fll-freak
I found an old CueCat barcode scanner in my attic and started in on a way to inventory my parts. I took the approach of just using a flat file database using Excel. I purchased a large number of ESD bags from ULine and put my own barcodes on each bag. Not sure it will make life any easier. As blogradio mentioned, once you forget to decrement a part when you use it, you are screwed.

Re: Simple parts inventory program? (free or opensource)

Posted: Sun Jan 29, 2012 5:28 pm
by ic3man5
This is the only program I know of that does inventory management: http://www.trilogydesign.com/
$99 bucks for the cheapest version.

I've written a program that is similar, to better suit my needs with mysql as the database engine. If I get a huge push for something I could possible make something for cheap ($40 bucks) with a free version with limitation. Does anyone know of something out there that you can actually pay for?

Re: Simple parts inventory program? (free or opensource)

Posted: Wed Feb 01, 2012 5:13 pm
by rpcelectronics
I'm kind of late to the party on this, but you mentioned you use Mouser. Mouser is my best friend when it comes to keeping BOM's straight for each product. Will it track your inventory? No, but you can keep a nice online listing of BOM's for each project/product. I have invested a minimal amount of money over the last ten years on various invoicing and tracking software and I found that the NCH products were the best option for me. Not too expensive, but I know you are looking for a free option, so it's just a suggestion if you ever get to the point where you want to spend some money.

Overall, I have found a good combination of Mouser's BOM manager, some good homegrown spreadsheet systems and my NCH software has kept me on track 99% of the time.

Good luck with your project!

Re: Simple parts inventory program? (free or opensource)

Posted: Fri Feb 03, 2012 3:07 pm
by macegr
Excel spreadsheets are very commonly used for BOM management in industry. You can specify as many parameters about a part as you like, you can do on the fly calculations for cost estimates, you can put in the sizes and pad counts for manufacturing estimates, you can insert notes, you can assign hyperlinks to datasheets and part sources.

I use spreadsheets to communicate BOMs to and from PCBA companies. If you don't give them a spreadsheet at the beginning, they'll probably put it all in a spreadsheet and send it back to you for review anyway.

OpenOffice and Libre Office are free, extremely powerful tools; the spreadsheet programs have so much more untapped ability than typing numbers in cells and adding some of them up. I use Excel to design SMPS and certain analog circuits. Once you crystallize a design down to a set of functions, it's really easy to adjust parameters to come up with something for different applications or available parts.

Re: Simple parts inventory program? (free or opensource)

Posted: Fri May 18, 2012 4:29 pm
by static
Hi guys

I've just deployed a web app that i created to help me keep track of my inventory. I figured why not share it with others. So i've added the login function (so everyone who signed up has their own inventory, duh ;)

check it out: http://inventory.railified.com/

note: after you signup, click on link in email to confirm. (and don't worry, i'm not gonna spam you :)

Interface is very basic and not stellar looking yet. I plan to keep on improving it as time permits (i have a long list of improvements and features i would like to add, and im of course open for suggestions)

Cheers
Alex

Re: Simple parts inventory program? (free or opensource)

Posted: Thu Nov 01, 2012 5:57 pm
by donzi
You might take a look at the following

http://www.ecdb.net/about.php

Thinking of giving it a try. what do you think.

Don