Inventory Software?

[Chargerguy74]

I want to start keeping an inventory of parts by part number or lot number/description etc. and was wondering if there is any good software out there to do it? Thanks

[Shakey]

I want to start keeping an inventory of parts by part number or lot number/description etc. and was wondering if there is any good software out there to do it? Thanks

Microsoft Excel

[Chargerguy74]

I dont have experience with excel, but basically I'm looking for something where I can type in a part number to see if I have it, how many I have, etc. Not just a spread sheet.

[adauto]

All the salvage dealers have one form or another of Hollander. But its a system and runs thousands! I'd suggest getting a used Hollander manual from a swap meet or e-gag and make some sort of speadsheet based on that. Of course this will only work for major components. They do not list Speedo needles, brake springs or knutson valves. But it would be a start.  ....unless I misunderstood your intentions.

[Shakey]

I dont have experience with excel, but basically I'm looking for something where I can type in a part number to see if I have it, how many I have, etc. Not just a spread sheet.

Excel is a lot more than just a spreadsheet.  Correct, that is what you start with and then you can customize it to do whatever you wish.

Open up a new sheet and start with a list of 10 part numbers.

Create 3 columns - PART #, DESCRIPTION, STOCK

Then enter the 10 part numbers in the corresponding column, followed by the description and in the third column (STOCK) put a Y for yes if you have one and a N for no if you don't.

You can then sort the data to have it show your part #'s in numerical order or whether or not you have something in stock etc.

After you get comfortable with it, you can add more columns.  For example you have a used part in stock and would like to show the condition of it, use a rating system of 1 to 5.  You can also insert a link to digital photo of the part.

I had zero experience with it a few years back and I am no expert but it is amazing what you can keep track of with it.  I have a few sheets in one workbook that track all of the old part #'s that are still available from MOPAR with their new part numbers as well.  In some cases, I have updated pricing with them.  I also have a Year One sheet, listing all of the items I need and have purchased from YO, with part #'s as well as two sets of prices, the catalogue prices and the - 20% prices.  I know exactly how much I have spent, what exchange rate was used, when I spent it and how much I need to spend.  Of course my Wife will never see this workbook.

Spend some time with it, create a few samples and search for some tips online on how to get the most out of it.  It is a simple product that can be customized to be fantastic.  It won't take you long to like it.

Good luck.

[Just 6T9 CHGR]

Excel is what I use for the registry.

I sort each car by VIN #.....I can quickly & easlilly sort through the almost 800 cars to see howmany F8 green R/T's I have with a white top & AM/FM radio etc

[mikepmcs]

Excel is what I use for the registry.

I sort each car by VIN #.....I can quickly & easlilly sort through the almost 800 cars to see howmany F8 green R/T's I have with a white top & AM/FM radio etc

so how do we see all that info?  is it avail on the registry site cause i can't find it.  i registered mine a little while ago and guess i was expecting some sort of email saying you got it or something.
v/r
Mike

[Shakey]

Excel is what I use for the registry.

I sort each car by VIN #.....I can quickly & easlilly sort through the almost 800 cars to see howmany F8 green R/T's I have with a white top & AM/FM radio etc

so how do we see all that info?  is it avail on the registry site cause i can't find it.  i registered mine a little while ago and guess i was expecting some sort of email saying you got it or something.
v/r
Mike

You mean you didn't get the Official Registry Welcome Package?

Must of gotten lost by UPS.

Mine had a 1/18 scale exact replica of my car, a bottle of Mumm Extra Dry Champagne, two tickets to a Maple Leafs game and some stylish lingerie for my Wife.

[mikepmcs]

shoot, i want washington caps tix for me and make sure my scale model is from the new movie with Jess on the box.
thanks, i'll be taking leave from work and waiting by the door for Dale Jarrett in the big brown truck.  hurry up though.
smartass, LOL
r/

[Chargerguy74]

Cool, thanks for the replies. I might try SPSS (took it in University) never knew you could ad links to pics, etc. Will be checking into Hollander too.