Title: Chiaro – AI Sales Analytics for WooCommerce Author: Michele Torresin Published: October 16, 2026 Last modified: October 16, 2026 --- Search plugins ![](https://ps.w.org/chiaro-ai-sales-analytics-for-woocommerce/assets/banner-772x250. png?rev=3750741) ![](https://ps.w.org/chiaro-ai-sales-analytics-for-woocommerce/assets/icon.svg?rev =3750741) # Chiaro – AI Sales Analytics for WooCommerce By [Michele Torresin](https://profiles.wordpress.org/tceitalia/) [Download](https://downloads.wordpress.org/plugin/chiaro-ai-sales-analytics-for-woocommerce.0.7.3.zip) * [Details](https://wordpress.org/plugins/chiaro-ai-sales-analytics-for-woocommerce/#description) * [Reviews](https://wordpress.org/plugins/chiaro-ai-sales-analytics-for-woocommerce/#reviews) * [Installation](https://wordpress.org/plugins/chiaro-ai-sales-analytics-for-woocommerce/#installation) * [Development](https://wordpress.org/plugins/chiaro-ai-sales-analytics-for-woocommerce/#developers) [Support](https://wordpress.org/support/plugin/chiaro-ai-sales-analytics-for-woocommerce/) ## Description Chiaro lets store owners ask questions about their own WooCommerce data, in plain language, and get back a short answer, a table and a chart: * “Which 5 products generated the most revenue this year?” * “How are sales going this month compared with last year?” * “Which products are returned the most, and why?” * “Which size do I sell the most?” * “Which provinces and countries do my orders come from?” * “Which products are out of stock but sold well in the last 6 months?” * “What is my margin this year, by category?” (with WooCommerce “Cost of Goods Sold”) Chiaro is in **beta**: it is tested on stores with thousands of orders, but we are still learning from real stores. If an answer looks wrong, the SQL query is always one click away, and we would love to hear from you in the support forum. **What you get** * **Dashboard** with the key numbers of your store compared with the previous period, the revenue of the last 12 months and the best-selling products. It runs on your site: no question is used. * **Suggested questions** based on your own data, one click away. * **Answers with a chart and a table**, automatically compared with the previous period when the question names one (this month, last year, the last 30 days…), with side-by-side bars for comparisons. * **Follow-up questions**: “and in June?”, “only for Milan”, “split it by month”. Chiaro remembers the last questions of the conversation (their text and query, never the data). * **Monday summary by email** (optional): last week compared with the week before, the best-selling products and up to three things worth a look (a product running out, a product selling less, refunds going up, days without orders). Calculated on your site: no question is used. * **Alerts** every morning in the dashboard, with a counter on the Chiaro menu: a product about to run out or out of stock while it was selling, sales dropping, no orders for 48 hours, refunds going up. Optional email as soon as one appears. Calculated on your site: no question is used. * **Pinned questions**: pin an answer and it runs again for free with today’s data. * **“Ask Chiaro”** buttons on products, orders and customers. * **CSV export** of every answer, ready for Excel. * **Voice dictation** of the question (Chrome, Edge, Safari). **Your data stays on your site.** Only your question and the structure of the data( view and column names) are sent to the AI service. The AI writes a database query; Chiaro checks it and runs it on your own database. The rows of the result are never sent to the AI: the text, the table and the chart are built by the plugin. **Safe by design.** * Chiaro reads the store through 10 read-only database views (`ai_bi_*`) that contain no customer names, emails, phone numbers or full addresses. * Every query generated by the AI is checked before it runs: a single `SELECT`, only on those views, with a row limit. * Queries run in a read-only database transaction, with a time limit where the database server supports it. * You can use a dedicated read-only MySQL user. * You can always see the SQL query used for each answer. **Works out of the box.** Activate Chiaro with your email and get 50 free questions, with no AI key to set up. When they run out you can buy question packs (see Pricing below), or use your own AI key. **Bring your own AI.** Chiaro also works with your API key for Google Gemini, Anthropic Claude, OpenAI or any OpenAI-compatible service (for example a local Ollama server). You pay the AI provider directly and Chiaro is free. **Your language.** The interface follows the language of your WordPress profile: English, Italian, French, Spanish and German (other languages use English). Answers follow the language of the question. #### Pricing With the Chiaro questions service the first 50 questions are free. Then you buy packs, with no subscription and no expiry: * 300 questions: €9 * 1,000 questions: €25 * 3,000 questions: €59 Prices include VAT. Pinned questions and the dashboard run again for free. Optional automatic top-up buys the same pack when the questions run low, up to a monthly limit you choose. An unused pack can be refunded within 14 days from the plugin. With your own AI key Chiaro is free. ### External services #### Chiaro questions service (default) When you activate Chiaro with your email, the plugin connects to the Chiaro service at https://chiaro-api.tceitalia.com, run by TCE Italia. * At activation it sends: the site address, the email you enter and the plugin version. * For every question it sends: the question, the structure of the Chiaro data views (names and descriptions of the columns) and, for follow-up questions, up to 3 previous questions of the same conversation with their database query. The question text may include product names or customer ids when you use “Ask Chiaro” on a product, order or customer screen. Store data rows (orders, customers, amounts) are never sent: the query runs on your site. * To show the questions left and manage top-ups it sends the site identifier, signed with a key stored on your site. * If you enter a partner code in Settings, it sends that code to link the site to the agency. The service forwards the question to Google Gemini to write the query. Terms: https://chiaro-api.tceitalia. com/terms – Privacy: https://chiaro-api.tceitalia.com/privacy #### Payments Question packs are sold by Paddle.com (merchant of record). The payment page opens on the Chiaro service and loads Paddle.js. Paddle terms: https://www.paddle.com/ legal/terms – Privacy: https://www.paddle.com/legal/privacy #### Your own AI key (optional) To answer a question, Chiaro sends a request to the AI service you choose in **Chiaro Settings**. Nothing is sent until you configure a service and ask a question (or press “Test the setup”). What is sent, every time you ask a question: the text of the question, the names and types of the columns of the `ai_bi_*` views, a description of the data model, today’s date and, for follow-up questions, up to 3 previous questions of the same conversation with their database query. Your API key is sent to that service only, for authentication. No order, product or customer data is sent. Depending on your choice, the request goes to one of these services: * **Google Gemini API** (Google LLC) – used when “Google Gemini” is selected. [Terms of service](https://ai.google.dev/gemini-api/terms), [Privacy policy](https://policies.google.com/privacy). * **Anthropic API** (Anthropic PBC) – used when “Anthropic Claude” is selected. [Commercial terms](https://www.anthropic.com/legal/commercial-terms), [Privacy policy](https://www.anthropic.com/legal/privacy). * **OpenAI API** (OpenAI, L.L.C.) – used when “OpenAI” is selected. [Terms of use](https://openai.com/policies/terms-of-use/), [Privacy policy](https://openai.com/policies/privacy-policy/). * **Another OpenAI-compatible service** – used when you enter its URL yourself; its own terms and privacy policy apply. #### Voice dictation (optional) The microphone button in the chat uses the speech recognition built into your browser( the Web Speech API). The plugin does not send audio anywhere: depending on the browser, your voice is processed by Google (Chrome), Microsoft (Edge) or Apple (Safari) under their own terms, and only the recognized text is written in the question box. Nothing is sent until you press the button; you can hide it in **Chiaro Settings**. ## Screenshots [⌊The dashboard: key numbers compared with the previous period, the revenue trend and the best-selling products.⌉⌊The dashboard: key numbers compared with the previous period, the revenue trend and the best-selling products.⌉[ The dashboard: key numbers compared with the previous period, the revenue trend and the best-selling products. [⌊An answer with a chart: revenue by category this month, compared with the same days of last year.⌉⌊An answer with a chart: revenue by category this month, compared with the same days of last year.⌉[ An answer with a chart: revenue by category this month, compared with the same days of last year. [⌊The table of the same answer, the CSV export, the pinned question and the SQL query used.⌉⌊The table of the same answer, the CSV export, the pinned question and the SQL query used.⌉[ The table of the same answer, the CSV export, the pinned question and the SQL query used. [⌊"Ask Chiaro" on a product: suggested questions about that product.⌉⌊"Ask Chiaro" on a product: suggested questions about that product.⌉[ “Ask Chiaro” on a product: suggested questions about that product. [⌊Pinned questions run again with today's data, for free.⌉⌊Pinned questions run again with today's data, for free.⌉[ Pinned questions run again with today’s data, for free. [⌊Topping up questions: with automatic top-up you see exactly what will be charged, when and up to which monthly limit.⌉⌊Topping up questions: with automatic top-up you see exactly what will be charged, when and up to which monthly limit.⌉[ Topping up questions: with automatic top-up you see exactly what will be charged, when and up to which monthly limit. ## Installation 1. Install and activate the plugin. WooCommerce must be active, with High-Performance Order Storage (HPOS) enabled. 2. The setup wizard opens. Choose how to answer: activate Chiaro with your email ( a code arrives by email, then you get 50 free questions) or paste your own AI key. 3. The wizard prepares the data views and checks the database. 4. Optional: in **Chiaro Settings** enter a MySQL user with read-only permission. If you leave it empty, Chiaro uses the WordPress database user inside read-only transactions. 5. Ask your first question, or start from a suggested one. ## FAQ ### Is my store data sent to the AI? No. Only the question and the structure of the views are sent. The query runs on your database and the results stay on your site. ### How much does it cost? With your own AI key Chiaro is free. With the Chiaro questions service the first 50 questions are free, then packs start at €9 for 300 questions, with no subscription. See Pricing above. ### Do I need to create an account? No account and no password: you activate the site with your email and a code. Your question balance is linked to that email and site. ### Can the AI change or delete data in my store? No. The plugin only runs a single `SELECT` on its read-only views, inside a read- only transaction that is always rolled back. For extra protection you can use a MySQL user that can only read the `ai_bi_*` views. ### Which AI service should I use? Chiaro is tested with Google Gemini (gemini-3.6-flash). Other services work if they follow the OpenAI or Anthropic API. ### Can Chiaro calculate my margin? Yes, if you use the WooCommerce “Cost of Goods Sold” feature: turn it on in WooCommerce > Settings > Advanced > Features and enter the cost of your products. Orders placed before you entered the costs use the current product cost. ### Does it work without HPOS? Not yet: the data views read the High-Performance Order Storage tables. ### What happens when I uninstall the plugin? The `ai_bi_*` views, the plugin settings and the account data (site connection) are removed. Your store data is never touched. Your question balance stays on the Chiaro service and comes back when you activate again with the same email. ## Reviews There are no reviews for this plugin. ## Contributors & Developers “Chiaro – AI Sales Analytics for WooCommerce” is open source software. The following people have contributed to this plugin. Contributors * [ Michele Torresin ](https://profiles.wordpress.org/tceitalia/) [Translate “Chiaro – AI Sales Analytics for WooCommerce” into your language.](https://translate.wordpress.org/projects/wp-plugins/chiaro-ai-sales-analytics-for-woocommerce) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/chiaro-ai-sales-analytics-for-woocommerce/), check out the [SVN repository](https://plugins.svn.wordpress.org/chiaro-ai-sales-analytics-for-woocommerce/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/chiaro-ai-sales-analytics-for-woocommerce/) by [RSS](https://plugins.trac.wordpress.org/log/chiaro-ai-sales-analytics-for-woocommerce/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 0.7.3 * Stock alerts and the Monday summary now use the same pace as the questions to Chiaro: the last 30 days, without refunded orders, and only for products with at least 5 sales in that time. * Line charts: dates under the chart are easier to read (for example “Oct 2026”) and no longer overlap. * Simpler setup: you activate Chiaro with your email and start with 50 free questions. Your own AI key is still available in Settings, under “Advanced”. * Settings: the data views count now shows all 10 views. * Partner codes: if a WordPress agency gave you a code, enter it once in Settings( Chiaro questions) to get its discount on question packs. #### 0.7.2 * Text domain renamed to match the WordPress.org slug (chiaro-ai-sales-analytics- for-woocommerce), so translations can come from translate.wordpress.org. #### 0.7.1 * Days of stock and reorder: ask which products will run out first at the current sales pace and how many units to reorder to cover the next 30 days (or the days you choose). The stock suggestion now asks this question. * Up to 9 suggested questions, so every question that fits your store’s data is shown. #### 0.7.0 * Alerts: every morning at 7 (site time) Chiaro checks the store and shows in the dashboard what is worth a look: a product that will run out within a week, a product out of stock that was selling, yesterday’s sales well below the usual for that weekday, no orders for 48 hours, refunds of the month more than double the usual. Each alert has “Ask Chiaro” and “Dismiss”; the Chiaro menu shows how many are open. Optional email as soon as a new alert appears (off by default). Open alerts also come first in the Monday summary. #### 0.6.0 * Monday summary by email: every Monday at 8 (site time) the numbers of the past week compared with the week before, the 3 best-selling products and up to three things worth a look: a product that will run out within a week, a product selling much less, refunds going up, days without orders. Turn it on in the setup or in Settings, with “Send me a test now”. Free: no AI, no questions used. Off for sites updated from earlier versions until you turn it on. #### 0.5.9 * Margin: with WooCommerce “Cost of Goods Sold” turned on, ask for margin, margin percentage, markup and cost of goods sold, by product, category or period. Orders placed before the costs were set use the current product cost. Without costs, Chiaro explains where to turn them on. * An answer with a comparison and other values shows the compared value once. #### 0.5.8 * Follow-up questions: continue the conversation with “and in June?”, “only for Milan” or “split it by month” without repeating the question. Chiaro sends the AI the last 3 questions of the conversation with their query, never the data.“ New conversation” starts again; a conversation also ends after 30 minutes. #### 0.5.7 * New questions you can ask: products returned the most, best-selling sizes and variants, cancelled and failed orders, free shipping by period. Stock of products with variants is the sum of the variants. * Answers follow the language of the question when it differs from your WordPress language. * Charts: comparisons show side-by-side bars with a legend; product and category names keep their capitals in the summary; the last month label of line charts is no longer cut. * Fixed: some English answers failed with a database syntax error when a column was named like a reserved MySQL word (for example “year_month”). * Automatic top-up: before paying (and when you change it) Chiaro shows exactly how much will be charged, when and up to what monthly limit. #### 0.5.6 * When the hourly question limit is reached, the wait is shown in minutes instead of seconds. #### 0.5.5 * Clearer activation: after “Send the code” you see where the code went, with “ Change email”; “Send a new code” shows the seconds left; the weekly summary option is gone until the feature is ready; without free questions the message explains how to top up. #### 0.5.4 * Settings are clearer: with Chiaro questions the section for your own AI key is hidden; if the site is not activated yet it opens with “I already have my own AI key”. The status shows “AI service: Chiaro questions” instead of asking for a key. #### 0.5.3 * Database permission warnings are translated, and an administrator user (such as root) gets one short warning instead of a long list of permissions. #### 0.5.2 * After a WooCommerce or Chiaro update the data views are recreated automatically, and checked once a day: if one stops working, a notice offers to update them. #### 0.5.1 * Column headings of the answers are fully translated. * Years, weeks and months are shown as labels (“2026”, “202639”), without thousands separators. #### 0.5.0 * Chiaro speaks your language: interface and answers in English, Italian, French, Spanish and German, following the language of your WordPress profile (other languages use English). * Suggested questions and the dashboard follow the language of each user. #### 0.4.8 * “Edit” button under each question in the chat: it puts the question back in the box, so you can change it and ask again. #### 0.4.7 * After an update the browser loads the new logo instead of an old saved copy. #### 0.4.6 * Fixed a typo in the logo (“Conversational BI”). #### 0.4.5 * The menu icon shows the whole Chiaro “C”, a little thicker so it reads well at small size. #### 0.4.4 * The Chiaro menu entry shows the Chiaro “C” instead of a generic chart icon. #### 0.4.3 * Dictation keeps listening through pauses (it stops after 4 seconds of silence or with another click) and the button stays red while it listens. #### 0.4.2 * Dictation says when it hears no voice (for example when the browser uses the wrong microphone) instead of stopping silently. #### 0.4.1 * Voice dictation: a microphone button next to the question box (Chrome, Edge, Safari) writes the question without sending it. It can be hidden in the settings. #### 0.4.0 * Pinned questions: pin an answer and it runs again for free with today’s data, from the Pinned page and the dashboard (up to 20). * CSV files are named after the question and the date; text that Excel would read as a formula is written as text. #### 0.3.4 * “Ask Chiaro” questions show product and customer names; the AI receives only their ids, and customer names never leave the site. * Setup wizard buttons wait until the page is ready, so the first click is never lost. #### 0.3.3 * The Chiaro logo at the top of the plugin pages. #### 0.3.2 * Purchases list in the settings, with a “Request refund” button: unused packs are refunded automatically within 14 days. #### 0.3.1 * Customer, order and product ids in the answers open the record in WooCommerce. * Suggested questions are written in the box, not sent: you decide when to ask. * Answers with a comparison show the value once. * Amounts always with two decimals. * The verification code can be pasted from the email. #### 0.3.0 * Questions without an AI key: 50 free questions, then question packs. * Setup wizard. * Dashboard as the first page of Chiaro. * Suggested questions based on your store data. * Comparison with the previous period in the answers. * “Ask Chiaro” on products, orders and customers. * Fix for answers with a table. #### 0.2.0 * New name: Chiaro – AI Sales Analytics for WooCommerce. * Database access through the WordPress database API, in read-only transactions. * AI requests through the WordPress HTTP API. * Interface in English with Italian translation. * Product sales of the last 12 months now count only valid orders, like the orders view. #### 0.1.1 * Easier to read answers in the chat. #### 0.1.0 * First version. ## Meta * Version **0.7.3** * Last updated **15 hours ago** * Active installations **Fewer than 10** * WordPress version ** 6.2 or higher ** * Tested up to **7.1.3** * PHP version ** 7.4 or higher ** * Tags * [AI](https://wordpress.org/plugins/tags/ai/)[analytics](https://wordpress.org/plugins/tags/analytics/) [reports](https://wordpress.org/plugins/tags/reports/)[sales](https://wordpress.org/plugins/tags/sales/) [woocommerce](https://wordpress.org/plugins/tags/woocommerce/) * [Advanced View](https://wordpress.org/plugins/chiaro-ai-sales-analytics-for-woocommerce/advanced/) ## Ratings No reviews have been submitted yet. [Your review](https://wordpress.org/support/plugin/chiaro-ai-sales-analytics-for-woocommerce/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/chiaro-ai-sales-analytics-for-woocommerce/reviews/) ## Contributors * [ Michele Torresin ](https://profiles.wordpress.org/tceitalia/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/chiaro-ai-sales-analytics-for-woocommerce/)