=== 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)
