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 Manager > + 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

 Login into the Wordpress Admin
 In the left side panel, select  Woocommerce > Settings Advanced Tab >  REST API
 Click  Add Key and enter your Key details. Click  Generate API Key 

 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. 

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. 

What time zone does WooCommerce data sync in?

WooCommerce data is synced in UTC. 

How to access pre-built WooCommerce Templates

 Navigate to the  Templates page
 In the Data Source drop-down list, select WooCommerce
 To view a preview of the Template populated with dummy data, click Preview
 To pull the Template into your Account and re-populate it with your own WooCommerce data, click Use Template
 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

 Navigate to  Databoards > + New Databoard > Start Blank
 Click on the  Datablock Library icon on the lefthand side of the Designer
 Select the appropriate WooCommerce Account from the  Data Source drop-down list in the  Datablock Library
 View the list of pre-built WooCommerce Datablocks in the  Datablock Library. Drag and drop your selected Datablock onto your Databoard    

 If a pre-built Datablock isn't available for your use case, click on the  Visualization Types icon under the Datablock Library icon

 View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
 Click on the Datablock on the Databoard to open the corresponding  Datablock Settings on the righthand side of the Designer
 Select the appropriate WooCommerce Data Source and Metric in the righthand Datablock Settings. This will update the Datablock and it will populate the Datablock with the corresponding data 
 Complete steps 4-8 until your Databoard is complete

Popular Xero 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.

Additional Information

  • "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." 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us