JSFoo 2013

All about being creative with JavaScript

Kingsley Jegan Joseph


Distributed, offline-enabled point-of-sale system using Google Apps Script

Submitted Jun 27, 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:

  1. The Design & Usability of POS systems in general and how we created a minimal, elegant UI that requires little to no training.

  2. The unorthodox architecture of our distributed (multi-outlet-ready), offline-enabled system that syncs with Google Spreadsheets. We get real-time insight into exactly how many cupcakes we’ve sold at individual store-levels. We use web-services built with Google Script (Javascript) and Google Docs’ own permission model to manage our data in the cloud.

  3. 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.

Speaker bio

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


{{ gettext('Login to leave a comment') }}

{{ gettext('Post a comment…') }}
{{ gettext('New comment') }}
{{ formTitle }}

{{ errorMsg }}

{{ gettext('No comments posted yet') }}

Hosted by

JSFoo is a forum for discussing UI engineering; fullstack development; web applications engineering, performance, security and design; accessibility; and latest developments in #JavaScript. Follow JSFoo on Twitter more