Write a question about your WooCommerce store: Chiaro answers with a table, a chart and the query it used.

Install from WordPress.org

Ask yourown store.

50free questions when you activate your site

Revenue by category in October, compared with October last year

10 rows. Total October 2026: 8,944.34 €. Highest: Giacche e cappotti, 2,088.78 €.

October 2026 October 2025

  • Giacche e cappotti2,088.782,776.90
  • Accessori2,010.211,633.25
  • Scarpe1,394.651,064.79
  • Maglieria1,329.691,637.24
  • Camicie e bluse502.32707.08
  • Intimo e calze465.64648.88
  • Pantaloni e jeans403.20539.02
  • Mare278.45297.52
  • Borse264.261,007.97
  • Abiti e gonne207.14987.40

The query that produced this answer, run read-only on the site:

SELECT p.categoria_prodotto AS categoria,
  ROUND(SUM(CASE WHEN r.data_ordine >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
    THEN r.ricavo_netto ELSE 0 END), 2) AS ottobre_2026,
  ROUND(SUM(CASE WHEN r.data_ordine >= DATE_FORMAT(CURDATE() - INTERVAL 1 YEAR, '%Y-%m-01')
    AND r.data_ordine < CURDATE() - INTERVAL 1 YEAR + INTERVAL 1 DAY
    THEN r.ricavo_netto ELSE 0 END), 2) AS ottobre_2025
FROM ai_bi_righe_ordine r
JOIN ai_bi_prodotti p ON r.prodotto_id = p.prodotto_id
GROUP BY p.categoria_prodotto
ORDER BY ottobre_2026 DESC

Try a question

Pick a question: see what the store owner writes, the query Chiaro runs and the answer that comes back.

Real answers from Chiaro’s demo store, an Italian shop: 4,697 orders in 24 months, 189 products, 3,593 customers. On your site the numbers are yours.

Question

Which 5 products earned the most this year?

Query

SELECT prodotto, ROUND(SUM(ricavo_netto), 2) AS fatturato
FROM ai_bi_righe_ordine
WHERE anno = YEAR(CURDATE())
GROUP BY prodotto_id, prodotto
ORDER BY fatturato DESC
LIMIT 5

Answer

5 rows. Total 41,284.28 €. First is Telo mare blu with 11,302.39 €.

  • Telo mare blu11,302.39
  • Sciarpa in lana rosso8,963.27
  • Sandalo grigio7,563.18
  • Ciabatta verde7,425.25
  • Camicia Oxford bianco6,030.19
productrevenue
Telo mare blu11,302.39
Sciarpa in lana rosso8,963.27
Sandalo grigio7,563.18
Ciabatta verde7,425.25
Camicia Oxford bianco6,030.19

Your data stays on your site

The query runs on your site, read-only, on views that hold no customer names, emails or phone numbers. And you can always read it.

What the AI receives

Your question
“Which 5 products earned the most this year?”
The column names
For example product, year, quantity, net revenue, category. Only the names, never the values.
Earlier questions
Those of the same conversation, to understand “and in June?”.

With these it writes the query. The query goes back to your site and runs there: no row of your data and no amount reaches the AI.

What stays on your site

  • Orders
  • Customers
  • Products

With amounts, dates, provinces, what each customer spent, stock and costs.

It also works on its own

Dashboard · last 30 days

Revenue€25,434▲ +43%
Orders216▲ +29.3%
Average order€145▲ +9.3%
New customers127▲ +22.1%
Returning customers85▲ +44.1%
Refunds14▲ +7.7%

Compared with the previous period. No question used.

This morning’s alerts

Sciarpa in lana rosso is out of stock. You sold 309 pieces in the last 12 months.
Pochette blu is out of stock. 116 pieces sold in the last 12 months.
Returns going up. 8 pieces returned this week, 1 the week before.

You see them in the dashboard. Email off.

From: Chiaro · Monday 12 October, 8:00
Subject: Your week, 5 to 11 October

Orders55 (49 the week before, +12.2%)
Revenue€7,111.07 (−0.6%)

Best sellers

  1. Sciarpa in lana rosso, 10 pieces
  2. Cappello blu, 7 pieces
  3. Maglione girocollo in lana bianco, 3 pieces

Worth a look

  1. Sciarpa in lana rosso is out of stock while it sells.
  2. Returns going up: 8 against 1.

Next one: Monday 19 October at 8:00.

Pinned: revenue month by month in the last 12 months

  1. Nov
  2. Dec
  3. Jan
  4. Feb
  5. Mar
  6. Apr
  7. May
  8. Jun
  9. Jul
  10. Aug
  11. Sep
  12. Oct

Updated Monday at 8:00 · no question used

Which 5 products earned the most this year?
  • Telo mare blu11,302.39
  • Sciarpa in lana rosso8,963.27
  • Sandalo grigio7,563.18
  • Ciabatta verde7,425.25
  • Camicia Oxford bianco6,030.19
Ask ChiaroDownload CSVPin

A dashboard, ready every morning

The key numbers of the last 30 days compared with the 30 before, the revenue of the last 12 months and the best-selling products. It is calculated on your site and does not use questions.

Alerts, before you notice

A product about to run out or out of stock while it was selling, sales dropping, no orders for 48 hours, refunds going up. Every morning in the dashboard, and by email if you want.

The Monday summary

Last week compared with the week before, the best-selling products and up to three things worth a look. It arrives by email on Monday at 8, if you turn it on.

Pinned questions

Pin an answer you need often and see it again updated with today’s data. The query is already written: running it again is free.

Follow-up questions

After an answer you keep talking: “and last year?”, “only Milan”, “split it by month”. Plus “Ask Chiaro” buttons on products, orders and customers, a CSV of every answer and voice dictation.

Three steps

The setup wizard creates the data views in one click. You don’t write queries or touch the database.

First, install the plugin.

Plugins → Add New Plugin

Chiaro AI Sales AnalyticsSearch
Chiaro – AI Sales Analytics for WooCommerceBy Michele Torresin
Install Now

Then activate your site with your email.

Chiaro → Set up Chiaro

you@yourstore.comActivate

Done! You have 50 free questions.

Then ask, in your own language.

Chiaro → Ask a question

Revenue by category in October so far, compared with October last yearAsk
Chiaro’s answer in the WordPress dashboard: revenue by category in October 2026 and 2025, with a bar chart and a table
The Chiaro panel in WordPress. Chiaro answers in English, Italian, French, Spanish and German.

Pay for answers, not months

300 questions

€9
  • 3 cents per question
  • VAT included
 Start with 50 free

1,000 questions

€25
  • 2.5 cents per question
  • VAT included
  • Optional automatic top-up, with a monthly cap
 Start with 50 free

3,000 questions

€59
  • About 2 cents per question
  • VAT included
  • Optional automatic top-up, with a monthly cap
  • Questions do not expire, as in the other packs
 Start with 50 free

No subscription. You buy a pack from the plugin, with the “Top up” button, when you need it. A question is deducted only when an answer arrives.

Payment through Paddle.com, our reseller and merchant of record, which issues the receipt or invoice. Full refund within 14 days for an unused pack.

Already have a key for Google Gemini, OpenAI, Anthropic or a compatible service? Use Chiaro with it, without packs: you pay the service directly.

Common questions

What do I need to use it?

WordPress 6.2 or later, WooCommerce with High-Performance Order Storage (HPOS) and PHP 7.4 or later. The plugin is free.

Which languages can I ask in?

English, Italian, French, Spanish and German. Chiaro answers in the language of the question.

What if an answer is wrong?

Under every answer is the query that produced it: you can check it, or rephrase the question. Chiaro is in beta and learns from real stores: if an answer doesn’t add up, tell us in the support forum or at info@tceitalia.com.

Does the AI see my customers?

No. It receives the question and the column names. The query runs on your site, read-only, on views that leave out names, emails and phone numbers: orders, customers and amounts never pass through our servers. The details are in the privacy policy.

How do refunds work?

For an unused pack you get a full refund within 14 days, directly from the plugin. The complete rules are in the refund policy.

I run an agency. Can I offer it to clients?

Yes: with your partner code your clients get 10% off packs and you receive 20% of the net revenue for 12 months. The terms are on the page for agencies.

The Chiaro dashboard: revenue, orders, average order and new customers of the last 30 days
A pinned question: revenue month by month in the last 12 months
The Ask Chiaro box on a WooCommerce product page

Install Chiaro and ask your first question: the first 50 are free.

The plugin is free, on WordPress.org.
Support: info@tceitalia.com