1. Help Center
  2. Data Source Guides

Guide: Using WooCommerce with Databox


How to connect WooCommerce to Databox


How to connect WooCommerce to Databox

To connect a WooCommerce Account in Databox, go to   Data Sources > + New connection. Type WooCommerce in the search bar and click on the green Connect button. 

This will open the  Activation window, which is where you will be prompted to enter your WooCommerce credentials and activate the Databox app. 

How to find your WooCommerce Consumer Key and Secret

  1. Login into the Wordpress Admin
  2. On the left side panel, select Woocommerce > Settings Advanced Tab >  REST API
  3. Click Add Key and enter your Key details. Click Generate API Key 
  4. Once generated, copy the Consumer Key and Consumer Secret to the Databox Activation window.

How much historical data is synced when you first connect WooCommerce to Databox?

When you connect a new WooCommerce Data Source in Databox, 36 months worth of data is initially available for most Metrics. 

Certain Metrics may have more or less historical data available. For more information about the amount of historical data available for a specific Metric, please contact our Support Team at help@databox.com.

Some Metrics do not have historical data available. These Metrics include Average Gross Daily Sales, Average Net Daily Sales, Refunded Orders, Refunded Items, and Refunded Amount. Learn more here.

What time zone does WooCommerce data sync in?

WooCommerce data is synced in UTC. 

How to access pre-built WooCommerce Templates

  1. Navigate to  Databoards > Public Templates
  2. In the Data Source drop-down list, select WooCommerce
  3. To view a preview of the Template populated with dummy data, click Preview
  4. To pull the Template into your Account and re-populate it with your own WooCommerce data, click Use Template
  5. Select the appropriate WooCommerce Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected WooCommerce Account and can be found on the Databoards page

Pro Tip: Once the Databoard is available on the Databoards page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the Designer.

Popular WooCommerce Template

WooCommerce (Shop Overview)
This dashboard gives an overview of your WooCommerce store, including total sales, popular products and new customers. 

How to build a Databoard using WooCommerce data


How to build a Databoard

  1. Navigate to  Databoards > + New Databoard > Start Blank
  2. Click on the Metric  Library icon on the left-hand side of the Designer
  3. Select the appropriate WooCommerce Account from the  Data Source drop-down list in the  Metric Library
  4. View the list of pre-built WooCommerce Datablocks in the  Metric Library. Drag and drop your selected Datablock onto your Databoard    
  5. If a pre-built Datablock isn't available for your use case, click on the  Visualization Types icon under the Metric Library icon
  6. View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
  7. Click on the Datablock on the Databoard to open the corresponding  Datablock Editor on the right-hand side of the Designer
  8. Select the appropriate WooCommerce Data Source and Metric in the right-hand Datablock Editor. This will update the Datablock, and it will populate the Datablock with the corresponding data 
  9. Complete steps 4-8 until your Databoard is complete

Popular WooCommerce Metrics 

Gross Sales Average Gross Daily Sales Refunded Orders
Net Sales Average Net Daily Sales Tax

You can view a full list of all WooCommerce Metrics available in Databox here.

How to use the Metric Builder for WooCommerce

Learn how to use the Metric Builder for WooCommerce here

Additional Information


Metric Considerations

  • The following (Legacy) Metrics have no daily historical data available.
    • Average Gross Daily Sales
    • Average Net Daily Sales
    • Refunded Orders
    • Refunded Items
    • Refunded Amount

Historical data is synced for these (Legacy) Metrics only in the form of total values for each available Date Range – for example, data is available for the Date Range "Last Week", but it is not available for specific days last week.

If these Metrics are used on a visualization type like the Line Graph, the Number above the line on the graph will display the total Metric value for the selected Date Range, but the line will be displayed only from one day before the initial Data Source connection and on.

  • We are adding new metrics which are pulled from the Analytics tab, no longer from legacy reporting tabs.
  • Depending on which report you are inspecting values, you will see different values. Those metrics have (<report>) in name to help you identify which report is extracting them.
  • All Dimensional metrics are Non Aggregatable
  • Due to the way the API is structured, metrics with date ranges equal or larger than a quarter with daily or weekly granulation can experience slower loading times. This can be addressed by either shortening the date range or using monthly granulation.
  • The Metric Builder has been added with filtering options just for Orders report from Analytics tab.

API Limitations

    • "Last 7 Days" is set differently in Databox and WooCommerce, so comparing the points on a Line Chart will not result in a one-to-one match. In WooCommerce, "Last 7 Days" includes "Today," whereas in Databox, "Last 7 Days" does not include "Today."