Slashdot Mirror
Software for Membership Tracking and Inventory?
ZeLonewolf asks: "I'm a consultant to a customer who owns two franchises of a fitness gym. The computers they use to keep track of members and inventory run DOS programs written in the early 90's by a company that has long since gone out of business. My customer needs an upgrade badly. Replacement software to keep track of members and handle check-in and membership expirations, as well as inventory and point-of-sale data, costs $5,000 and up, so a free software solution is desirable. Does GnuCash do the job? Have Slashdot readers successfully set a small business up with Free/Open Software? What software have you had success with?"
$5000 for an assumed lifecycle of 3 years comes down to about $137 a month. If your customer can't afford that, especially for what is likely to be a piece of business critical software, he should consider a different line of work. My work consists of helping customers evaluate Free / Open Source Software for businesses, and those that only look at FLOSS because it is free as in beer invariably end up not implementing FLOSS. Those who use FLOSS because of other reasons, such as source code availability etc, usually end up as success stories. Yes, FLOSS is a very powerful tool for the small business market, and my customers range from the 2-man-band kinda organisations, as well as the top of the Fortune 100, but if your business isn't worth an investment of less then $200 a month for your core system, you have to reasses your priorities.....
People who think they know everything are a great annoyance to those of us who do.
GNU Cash isn't all that extensible.
Have you looked at commercial database programs? There's lots of open source programs database programs, but they tend to be difficult to use for the end user (you could write a nice php front end for MySQL, but it may be time consuming). Rather, why not try (I shudder to recommend a MS product, but...) Access or the newly released FileMaker Pro 7? I can attest to FileMaker's ease of use (though I'm still on version 6) and its relative performance. Granted, it's not free, but at $300, it's not too overpriced.
An effective signature identifies a particular user amongst a base of thousands.
Goals for a future release: Database Independence.
php/mysql all the way....
Can you do it? Appearently I'll be paying less than a dollar an hour. When can you start?
I've written a point-of-sale system myself, and a fully-featured, relatively bug-free system might cost at least $100,000 to write. It's a LOT more work than it first seems to make it easy to use, for example. Retail operations are far more complex than they first appear.
Also, if your client isn't using barcodes, scanners, etc, you *might* actually be able to get by with this using nothing more than a LAMP solution.
Anthony Papillion
Advanced Data Concepts, Inc.
"Quality Custom Software and IT Services"
I ran my software consulting business on GnuCash. It was really pretty great, actually. Once you follow the tutorial and get a handle on basic accounting practices, I was able to handle all my expenses, invoicing, accounts payable/receivable, etc. Good stuff.
A lot of people kind of react poorly to GnuCash because it isn't a simple checkbook app. In my experience, that's a shame. It CAN be used that way--I run my personal finances on GnuCash, too. But it's powerful enough to run a mid-sized business on.
If your client is looking more for a POS app, take a peek at Banana POS. I don't know that much about it, but it is F/OSS and might be closer to a tracking application than GnuCash.
The open source Clubdata project might be of interest.
boakes.org
I'm not trying to imply that an upgrade *isn't* needed, but you didn't list a single reason in your question for upgrading. Being an old DOS app is fine if it works. Having no support is fine if you aren't having issues, and haven't in ages. Is the software not doing something he needs? Is it broken?
If it's doing the job it may be a good idea to keep it. You'll have the benefit of being able to run on practically free hardware, and no migration costs. Plus, whatever new vendor you find may not be a stupid as the company that sold you the previous software, and they might force you into an upgrade cycle, which is practically the only way a software company that targets such a narrow market can stay in business. Is that new software really just $5000, or are there yearly "maintnence" fees? Do they come out with a new version every 6 months?
Even free software has costs associated with it. It's free as in "freedom," not free as in beer, remember? You're unlikely to find exactly what you need, so how much of your time will you spend building something? How much is it worth to you compared to what you have, and this $5000 option?
If you decide you really do need something, and you don't want to buy a commercial product, a good option may be to find yourself a freshman year computer science student. After their first year they should have all the skills nescicary to build a simple database application for your membership needs, and they'll likely be availble for 3 more years of cheap support. It may cost you about $5000 in the long run, but it won't be all at once, and you'll get something that's tailored perfectly to your needs. When it's done, perhaps you could release it as free software, so the next guy in your situation doesn't have to reinvent the wheel. I know a few small businesses that do this, and it's worked out quite well for them. Also, I did this for a company when I was in college, and it worked out quite well for me too. I don't recommend having a custom built app handle your financials though...
I've written inventory software, but there is no chance that it'll ever be free. The reason for that is simply that inventory systems are typically enterprise applications and target LARGE COMPANIES.
Maybe what you need is Microsoft Access, or perhaps even MySQL and simply manage the data with one of the many front-end GUIs.
The Political Programmer
If your customer is unwilling to spend $5,000 on business-critical software, he's probally unwilling to spend $5,000 on YOU as well.
A small gym with 350 customers is grossing a minimum of about $170k/year from memberships alone. If he cannot afford a $5,000 capital expenditure, he's out of business within a few months.
Conformity is the jailer of freedom and enemy of growth. -JFK
As an IT worker for a YMCA we've recently been looking at software to replace our aging DOS application as well. I've looked at quite a few different packages and I'ved listed them below along with websites. Many of them are YMCA centric but they might still be of help.
* Aphelion (http://www.aphelion.net)
* Christensen Computer Company (http://www.cccsoft.com/)
* Class (http://www.classinfo.com/)
* CSI (http://www.csisoftwareusa.com/)
* Daxko (http://www.daxko.com)
* Finesstri (http://www.finesstri.com/)
Those are a few that I've found during my search. I've personally seen Aphelion, CCC, Daxko and Finesstri. Daxko's pricing is revenue based where most of the others set a rate on number of users or other factors that might suit a small place well.
I've spent about six months or so repairing a botched installation of Quickbooks (http://www.quickbooks.com) and setting up an inventory and accounting system for a small distribution/wholesale concern. Aside from the fact that QuickBooks was designed by accountants who obviously hate all techies, and despite the additional badness of possessing an inflexible and proprietary back-end with a five- or ten-seat 'concurrent use' limit, Quickbooks possesses the following serious advantages:
:)
1. Price. A one-year subscription to Quickbooks Pro, including tech support, costs $85 a month, which means that you get the whole accounting package for a little over a grand. (You can cancel your subscription and keep your seats.) That's a steal, especially since I'm computing this in Canadian dollars.
2. QB Pro comes with an SDK, so you can buy third-party extensions to attach your database to ODBC, etc, which mitigates the allergy you might have to proprietariness. Also, people like www.numbercruncher.com have developed very complete sales/invo add-on packages for Quickbooks, which are worth taking a gander at if Quickbooks built-in inventory system is insufficient. (It'll probably be sufficient on its own, however, unless you're doing something weird.)
3. You really, really don't want to roll your own accounting system. Funny thing is that an inventory system must be pretty tightly integrated with an accounting system in order to work well. (ie. inventory adjustments should alter the accountant's info about what assets you have on hand; double-entry bookkeeping dictates that the difference in the asset account must match an occurrent change in an income account; valuation must be performed by averaging the cost of each order of a given inventory item type; etc.) You don't want your client to get to year-end and then find that his books don't make sense. The IRS and Revenue Canada both hate that sort of thing, and your client will likely pass the hatings on to you. Don't leave him up that particular canal without a gondola pole.
4. Quickbooks is really easy for end-users to use. Ease-of-use is paramount when you're going to let the minimum-wagers at the counter enter info.
5. Intuit sells a POS for QuickBooks. Never tried it, but I'm sure it works well.
6. Quickbooks might be too dinky for your client's business, but that's okay: It comes with a 60-day money-back guarantee, so you can try before you buy. If quickbooks isn't enough, go get $10,000 of AccPac like everyone else.
7. Message me for more info about what I've seen work and not work.
- undoware.ca
If the problem is with FoxPro for DOS, maybe I can help. Reply to this post.
If the problem is with serial port compatibility in Win XP, I may be able to help there, also.
my community food co-op
has been using this for years now
linux canada quasar pos
back in the day we didnt have no old school
"5. Intuit sells a POS for QuickBooks. Never tried it, but I'm sure it works well."
Intuit is number 4 on the Gripelog Hall of Shame. It was number 1, but now the others are worse! That means that Intuit has been voted one of the most abusive computer companies in the world. Do you want them for a business partner?
I've looked at the hardware sold in a package with the QuickBooks POS. It looks VERY cheap. Anyone have experience with the package?
She's on a death rampage for yuri's soul and he should stay away.
One of my businesses is a retail store and we use the CamCommerce RetailIce POS (that's "Point-of-Sale", wise guys). The cost is $30 for a stand-alone station and it runs on a Windows PC. While I'm not sure if they still do this, the publisher was selling it on EBay for $15 when I bought it.
RetailIce is a full-featured system that does what you are looking for. We have been using it for almost two years now and it has certainly been very much worth the cost.
The reason for the price (which basically just covers production and shipping) is that they realize that a small business (mom-and-pop typically) cannot afford a full-blown $5000 per station system. So they give it to you in hopes that you will be successful, grow, and then need more licenses. It's a nice business model that has been working out very well for them. It's important to understand, however, that the $30 version only supports a single station. If you need more, then you might want to look into the POS solutions from Wasp or (dare I say it?) Intuit. I haven't used either but the are less than $500.
You can find info on it at www.camcommerce.com and, no, I don't work for them.
Ryosen
One man's "Troll, +1" is another man's "Insightful, +1".
It's called Accounting, any half arsed account package supports repeat billing for fixed lengths of time. Any decent accounting program can handle inventory.
I don't know where the submitter is getting $5000, in 2hrs you can get Quickbooks or Peachtree up and running to do everything you've mentioned with Nice pretty idiotproof forms and restrict access to everything the people filling out those forms shouldn't have access to.
Unfortunately no, there is no open source answer to Quickbooks/Peachtree and such.
Unfortunately most techs aren't accountants and they may know how to fix problems with programs like quickbooks and peachtree but don't have a clue as to their full capabilities or use. Accountants know what they need but depend on the techs to setup the software.
This means there are MANY MANY MANY custom accounting and inventory programs out there, which cost thousands of dollars, probably lock up the data in some proprietary unexportable fashion (at least there is documentation to get data out of either quickbooks or peachtree) for NO valid reason. Yes some things require additional modules but your HIGHLY unlikely to rack up $5k on peachtree or quickbooks modules.
On windows with proprietary software at least accounting/inventory/pos doesn't require a custom application, if quickbooks won't handle it seamlessly then peachtree can.