OrderPipe Magento Extension Now Available on Magento Connect

The OrderPipe Magento extension has just been released, it will ping the OrderPipe platform as soon as you make a sale, so that we can fetch orders to your mobile dashboard in near-realtime.

You can get the extension directly from Magento Connect or peruse the open-source code on Github. If you have any questions about the extension, please let us know.

OrderPipe App Now Available

We’re very pleased to announce that the new OrderPipe app is now available in the App Store. The App allows you to set daily goals on revenue or orders and notifications for orders of certain sizes. When a goal or notification is triggered you can have your phone or ipad play a ‘Ch-Ching’ sound, or the default system notification (or no sound at all).

We’ve been trialling the app ourselves for the last few months and love getting a little Ch-Ching sound when a big-ticket order comes in or we break our expected revenue goal for a day.

So grab it from the App Store and give it a try, any feedback would be very much appreciated.

Connecting OrderPipe to Amazon in Detail

OrderPipe.com integrates with Amazon to make your Amazon.com, Amazon Webstore and Checkout by Amazon sales available in our mobile sales dashboard. We can connect to Amazon.com, Amazon.co.uk, Amazon.de, Amazon.jp and Amazon.ca - more marketplaces are coming, if you have specific requirements, please let us know. To add an Amazon Sales Channel click ‘Add Order Source’ in the settings menu. This will show a screen like this:

To connect OrderPipe to your Seller account you need to provide a Merchant ID and a Marketplace ID. To allow the OrderPipe application to access your account visit the appropriate Marketplace signup page by selecting the link.

alt text

Some users have reported the links above do not correctly populate the OrderPipe developer ID and application name. If that happens to you please input the information below manually:

Application Name: OrderPipe

Developer ID:

Amazon.com 9535-3333-6211

Amazon.co.uk 4448-4546-7087

Amazon.ca 1968-0823-1336

Amazon.jp 6266-0919-4743

Amazon.de 4448-4546-7087

Once you have inputted this information, Amazon will display the required Merchant ID and Marketplace ID. Lastly, copy and paste these values into OrderPipe, and save your order source. OrderPipe immediately begins fetching yoru recent history and crunching the statistics for your dashboard. You should be able to see your results within 15 minutes, but if the platform is busy, it can take up to an hour. If you still have no result after an hour, you should contact us.

For choosing a currency, we suggest setting your OrderPipe account to your primary currency, and either converting other currencies if they arrive, or ignore them, and create more OrderPipe accounts for your other marketplaces. It is fast and easy to switch between OrderPipe accounts.

Connecting OrderPipe to Amazon

You sell through the Amazon Marketplace and you’d like to see your Amazon sales on your OrderPipe mobile sales dashboard. Here’s what you need to do to make the Amazon-OrderPipe connection.

In the OrderPipe Setting screen click the big button labelled ‘Add Order Source’.

Add Order Source

Then click the Amazon button and you’ll see a form appear, asking you for three pieces of information.

Form Add Amazon Order Source

Marketplace ID and Merchant ID

Together these two pieces of information are the credentials that OrderPipe will use to connect to Amazon’s systems to request your order data. OrderPipe uses a service called Amazon MWS, “Amazon Merchant Web Services”. You’ll need to log in to Seller Central to enable MWS and and to find your Marketplace ID and Merchant ID. While you’re in the MWS part of Seller Central you’ll also need to grant OrderPipe access.

Market

This is where you tell OrderPipe which Amazon Marketplace to connect to.

Once that’s done, tap the big ‘Submit’ button. OrderPipe will connect to Amazon MWS and start displaying your Amazon orders. It can take a few minutes to make the connection, and to process the first sales statistics. If all’s well, there’s nothing more for you to do than go to the OrderPipe main screen to watch your sales roll in.

Orderpipe Now Has Tags

Great News! It is now possible to group your sales in any way you would like with our latest feature, Tags.

Revenue By Tag Pie chart

A Bit About Tags

Tags allow you to create groupings of products that match certain criteria. For example, you could have a tag for your best selling products, called ‘Best Sellers’ and a list of the SKU’s that match that criteria will be tagged as ‘Best Sellers’. This way you can quickly see what % of your sales, are made up of you best selling products.

Another example is to use tags to mark certain brands of product you are interested in. A common use case is the first few characters of a products SKU is often it’s brand. We are able to use regular expressions to define tags. If you had a range of widgets made by Acme Corp whose SKU’s all started with the letters AC, then you could define a regular expression that tags all their products with the ‘Acme Corp’ brand. This would allow you to see what portion of your sales are made from Acme products.

How do Tags work?

When Orderpipe crunches numbers for your orders from Amazon, Magento and Shopify it will now also check which tags apply to an order, and calculate statistics for those tags. The tag data is available in a number of places; The mobile dashboard has a pichart, the Geckoboard integration shows tags for a number of it’s widgets and very soon the XML and JSON API’s.

How Do I Start Using Tags?

Tags are created, edited and deleted from within the Settings area of OrderPipe. You’ll need to signup first.

To create a tag follow these steps:

  1. Enter a Tag Name that you want to identify the tag with, for example: ‘Top Sellers’, ‘Brand X’ or ’ Winter Clothes’.

  2. Choose the type of tag you want; either a list of SKUs or a Regular Expression (Called a ‘Regex’).

  3. Set the Tag value (further explained below) for your tag.

  4. Click the ‘Create Tag’ button to save your tag.

editing tags

How Do I Change My Tags?

You can view or edit a tag by clicking on it as shown in the screenshot below. In this dialof you will have the option of editing the value for the tag, as well as setting a preferred color when the tag is displayed. The preferred color will be set to “Don’t Care” by default, this lets the display widget decide on a suitable color. Remember to save your changes.

Note: OrderPipe may take a while to recaluculate your tag data for the current day, please be patient.

Tag Types and Values

This section will summarize the two types of tags and how their values differ.

The List of SKUs

This is the most common type you should use for small collections of products.

This tag type uses a comma-seperated list of SKUs to determine which products should be included in the tag.

Here are some examples:

Tag ‘Winter Products’

List of SKU’s: WJ0001,WJ0002,WJ0003

Tag ‘Summer Products’

List of SKU’s: SJ0001,SJ0002

The ‘Winter Products’ tag will match WJ0001, WJ0002 but not SJ0001.

The ‘Summer Products’ tag will match SJ0001, SJ0002 but not WJ0001.

The Regex

This is a powerful tag type and is recommended for advanced users.

This tag uses a regular expression (regex) to determine what products should be included in the tag.

Here are some examples:

Tag ‘Winter Products’

Regex: WJ.*

Tag ‘Summer Products’

Regex: .**S.

The Winter Products Regex tag will match WJ0001, WJ0002 but not SJ0001.

The Summer Products Regex tag will match SJ0001, AS0001 but not WJ0001.

For the nitty gritty information on how regexes work read here.

Tags Created, Now What?

Once you have your tags set up you will see a pie chart that breaks down each tag on the OrderPipe mobile dashboard.

Pie Chart Example

You can also see pie charts on your Geckoboard dashboard using the pie chart widgets and very soon we will have the ability to filter all the Geckoboard widgets by a specific tag. Exciting stuff!

Geckoboard Support for Amazon, Magento and Shopify.

We’re very excited to announce support for Geckoboard widgets from OrderPipe. This means you can now display your OrderPipe metrics such as revenue, orders or units (current or 30-day history) as Geckoboard custom widgets. You can also show OrderPipe sales locations on a map on your Geckoboard dashboard. As a bonus, using our other new feature, tags, you can even show pie charts which break down your tag revenue, units or orders metrics for the day so far. Can you tell we’re very excited about this?! We’ve been using a ‘pre-alpha’ (read: in-development) version of the our widgets on a Geckoboard LCD in our office and it’s totally cool to see the metrics on a big screen. The projector I’m told, sadly, has to wait until the numbers are a bit higher! The good news for merchants selling on Amazon, Magento or Shopify is that you can now effortlessly show key ecommerce metrics alongside your Google Analytics, Salesforce, Facebook or Twitter interactions or server performance monitoring widgets with Geckoboard - too easy.

What is Geckoboard?

Geckoboard is a hosted, real-time status board serving up business indicators such as metrics for web analytics, CRM, support, infrastructure, project management, and sales.

Geckoboard dashboards are perfect for display on a big screen in your office showing real time, automatically-updated, the key metrics to keep track of your business. For e-commerce businesses key metrics include orders, revenue, top-selling products and sales trends. What’s the best source of metric data to display on a geckoboard dashboard? OrderPipe.

Geckoboard

How does it work?

There’s only two steps, one on the OrderPipe side to enable Geckoboard and one on the Geckoboard side to grab the Orderpipe metrics into a custom widget.

1) In OrderPipe go to your settings and enable Geckoboard by clicking the button, surpisingly labeled ‘Enable Geckoboard’ as shown below.

Once enabled, the Geckoboard settings section will reveal the wide range of available widgets, and each will have a specific URL beside it.

Geckoboard Enable

2) In Geckoboard create a new custom widget with the following settings:

   - Widget type : Custom
   - Feed format : XML
   - Request type : GET
   - Reload time : this can be whatever you want but 3 minutes is quite nice.
   - Label : whatever you want.

And obviously the URL is one of the URL’s that you copy-paste from OrderPipe.com - chosen depending on which actual metric you want to see.

Geckoboard Modify

That’s all there is to it, the Geckoboard widget will use the special URL we generated and grab your metrics, graphs, maps or pie charts for display along side any other dashboard data. That has to be the easiest way to get Amazon, Magento and Shopify hooked up to Geckoboard? Whoop! We think so too.

Is this Secure?!

Each Geckoboard URL is uniquely generated using two 128 bit keys - if you are reading the section on security you may care to know they’re cryptographically strong pseudo random numbers but more importantly, with two of them combined, you have 2 to the power of 256 possible key pairs (that’s about 7-with-68-zeros-after-it years to break the key at 5 attempts per second). So the URL’s themselves are strong, no-one will guess yours that’s for sure. But if you give it to someone, and then later decide you do not want them to have access to your data, you can refresh your keys by clicking the button on the settings screen. This will invalidate your previous Geckoboard URL’s and only your newly generated ones will work.

What Widgets can I use?

At the moment there are 15 available widgets to choose from. There are five types of widgets each of which can be used with one of three metrics; revenue, units or orders.

Simple widgets

Geckoboard Orders

This widget shows the current days value for Revenue, Units or Orders. This is very useful for seeing how your daily sales have been going. This is a Custom Widget of type ‘text’ in Geckoboard.

30 Day Line Graphs

Geckoboard Graph

This widget shows the last 30 days values for Revenue, Units or Orders. This is very useful in seeing the trend for you sales over the past 30 days. This is a Custom Charts of type line chart in Geckoboard.

Top SKU Table

SKU Table

This widget shows you your top SKU’s that have been selling today. It will automatically place any other sales not in your top SKU’s in an other category. This is useful to see what SKU’s have been selling well today. This is a Custom Widget of type text in Geckoboard.

Map Widget

Geckoboard Map Widget

This widget shows you where orders have been coming in from today. It also shows bigger points for bigger sales in that city, either more revenue, units or orders. This is a Custom Widget of type Map in Geckoboard.

Tag Pie Charts

Geckoboard Pie Chart Example

This widget shows a pie graph of your sales today, based on custom tags you configure. You can find out more about tags in our other blog post announcing the feature. It will use the colour you chose for each tag, or an arbitrary colour if you choose “don’t care”. If you define tags for brand, or product category than you can visualize what percentage of revenue is being made by members of those categories or brands. This is a Custom Chart of type pie in Geckoboard.

Note: Since an item can match more than one tags the pie charts can reflect more than the total amount of revenue, orders or units in a day - so be careful about how you set up your tags, or reconsider using a pie chart if your data does not fit well to the pie chart assumptions.

Stay tuned we’ll have a blog post shortly about how to setup and define tags, and also how you can best use them with your order data.

If you have any questions or comments on how these widgets work, please do not hesitate to contact us.

New Features for OrderPipe

We’ve been busy working on some great new features in OrderPipe these past few weeks. Here’s what’s new:

A drop down navigation panel

You can now tap view to reveal options for navigating through your dashboard history, the arows take you forwards and backwards (but only as far forward as today, we’re not futurists!).

Monthly summaries

Another of the View options added is the Monthly button. Tap this and your dashboard will change from a daily summary to a monthly one, the current month is presented with month to date data.

View Panel

A fully functioning demo

For those who want to fully test-drive OrderPipe before deciding - we now have a fully functioning demo. You can gain access directly from orderpipe.com by simply clicking the big ‘Try the Demo’ button. You’ll need to log in with a google account to gain access.

In addition to having lots of pretty data to explore, the demo gets several new orders added every hour, so it’s a great way to experience orders arriving in OrderPipe while you’re out and about on your mobile device.

Demo

In addition to these changes, the beta program is going well, your feedback has been very much appreciated. We’ll be ramping up our intake next week, so if you have not already received your invite link, you should receive one shortly.

Shopify Now Supported on OrderPipe Mobile Dashboards

We have just added beta support for Shopify.com hosted ecommerce stores to the OrderPipe dashboards. You can now monitor your Shopify sales, alongside other sales channels on your mobile device.

OrderPipe Shopify Mobile

If you use Shopify and would like to be part of our beta test program, please register on our site.

The Sales Location Map

If you’re selling in the United States, the OrderPipe home page features a U.S. map headed Sales Locations which gives you an at-a-glance view of where your sales are going and whether your sales are concentrated in particular regions. If you’re wondering what exactly it’s displaying, here’s an explanation.

Sales Location Map

The shading of the states represents the aggregate revenue of orders being delivered to customers in each state. The darker the shade, the higher the revenue. In the example above California represents the highest revenue share.

The darkness of the shade is relative to the maximum sales to any one state in the recent past. This means that if you sold $1,000 of product to customers in California one day last week and it was displayed in the darkest colour that day, you’d have to sell at least $1,000 to any one state today for it to show in that same dark shade. In other words, not only does the OrderPipe Sales Locations map give you a picture of where your customers are, it indicates the relative revenue amounts and geographic concentration at the same time.

The dots represent actual delivery locations, when they’re available. In the map above you can see that the Washington orders are going to Seattle, and the Oregon orders to Portland.

If you can see that a particular state has revenue but no dots are shown, such as Texas in the map above, chances are that OrderPipe has as yet received only partial information and may not yet have received the delivery address from the system providing your sales data. In some instances it may not be able to interpret the address information. The OrderPipe map will, though, always show the most up-to-date information it has available to the best of its ability.

The map uses SVG (scalable vector graphics) rendering technology. This is used to draw the map, to shade the regions and to draw the dots, which gives a superior representation than a static image. SVG does mean, though, that it can take a little longer to display than the other sections of the page.

map, svg

OrderPipe Consolidates Sales Across Channels

My business sells its products using many on-line sales channels. Foremost amongst them are Magento-based webstores and the Amazon Marketplaces in the USA and UK, and we’re adding more all the time. Magento is quite good at reporting sales. Its admin home page features a sales dashboard, if offers a new orders RSS feed and its reporting includes all orders up to the minute. When you operate one store and it’s your entire business this is fine. But when you’re running two Magento webstores, or a dozen or more, the standard Magento capabilities aren’t much use if what you’re after is an at-a-glance view of your total sales, rather than store-by-store detail.

The Amazon marketplace presents the e-commerce merchant with another set of challenges. You get access to Seller Central which includes good reporting, but the reports for the most part include data only up to a few days ago. No good if you want to see today’s sales. There’s also the Seller Central order screen which lets you know when sales are made, but often doesn’t give near enough detail. In any case, Seller Central gives you a picture only of sales made through one sales channel, the Amazon Marketplace.

This is where OrderPipe mobile sales dashboard comes in.

It gives you a consolidated, up-to-the-minute picture of your sales across multiple sales channels. If so far today you’ve made 140 sales of 255 units totalling $5,432 in value across Amazon and five webstores, it’ll tell you so, at a glance. This is valuable information that you won’t get from any individual sales channel system, no matter how good.