Re: Point of Sale program?
There are many point of sale systems out there that can be customized to your needs, but if you really want to roll your own...
Since you are posting in the C# forum, I assume you will be using C#. If so, I would recommend that you stay in the Microsoft stack and use MS SQL (a version of which is installed with your installation of Visual Studio).
If you want to write a stand-alone app, I'd start with WPF. For web based, I'd go with ASP.Net MVC4. You may consider going with the ASP.Net because there are project templates and tutorials out there that can quickly get you up to speed interacting with an MS SQL database using Entity Framework. They also incorporated security into, so you can have different types of user roles that are able to provide different functionality.
Re: Point of Sale program?
Thank you for your clear and straight advice.
I've looked into lots and lots of customizable point of sale software and supposedly-flexible programs but they were never adequate. I think it's best if I set it up on my own that will include all of my know-hows I learned over the course of using Quickbooks POS.
I was thinking of getting started with C# + any easy and yet robust database first, then moving onto a web-based version because I have four offline-stores and two online shops that I wish to be integrated so no more repetitive work has to done in near future. In this case, do you feel I then might as well just start with ASP.Net MVC 4 and MS SQL right off the bat? For now, I'm trying to achieve a system where customer information (mostly reward points) and transaction histories are sync'd between stores and the office not necessarily instantly but maybe at least every 10 minutes, 30 minutes latest.
Ideally, on one end, two web sites will use the back-end database, and on the other end, four offline stores will also access the same database but use a POS interface within the browser. Also, would this method require a offline mode as well, thus needing a separate windows application? Can this be all done on a domain we're leasing through a web-hosting company, or do we need an office based server?
Thank you for all your inputs.