# Integrate WooCommerce with Databox WooCommerce is a flexible eCommerce platform built on WordPress that enables businesses to sell products and services online. It provides tools to manage products, process orders, handle payments, configure shipping and taxes, and manage customer information. Store owners can use WooCommerce data to understand revenue trends, purchasing behavior, and overall store performance, helping them make informed decisions to grow their business. ## Connection ### Before you begin ### Step 1: Generate API credentials in WooCommerce Databox uses WooCommerce REST API credentials to securely authenticate your store connection. Follow [WooCommerce's official documentation](https://developer.woocommerce.com/docs/apis/rest-api/#generate-keys) to generate a REST API Consumer Key and Consumer Secret. After generating the credentials, copy and store the **Consumer Key** and **Consumer Secret** securely. You will need to paste them into Databox in the next step. ### Step 2: Add your WooCommerce details in Databox 1. In Databox, enter your **Website URL**. Your domain should look like `yourstore.com` (do not include `http://` or `https://`). 2. Paste the **Consumer Key** you generated in Step 1. 3. Paste the **Consumer Secret**. 4. Click **Connect**. connect ## Metric Builder The WooCommerce integration allows you to create custom metrics using the metric builder, ideal for visualizing data not included in the basic metrics offered by the integration. metric-builder To create a custom metric, start by selecting a metric from the "Metric" selector. Next, customize your metric by optionally adding a dimension and applying one or more filters. The available options depend on the selected entity and data type (e.g., number, text, etc.). The available metric options include standard WooCommerce revenue and order metrics such as Gross Sales, Net Sales, Total Sales, Orders, Products Sold, Returns, Shipping, Total Taxes, Coupons Amount, Coupon Orders, Avg. Order Value, Avg. Items per Order, and Total Customers. These metrics reflect aggregated store performance based on the same WooCommerce Analytics data available in your WordPress dashboard. ## ![lock](/assets/lock.2fb1bbc208afcc03d15a0a45f22bdf7f830322016e038e5721965851130807af.419bb737.svg) Datasets The WooCommerce integration supports the creation of [datasets](/understanding-datasets), which allow you to structure and format your WooCommerce data for more flexible reporting in Databox. By organizing your data into a tabular format, datasets make it easier to filter, segment, and visualize key metrics across projects, clients, and team members. The entity relationship diagram (ERD) below illustrates how data is organized within the WooCommerce integration, displaying the available **views** and **columns**, as well as the relationships between them (primary and foreign keys). This diagram represents the **schema**, or structure, of the data and helps you understand the underlying data model. With this context, you can create datasets using the relevant views and columns to build custom metrics tailored to your reporting needs. ## Resources For comprehensive details on metrics, data availability, templates, specifications, usage guidelines, and other key information, refer to the resources listed below. The metric builder pulls raw and analytics data from WooCommerce's APIs. If an entity or property is missing, it is likely due to limited API support or technical implementation restrictions. If there's something you'd like to see included, feel free to [submit a request](https://roadmap.databox.com/b/metric-requests/) on our Roadmap, so we can consider it for future updates to the integration.   Ask Genie Get instant answers or help with your data using the in-app AI assistant. Talk to an expert For customers: Get help with your setup, strategy, or making the most of Databox. Book a demo New to Databox? See how it works and get guidance on getting started. Send an email Reach out to support for help with your account, data, or technical issues.