WooCommerce connector: datasets and metric definitionsBeta
Bring in orders, net sales, refunds, products and stock, and new versus returning customers. Updates daily.
When you connect WooCommerce, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [WooCommerce] Orders | One row per order in every status; is_counted = 1 for the statuses WooCommerce Analytics counts (every status except pending, failed and cancelled). Amounts in the order currency. order_value = subtotal - coupons + fees; net_sales = order value minus refunded product value. is_first_order only sees orders in the imported window. Guests are recognized by a one-way code, never their email.27 columnsorder_id, order_number, order_date, month, status, is_counted, currency, subtotal, coupons, fees, order_value, shipping, tax, total, refunded_amount, net_sales, items_count, created_via, source_type, utm_source, utm_medium, utm_campaign, country, customer_key, is_registered, is_first_order, coupon_codes |
| [WooCommerce] Order line items | One row per product line of a counted order: quantity, unit price, gross, coupons, total and quantity refunded.13 columnsline_item_id, order_id, order_date, product_id, variation_id, product_name, sku, qty, unit_price, line_gross, line_coupons, line_total, refunded_qty |
| [WooCommerce] Refunds | One row per refund since the start of the imported window, on its refund date: amount, items returned, and the shipping and tax refunded. Refund reasons are not imported.8 columnsrefund_id, order_id, refund_date, month, amount, items_returned, shipping_refunded, tax_refunded |
| [WooCommerce] Sales | One row per product, fee, shipping or tax line of each counted order on its order date, and of each refund on its refund date (event_type return, negative). Fees (line_type fee) count in gross and net sales, as in Analytics. net_sales = gross_sales - coupons - returns; total_sales = net_sales + shipping + taxes. Matches WooCommerce Analytics > Revenue. Amounts in the order currency.24 columnssale_date, month, order_id, event_type, line_type, product_id, product_name, sku, quantity, gross_sales, coupons, returns, net_sales, shipping, taxes, total_sales, currency, country, customer_key, is_first_order, source_type, utm_source, utm_medium, utm_campaign |
| [WooCommerce] Products | One row per simple product and per variation, as of the last refresh: prices, stock status and quantity, categories, and WooCommerce's lifetime units sold (per product, blank for variations).16 columnsproduct_id, variation_id, product_name, variation_name, sku, type, status, price, regular_price, sale_price, stock_status, stock_quantity, manage_stock, categories, total_sales, created_at |
| [WooCommerce] Customers | One row per customer seen in the imported window: registered customers by id, guests by a one-way code (never their email). First and last order date, counted orders, amount spent net of refunds, and billing country.7 columnscustomer_key, is_registered, first_order_date, last_order_date, orders_count, amount_spent, country |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[WooCommerce] Orders
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| WooCommerce orders | Count of distinct order_id, where is_counted = 1 | order_date | Orders placed, by order date, in the statuses WooCommerce Analytics counts (every status except pending, failed and cancelled). |
| WooCommerce order value | Sum of order_value, where is_counted = 1 | order_date | Product subtotal minus coupons plus fees per counted order: the numerator of average order value. |
| WooCommerce average order value | WooCommerce order value ÷ WooCommerce orders | order_date | Order value divided by orders (before refunds, shipping and tax). |
| WooCommerce new customers | Count of distinct customer_key, where is_first_order = 1 | order_date | Customers placing their first counted order in the imported window, by order date. Guest shoppers are recognized by a one-way code, never their email. |
[WooCommerce] Order line items
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| WooCommerce units sold | Sum of qty | order_date | Units ordered in counted orders, by order date. |
[WooCommerce] Sales
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| WooCommerce gross sales | Sum of gross_sales | sale_date | Product sales before coupons and returns, without shipping or tax (WooCommerce Analytics' gross sales). |
| WooCommerce coupons | Sum of coupons | sale_date | Coupon discounts on products, as a positive amount. |
| WooCommerce returns | Sum of returns | sale_date | Refunded product value, counted on the refund date, as a positive amount. |
| WooCommerce net sales | Sum of net_sales | sale_date | Gross sales minus coupons minus returns, returns on the refund date: matches WooCommerce Analytics > Revenue. |
| WooCommerce total sales | Sum of total_sales | sale_date | Net sales plus shipping and taxes. |
Works with other connectors
- WooCommerce + Google Analytics: WooCommerce against GA4. The same reconciliation for a WooCommerce store. Read the guide.
Questions to ask
- What were net sales by month this year, and versus last year?
- Which products drove the most net sales last quarter?
- What is our average order value by month?
- How many new customers did we get each month, and how many came back?
- Which products are out of stock or running low?
- Which products get refunded most?
- Which countries do our sales come from?
Related guides
- Ecommerce Contribution Margin, Break-Even ROAS and MER
- WooCommerce AI: Ask Your Store Questions
- WooCommerce Analytics Beyond the Dashboard
Ask WooCommerce in plain words
Try the questions on sample data with no signup, then connect WooCommerce read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in WooCommerce?
How often does the WooCommerce data refresh?
Can I change how a metric is calculated?
Can I combine WooCommerce with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.