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:<\/p>\n\n
Chiaro is in beta<\/strong>: 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.<\/p>\n\n What you get<\/strong><\/p>\n\n Your data stays on your site.<\/strong> 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.<\/p>\n\n Safe by design.<\/strong><\/p>\n\n Works out of the box.<\/strong> 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.<\/p>\n\n Bring your own AI.<\/strong> 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.<\/p>\n\n Your language.<\/strong> 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.<\/p>\n\n With the Chiaro questions service the first 50 questions are free. Then you buy packs, with no subscription and no expiry:<\/p>\n\n 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.<\/p>\n\n When you activate Chiaro with your email, the plugin connects to the Chiaro service at https:\/\/chiaro-api.tceitalia.com, run by TCE Italia.\n* At activation it sends: the site address, the email you enter and the plugin version.\n* 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.\n* To show the questions left and manage top-ups it sends the site identifier, signed with a key stored on your site.\n* If you enter a partner code in Settings, it sends that code to link the site to the agency.\nThe service forwards the question to Google Gemini to write the query. Terms: https:\/\/chiaro-api.tceitalia.com\/terms \u2013 Privacy: https:\/\/chiaro-api.tceitalia.com\/privacy<\/p>\n\n 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 \u2013 Privacy: https:\/\/www.paddle.com\/legal\/privacy<\/p>\n\n To answer a question, Chiaro sends a request to the AI service you choose in Chiaro \u2192 Settings<\/strong>. Nothing is sent until you configure a service and ask a question (or press \"Test the setup\").<\/p>\n\n What is sent, every time you ask a question: the text of the question, the names and types of the columns of the Depending on your choice, the request goes to one of these services:<\/p>\n\n 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 \u2192 Settings<\/strong>.<\/p>\n\n\n 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.<\/p><\/dd>\n With your own AI key Chiaro is free. With the Chiaro questions service the first 50 questions are free, then packs start at \u20ac9 for 300 questions, with no subscription. See Pricing above.<\/p><\/dd>\n 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.<\/p><\/dd>\n No. The plugin only runs a single Chiaro is tested with Google Gemini (gemini-3.6-flash). Other services work if they follow the OpenAI or Anthropic API.<\/p><\/dd>\n 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.<\/p><\/dd>\n Not yet: the data views read the High-Performance Order Storage tables.<\/p><\/dd>\n The \n
\n
ai_bi_*<\/code>) that contain no customer names, emails, phone numbers or full addresses.<\/li>\nSELECT<\/code>, only on those views, with a row limit.<\/li>\nPricing<\/h4>\n\n
\n
External services<\/h3>\n\n
Chiaro questions service (default)<\/h4>\n\n
Payments<\/h4>\n\n
Your own AI key (optional)<\/h4>\n\n
ai_bi_*<\/code> 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.<\/p>\n\n\n
Voice dictation (optional)<\/h4>\n\n
\n
\n
Is my store data sent to the AI?<\/h3><\/dt>\n
How much does it cost?<\/h3><\/dt>\n
Do I need to create an account?<\/h3><\/dt>\n
Can the AI change or delete data in my store?<\/h3><\/dt>\n
SELECT<\/code> 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_*<\/code> views.<\/p><\/dd>\nWhich AI service should I use?<\/h3><\/dt>\n
Can Chiaro calculate my margin?<\/h3><\/dt>\n
Does it work without HPOS?<\/h3><\/dt>\n
What happens when I uninstall the plugin?<\/h3><\/dt>\n
ai_bi_*<\/code> 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.<\/p><\/dd>\n\n<\/dl>\n\n\n0.7.3<\/h4>\n\n
\n
0.7.2<\/h4>\n\n
\n
0.7.1<\/h4>\n\n
\n
0.7.0<\/h4>\n\n
\n
0.6.0<\/h4>\n\n
\n
0.5.9<\/h4>\n\n
\n
0.5.8<\/h4>\n\n
\n
0.5.7<\/h4>\n\n
\n
0.5.6<\/h4>\n\n
\n
0.5.5<\/h4>\n\n
\n
0.5.4<\/h4>\n\n
\n
0.5.3<\/h4>\n\n
\n
0.5.2<\/h4>\n\n
\n
0.5.1<\/h4>\n\n
\n
0.5.0<\/h4>\n\n
\n
0.4.8<\/h4>\n\n
\n
0.4.7<\/h4>\n\n
\n
0.4.6<\/h4>\n\n
\n
0.4.5<\/h4>\n\n
\n
0.4.4<\/h4>\n\n
\n
0.4.3<\/h4>\n\n
\n
0.4.2<\/h4>\n\n
\n
0.4.1<\/h4>\n\n
\n
0.4.0<\/h4>\n\n
\n
0.3.4<\/h4>\n\n
\n
0.3.3<\/h4>\n\n
\n
0.3.2<\/h4>\n\n
\n
0.3.1<\/h4>\n\n
\n
0.3.0<\/h4>\n\n
\n
0.2.0<\/h4>\n\n
\n
0.1.1<\/h4>\n\n
\n
0.1.0<\/h4>\n\n
\n