Simple Retail Solution iSeries POS

Posted on 2016-08-02
Last Modified: 2016-08-04
Has anyone got any idea's on a product that will handle a simple, small, Mom and Pop Shoe Store, that will allow inventory (UPC, Style, Width, Size, Color, Description) to be uploaded (via CSV or other text) and allow scanning out at POS time, and possibly even hook up to the bank.

Even if its an app that will run on the PC, and have the ability to download a CSV to the iSeries.
Us as programmers can handle an initial inventory of the store on the iseries by scanning with a tricoder and uploading the data.
Its the iseries/POS area that has us confused.

All of our "Retail" solutions I seem to find, want lots of dollars and act like we are a Sears or something. This is a simple inventory/POS program.

Thanks in Advance.
Question by:RjCoats
  • 3
  • 3
LVL 27

Expert Comment

ID: 41739440
I'm not aware of any non-"Sears"-scale POS specific to IBM i. But have you searched for [open source POS]? There are a couple that could be modified/configured for a DB2 back-end that could be on IBM i about as easily as anywhere else.
LVL 34

Expert Comment

by:Gary Patterson
ID: 41741141
Most IBM i POS solutions are designed for larger, multi-location retailers.  There are a blue million inexpensive small business POS solutions out there, including cloud solutions and many that run on Windows - that will support inventory import/export (or that already provide inventory control features).  

I'd need to know a lot more about the business to make any specific recommendations.  Here are just a few examples of questions:

Is this a new store or an existing store?  If existing, what do you use now?  
Do you need compatibility with existing POS equipment?
What's driving the need to interface with IBM i?  That's an unusual requirement for a small "mom and pop" company.  A lot of small business POS systems include inventory management.
How many locations?  Plans to add more?
How many registers do you have/need?  
Do you need employee timekeeping?
Loyalty program?
Gift cards?
Web store integration for shared inventory, inventory visibility, order online and pickup in store?
Special order / vendor drop ship?
Credit card processing?
Delivery order processing?

Author Comment

ID: 41741185
Thanks Gary...
here they are as you requested.. But in short, we are a shoe manufacturer, and have an "FD" store built on our warehouse. Been here forever, just never tied to a computer. Inventory on Paper, and marked off as its sold, and a credit card machine and cash register for cash...
Basically, we want the POS mostly for transaction processing, but at least be able to batch it to the iSeries for inventory and sales reports.

Is this a new store or an existing store?  Existing

If existing, what do you use now?   Credit Card Machine, Cash Drawer

 Do you need compatibility with existing POS equipment? No.

 What's driving the need to interface with IBM i?  Our Manufacturing System is an ABS (Apparel   Business Systems) program purchased and modified by our IT staff. It has all of our UPC data (which we can transfer to an outside POS sytem). It also has SEQUEL installed so we can show reports once we write a system on the iSeries.

That's an unusual requirement for a small "mom and pop" company.  A lot of small business POS systems include inventory management. Correct, hoping to integrate.

 How many locations?   One, Plans to add more? No

 How many registers do you have/need?   One.

 Do you need employee timekeeping? We have that on the iSeries.

 Coupons? NO
 Loyalty program? NO
 Gift cards? NO
 Web store integration for shared inventory, inventory visibility, order online and pickup in store? NO
 Special order / vendor drop ship? NO

 Credit card processing? YES
 Delivery order processing?  NO

Pretty much want something in windows, that can scan a product, know what it is and costs, process the credit card, then batch up the information, even if its a UPC, and transfer to the iSeries for reporting and inventory.

Thanks for the questions and help.
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

LVL 34

Accepted Solution

Gary Patterson earned 500 total points
ID: 41741394
OK,  I have a much better picture now.  

There are a lot of inexpensive non-cloud POS systems that are suitable for a single store and come in a little hardware/software bundle (very low priced example is the Royal TS1200MW - $600 at Sam's Club).

Looks like this has Quickbooks integration features that you might be able to leverage to get data exported and with a little code into a format you can use.

Author Comment

ID: 41742381
Thank you Gary. I just took a glance at the specs, don't see UPC import, or Credit Card processing (we are hoping for an internet Card Processor, get rid of a phone line), BUT, you just guided me in a direction now, that I didn't think of. While I was looking for "Software", I may be looking for a "unit" to interface with that handles the things I would like.

Awesome. Thank you Sir. I think I am going to call royal, and see if they can guide me to the correct product and we'll see.
Thanks again
LVL 34

Expert Comment

by:Gary Patterson
ID: 41742427
Great.  Some of these small systems are sold as a hardware/software bundle.  If you find something that works for you, post back.  I'd be curious to see what you end up with.

Also, don't forget Tom's suggestion - several open source POS packages and POS development frameworks out there that you could customize to do anything you need.

Author Comment

ID: 41742441
Will Do.
Thanks again Gary.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now