PrestaShop AI Reporting

The Magic Search page is where a question becomes a result. Type it, and the module builds a prompt containing your schema and worked examples, sends it to your configured AI provider, guards the returned SQL and executes it.

• Ask questions in plain language with a single search box and a set of example prompts
• Switch the same result between table, line, pie, bar and area views without re-running the query
• Set the chart label, X-axis column and Y-axis column from a dedicated panel
• Read the exact SQL behind any result in a dedicated SQL view, with a Copy SQL control
• Download the table as CSV or the chart as a PNG image
• Save any result as a named report with its chart type and axes

Orders, order line items, Products and Customers are copied into dedicated flat tables so the questions that matter most run fast. The rebuild is yours to trigger, per entity, and reports progress live while it works.

• Rebuild Orders, Products or Customers individually from the configuration screen
• Watch per-entity live progress, row counts and Pending, Running, Done or Failed status
• Optional columns for orders, order items, products and customers are chosen from a checkbox picker, and the tables are rebuilt to match
• Schedule unattended rebuilds through a cron URL protected by a generated token

Two ways to connect an AI service are supported, and both are configured from the same General screen. The active type is preconfigured as a self-hosted or hosted reporting endpoint with a token key, while the LLM Provider type talks directly to one of six supported vendors.

• Preconfigured: set a reporting endpoint URL and a token key, then validate the endpoint and push your schema to it
• LLM Provider: pick OpenAI, Gemini, Anthropic, OpenRouter, Cerebras or DeepSeek
• Choose a model from a list fetched live from the provider, with a built-in fallback list if the fetch fails
• Run a Validate Provider check that sends a real connectivity test and reports Valid or Invalid
• The API key is stored encrypted and is never written as a plain configuration row; clearing the field keeps the saved key

Saved reports live in their own Back Office section with two interchangeable modes. The list gives you search, filtering and bulk delete; the dashboard gives you a wall of live cards.

• List mode with sortable and filterable columns for label, question, chart type and creation date
• View a single saved report to see its stored definition and its freshly executed result
• Dashboard mode draws two report cards per row and re-runs every saved report on page load
• Reorder reports by dragging and delete them individually or in bulk
• Every saved report is scoped to the shop it was created under

• Turn a plain-English question into SQL and return the answer as a table or chart.
• Report on nine entities: Orders, Refunds, Products, Customers, Product Inventory, Category, Abandoned Cart, Product Reviews and Wishlist.
• Serve Orders, Products and Customers from rebuildable flat tables for fast queries.
• Connect to a Webkul preconfigured endpoint or your own OpenAI, Gemini, Anthropic, OpenRouter, Cerebras or DeepSeek key.
• Guard every generated query with a single-statement check, a keyword blacklist and a table/column whitelist.
• Switch between table, line, pie, bar and area chart views and inspect the generated SQL.
• Save reports to a dashboard that reorders, re-runs and redraws them on load.
• Export table results as CSV and chart views as PNG.
• Rebuild flat tables on demand from the configuration screen or on a token-guarded cron schedule.

For any query or issue, please create a support ticket here: https://webkul.uvdesk.com/en/customer/create-ticket/ You may also check our quality PrestaShop Module: https://store.webkul.com/PrestaShop-Extensions.html