Ira Bodnar··Updated ·12 min read

WooCommerce dashboard: metrics, template and AI prompt

Quick answer: A WooCommerce dashboard needs 14 metrics on 5 panels. Ryze AI is the best option for asking a WooCommerce store about orders, refunds and sales in plain language from chat or Claude, with one caveat: a chat answer is a table at that moment, not a saved dashboard that refreshes on its own.

Below: metrics with REST API field names, a 5-panel template, WooCommerce's own options, prompts and a weekly routine.

Ryze AI · Paid Ads

Ask your WooCommerce store for its weekly numbers

  • 7-day free trial, $89 a month flat

Used by 2,000+ marketers

Uber Eats logoadidas logoDuolingo logoMGM Resorts logoWharton logoLendingClub logoNorton logoEventbrite logoHuel logoTogether AI logoghd logoHack The Box logo

WooCommerce dashboard at a glance

5 panels, read top to bottom once a week.

  1. 1SalesLast full week vs the week before

    Metrics: Total sales, net sales, order count, a 30-day daily line

    Question it answers: What did the store take in?

  2. 2Order valueLast full week vs the week before

    Metrics: Average order value, items per order, discounts

    Question it answers: Is each order worth more or less?

  3. 3Refunds and statusLast full week vs the week before

    Metrics: Refunds, refund rate, orders by status

    Question it answers: How much came back, and where do orders sit?

  4. 4Products and couponsLast 30 days

    Metrics: Top sellers, coupon use, shipping and tax collected

    Question it answers: What sold, and what discount drove it?

  5. 5Customers and paymentLast 30 days

    Metrics: New customers, orders by payment method

    Question it answers: Who is buying, and how do they pay?

The next section maps each metric to its REST API field.

The 14 WooCommerce dashboard metrics and their API fields

14 metrics answer 4 weekly questions: what the store took in, what each order was worth, what came back and what sold.

Field names come from the WooCommerce REST API reference, version wc/v3: the sales report, the order object and the top sellers report. An agent or a script can pull the exact field once it knows the name.

  1. Total sales

    Plain definition
    Sales amount for the period
    API field
    reports/sales: total_sales
    How to read it
    Set the period with date_min and date_max
  2. Net sales

    Plain definition
    Sales net of returns and coupons, in WooCommerce's definition
    API field
    reports/sales: net_sales
    How to read it
    Use this one for revenue trends
  3. Average order value

    Plain definition
    Average sales per order
    API field
    reports/sales: average_sales
    How to read it
    Check the report's totals_grouped_by value before you compare weeks
  4. Order count

    Plain definition
    Orders in the period
    API field
    reports/sales: total_orders
    How to read it
    Also available per status from reports/orders/totals
  5. Items sold

    Plain definition
    Units across the orders
    API field
    reports/sales: total_items
    How to read it
    Divide by order count for items per order
  6. Discounts

    Plain definition
    Discount amount applied
    API field
    reports/sales: total_discount; order: discount_total
    How to read it
    Divide by gross sales for a discount rate
  7. Shipping

    Plain definition
    Shipping charged
    API field
    reports/sales: total_shipping; order: shipping_total
    How to read it
    Watch it against total sales
  8. Tax

    Plain definition
    Tax collected
    API field
    reports/sales: total_tax; order: total_tax
    How to read it
    Keep it out of net sales comparisons
  9. Refunds

    Plain definition
    Amount refunded in the period
    API field
    reports/sales: total_refunds
    How to read it
    Order refunds also sit in each order's refunds list
  10. Orders by status

    Plain definition
    Order counts per status
    API field
    reports/orders/totals; order: status
    How to read it
    Decide which statuses count as sales
  11. Top sellers

    Plain definition
    Products ranked by quantity sold
    API field
    reports/top_sellers
    How to read it
    Use a 30-day range so the list is stable
  12. Coupon use

    Plain definition
    Codes applied to orders
    API field
    order: coupon_lines
    How to read it
    Group orders by code
  13. Customer count

    Plain definition
    Customers registered
    API field
    reports/customers/totals
    How to read it
    Compare it with last week's reading
  14. Payment method

    Plain definition
    Gateway used on the order
    API field
    order: payment_method
    How to read it
    Group by the gateway ID

4 things that trip up a first dashboard

  • Which statuses count. WooCommerce Analytics leaves Pending payment, Cancelled and Failed out of its reports by default and counts Processing, On hold and Completed. Apply the same rule to any other source so the totals match.
  • Pages of 10. A list request returns 10 items by default. Set per_page and walk the page parameter, and read the X-WP-Total and X-WP-TotalPages headers to know when you are done.
  • Sales vs net sales. WooCommerce defines Net Sales as gross sales minus returns and coupons, and Total Sales as net sales plus taxes and shipping. Pick one and label the panel with it.
  • Cached reports. WooCommerce says Analytics data is cached and regularly updated, so a number can lag the newest order.

Refund rate and discount rate are not fields. Divide total_refunds or total_discount by gross sales yourself.

The WooCommerce dashboard template: 5 panels

Put the 14 metrics on 5 panels, ordered from revenue to customers.

  1. 1. Sales

    Tiles or chart
    Total sales, net sales, order count, plus a daily line of net sales
    Date range
    Last full week; line: last 30 days
    Compare with
    The week before
  2. 2. Order value

    Tiles or chart
    Average order value, items per order, discounts
    Date range
    Last full week
    Compare with
    The week before
  3. 3. Refunds and status

    Tiles or chart
    Refunds, refund rate, orders by status
    Date range
    Last full week
    Compare with
    The week before
  4. 4. Products and coupons

    Tiles or chart
    Top 5 sellers, coupon use, shipping and tax collected
    Date range
    Last 30 days
    Compare with
    The 30 days before
  5. 5. Customers and payment

    Tiles or chart
    Customer count, orders by payment method
    Date range
    Last 30 days
    Compare with
    None

Where WooCommerce Analytics already covers a panel

WooCommerce Analytics has Revenue, Orders, Products, Variations, Categories, Coupons, Taxes, Downloads, Stock and Customers reports, so panels 1, 3 and 4 map to reports you already have. Use the dashboard to keep one fixed view next to them.

Option 1: WooCommerce Analytics in wp-admin

Analytics is the reporting built into WooCommerce, and its Overview page is already a dashboard.

Per the WooCommerce Analytics documentation, the Overview has 3 sections, Performance, Charts and Leaderboards, and each can be toggled, renamed, reordered or removed. The date range picker has presets and custom ranges, and compares with the previous period or the previous year. A table's Download link exports its data as CSV, and a larger export runs as a background job.

Under Analytics > Settings you can choose which order statuses are excluded and import historical data. This option costs nothing extra and stays inside wp-admin. It is a view you open in the WordPress admin, so you cannot ask it a follow-up question in Claude or ChatGPT, and a fresh order can take a moment to appear because the data is cached.

Option 2: pull reports from the REST API

Any script, spreadsheet add-on or BI tool that can send an authenticated GET request can fill the 5 panels.

Create a key in WooCommerce > Settings > Advanced > REST API with Read permission, and send the consumer key and secret as HTTP Basic Auth over HTTPS. These 3 request sketches follow the REST API reference. We have not run them against a store, so test each on yours. The domain and keys below are placeholders, and the dates are one example week.

REST: panels 1 to 3, sales report for one week
curl "https://example-store.com/wp-json/wc/v3/reports/sales?date_min=2026-11-09&date_max=2026-11-15" \ -u ck_XXXX:cs_XXXX
REST: panels 3 and 5, orders created in the week
curl "https://example-store.com/wp-json/wc/v3/orders?after=2026-11-09T00:00:00&before=2026-11-15T23:59:59&per_page=100&page=1" \ -u ck_XXXX:cs_XXXX
REST: panel 4, top sellers
curl "https://example-store.com/wp-json/wc/v3/reports/top_sellers?date_min=2026-11-09&date_max=2026-11-15" \ -u ck_XXXX:cs_XXXX

Repeat each request for the week before to fill the comparison column. The sales report takes period, date_min and date_max, and the order list takes after, before, status, per_page and page. Add amounts first and divide afterward so a quiet week does not skew an average.

Pick this option when you want a saved layout that refreshes on a schedule and you are happy to maintain a script or a sheet.

Option 3: the Ryze AI prompt that reads your store

Ryze AI reads a connected WooCommerce store through a read tool that sends GET requests to the REST API, so you describe the 5 panels and ask for tables back.

In WordPress, go to WooCommerce > Settings > Advanced > REST API > Add key and choose Read, which is enough for reporting. Copy the consumer key (ck_) and consumer secret (cs_). In Ryze AI, open Integrations, click Connect on the WooCommerce card, enter the Store URL (it must be https), the key and the secret, and click Continue. The Ryze AI WooCommerce guide has the screens. The same prompt works in Claude or ChatGPT once you add https://connector.get-ryze.ai/mcp as a custom connector (in ChatGPT, as an app under Settings > Apps).

Prompt: Ryze AI chat or Claude with the Ryze AI connector
Use my WooCommerce store. Read only: change nothing. Build a weekly dashboard as 5 tables, last full week (Monday to Sunday) vs the week before: 1. Sales: total_sales, net_sales and total_orders from the sales report, plus a daily line of net sales for the last 30 days. 2. Order value: average order value, total_items divided by total_orders, and total_discount. 3. Refunds and status: total_refunds, refund rate (total_refunds / total_sales) and order count by status. 4. Products and coupons, last 30 days: the top 5 sellers, orders per coupon code, and total_shipping and total_tax. 5. Customers and payment, last 30 days: the customer total and orders by payment_method. Count Processing, On hold and Completed orders as sales and tell me how many orders in other statuses you left out. List the fields or reports you used.

What comes back depends on what the store holds. Ask for the field names so you can compare them with the table above.

What this setup cannot show

  • The tools reach only what the WooCommerce REST API returns for the key. Anything held in another plugin's own tables is outside this guide.
  • Ryze AI holds one WooCommerce connection per workspace; to switch stores, disconnect the current one and connect again.
  • The store must be served over HTTPS, because Ryze AI works only with HTTPS stores.
  • A chat answer is a table at that moment. For a saved layout that refreshes on its own, use Option 2.

Check approvals first. In Ryze AI chat, the Tool approvals setting starts on Skip all approvals; switch it to Approve write & delete or Manual approve to review changes. Scheduled tasks run without an approval step. In Claude, set write and delete tools to Needs approval under Customize > Connectors > Ryze AI > Tool permissions. A Read key rejects writes, which is the safest way to run a dashboard. Every prompt here says read only.

For the store-side tool list, see the Ryze AI WooCommerce MCP page.

A weekly routine for the dashboard

Review the dashboard on the same day each week, for the last full week, and re-read the week before.

  1. 1. Refresh

    Check
    Re-run the pull or the prompt before reading
    Panel
    All
    Act when
    The figures predate the newest order
  2. 2. Sales

    Check
    Net sales and order count against the week before
    Panel
    1
    Act when
    Order count rose while net sales fell
  3. 3. Value

    Check
    Average order value and discounts
    Panel
    2
    Act when
    Discounts rose faster than orders
  4. 4. Refunds

    Check
    Refunds and orders in Refunded or On hold
    Panel
    3
    Act when
    Refunds cluster on one day or product
  5. 5. Products

    Check
    Top sellers and coupon use
    Panel
    4
    Act when
    One coupon accounts for most orders
  6. 6. Customers

    Check
    Customer count and payment methods
    Panel
    5
    Act when
    A payment method stops appearing

Write each change you make next to the date. Refunds are booked after the order, so last week's refund total can grow after your review.

Analytics vs REST API vs WooCommerce MCP vs Ryze AI

Analytics suits a view inside wp-admin, the API suits a saved layout, and Ryze AI suits questions you put to the store in a sentence.

  1. Price

    WooCommerce Analytics
    Part of WooCommerce
    REST API
    A key; the script or sheet is yours to build
    Ryze AI
    Paid Ads plan, $89 a month, 7-day free trial
  2. How you build it

    WooCommerce Analytics
    Arrange the Overview sections
    REST API
    Write requests and a sheet or script
    Ryze AI
    Describe the panels in chat
  3. Where it runs

    WooCommerce Analytics
    WordPress admin
    REST API
    Your script or BI tool
    Ryze AI
    Ryze AI chat, Claude or ChatGPT
  4. Saved layout

    WooCommerce Analytics
    Yes, on the Overview
    REST API
    Yes, if you build one
    Ryze AI
    No, a table per request
  5. Access it needs

    WooCommerce Analytics
    A WordPress user with report access
    REST API
    REST API key with Read
    Ryze AI
    REST API key with Read
  6. Changing the store

    WooCommerce Analytics
    Not a reporting feature
    REST API
    Whatever the key allows
    Ryze AI
    Writes need a Read/Write key, under your Tool approvals setting
  7. Several stores

    WooCommerce Analytics
    One site at a time
    REST API
    One key per store
    Ryze AI
    One WooCommerce connection per workspace

WooCommerce's own MCP integration

WooCommerce documents an MCP integration that is in developer preview. It needs the MCP Adapter plugin and WooCommerce 11.3 or later, signs in with a WordPress Application Password, and exposes product and order abilities: query, create, update and delete products, and query orders, update order status and add notes. The documentation lists no reporting abilities, so it is a poor fit for a sales dashboard. Its endpoint has the form https://yourstore.com/wp-json/mcp/mcp-adapter-default-server.

That route suits a developer who wants product and order management through a plugin on the store. Ryze AI needs nothing installed on the store, uses a REST API key, and uses one connector URL, https://connector.get-ryze.ai/mcp, whose read tool covers sales reports and orders.

Which WooCommerce dashboard to use

Match the option to what you need to see and how you want to ask for it.

  1. You want a fixed view inside WordPress

    Use
    WooCommerce Analytics
    Why
    Built in, with its own date comparison
  2. You want a saved layout that refreshes on a schedule

    Use
    REST API into a sheet or BI tool
    Why
    You control the fields and the refresh
  3. You want product and order management through a store plugin

    Use
    WooCommerce MCP integration
    Why
    Developer preview, Application Password sign-in
  4. You want store questions in plain language from chat

    Use
    Ryze AI
    Why
    One chat reads orders and sales reports from a Read key

Ryze AI limits for this job: it is paid after the trial, it holds one store per workspace, and the tools need an active plan or trial.

WooCommerce API limits that shape a dashboard

Two points from the REST API reference matter most: HTTPS and the page size.

  • Page size: a list returns 10 items by default. Set per_page and page, and use the X-WP-Total and X-WP-TotalPages headers to know the full count.
  • Authentication: Basic Auth with the consumer key as username and the consumer secret as password, per the reference. Use it over HTTPS.
  • Request rate: we found no request rate limit in the REST API reference, so any limit comes from your host, a security plugin or a firewall.

If a long week returns only part of the list, ask for more pages or a shorter date range.

Sources

The verdict

A WooCommerce dashboard needs 14 metrics on 5 panels and a weekly review that re-reads the week before. Analytics and the REST API cover it with WooCommerce's own definitions, and either gives you a saved layout.

Ryze AI answers store questions from chat for $89 a month after the 7-day free trial, and it returns a table per request rather than a saved dashboard.

Frequently asked questions

What should a WooCommerce dashboard include?
14 metrics on 5 panels: sales, order value, refunds and status, products and coupons, and customers and payment. The core ones are total_sales, net_sales, total_orders, total_refunds and orders by status. Compare the last full week with the week before.
Does WooCommerce have a built-in dashboard?
Yes. WooCommerce Analytics has an Overview with Performance, Charts and Leaderboards sections, plus Revenue, Orders, Products, Coupons, Customers and other reports. Each Overview section can be toggled, renamed and reordered.
Which API gives WooCommerce sales data?
The REST API sales report at /wp-json/wc/v3/reports/sales. It returns total_sales, net_sales, average_sales, total_orders, total_items, total_tax, total_shipping, total_refunds and total_discount, and takes date_min and date_max.
How do I get a WooCommerce REST API key?
In WordPress, go to WooCommerce > Settings > Advanced > REST API > Add key. Choose Read for reporting, or Read/Write if something should change, then copy the consumer key and secret.
Show 7 more questions
Which orders does WooCommerce Analytics count?
By default it excludes Pending payment, Cancelled and Failed and includes Processing, On hold and Completed. You can change this in Analytics > Settings.
Why does my WooCommerce list stop at 10 items?
The REST API returns 10 items per page by default. Set per_page and walk the page parameter, and read the X-WP-TotalPages header to see how many pages there are.
Can Ryze AI read WooCommerce sales reports and orders?
Yes. Its read tool sends GET requests for orders and refunds, sales reports, products and variations, customers, coupons, and shipping and tax settings. A Read key is enough.
Can Ryze AI change my WooCommerce store?
Yes, with a Read/Write key it can create coupons, products and order notes, and update order status, prices and stock. Delete is a separate tool. In Ryze AI chat, Tool approvals starts on Skip all approvals, so switch it to Approve write & delete first. For a dashboard, use a Read key and say read only in the prompt.
Does WooCommerce have its own MCP server?
WooCommerce documents an MCP integration in developer preview. It needs the MCP Adapter plugin and WooCommerce 11.3 or later, signs in with an Application Password, and lists product and order abilities, with no reporting ones.
Does Ryze AI work with several WooCommerce stores?
Each workspace holds one WooCommerce connection. To switch stores, click View on the connection, disconnect the current store and connect the other.
How much does Ryze AI cost for a WooCommerce dashboard?
The Paid Ads plan is $89 a month with a 7-day free trial and gives access to the agent tools. SEO Starter is $129 a month with a 3-day free trial and Agency is $279 a month. Annual billing is 30% off the first year, and adding the connector is free.

Related guides

Ryze AI: WooCommerce store questions

7-day free trial, $89 a month flat

Start free trial