posted on March 24, 2001 10:13:24 AM new
Does anyone have a BASIC inventory program that I can download or somewhere I can purchase?
I never used the ones on AW etc...and I KNOW there is one on quickbooks...but I am looking for a BASIC one that stands alone that I can open up...add the item info or mark sold ....and it will keep track. I have looked up several on the net but they want hundreds of dollars and have more features than I will ever use...Can't find one that just lets me list stuff and enter/delete as it sells etc. Any ideas???
posted on March 24, 2001 09:33:41 PM new
If you have an Electronic Boutique in your area go to it and look on the spinner racks. I'm told the CD's are as low as $10 or more depending... or try a shareware program. Do a search on your browser...
posted on March 24, 2001 09:59:01 PM new
Empires...thanks for the tip...I have an electronics boutique over at the mall I will check it out. I did do a search on the web and so far came up with some pretty pricey programs. I will see what else I can hunt up. but if I can find one at the mall thats simple I will grab it.
posted on March 24, 2001 11:38:28 PM new
Go play around with Excel..if you have Windows, you prolly have Excel...go thru the "help" stuff, and you will be able to create your own inventory spreadsheet...I have handled a 600 item/$40K inventory with Excel..takes some time to set up, but it is easy to adjust once you have "built" it.
Keith
I assume full responsibility for my actions, except
the ones that are someone else's fault.
posted on March 25, 2001 01:05:16 AM new
I use the built in inventory features of AuctionTrakker. It will keep track of the items you list. I am not sure if it smart enough to figure out not to subtract if it doesn't get a bid, but it automates the tracking and listing.
posted on March 25, 2001 03:39:46 AM new
I'm in the process of writing one for myself because I looked all over the web and couldn't find a program that would do what I needed for a reasonable price. If I can polish it up enough, and make it flexible enough, I may try to sell it.
posted on March 25, 2001 07:37:30 AM new
I'm currently just using a little list in Excel.
I have a really stupid Excel question. And I mean really stupid. But then, I've never liked numbers (and they've never liked me back), so it stands to reason I don't like spreadsheets (and they don't like me back), right?
There's got to be a way, when you're entering data (tab-enter data, tab-enter data, tab-enter data) to use some keyboard combination when you're finished with that row to go back to the left and down one row to start entering data in that row. What is it?????
posted on March 25, 2001 08:05:10 AM new
I did some extensive searching last night and the ones I found are pricey and more than I want in features.
While I am pretty good at html etc for building webpages...I guess I am mentally challenged when it comes to spreadsheets, excel etc....sigh. The simpler the better. There must be others like me....LOL...that just want to enter an item, sell it and take it off inventory. Nothing fancy or complicated.
If anyone writes and sells one please let us know. Thanks.
posted on March 25, 2001 08:09:11 AM new
Hey CleverGirl. The keyboard combo is Enter then Home. So, that in effect is like a carriage return and linefeed on a typewriter.
posted on March 25, 2001 12:03:22 PM new
I'm looking for a good inventory program as well. I have over 300 pieces of silverplate, and I really NEED to keep track of sales and purchases.
I downloaded a bunch of trial and free inventory programs from the AOL archives, but haven't had a chance to check all of them out yet. If you're not on AOL, there is a great site with thousands (if not millions) of free and demo software programs. I just wish I could remember the site addy! Search on "shareware" and it'll come up, I'm sure.
posted on March 25, 2001 01:08:12 PM new
Check www.nonags.com and the freeware section. Browse to "organizers" and see what's there.
An EXCEL spreadsheet is OK ... just enter it when you buy it, with price and put the sales price in when you sell it. periodically you can sort out all the SOLD items and copy them to an archive spreadsheet.
posted on March 25, 2001 05:53:45 PM new
WOW...Hey Abacaxi....that no-nag site is FANTASTIC...thanks for pointing me in that direction. I found a lot of great programs.....THANK YOU!!!!!!!
posted on March 26, 2001 09:10:47 PM newClevergirl, I have found that just pressing the ENTER key will take you to some location* on the next row.
(* I think that MS Excel tries to make some intelligent guess as to where you want to continue from. If you are just entering values straight across, then press return and it should put you back in column A again. If you skip columns then it may put you in the column following the skip.)
posted on March 26, 2001 09:19:14 PM new
To change the movement of the cursor in Excel, go to Tools, Options, Edit & go to the "Move Selection After Enter" checkbox.
Once there, you can select the direction of the cursor after you hit enter. Your options are Down, Right, Left & Up. If you don't want your cursor to move out of the cell at all, uncheck the box.
posted on March 26, 2001 11:34:27 PM new
Filemaker pro is nifty.
Mac comes with a little brother in Appleworks, but Filemaker Pro does do it for Wintel.
I used it on my windows monster for freelance work of a non-video nature.
It's a blank slate, you can customize it nicely.
I use it for invoices, inventory, I can even break down who got what, their ID, etc. I can type in a user and see if they are a repeat customer, or if there was a return, how I shipped, etc.
I can take a few minutes on a customized page and add a bunch of info. If 5 months later (so far no one's done this) they ask for more of "that widget" I can look up what the heck I sent them.
Of course if someone changes email, ID, etc, well there's the rub in any DB, right?
It beats the HECK out of a spread sheet.
Plus I have a separate DB for my own Real Life job. It's great to relate referrals to each other, esp on the phone with a client. And I can pull my inventory, compare it to my gig then go rent, hire, beg, borrow or steal accordingly.
One caveat: It's not plug and play or proprietary for any one task. This means that you will have to spend a little ramp-up time bonding with it - or at the very least customizing it.
If you sell something repeatable, identical etc, you may want to track venders etc as well. (Example - if vender A only sells widget XYZ in one color lot)
Also can pull together info on how auctions do, etc.
I'll be honest, I don't use it so much for that, I really just want to keep track of what I am selling and who it goes to, and of course how much I am selling for, etc.
BUT, my scale is pretty small, so if you are as big as say, Jereth's operation, this may reveal some more info than I even bother with.
