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
WooCommerce dashboard at a glance
5 panels, read top to bottom once a week.
- 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?
- 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?
- 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?
- 4Products and couponsLast 30 days
Metrics: Top sellers, coupon use, shipping and tax collected
Question it answers: What sold, and what discount drove it?
- 5Customers and paymentLast 30 days
Metrics: New customers, orders by payment method
Question it answers: Who is buying, and how do they pay?
| # | Panel | Range | Metrics | Question it answers |
|---|---|---|---|---|
| 1 | Sales | Last full week vs the week before | Total sales, net sales, order count, a 30-day daily line | What did the store take in? |
| 2 | Order value | Last full week vs the week before | Average order value, items per order, discounts | Is each order worth more or less? |
| 3 | Refunds and status | Last full week vs the week before | Refunds, refund rate, orders by status | How much came back, and where do orders sit? |
| 4 | Products and coupons | Last 30 days | Top sellers, coupon use, shipping and tax collected | What sold, and what discount drove it? |
| 5 | Customers and payment | Last 30 days | New customers, orders by payment method | 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.
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
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
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
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
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
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
Shipping
- Plain definition
- Shipping charged
- API field
- reports/sales: total_shipping; order: shipping_total
- How to read it
- Watch it against total sales
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
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
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
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
Coupon use
- Plain definition
- Codes applied to orders
- API field
- order: coupon_lines
- How to read it
- Group orders by code
Customer count
- Plain definition
- Customers registered
- API field
- reports/customers/totals
- How to read it
- Compare it with last week's reading
Payment method
- Plain definition
- Gateway used on the order
- API field
- order: payment_method
- How to read it
- Group by the gateway ID
| Metric | Plain definition | API field | How to read it |
|---|---|---|---|
| Total sales | Sales amount for the period | reports/sales: total_sales | Set the period with date_min and date_max |
| Net sales | Sales net of returns and coupons, in WooCommerce's definition | reports/sales: net_sales | Use this one for revenue trends |
| Average order value | Average sales per order | reports/sales: average_sales | Check the report's totals_grouped_by value before you compare weeks |
| Order count | Orders in the period | reports/sales: total_orders | Also available per status from reports/orders/totals |
| Items sold | Units across the orders | reports/sales: total_items | Divide by order count for items per order |
| Discounts | Discount amount applied | reports/sales: total_discount; order: discount_total | Divide by gross sales for a discount rate |
| Shipping | Shipping charged | reports/sales: total_shipping; order: shipping_total | Watch it against total sales |
| Tax | Tax collected | reports/sales: total_tax; order: total_tax | Keep it out of net sales comparisons |
| Refunds | Amount refunded in the period | reports/sales: total_refunds | Order refunds also sit in each order's refunds list |
| Orders by status | Order counts per status | reports/orders/totals; order: status | Decide which statuses count as sales |
| Top sellers | Products ranked by quantity sold | reports/top_sellers | Use a 30-day range so the list is stable |
| Coupon use | Codes applied to orders | order: coupon_lines | Group orders by code |
| Customer count | Customers registered | reports/customers/totals | Compare it with last week's reading |
| Payment method | Gateway used on the order | order: payment_method | 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. 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. Order value
- Tiles or chart
- Average order value, items per order, discounts
- Date range
- Last full week
- Compare with
- The week before
3. Refunds and status
- Tiles or chart
- Refunds, refund rate, orders by status
- Date range
- Last full week
- Compare with
- The week before
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. Customers and payment
- Tiles or chart
- Customer count, orders by payment method
- Date range
- Last 30 days
- Compare with
- None
| Panel | Tiles or chart | Date range | Compare with |
|---|---|---|---|
| 1. Sales | Total sales, net sales, order count, plus a daily line of net sales | Last full week; line: last 30 days | The week before |
| 2. Order value | Average order value, items per order, discounts | Last full week | The week before |
| 3. Refunds and status | Refunds, refund rate, orders by status | Last full week | The week before |
| 4. Products and coupons | Top 5 sellers, coupon use, shipping and tax collected | Last 30 days | The 30 days before |
| 5. Customers and payment | Customer count, orders by payment method | Last 30 days | 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.
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).
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. Refresh
- Check
- Re-run the pull or the prompt before reading
- Panel
- All
- Act when
- The figures predate the newest order
2. Sales
- Check
- Net sales and order count against the week before
- Panel
- 1
- Act when
- Order count rose while net sales fell
3. Value
- Check
- Average order value and discounts
- Panel
- 2
- Act when
- Discounts rose faster than orders
4. Refunds
- Check
- Refunds and orders in Refunded or On hold
- Panel
- 3
- Act when
- Refunds cluster on one day or product
5. Products
- Check
- Top sellers and coupon use
- Panel
- 4
- Act when
- One coupon accounts for most orders
6. Customers
- Check
- Customer count and payment methods
- Panel
- 5
- Act when
- A payment method stops appearing
| Step | Check | Panel | Act when |
|---|---|---|---|
| 1. Refresh | Re-run the pull or the prompt before reading | All | The figures predate the newest order |
| 2. Sales | Net sales and order count against the week before | 1 | Order count rose while net sales fell |
| 3. Value | Average order value and discounts | 2 | Discounts rose faster than orders |
| 4. Refunds | Refunds and orders in Refunded or On hold | 3 | Refunds cluster on one day or product |
| 5. Products | Top sellers and coupon use | 4 | One coupon accounts for most orders |
| 6. Customers | Customer count and payment methods | 5 | 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.
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
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
Where it runs
- WooCommerce Analytics
- WordPress admin
- REST API
- Your script or BI tool
- Ryze AI
- Ryze AI chat, Claude or ChatGPT
Saved layout
- WooCommerce Analytics
- Yes, on the Overview
- REST API
- Yes, if you build one
- Ryze AI
- No, a table per request
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
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
Several stores
- WooCommerce Analytics
- One site at a time
- REST API
- One key per store
- Ryze AI
- One WooCommerce connection per workspace
| Question | WooCommerce Analytics | REST API | Ryze AI |
|---|---|---|---|
| Price | Part of WooCommerce | A key; the script or sheet is yours to build | Paid Ads plan, $89 a month, 7-day free trial |
| How you build it | Arrange the Overview sections | Write requests and a sheet or script | Describe the panels in chat |
| Where it runs | WordPress admin | Your script or BI tool | Ryze AI chat, Claude or ChatGPT |
| Saved layout | Yes, on the Overview | Yes, if you build one | No, a table per request |
| Access it needs | A WordPress user with report access | REST API key with Read | REST API key with Read |
| Changing the store | Not a reporting feature | Whatever the key allows | Writes need a Read/Write key, under your Tool approvals setting |
| Several stores | One site at a time | One key per store | 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.
You want a fixed view inside WordPress
- Use
- WooCommerce Analytics
- Why
- Built in, with its own date comparison
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
You want product and order management through a store plugin
- Use
- WooCommerce MCP integration
- Why
- Developer preview, Application Password sign-in
You want store questions in plain language from chat
- Use
- Ryze AI
- Why
- One chat reads orders and sales reports from a Read key
| Your situation | Use | Why |
|---|---|---|
| You want a fixed view inside WordPress | WooCommerce Analytics | Built in, with its own date comparison |
| You want a saved layout that refreshes on a schedule | REST API into a sheet or BI tool | You control the fields and the refresh |
| You want product and order management through a store plugin | WooCommerce MCP integration | Developer preview, Application Password sign-in |
| You want store questions in plain language from chat | Ryze AI | 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?
Does WooCommerce have a built-in dashboard?
Which API gives WooCommerce sales data?
How do I get a WooCommerce REST API key?
Show 7 more questionsShow fewer questions
Which orders does WooCommerce Analytics count?
Why does my WooCommerce list stop at 10 items?
Can Ryze AI read WooCommerce sales reports and orders?
Can Ryze AI change my WooCommerce store?
Does WooCommerce have its own MCP server?
Does Ryze AI work with several WooCommerce stores?
How much does Ryze AI cost for a WooCommerce dashboard?
Related guides
WooCommerce MCP with Ryze AI
The 3 WooCommerce tools, setup per client, limits and errors.
Shopify dashboard
13 Shopify metrics with Admin GraphQL field names and a 5-panel template.
BigCommerce dashboard
15 order metrics with Orders V2 field names and a 5-panel template.
Google Analytics dashboard (GA4)
GA4 metrics with their Data API names and the Ryze AI prompt that reads them.
All integrations
Every platform Ryze AI connects to.





