Keep Track Of Your WooCommerce Orders Using Google Sheets And Zapier

WooCommerce is a WordPress extension that makes getting your online store off the ground much faster. It provides you with an eCommerce template, helps track orders, customers, and shipping, and a lot more! In this article, we’ll cover how to automatically add your WooCommerce orders to a Google Sheets spreadsheet using Zapier, which will make it even easier to keep up track of your online shop’s orders. 

Continue reading
Locals Know

Project Profile: Locals Know

Locals Know is a social travel application for the iOS and Android platforms.  We worked on a web-based RESTful API used by the mobile applications to pull data from the server.  Much of the structure for the API was already built by a previous developer.  However, the existing code base had several outstanding issues.  First of all, the database schema did not match the intended design of the app, and there were some other issues.  We restructured the database, wrote migrations, modified the API responses, and fixed several other bugs.  Beyond bug fixes, we also added additional API end points for new features and helped troubleshoot some issues with the API requests from the iOS application.

As well as dealing with the RESTful API, we built a client-facing web interface to allow users to view this content outside of the native mobile apps.  Using the responsive design features in Twitter Bootstrap, we built this web interface to render on desktop web browsers, tablets, and mobile browsers.

In addition, to support this web interface, and the social nature of the app, we built a custom URL shortener system to aid in sharing content via Twitter and Facebook.  The URL shortener created compact URLs, uniform in length, with no discernible pattern, guaranteed to be unique.

For this project we made use of PHP, MySQL, Yii MVC Framework, JavaScript, jQuery, Google Maps API, and Twitter Bootstrap.