Computer software/program for small business inventory?

[YELLAHEEP]

Many of you are aware by now..... I got a little side thing going parting out XJ's......

Well, I've got a huge pile of disorganized parts that I'd like to get under control and got to thinking....... Surely there's gotta be a computer program or software out there that is fairly easy to use for inventory right?

Anyone out there know what I'm talking about? I'd like to be able to enter the parts into categories and establish the pricing along with it. I've "lost" parts I thought I'd sold, and offered parts I no longer have because I don't have an inventory list.

Would a simple Excel spreadsheet do what I need? I only have a very basic knowledge of Excel, but I don't know what it's capabilities are.

I've also built a mobile warehouse in the back of a U-haul van I picked up cheap and was thinking of labeling the shelves with bin numbers so I can find those parts easier.....

Also, would I be able to link part of that inventory list to a website? I'm also wondering if it's time to build a website so I can let folks browse at the parts I've got.


Anyone have any suggestions?

 

[buschwhaked]

Quickbooks Pro has an inventory management portion of it's software. It's tucked in there with all the other stuff they offer and it costs about $200. If your business is beginning to take off you might want this anyway.

http://quickbooks.intuit.com/product/accounting-software/simple-start-bookkeeping-software.jhtml

On the feature list with this link, the inventory feature is listed 3rd from the bottom.

 

[turpehar]

You can do this yourself with a little work, thought, and time. The difficulty lies in hitting your mark on how much business you do now compared to how much you want or hope to do in the future.

What you want is a database that is searchable with a front end to easily enter new parts while being able to relieve inventory. You could go small or whole hog.

Microsoft Access would be a good starting point. When things start to grow you could map that into an SQL database. See below what I did in a few minutes. Let me know if you need some help.

 

[Sting25]

Use quickbooks your future accountant will like you better then if roll your own.

 

[riverfever]

Troy...I could put you into an hp laptop. REAL REASONABLE. She's a runner. Marinate on it a bit man and get back to me.

 

[Kittrell]

Troy...I could put you into an hp laptop. REAL REASONABLE. She's a runner. Marinate on it a bit man and get back to me.

:laugh2:

 

[YELLAHEEP]

Troy...I could put you into an hp laptop. REAL REASONABLE. She's a runner. Marinate on it a bit man and get back to me.

LOL! Well, if I discover I need a large paperweight anytime soon, I'll holler at ya........

 

[Fred]

Troy,

I did inventory for years. Computers aren't worth the time or trouble for inventory of less than 1000 items. I know, I wrote my own database program to do it, and kept on using my inventory book. That said, a quick search does not reveal any such book for sale.

The hardest part of keeping track of things is categorization, labeling, and organizing. Counting and recording is easy once that is done.

As far as quickbooks goes, I've used it and didn't like it, but it is what an accountant expects to find.

My .02.

Fred

 

[JohnJohn]

Troy do an excel sheet.


The 100 parts you have are probably doubled or tripled. Create a sheet for exterior, interior, etc. Then keep track of the type, quantity, condition, year etc via columns and rows.

That's what I would do if I still had a PC. On a MAC I would just build a database in "Bento"

 

[98XJROKS]

speaking of parts......Clock Spring for a 98' w/ cuise? Anyone anyone?