Skip to Content
Author's profile photo Former Member

Openui5 + Heroku + Mailgun + Google Spreadsheet + Dropbox = the whole package = a simple yet robust e-commerce solution


Ever since I encountered Openui5, this awesome front-end framework, I’ve been thinking, how could I introduce it to more people, how about an end to end real-life application? Not only showcase the goodies of the framework, but show people how easy it is to work with a back-end database, to deploy, and to add common features like sending emails, make it the whole package.

So here it is, the Openui5 demo app – shopping cart on steroids 🙂

Key features:

  • Powered by Openui5 / Ruby Sinatra. It’s built on top of the demo app, the only non-Openui5 / JavaScript code is the email sending part, which is written in Ruby.
  • Hosted by Heroku, which connects with my Github repo (automatic deploy).
  • Outgoing emails service is provided by Mailgun. Their free plan allows us to send out 400 mails each day.
  • Images hosted using Dropbox.
  • And the best is that it uses Google spreadsheet as the database (I had a reusable Openui5 module written for this task), which makes it super easy to manage the back-end data, and robust as hell.

I’ll go out and say this is the perfect e-commerce solution for mamas and papas stores, give me five ^__^

Actually I’m fairly new to programming, you could for sure sniff some code smells here and there, but it does not keep me from solving problem programmatically and contributing, cheers.

Check out the live demo, and all of my code:

Live demo

j1wu/openui5-app-shopping-cart · GitHub

j1wu/openui5-module-sheet-as-model · GitHub

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Alexandre Costa
      Alexandre Costa

      I think your solution awesome, Ji Wu!

      Regarding your sample, is possible to share a google spreadsheet as public as JSON format, is correct ?

      Is it possible to manage data (like CRUD application) ?

      I'm figuring out something like this !

      Thank you !

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Alexandre,

      Thank you 🙂   Check out the read me of my SheetAsModel module, it explains how I convert Google spreadsheet into formatted JSON model, and here's the spreadsheet I'm using in this application. Unfortunately, as far as I can tell, it can only be used as the read-only data source, if you want to do all CRUD operations, I'll probably go with services like Parse.

      Author's profile photo Martin Böschen
      Martin Böschen

      Impressive! Thanks for the Demo!