Guide: Using WooCommerce with Databox
HOW TO
How to connect WooCommerce to Databox
IN THIS SECTION
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
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
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
If a pre-built Datablock isn't available for your use case, click on the Visualization Types icon under the Metric Library icon
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.
Additional Information
IN THIS SECTION
Metric Considerations
-
The following 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 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.
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."