Home / Connectors / WooCommerce
Connector

WooCommerce connector: datasets and metric definitionsBeta

Bring in orders, net sales, refunds, products and stock, and new versus returning customers. Updates daily.

6 datasets10 metric definitionsRead-onlyRefreshes 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

DatasetWhat it holds
[WooCommerce] OrdersOne 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 itemsOne 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] RefundsOne 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] SalesOne 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] ProductsOne 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] CustomersOne 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

MetricHow it is calculatedDated byNotes
WooCommerce ordersCount of distinct order_id, where is_counted = 1order_dateOrders placed, by order date, in the statuses WooCommerce Analytics counts (every status except pending, failed and cancelled).
WooCommerce order valueSum of order_value, where is_counted = 1order_dateProduct subtotal minus coupons plus fees per counted order: the numerator of average order value.
WooCommerce average order valueWooCommerce order value ÷ WooCommerce ordersorder_dateOrder value divided by orders (before refunds, shipping and tax).
WooCommerce new customersCount of distinct customer_key, where is_first_order = 1order_dateCustomers 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

MetricHow it is calculatedDated byNotes
WooCommerce units soldSum of qtyorder_dateUnits ordered in counted orders, by order date.

[WooCommerce] Sales

MetricHow it is calculatedDated byNotes
WooCommerce gross salesSum of gross_salessale_dateProduct sales before coupons and returns, without shipping or tax (WooCommerce Analytics' gross sales).
WooCommerce couponsSum of couponssale_dateCoupon discounts on products, as a positive amount.
WooCommerce returnsSum of returnssale_dateRefunded product value, counted on the refund date, as a positive amount.
WooCommerce net salesSum of net_salessale_dateGross sales minus coupons minus returns, returns on the refund date: matches WooCommerce Analytics > Revenue.
WooCommerce total salesSum of total_salessale_dateNet sales plus shipping and taxes.

Works with other connectors

Questions to ask

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?
No. The WooCommerce connector is read-only. Quiriz reads the data into datasets and never writes back to WooCommerce.
How often does the WooCommerce data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine WooCommerce with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.