OrderPipe.com Multi-channel Sales Dashboard for Magento, Amazon and Shopify

November 2, 2011

There’s been a distinct lack of new Magento content here for the last few months. That’s because I’ve been busily beavering away on our latest internal project which I’d like to share with you. It’s only partly Magento related, so bear with me. We’ve created a multi-channel mobile sales dashboard on Google App Engine called OrderPipe, and it’s now been made publicly available. It aggregates order data from multiple online sales channels for consumption on mobile and desktop.

OrderPipe.com screenshot

We launched a private beta trial at the end of September, and are nearing a point where we’ll be making it generally available (albeit initially free) to everyone.

I thought I’d take this opportunity to tell you about it, what it does (technically), and why it may interest you.

Internally OrderPipe is used to keep track of what sales are happening and which channels are doing well on any given day, and to summarize that data for each month. We access it from iPads, iPhones and on the desktop tens or even hundreds of times a day (on particularly exciting sales days).

Keeping a handle on sales became hard once we started running multiple Magento stores, and selling through multiple Amazon markets. Our solution internally was to start slurping order details from multiple places and aggregating them in an App Engine app. Over time that app has grown and evolved, and now we think others will find it useful too.

What does it do?

OrderPipe brings orders from several sales channels into a single place, and aggregates them for display on a mobile dashboard (think tablets, smartphones etc). From a technical point of view, that means we hook into the API’s of various sales channels and pull order data into our own system. On the way in the data needs to be cleaned up and any gaps in the data plugged through a variety of means. We’re constantly working to improve the data quality, it’s a never ending job finding places where API data is lacking and finding ways to import it consistently for display along side orders from other sources.

Some cool things OrderPipe does:

Revenue Progress Worm

A Sales Progress ‘worm’ inspired by the politcal devices shows you your sales progress through the day, and how it measures up to the recent average day. You can see if your day is off to a good start or not, whether you’re likely to have an above average day, and when reviewing previous days, which days were well ahead of the recent average.

Sales Map

A Sales Map, showing you where individual sales are happening (as they happen during the day) and also giving you a shaded color indication of which states are earning you the most revenue relative to each other.

There are loads of other features too; top sellers, top earners, order lists and order views. You can try out the demo dashboard by filling out the demo form.

What else will it do?

Internally we use two tools; Roambi and Geckoboard for detailed sales analysis and a shared ‘office dashboard’. To do this we feed our OrderPipe data into these systems. Public API’s to do this, and to more generally access your OrderPipe data programatically are very high priorities on our roadmap.

Equally important is getting order data into OrderPipe from sales channels that we do not yet support (eBay, WooCommerce, Jigoshop and WP-Ecommerce, for example) – we’re hoping a published input API will help other developers bring their own data.

Why you should use it?

We’re really aiming this at business people who are actively running an ecommerce store and selling on multiple channels. One of the things Magento and Amazon do poorly is give you a up-to-the minute data in your pocket, particularly if you want to see the whole picture in aggregate, rather than logging in to different sales channels. OrderPipe solves the problem of multi-channel sales visibility, and lets you enjoy the benefit of an internet business, away from your desk!

As an agency, if you have clients using Magento and also selling on Amazon (or soon eBay) and think they might be interested, please contact us for more information about how we can work together.

Try the Beta

We’ll be running the free private beta for a short while longer, so if you’re interested please let me know. Once we launch we will hopefully be offering a ‘free for the rest of 2011’ deal so that people can continue to try OrderPipe. Going forward a monthly pricing plan starting at around $9/month is the plan, depending on transaction volumes.

Stay tuned for an update on OrderPipe once we release it for general availability, and if you’re interested in the project, please check out the OrderPipe blog for ongoing product and feature updates.

Ashley

Posts

Hi! I'm Ashley Schroder, a Software Engineer from New Zealand - this is a collection of notes on my experiences with Ecommerce Web Development, particularly Magento Development.

Are Your Customers Getting The Magento Emails You Send?

MageSend Magento Email sending with Amazon SES

I have made a premium Magento Extension called MageSend. MageSend makes it simple and easy to send using Amazon's highly reliable SES email service.

The extension is $99, and comes with a complete money back guarantee, please check it out, I am confident it will resolve any email sending problems with your Magento store.

9 responses to OrderPipe.com Multi-channel Sales Dashboard for Magento, Amazon and Shopify

  1. This is very cool! One the x.fabric matures a bit more this would be a natural fit… just subscribe to order messages from any endpoint publishing them. Are you planning to use it as one input channel?

  2. I get a feeling you don’t mean this: http://x-fabric.com/home/ did I miss something interesting/relevant at the Innovate conference?!

  3. Ok, so this Fabric is what Vin was referring to – the bus for the X.commerce system eBay/Paypal/Magento are building. (so out of touch it seems, after missing an important Magento conference…)

    This sort of API call will be very useful for eBay integration in OrderPipe (which is coming soon)

    Also seems like a pathway to, I assume, Paypal’s in-store/NFC payments for local brick and mortar stores (maybe)?

    PS: whenever I hear the word ‘bus’ mentioned with respect to webservices I shudder – it reminds me of the early to mid 2000’s ESB overkill. Fingers crossed that’s not what fabric will turn out like!

  4. Two of the greatest things about OrderPipe:
    1. It shows orders from all your sales channels aggregated into overall sales metrics. Maybe there are lots of people who sell only on one webstore, but for those of us that sell using several stores and marketplaces OrderPipe is the best way to get an immediate view of how things are going overall.
    2. It is very clever in the way it works around the idiosyncracies (did I hear someone say severe failings?) of the Amazon MWS APIs. What this means is that even though Amazon seems to be doing its best to prevent it, OrderPipe gives you timely information about your sales through the Amazon Marketplace and Webstore-By-Amazon sales channels. Ever tried running Seller Central on your mobile phone, or trying to figure out what your Amazon sales are so far today? You’ll love OrderPipe.

  5. Hi
    Would love to try the beta however currently I cannot save any roles in Magento version 1.6.1.0, I did a search on the topic and it seems to be a comment problem in Magento 1.6. Anyone found a workaround for this?
    Thanks

  6. Hi,

    I’m interested in testing it.

    Thanks
    Bruno

  7. Ashley, I’ve got a number of multi-channel e-commerce clients who have been looking for a service just like this for a long time, but when I show it to them they all say they exact same thing: “What about eBay?”

    Any chance that adding eBay is on the short list?

  8. Ashley, I’m coming to Imagine and will be at your session on APIs. Would love to chat more about this beta and other ways we might work together.

  9. Any way I can pull all orders from marketplaces to view in the magento back end. When I make a sale across a marketplace it will adjust the magento inventory accoringly on my core site. Also price updates or quantity updates from magento admin will generate updates to the various marketplaces ie amazon marketplace.