=== Askeet — Talk to Your WooCommerce Data === Contributors: 2wstechnologies Tags: AI, WooCommerce, analytics, charts, reports, business intelligence, GPT, ChatGPT, conversational, dashboard, insights, sales, customers, products Donate link: https://www.askeet.ai/ Requires at least: 6.2 Tested up to: 6.9 Stable tag: 3.1 License: GPLv2 or later License URI: http://www.gnu.org/licenses/gpl-2.0.html The AI analyst for your WooCommerce store. Ask any question in plain language — get answers, charts, and recommendations in 5 seconds. == Description == **Stop reading dashboards. Talk to your data.** A freelance data analyst costs $500–$3,000/month. Askeet does the same job for $19/month, available 24/7, with zero technical skills required. Type a question. Get the answer, the chart, and a recommendation — instantly. = Example questions you can ask = * "Show me my top 10 customers this month" * "Which products are selling best by region?" * "How does this month's revenue compare to last month?" * "What's my refund rate over the last 90 days?" * "Which customers haven't ordered in 3 months?" * "Plot daily sales for the last 30 days" Each answer comes with **interactive charts** (line, bar, pie, area), a **plain-language summary**, and **actionable recommendations** — no SQL, no dashboards, no learning curve. = What's new in v3 = * **📊 Interactive charts in answers** — bar / line / pie / area, auto-selected by AI from your data shape * **🎁 14-day Business trial on install** — no credit card, all features unlocked * **🔥 Founder's price $19/mo for life** — first 200 customers, locked in forever * **💼 Business plan with webhooks, REST API, and multi-store** (up to 5 stores) * **📚 100+ pre-built insights library** — sales, products, customers, orders, inventory, marketing, finance * **🩺 Store Health Score** with proactive weekly alerts * **☕ Monday Morning Brief** — weekly digest of your KPIs by email * **🧠 Smarter AI** — now reads your real database conventions (HPOS-aware, real meta_keys, prefer denormalized lookup tables) for dramatically more accurate SQL = Why Askeet changes everything = * **🚀 Save 10+ hours per week** — no more manual reports * **💡 Decide in seconds, not days** — answers in 5 seconds * **📈 Grow your revenue** — discover opportunities hidden in your data * **🎯 Zero learning curve** — if you can ask a question, you can use Askeet * **🔒 Your data stays put** — only your question is sent to Askeet, never your customer/order data = Perfect for = * Store owners who want answers without learning a dashboard * Marketing managers tracking campaign performance * Operations / inventory managers watching stock and orders * Agencies running multiple WooCommerce stores * Anyone tired of opening 5 tabs to answer one question = Key features = **🎤 Natural-language interface** * Ask in plain English, French, Spanish, German, Arabic — the plugin adapts to your WordPress language * No SQL, no dashboards to learn * Conversational follow-ups: "and last month?", "filter by France only", "sorted by revenue" **📊 Interactive charts (Pro+)** * Bar charts for rankings and comparisons * Line charts for time-series trends * Pie charts for breakdowns and proportions * Area charts for cumulative growth * Hover tooltips, responsive sizing * Persisted in saved reports — re-render on demand **📁 Exports (Pro+)** * PDF for client/team reports * Excel for further analysis * CSV for ETL pipelines * Up to 10,000 rows per export **📚 100+ insights library** * Sales: revenue trends, top products, AOV, daily/weekly/monthly views * Customers: VIPs, lifetime value, new vs returning, cohorts * Inventory: low-stock alerts, out-of-stock, dead stock * Orders: status breakdown, refund rate, completion rate * Finance: revenue per channel, tax breakdown, gross margin * Marketing: campaign performance, conversion by source, abandoned-cart analysis **🩺 Store Health Score** * Composite 0-100 score across sales, inventory, customers, operations * Sub-scores per area * Actionable recommendations * History trend (Business plan) **🔔 Proactive alerts (Pro+)** * Pro: 5 weekly alerts (top anomalies and opportunities) * Business: unlimited, with custom thresholds **📧 Automated reports** * Pro: Monday Morning Brief (weekly KPI digest) * Business: daily, weekly, and monthly reports **🔌 Outbound webhooks (Business)** * Slack, n8n, Zapier, Make, custom URLs * Fire on report delivery, alert trigger * Signed payloads **🔑 REST API (Business)** * `wp-json/askeet/v1/insights`, `/reports`, `/health-score` * Per-install API keys * Build your own dashboards or sync with your data warehouse **🏪 Multi-store (Business)** * Connect up to 5 WooCommerce stores under one account * Switch between them in the plugin header * Aggregated reports across all stores **🔒 Privacy & security** * Your customer, order, and product data **never leaves your server** * Only the natural-language question + an anonymized schema dump goes to Askeet * GDPR compliant * Stripe-secured payments * 30-day money-back guarantee = Pricing = **🆓 Free** — $0/mo forever * 50 queries / month * Text answers * 10 starter insights * Community support **💼 Pro** — $19/mo billed yearly (or $29/mo monthly) * Unlimited queries * Interactive charts * PDF / Excel / CSV export * Health Score * 5 weekly proactive alerts * Monday Morning Brief * 100+ insights library * Email support (24h) **🚀 Business** — $49/mo billed yearly (or $79/mo monthly) * Everything in Pro * Unlimited proactive alerts * Daily + weekly + monthly reports * Slack / n8n / Zapier webhooks * REST API access * Multi-store (up to 5) * Priority support (12h SLA) **🔥 Founder's price** — $19/mo for life (limited to 200 seats) * Same unlimited Pro plan * Locked at $19/mo as long as you stay subscribed * No yearly commitment required = 30-day money-back guarantee = Not satisfied? Get a full refund within 30 days, no questions asked. Visit [https://www.askeet.ai/](https://www.askeet.ai/) to learn more. == Installation == = Automatic installation (recommended) = 1. WordPress admin → **Plugins → Add New** 2. Search for "**Askeet**" 3. Click **Install Now**, then **Activate** 4. Visit the new **Askeet** menu item — your 14-day Business trial starts automatically 5. Ask your first question = Manual installation = 1. Download the `askeet.zip` file 2. WordPress admin → **Plugins → Add New → Upload Plugin** 3. Choose `askeet.zip`, click **Install Now**, then **Activate** 4. Visit the **Askeet** menu = After installation = * You're auto-enrolled in a 14-day Business trial — full access, no card required * When the trial ends, you stay on Free (50 queries/month) or upgrade to Pro / Business * All configurations you build during the trial (alerts, reports, custom insights) are preserved — re-activate them by subscribing == Frequently Asked Questions == = Do I need an account or subscription? = No. Install the plugin and you're auto-enrolled in a 14-day Business trial — every feature unlocked, no credit card. After the trial you stay on the Free plan (50 queries/month forever) unless you subscribe. = Is my data secure? = Yes. Your customer, order, and product data never leaves your WordPress server. Only the natural-language question (and an anonymized list of your tables) is sent to api.askeet.ai. The SQL runs locally on your database. Askeet never sees your data. = Do I need technical skills? = Zero. If you can ask a question in plain language, you can use Askeet. No SQL, no dashboards to configure. = Does it work with my theme and plugins? = Yes. Askeet only reads from your WooCommerce database — it doesn't touch your front-end. Compatible with all themes, page builders, and other WooCommerce plugins. HPOS-aware (works with both legacy and the new High-Performance Order Storage). = What languages are supported? = The plugin UI adapts to your WordPress language. The AI understands questions in any major language (English, French, Spanish, German, Italian, Portuguese, Arabic, Dutch, etc.). = Can I export results? = Yes. Pro and Business plans export to PDF, Excel, or CSV — up to 10,000 rows per export. Charts are exported as embedded images in PDFs. = Does it slow my store down? = No. The plugin is under 500 KB. Queries only run when you ask one — no background polling, no front-end impact for your customers. The schema dump (sent once to the AI) is cached for 12 hours. = How is Askeet different from Metorik or MonsterInsights? = Metorik and MonsterInsights are **dashboards** — you read pre-built charts, learn the UI, build reports yourself. Askeet is a **chat** — you ask a question in plain language and get the answer + the chart, with zero learning curve. Both can coexist; they solve different problems. = Can I use it for multiple stores? = Yes — the **Business** plan supports up to 5 WooCommerce stores under one account. You switch between them in the plugin header. = How often is the data updated? = Real-time. Askeet queries your live WooCommerce database — there's no nightly sync, no cached snapshots. Every answer reflects the data as of "now." = Do you provide support? = * **Free**: community support (Discord + Slack) * **Pro**: email support, 24h response time * **Business**: priority email support, 12h SLA = What if I'm not satisfied? = 30-day money-back guarantee, no questions asked. Cancel anytime from the in-plugin "Manage Billing & Invoices" button (Stripe customer portal). = What happens to my configurations if my trial ends or I downgrade? = Nothing is deleted. All configurations (alerts, reports, custom insights, webhooks) are preserved. They simply pause. Subscribe again and they reactivate instantly — same settings, same history. == Screenshots == 1. AI Chat — ask any question, get the SQL, the table, and an interactive chart 2. Charts — bar, line, pie, area, picked automatically based on the data shape 3. Subscription page — clear pricing with live Founder's seats counter 4. Health Score dashboard with sub-scores and recommendations 5. 100+ insights library — pre-built queries grouped by category 6. Saved reports with re-renderable charts 7. Mobile-responsive — answer questions from your phone == Changelog == = 3.1 = * **🔒 SECURITY FIX (CVE-2026-5651, CVSS 4.9)**: hardened `Askeet_Security::is_safe_query()` against MySQL conditional-comment evasion (`/*!UNION*/`). The previous implementation stripped `/*...*/` comments before keyword scanning, which silently removed conditional comments that MySQL still executes — letting an authenticated administrator append UNION/INSERT/etc. to the validated query. The validator now rejects any query containing `/*!` outright, additionally strips `#` line comments (previously missed), and extends the forbidden-keyword list to include OUTFILE, DUMPFILE, LOAD_FILE, BENCHMARK, SLEEP, INFORMATION_SCHEMA, HANDLER. Patched paths: `askeet_execute_sql_query`, `askeet_export_all_results`, the natural-language pipeline, and the cron insight runner — all four call the central validator. * IMPROVED: extends backtick-identifier stripping in the validator (defense-in-depth against false positives). * IMPROVED: Compatibility with WordPress 6.9. Credits: vulnerability reported by Régis SENET via Wordfence. = 3.0 = * **NEW: Interactive charts in answers** (Pro+) — bar / line / pie / area, auto-selected from data shape, hover tooltips, responsive * **NEW: 14-day Business trial on install** — no credit card, all features unlocked * **NEW: Founder's price $19/mo for life** — first 200 customers, locked-in pricing * **NEW: Pro $29/mo, Business $79/mo** — yearly billing saves 34-38%; monthly available * **NEW: 50 queries/month free tier** (was 10/day) * **NEW: Outbound webhooks** (Business) — Slack, n8n, Zapier, Make * **NEW: REST API + auth keys** (Business) — `wp-json/askeet/v1/*` * **NEW: Multi-store registry** (Business) — up to 5 stores under one account * **NEW: Daily + monthly reports** (Business) * **NEW: 100+ pre-built insights library** — sales / products / customers / orders / inventory / marketing / finance * **NEW: Health Score history** (Business) * **NEW: Trial countdown banner + paywall modals** with feature-pause-on-downgrade UX * **IMPROVED: AI now reads your real DB conventions** — HPOS-aware, real meta_keys sampled from `wp_postmeta`, prefers denormalized `wp_wc_*` lookup tables → dramatically more accurate SQL * **IMPROVED: Subscription page redesigned** — 3-column grid, "Most Popular" ribbon on Pro, live Founder counter, value props, FAQ * **IMPROVED: Chat readability** — bigger tables, larger charts, wider response bubbles, no more inner scrollbars * **IMPROVED: Pagination fixed** — 20 rows/page now actually shows 20 (was showing all rows) * **IMPROVED: Export Page / Export All** — Page exports the visible slice, All exports the full set * **IMPROVED: Plugin logo refreshed** (loupe-style icon) * **IMPROVED: Migration-safe** — existing v2 customers keep their grandfathered prices, gain access to all v3 features * **FIXED: AI follow-up answers** rendering in too-small bubbles * **FIXED: Community page buttons** (Discord / Slack / Contact) not opening * **FIXED: Subscription "Free" button** showing as enabled when on a paid plan * **FIXED: Two scrollbars** on Settings / Insights / Reports / History pages * **FIXED: Feedback / ratings storage** — submissions now correctly land in the Supabase `feedbacks` and `ratings` tables = 2.0 = * NEW: Modern subscription management page with pricing cards and one-click upgrades * NEW: Smart pagination — display 50 rows, export up to 1,500 rows per page * IMPROVED: Export limit increased to 10,000 rows with "Export All" button * IMPROVED: Dynamic rows per page selector (20, 50, 100, 500, 1,500) * IMPROVED: Performance notifications for large datasets * FIXED: Upgrade modal display when reaching plan limits * UPDATED: Community links (Discord + Slack) * UPDATED: UI/UX design optimization with better responsiveness = 1.0 = * Initial release * Natural-language query interface * Basic analytics and reporting * Free tier with 50 monthly queries * WooCommerce integration * Multilingual support * Export functionality (Pro) == Upgrade Notice == = 3.1 = **Security fix.** Patches CVE-2026-5651 — an authenticated-administrator SQL injection via MySQL conditional comments. All site administrators should update immediately. = 3.0 = Charts in answers, 14-day Business trial on install, Founder's price $19/mo for life (200 seats), webhooks, REST API, multi-store, 100+ insights library, smarter AI. Existing v2 customers keep their grandfathered prices. = 2.0 = Modern subscription management, smart pagination up to 1,500 rows/page, export up to 10,000 rows, refined UI. = 1.0 = Initial release. Install now to start getting instant insights from your WooCommerce data. == Source Code == The unminified source code for JavaScript and CSS is included in the `/assets/js/` and `/assets/css/` folders of this plugin. == External Services == This plugin connects to https://api.askeet.ai to process AI queries, check user plans, and manage subscriptions. Data sent: site URL, install ID, the natural-language question, and an anonymized list of your database table names. **No customer, order, or product data is sent.** Service provider: Askeet (Reach Technologies) Legal Notice: https://www.askeet.ai/#mentions Privacy Policy: https://www.askeet.ai/#privacy == Support & Community == * **Website:** [https://www.askeet.ai/](https://www.askeet.ai/) * **Support email:** contact@askeet.ai * **Discord:** [https://discord.com/channels/1438540885758443570/1438540942973079766](https://discord.com/channels/1438540885758443570/1438540942973079766) * **Slack:** [https://reach-technologies.slack.com/archives/C09S953P6MD](https://reach-technologies.slack.com/archives/C09S953P6MD)