Guide: WooCommerce

WooCommerce is a WordPress plugin which lets you track your websites sales, number of placed orders, items purchased and much more.

IN THIS ARTICLE

1. How to connect WooCommerce to Databox

To connect Woocommerce, you will need to enter your Website URL (without "http://" or "https://") and insert the Consumer Key and Consumer Secret.

add_user_popup@2x

Here is a step by step guide on how to find the Consumer Key and Secret:
1
 Login into the Wordpress Admin.
2
 In the left side panel select Woocommerce > Settings Advanced Tab >  REST API.
3
 Click on the Add Key button, enter key details and click on the Generate API Key button.
4
 Once generated copy the Consumer Key and Consumer Secret to the Databox connect window.

2. How to build an WooCommerce Databoard

Follow these steps in the  Databox Web Application:

1
 Click  Templates in the top menu
2
 In the search bar, type "WooCommerce" or filter by used Data Source
3
 Hover over your desired template and click Use Template
4
 If you have multiple WooCommerce accounts connected, select the one you want to use to populate the Databoard in the drop down menu
Once the Template is pulled into your account, you have the ability to customize the Databoard using the  Databox Designer

Popular template

WooCommerce (shop overview)

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


Creating a custom Databoard

If you decide not to use a prebuilt Template, you have the ability to use the the Designer to create a Databoard from scratch.  Learn how here

3. Most popular WooCommerce metrics

Gross Sales New Customers Gross Sales by Product

Gross sales (sum of the order totals after any refunds and excluding shipping and taxes).
New customer gained during the specified date range.
Gross sales split up by product (sum of order totals after any refunds and excluding shipping and taxes).
Orders Placed

Refunded amount

Worth of Coupons Used

Total of orders placed.
Total amount of refunded orders..
Total of coupons used.

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


4. Additional Info

1. "Last 7 Days" date range reports differently in Databox when compared to WooCommerce UI.
WooCommerce has a different render of "Last X Days" Date Ranges. They include "Today", whereas Databox does not include "Today". The difference is only visible when comparing the points on a Line Chart. The total number will still be the same as in WooCommerce UI.

2. Some Metrics do not have historical data available.
Some Metrics do not have historical data available which will result in not seeing any data on a Line Chart for before the initial connection. The next day the data will be available.

Affected Metrics are the following:

  • Average gross daily sales
  • Average net daily sales
  • Refunded orders
  • Refunded items
  • Refunded amount

Still need help? Contact Us Contact Us