LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 05-20-2012, 01:16 AM   #1
Beanz239
LQ Newbie
 
Registered: Feb 2009
Location: Phoenix, AZ
Distribution: Linux Mint
Posts: 28

Rep: Reputation: 0
New Project: Point of Sale


I was wondering if the project of building a point of sale would be a good choice on Linux. I'm going to start small with a closed system, not necessarily designed for credit/debit transactions and only cash as a payment. At the moment, this will only be a personal project to see if I can learn some Linux programming.

Some other questions I have here are things like:
Should I have it run as a program or a standalone OS?
If it's a program, what GUI should I use (KDE/Gnome)?
Is Linux capable of connecting with things like banks to do credit/debit transactions?

These are just a few of the questions floating around in my head right now. Also, could anyone refer me to a solid book or website that I could learn a lot of this basic information? I know I'm trying to tackle the world with something this complicated, but I figure I'll start small and work my way up.

Thanks in advnace for any input I receive as this is something I've been wanting to start doing for a while. I plan on starting this out on a virtual machine and eventually transferring it to a Raspberry Pi (that I wish I could get my hands on!)...
 
Old 05-20-2012, 08:39 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065
Good choice? Yup, sure would.

A few things you might want to think about (been there, did that, lessons learned during a wasted youth).

Think data base. Specifically, think LAMP (Linux, Apache, MySQL, PHP) -- no display programming, all that's needed at the business end is a browser, doesn't matter what browser, doesn't matter what operating system, the LAMP server does the work and anything that supports a browser can interact with it. You don't have to lock in with MySQL -- other DBMS' work just fine with PHP. A server with thin clients on a LAN or a server on the internet, a mix of both, not a problem. Think Amazon.com (or pretty much any site you've shopped and bought stuff from -- they're mostly some variant of LAMP).

The hard part is the data base design. I could do a few hours on data base design but, essentially, a data base consists of a number of tables each of which holds unique data that is joined to other tables by one or more keys.

You'd have a table that contains the items you're buying and selling. Pretty much everything you'll ever buy or sell is going to have a UPC; that's your key. The table can contain the UPC and a description (which you get electronically from your vendor).

Point of sale? UPC? Scanner!

Want more information about items, add columns for vendor ID, cost per unit, selling price per unit, taxable (not everything is everywhere), effective date of cost, effecting date of selling price, cost of goods sold account ID, income account ID and whatever else you can think of that is unique to an item.

You have a separate table for vendors (ID, name, address, terms, representative ID).

You have a separate table for representatives (ID, name, address, contact information, whatever).

You have a separate table for purchases, another for sales, another for receivers (add stuff to inventory), another for payables and so on. All that goes in them is an ID, a UPC, one or more dates, units and a price per unit. DBMS' do arithmetic (and statistics and a lot of other mathematical functions) so you don't really need to store totals (but you usually do anyway -- there are carbon-base units that look at the stuff).

You've a separate table for customers.

Once you've got all that stuff you start with Apache and PHP -- data entry forms, data reporting forms, search, whatever -- all done in a browser, or a cash register or whatever you've got.

Frankly, this is not a trivial undertaking. It's doable, hardware (like scanners) is available, most of them are pretty much standard (basically they're more or less a keyboard, delivering a number to your server when you hear the beep). UPC is a standard and vendors are more than happy to provide UPC files to you. Accepting plastic is pretty straight-forward (but, boy, do they get you on transaction costs and percentage of sale).

If you can do a LAMP model system you can sell it for a lot less than a custom hunk of hardware that will be obsolete next week. Thin clients (no disk drive, boots from the server) are inexpensive, no operating system maintenance to worry about (can you imagine having to keep 5, 10, 20 or more Windows things up to date? Ugh!). And, you probably won't be answering the phone at 0300; that's a Good Thing.

Give it some thought, do some research (Google is helpful here), maybe buy a couple of books (O'Reilly has some pretty useful books on these subjects). Mull you options.

Hope this helps some.
 
Old 05-20-2012, 12:22 PM   #3
smoker
Senior Member
 
Registered: Oct 2004
Distribution: Fedora Core 4, 12, 13, 14, 15, 17
Posts: 2,279

Rep: Reputation: 250Reputation: 250Reputation: 250
Quote:
Originally Posted by tronayne View Post
Specifically, think LAMP
I concur. Personally I would prefer Perl to PHP but that's life. You can make a system that runs completely solid state from ram and a compact flash card. Upgrade / update ? Simply plugin a new compact flash.
 
Old 05-20-2012, 01:40 PM   #4
CincinnatiKid
Member
 
Registered: Jul 2010
Posts: 454

Rep: Reputation: 47
A few years ago, in my senior year of college, I created a POS system using LAMP for my senior design project. I thought it was great because it was truly platform independent, everyone thought I was crazy for creating a web based POS system though for some reason.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Install Issues with L-ane Point of Sale computer_cody Linux - Newbie 4 08-25-2009 10:35 PM
Point of Sale Software? Jeff91 Linux - Software 1 03-06-2009 10:23 AM
Point of Sale tommyc1984 Linux - Software 1 03-26-2007 06:51 AM
Point of Sale for Linux marsh12 Linux - General 5 04-24-2004 06:16 PM
Kitchen video/ Point Of Sale for linux?? frieza Linux - General 3 03-21-2002 01:21 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 05:57 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration