In this article, we'll show how to connect to, and use, our Shopify data source to track Sales and Order related metrics from your Shopify store on your Geckoboard dashboard.
To connect your Shopify data to Geckoboard, you must be on a Pro plan.
Connect your Shopify store to Geckoboard
When adding your first Shopify widget, you'll be prompted to create a connection and authenticate your Shopify store account.
- In the Shopify connection panel, first enter your Shopify company URL into the Your Shopify company URL field. This is the name of your Shopify account. For example, for
company.myshopify.com, you'd enter
- Next you'll need your Shopify API key and password. To obtain these you'll need to create a private app within Shopify and grant it access for the
read_ordersscope. If you've already done this, skip forward to step 11.
- Log into your Shopify admin account and click on Apps in the navigation list.
- From the Apps screen click the Manage private apps link below the Shopify App store content. Then click on the Create new private app button to begin creating your private app.
- After naming your private app, scroll down to the Admin API section. As the
read_ordersscope isn't included by default, click the Show inactive Admin API permissions to expand the list.
- From the alpabetical list of API permissions, scroll down to Orders. Switch on Read access from the option menu to grant access for the
read_ordersscope. Click Save to return to the Private apps screen. You'll now see your new private app listed.
- To access and copy both your API key and password, click on your private app from the Private apps screen. Scroll down to the Admin API section and click the copy icons beside the API key and password fields. Now switch back to Geckoboard to paste them in their corresponding fields in the connection panel.
- Finally, click on the button. 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.
If you manage more than one Shopify account, you can also connect multiple Shopify accounts to your Geckoboard. However, you can't combine data across Shopify accounts on your dashboard. To do this you'd need to use our spreadsheets data source, or an external service like Integromat or Zapier.
Shopify metrics available in Geckoboard
Displays the number of orders or revenue from sales for a given time period. This can be filtered by payment and fulfillment statuses. There's also the option to display a secondary stat.
Displays the status of orders or sales for a given time period. These are split out by abandoned, pending, paid payment statuses.
RAG (Red, Amber, Green) status
Displays the status of orders or sales for a given time period. These are split out by unshipped, partially shipped and shipped fulfillment statuses.
In this example we'll 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.
This widget can be created using the following configuration:
- Title: Sales/orders total (rename 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