Distributed, offline-enabled point-of-sale system using Google Apps Script
Submitted by Kingsley Jegan Joseph (@kingsley2) on Thursday, 27 June 2013
In March 2013, my wife and I opened a cupcake store (www.bitemecompany.com) and I went looking for a point-of-sale (POS) solution that could work offline, but synced data with the cloud as often as possible. I also wanted something that was easy to use for our sales people, and easy to customize and deploy for me. Disappointed by the available options, I decided to write my own - we now have an elegant, usable system that continues working even if completely offline, but also provides us with real-time stock & revenue reports via Google Spreadsheets when online.
My talk will cover 3 broad areas:
The Design & Usability of POS systems in general and how we created a minimal, elegant UI that requires little to no training.
Operational deployment & future possibilities. Our deployment process is very simple - the main POS is a self-contained, local HTML file that gets synced through Google Drive. Future possibilities include a built-in loyalty program and lightweight CRM/social media integration.
I will also try to clean up and make the storage/syncing part of the code available at the conference.
Over his 15 years of experience in the software industry, Kingsley has launched & managed multiple million-dollar-plus technology products. Kingsley played pioneering roles at salesforce.com and Digital Chocolate in Silicon Valley. While at salesforce.com, Kingsley created the IdeaExchange, which won the Forrester Groundswell Award, a Webby nomination, and a patent. The IdeaExchange created a new genre of community apps, as well as salesforce.com's entry into social CRM.
Kingsley has spoken at events like O'Reilly's Web 2.0 Expo, Communities Exchange, Facebook's Developer Garage & Droidcon India. He has a Masters in Information Systems from Indiana University, a Master of Arts majoring in Sociology from Annamalai University, as well as a Graduate Diploma in Fashion Design from the National Institute of Fashion Technology.
Design, Sociology, Marketing, Business Development and Product Management for Mobile, Social Media & Emerging Markets