Track Shopify store sales and order metrics in Geckoboard

Shopify is an ecommerce solution that allows you to set up an online retail store to sell your goods.

In this article, we'll show how to track Sales and Order related metrics from your Shopify store on your Geckoboard dashboard.

Which metrics and visualizations are available for Shopify?

  • Sales/Order total
    Display the number of orders or revenue from sales for a given time period. This can be filtered by payment and fulfillment statuses. Optionally, a secondary stat. can be displayed as well.
  • Order/Sales status
    Display the RAG (Red, Amber, Green) status of orders or sales for a given time period. These are split out by abandoned, pending, paid payment statuses.
  • Order/Sales breakdown
    Display a RAG status of orders or sales for a given time period. These are split out by unshipped, partially shipped and shipped fulfillment statuses.

Create a new Shopify widget

To create a Shopify widget for your dashboard, follow these steps:

  1. Click Add widget, located in the top right of your dashboard.
  2. Search for Shopify using the Search sources field.

    Alternatively, you can also scroll down the alphabetical list of integrations until you reach the Shopify integration.
  3. Click on the Shopify integration.

Note

Is this is your first Shopify widget? You'll need to connect your Shopify account to Geckoboard.
If not, you can skip to our example Shopify widget.

Create a connection with Shopify

When adding your first Shopify widget, you'll be asked to create a connection and authenticate your Shopify account so that we're able to collect your data and display it on the dashboard. You only need to create this connection once – we'll take care of the rest.

To connect your Shopify account with Geckoboard, follow these steps:

  1. The authentication box will ask you to enter your Shopify company URL.

    Example

    This would be the name of your Shopify account. For gecko.myshopify.com, it'll be gecko.

    Connect Geckoboard with Shopify
  2. You'll then need to enter your API key and password. These are required by Geckoboard to access your Shopify store and display metrics. You'll first have to create a new Private App from within your Shopify account.Shopify private app for geckoboard

    Tip

    Give your Private App a suitable name so that you can keep track later on.

    Name_Shopify_private_app
  3. Pick up the API key and password.API_Key_and_Password
  4. Click on the Connect button.
  5. You're now ready to configure your first Shopify widget! Any Shopify widgets you create will pull in and display data from this Shopify account.

    Note

    If you manage more than one Shopify account, you can also connect multiple Shopify accounts to your Geckoboard.

Configuring an example Shopify widget

Use the Sales/orders total widget to display the number of orders that have been paid for and shipped today. As a secondary stat, we can also see how we compare with yesterday's performance.Shopify_orders_today

This widget can be created using the following configuration:Shopify_setup_widget

  • Title: Paid & Shipped Orders Today (can be set to anything of your choice)
  • Metrics: Orders
  • Base data on: Date Created
  • Payment Status: Paid
  • Fulfillment Status: Shipped
  • Period: Today
  • Secondary Output: Change from prior period
Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!