PrestaShop Smart AI Admin Assistant User Manual & Setup Guid

1.0 Introduction

Managing a PrestaShop store means working with data every day. Orders, stock levels, customer registrations, abandoned carts, revenue, coupon activity, the numbers keep coming. Running the same data checks every day means going through the same steps each time: open a report, set the filters, wait for the page, and do it all over again the next morning. It adds up to a lot of time spent on something that should take seconds. The Knowband PrestaShop Smart AI Admin Assistant removes that friction. It places an AI-powered chat interface directly inside your PrestaShop back office. Type a question in plain English, get an answer from your live store data in seconds, no SQL knowledge, no report navigation, no developer required.

This user manual covers every tab and setting so you can configure the module, connect your AI provider, and start querying your store data on day one. Compatible with PrestaShop 1.7.x through 9.x.

1.1 Who Is This Module For

The PrestaShop Smart Admin Assistant is built for:

Store owners who check the same figures every morning and want a faster way to do it.
Operations managers who need instant answers on orders, stock, and revenue without digging through reports.
Stores with multiple admin staff where different roles need different levels of data access.
Any merchant who wants AI-powered PrestaShop back office analytics without a developer on call.

2.0 Installation Guide

System Requirements

PrestaShop 1.7.x, 8.x, or 9.x
PHP 7.2 or higher
A working API key from OpenAI, Anthropic, or Google

Uploading and Installing the Module

Step 1: Log in to your PrestaShop back office, go to Modules, and open Module Manager.

Step 2: Find the “Upload a Module” button at the top right, select the ZIP file you downloaded from Knowband, and confirm. PrestaShop takes it from there.

Step 3: Once the upload finishes, an Install button appears. Click it. The module configuration screen opens on its own once installation is done.

Step 4: If nothing appears after install, type Smart Admin Assistant into the Module Manager search bar and hit Configure.

Common Installation Issues

Upload fails: Server upload size limit is too low. Ask your host to increase upload_max_filesize and post_max_size in the PHP settings to at least 32 MB.

Module not visible after install: Clear the PrestaShop cache under Advanced Parameters, then Performance, then search for the addon again.

Configuration page appears broken: Clear your browser cache and the PrestaShop theme cache under Design, then Theme and Logo, then Advanced Settings.

3.0 PrestaShop Smart AI Admin Assistant: Admin Panel Overview

The PrestaShop Smart AI Admin Assistant has eight tabs across the top of the configuration page:

Settings: Core preferences, SQL toggles, voice input, language, log retention, schema cache.
AI Provider: Connect OpenAI (ChatGPT), Anthropic Claude, or Google Gemini using your API key.
Widget Layout: Customise the chat widget appearance with a live preview that updates as you make changes.
Database Views: Choose which data categories the AI is allowed to query.
Access Control: Manage which admin profiles are permitted to open the assistant.
Predefined Chips: One-click question buttons for quick daily checks.
Query History: A running log of every query, showing the employee, how long it took, and whether it succeeded.
Sessions: Complete chat threads per employee.

Together, these tabs cover everything from PrestaShop Smart Store Analytics and reporting to data access control and session history.

4.0 Settings Tab

4.1 General Settings of the PrestaShop AI Dashboard Module

Enable Chatbot: Toggle the PrestaShop Smart AI Admin Assistant on or off. All settings are preserved when disabled; re-enabling them brings everything back instantly.

Enable Predefined Chips: Toggle the quick-click question buttons on or off inside the chat widget.

Chips Default State: Collapsed means the chips panel will be hidden when the widget first opens. Expanded means all chips will be visible as soon as the assistant loads.

Max Result Rows: The maximum number of rows the AI may return for any one query.

The range runs from 1 to 1000, with 100 as the default. Push it higher for detailed data pulls, keep it lower when you just need a quick figure.

Show SQL Query Toggle: When set to Yes, the assistant displays the exact SQL it generated beneath each answer. This is the core PrestaShop back office analytics transparency feature; admins see precisely how every answer was produced.

Allow SQL Edit and Re-run: When set to Yes, admins can edit the generated SQL directly in the chat and re-run it. Useful for adjusting a date range, threshold, or filter without typing a new question from scratch.

Voice Input: Enables the microphone icon in the chat input. Admins can speak questions instead of typing, using the browser’s Web Speech API. This voice input admin feature for PrestaShop works best in Chrome on a desktop.

4.2 Language Settings

Use Back-office Language: The assistant matches the language your PrestaShop admin panel is currently running in.

Use Custom Language: Choose a fixed response language which will not change based on the language the back office is set to. Useful when individual staff members work in a language different from the one in which the back office is configured.

4.3 Log and Cache Settings

Log Retention (days): Decides how many days of query history the module holds before deleting old entries. Default is 90 days. The cleanup runs on its own schedule without any manual database work.

These settings help the PrestaShop Smart Insights Module maintain accurate and up-to-date query records at all times.

Schema Cache TTL (minutes): The schema is the structure map of your database that the AI reads to build accurate queries. This setting controls how long the map is cached before the addon fetches a fresh copy.

Refresh Schema Now: Triggers an immediate schema refresh on demand. Run this after adding a new module, upgrading PrestaShop, or any change that alters the database structure.

Click Save Settings to apply all changes on this tab.

5.0 AI Provider Tab

The AI Provider tab is where you link the module to your preferred AI service. OpenAI (ChatGPT), Anthropic Claude, and Google Gemini are all supported. This multi-AI provider support means you are not locked into a single vendor. You supply your own API key, and the addon connects directly to your chosen provider.

5.1 Choosing Your Provider

Click the provider button, OpenAI (ChatGPT), Anthropic Claude, or Google Gemini, to select it. The settings below update to show fields for that provider.

5.2 How to Get Your API Key

OpenAI

Go to platform.openai.com and sign in or create an account.
Select API Keys from your profile menu. Hit Create new secret key, name it, and confirm. Copy the key right away since OpenAI only shows it once.
Paste it into the OpenAI API Key field in the module. This connects the PrestaShop OpenAI back office integration directly to your account.

Anthropic Claude

Go to console.anthropic.com and sign in or create an account.
Click API Keys in the left sidebar.
Click Create Key, give it a name, and copy the key shown.
Paste it into the Claude API Key field. The PrestaShop Claude AI back office connection is established as soon as the key is saved.

Google Gemini

Go to aistudio.google.com and sign in with a Google account.
Click Get API key in the top left.
Click Create API key, select a project, and copy the generated key.
Paste the key into the Gemini API Key field in the addon. The PrestaShop Gemini Admin Module integration activates immediately after saving.

5.3 Selecting a Model

OpenAI models:

GPT-4o Mini (Fast and Cheap): A solid choice for everyday admin queries.
GPT-4o (Balanced): Handles more complex questions that involve multiple tables.
GPT-5.5 (Most Capable): The strongest option for detailed analytical work.

Anthropic Claude models:

Claude Haiku 4.5 (Fast and Cheap): Works well for straightforward daily checks.
Claude Sonnet 4.6 (Balanced): Sits between speed and depth for most use cases.
Claude Opus 4.7 (Most Capable): Use this when queries involve several joined tables or layered conditions.

Google Gemini models:

Gemini 3.5 Flash (Fast and Capable): The recommended pick for general store queries.
Gemini 3.1 Flash-Lite (Fastest and Cheapest): Best suited for stores where keeping API costs low is the priority.

5.4 Temperature Setting

This controls how strictly the AI sticks to factual output. At 0, responses are as precise as possible. At 1, there is more variation in how answers are phrased. For store data queries, 0.3 works well as a starting point. Drop to 0.0 if you need the most literal, consistent results.

Click Save Provider Settings to apply.

The Widget Layout tab controls how the chat window looks inside the back office. A live preview panel on the right updates in real time as you adjust each setting.

Position: Where the chat bubble sits on screen. Default is Bottom Right.

Chatbot Name: The label shown in the widget header. Default is Smart Admin Assistant.

Greeting Message: The opening line the assistant shows when the widget is opened. Default reads “Hello! Ask me anything about your store.”

Bubble Icon: A custom image for the floating chat button. Square PNG, 64×64 px, maximum 2 MB.

Chatbot Avatar: The image that appears beside bot messages inside the chat window. Square PNG, 48×48 px, maximum 2 MB.

Widget Width and Height (px): Controls the size of the chat panel. Default is 400 wide by 560 tall.

Colour Settings: Six individual controls for Header, Chat Bubble, User Message, Bot Message, Background, and Text colours. No CSS editing needed.

Click Save Layout to apply.

7.0 Database Views Tab

7.1 What Are Database Views

Database views in PrestaShop are pre-built MySQL structures that join and simplify relevant tables. The PrestaShop AI back office module works through these views rather than querying raw database tables directly, so the AI can give accurate answers without any risk of touching data it should not. Every view is read-only. The assistant can retrieve information but cannot change, remove, or add anything.

Turning off a view removes it from what the assistant can query. The MySQL view itself stays in the database unchanged, so switching it back on works immediately.

7.2 Available Database Views

Orders Overview: Order records including customer details, currency, status, and totals. Provides real-time order data for admins without any report generation.
Order Line Items: Individual product lines within each order, with quantities and prices.
Customers: Customer accounts with group membership, gender, and last visit date.
Products: Product data covering name, stock, price, category, and image information.
Specific Prices / Product Discounts: Price overrides set at the product level. Off by default.
Categories: Category names and the hierarchy they sit in.
Shopping Carts: Both active and abandoned carts, with customer and currency details.
Cart Rules / Coupons: Discount rules with usage data, free shipping flag, and conditions.
Stock Availability: Stock levels per product and combination with readable combination names. Powers PrestaShop stock insights AI queries about low and out-of-stock items.
Employees: Back-office user accounts and profile information.
Customer Addresses: Full address records with country, state, and linked customer names.
Carriers / Shipping Methods: Active delivery carriers. Off by default.
Manufacturers / Brands: Brand records with descriptions and product counts.
Product Combinations / Variants: Variant-level data, including stock, reference, and attribute names.
Product Attributes and Values: Attribute groups such as Colour and Size, with all associated values.

Click Save and Create Views to apply. The module builds the MySQL views for each domain you have switched on.

8.0 Access Control Tab

The Access Control tab controls which back-office users can see and open the PrestaShop Smart Admin Assistant.

Toggle: Enable role-based access by limiting the chatbot to particular employee profiles.

When on, a profile list appears. SuperAdmin always has access and is not listed. Tick the additional profiles: Logistician, Translator, and Salesman. Profiles left unticked cannot see the assistant. Leaving all profiles unticked with role-based access restricts the assistant to SuperAdmin only.

This employee access control feature for PrestaShop makes the PrestaShop Store Management AI capability available only to the staff roles that need it.

Click Save Access Settings to apply.

9.0 Predefined Chips Tab

Predefined chips are quick-click question buttons inside the chat widget. Clicking a chip sends the saved question to the AI instantly, no typing needed.

They are one of the most practical features for PrestaShop Smart Store Analytics, covering the most common store performance questions admins ask every day.

9.1 Default Chips in the PrestaShop Smart AI Admin Assistant

The module ships with ten predefined quick query chips that are active and ready to use from the first login:

Orders Today: How many orders were placed today?
Revenue (30d): What is the total revenue in the last 30 days?
Cancelled Orders: How many orders were cancelled in the last 30 days?
Abandoned Carts: How many abandoned carts are there in the last 30 days?
Active Customers: How many active customers do we have?
Out of Stock: Which active products are currently out of stock?
Low Stock (less than 5): Which products have fewer than 5 units in stock?
No SKU Products: How many products do not have a SKU reference?
Free Shipping Coupons: Are there any active coupons that offer free shipping?
New Customers (This Month): How many customers registered this month?

9.2 Adding a Custom Chip

Click Add Chip to open the edit panel.

Label: The short text that shows on the chip button itself. For example: Weekly Revenue.

Question: The full question that gets sent to the AI when someone clicks the chip. For example: What is the total revenue for the last 7 days?

Position: Sets where this chip sits in the list. Lower numbers come first.

Active: Yes, puts the chip in the widget. No hides it without removing the configuration.

Click Save Chip to confirm. Each existing chip has Edit and Delete buttons on its row for making changes or removing it entirely.

10.0 Query History Tab

The Query History tab keeps a log of every question submitted through the PrestaShop admin AI chatbot, functioning as a complete admin session history log for back-office data requests. Each row shows:

Date: When the question was asked
Employee: The admin account that sent it
Question: The full text of the query
Rows: The number of data rows the answer contained
Time (ms): How long the query took to run, in milliseconds
Provider: Which AI provider processed the query, displayed as a labelled badge
Status: Shown as a green badge for success or a red badge for an error
SQL: The generated SQL is available to view directly in the row

Use the status and date filters at the top of the tab to narrow the list. Export to CSV or Excel with the buttons above the table. Click Purge Old Logs to immediately delete entries older than the Log Retention setting.

11.0 Sessions Tab

The Sessions tab stores complete conversation threads per employee. Each session shows the employee name, start time, and message count. Click View to open the full conversation, questions, and responses displayed chronologically in a pop-up. Useful for auditing how the assistant is being used or picking up context from a previous session.

12.0 Analytics Dashboard

The Analytics Dashboard is also the core feature of the PrestaShop AI Admin Assistant, which is added in the version 1.0.1, giving store owners a single, live screen for revenue, orders, customers, and stock the moment they open their back office. Being as a PrestaShop AI Dashboard Module, it removes the need to dig through order lists or export spreadsheets from the default prestashop just to understand how the store is performing. Here, widgets are grouped into three categories:

Key Metrics: KPI cards covering revenue, order volume, and customer activity
Charts & Trends: visual breakdowns of how sales move over time and across categories
Lists & Tables: ranked views such as top-selling products and low-stock warnings

Each employee can decide which widgets show up on their own dashboard and arrange them however suits their work using the module configuration. You can change the setting from the dashboard settings in the Prestashop Analytics & Reporting Module, like which order states count toward revenue are configured so that numbers stay consistent across the whole team. Together, this makes the module one of the more complete options for PrestaShop AI Backend Analysis, combining reporting, forecasting, and inventory intelligence in one place.

12.1 Analytics Dashboard Settings

You’ll find these controls under Settings → Dashboard Settings. This is the central configuration screen for Knowband Smart AI Admin for PrestaShop, and every option here applies store-wide, across all employee accounts. Individual staff can still adjust their own widget selection and layout from the dashboard’s Customize panel, but the calculations behind the numbers are governed here. Use this section to define how revenue is calculated, which time frame the dashboard opens with by default, its visual theme, and whether it becomes your new back office landing page.

12.2 Dashboard Settings in Smart AI Admin

Revenue Order States

This setting determines which PrestaShop order states are counted as revenue throughout the dashboard, feeding every sales-related widget including Revenue, Orders, Average Order Value, Best Sellers, Top Customers, and Coupon Usage.

Default Period

Sets the time range the dashboard loads with by default. Choose from Last 7 Days, Last 30 Days, Last 3 Months, Last 6 Months, or Last 1 Year.

Colour Theme

Controls the visual styling of the dashboard. Available themes include Indigo (default), Ocean, Emerald, Rose, Dark, and Custom.

List Rows

Sets how many rows appear in each list- or table-based widget across the dashboard, including Best Sellers, Top Customers, Slow Movers, Reorder Suggestions, Churn Risk, Low Stock Alerts, Coupon Usage, and Brand Performance.

Churn Window

Defines the number of days a customer must be inactive before they appear in the Churn Risk widget, one of the module’s dedicated customer retention tools.

Low Stock Threshold

Sets the quantity at or below which a product is classed as “low stock” across the Low Stock, Low Stock Alerts, and Reorder Suggestions widgets. This threshold underpins the dashboard’s Stock Insights AI, the module’s dedicated engine for surfacing inventory risks before they become lost sales.

Replace Default Dashboard

Enable this option to have the Analytics Dashboard take over as your PrestaShop back office home page, opening automatically for every employee immediately after login. When disabled, PrestaShop’s native dashboard remains the default landing screen, and the Analytics Dashboard can still be opened separately from the admin menu whenever it’s needed. This is what makes the module function as a true PrestaShop AI Module Back Office replacement rather than a bolt-on report you have to remember to check.

Customising Your Dashboard

Every employee can rearrange their own dashboard independently, without affecting anyone else’s view.

Click Customise (the widget library icon) on the dashboard. Drag widgets to reorder them within their group (Key Metrics, Charts & Trends, or Lists & Tables). Close the panel to see your updated layout in place. If you’d rather start over, click Restore Default to reset the dashboard to its original configuration.

12.2 Key Metrics (17 widgets)

As a PrestaShop Admin Analytics AI toolkit, the Key Metrics group is where store owners get their fastest daily read on the business, before digging into charts or lists.

Revenue shows total order value for the chosen period and the order states defined in your dashboard settings, paired with a daily trend line and a percentage change against the prior period. This is the module’s built-in PrestaShop AI Sales Report Module output, always visible from the moment you log in.

Orders: Displays the number of orders placed within the selected period, along with a trend line and percentage change, giving you the volume side of the store’s order analytics at a glance.

Avg. Order Value: Calculated as total revenue divided by total orders, this metric gives store owners an immediate pulse check without opening a spreadsheet. If pricing or promotions shift customer spending, it shows up here first.

Items Sold: Total units sold across all orders in the selected period. Useful for tracking sales volume on its own terms, separate from revenue, particularly when running discounts or bundle offers.

Items per Order: Shows the average number of items per order, helping you understand whether customers are typically buying single items or shopping in bulk.

Discounts Given Totals the value of vouchers, cart rules, and reward discounts applied in the selected period, with a percentage change against the previous period so you can track how promotional activity is trending.

Taxes Collected: Reports total tax collected on orders during the selected period, useful when reconciling figures for accounting or compliance.

Shipping Revenue Totals the shipping fees collected from customers over the selected period, with a percentage change shown against the prior period.

Refunded Value Tracks the total value of orders marked as refunded within the selected period, giving visibility into returns and revenue lost to them.

New Customers: Counts customers who created an account during the selected period, pulled directly from registration data. This metric lets store owners see the real-time effect of acquisition campaigns without waiting on a manual export.

Repeat Customers: Counts customers who placed two or more orders within the selected period. This figure feeds directly into the module’s customer retention view, offering a quick read on loyalty without manually cross-checking order histories.

Returning Buyer Rate: The percentage of buyers in the period who ordered more than once, calculated as repeat customers divided by total unique purchasers. It’s a fast way to see whether retention efforts, from email campaigns to loyalty schemes, are actually turning first-time buyers into repeat business.

Total Customers shows the full customer count registered in the store to date, independent of the selected period. As a live snapshot, it always reflects the current total the moment the dashboard loads.

Active Products shows how many products are currently enabled and available for sale on the storefront, giving a quick read on active catalogue size when auditing inventory.

Out of Stock Flags enable products currently sitting at zero quantity, so stockouts are caught immediately rather than discovered after a customer tries to order.

Low Stock Counts enabled products at or below the low-stock threshold set in Analytics Dashboard Settings, acting as an early warning for reordering before a product actually runs out. This is one of the widgets that makes Stock Insights AI genuinely useful day to day, rather than just a static report.

Units in Stock totals the quantity held across every enabled product in the store, giving a single figure for overall stock volume. Best read alongside Low Stock and Out of Stock for a full inventory picture.

12.4 Charts & Trends (Includes 9 widgets)

Revenue Trend plots revenue over time as a line chart, shown daily for periods up to six months and monthly for a full year. It’s a visual companion to the store’s sales figures, making spikes, dips, and seasonal patterns easier to spot than in raw numbers alone.

Revenue Forecast looks at the last 90 days of trading and projects likely revenue for the next 30 days, based on recent momentum rather than the period currently selected. Powered by the same engine behind the module’s PrestaShop AI Backend Analysis, this helps store owners plan stock orders, cash flow, and marketing spend ahead of time, grounded in actual sales data rather than guesswork.

Orders Trend Charts order volume over time using the same daily-or-monthly logic as Revenue Trend, giving a volume-based counterpart to the revenue chart.

Payment Methods: Breaks down revenue by the payment option customers actually chose at checkout. If one method is quietly outperforming the rest, it’s worth understanding why; if another is barely used, that’s often a sign it needs more visibility or trust-building at checkout.

Sales by Country: A straightforward bar chart of revenue by shipping destination, and a genuinely useful one for spotting where a store’s real geographic strength lies, especially when weighing up new shipping zones or ad spend.

Order Status: Lists every active order state with its revenue and order count side by side, making it easy to see at a glance where orders currently stand, whether still processing, stuck pending, or already delivered.

Sales by Carrier Breaks revenue down by shipping carrier, so you can see which ones your customers actually choose. Worth reviewing periodically, especially when renegotiating rates or deciding whether a new carrier is worth adding.

Sales by Day of Week Groups total revenue by weekday across the whole selected period, not just the past week. Patterns often surface here that aren’t obvious day to day, such as a Thursday that consistently outsells the rest, useful when planning promotions or staffing.

Sales by Hour Shows exactly when customers are most likely to buy, which takes the guesswork out of timing flash sales, email sends, or live chat support.

12.4 Lists & Tables (8 widgets)

Best Sellers ranks products by units sold, showing reference, quantity, and revenue side by side. A quick way to see exactly which products are carrying the business.

Slow Movers Lists active products with the fewest sales in the selected period, helping store owners identify stock that needs a promotional push, a price adjustment, or removal from the catalogue.

Top Customers ranks customers by total revenue alongside order count, giving a clear view of who to prioritise for loyalty perks, personal outreach, or dedicated account management.

Churn Risk Flags high-value customers who haven’t ordered within the configured Churn Window, along with their lifetime value and last order date. This is the core of the module’s retention toolkit, helping store owners re-engage customers before they’re gone for good.

Low Stock Alerts: Lists every product at or below the configured stock threshold, or already out of stock, with reference and quantity, giving an early warning before a bestseller disappears from the shelf.

Reorder Suggestions: Calculates suggested reorder quantities for products sold in the last 30 days, based on current stock, average daily units sold, and remaining days of stock cover. Store owners can use this to restock the right amount, avoiding both overstocking and stockouts.

Coupon Usage shows every voucher redeemed during the selected period, along with number of uses and total discount value, making it easy to see which promotions are actually driving orders versus which ones are just cutting into margin.

Brand Performance Ranks manufacturers by revenue and units sold, rounding out the dashboard’s view of what’s actually driving the store, down to the brand level.

13.0 Frequently Asked Questions

Q: What is the PrestaShop Smart AI Admin Assistant, and how does it work?

The PrestaShop Smart AI Admin Assistant by Knowband lets store admins ask plain-language questions about their store data and receive instant answers. It connects to the live database through pre-built read-only MySQL views, sends the question to the chosen AI provider: OpenAI, Anthropic Claude, or Google Gemini, which generates and runs a SQL query and returns the result in natural language. It brings real-time data access to any back office user without requiring technical knowledge.

Q: Which AI providers does the PrestaShop Smart Admin Assistant support?

The module supports OpenAI (GPT-4o Mini, GPT-4o, GPT-5.5), Anthropic Claude (Haiku 4.5, Sonnet 4.6, Opus 4.7), and Google Gemini (Gemini 3.5 Flash, Gemini 3.1 Flash-Lite). You supply your own API key, and the module connects directly. No subscription to the module’s own AI service is needed. You pay only for actual API usage. All models integrate with the PrestaShop AI Sales Analytics Addon to deliver accurate, fast answers from your live store data.

Q: Can the PrestaShop Smart Admin Assistant modify or delete store data?

No. The assistant accesses the database through pre-built MySQL views, read-only by design. It cannot update, delete or insert any data through the chat interface. Every answer is a read-only retrieval from your live PrestaShop store. It is therefore a safe tool for back office automation without any risk of storing data.

Q: What can I ask the PrestaShop Admin AI Module?

You can ask natural language queries about orders, customers, revenue, stock levels, abandoned carts, discount coupons, product combinations, employee accounts, shipping carriers, brands, and categories. The experience is similar to asking ChatGPT, but every answer comes directly from your live store data. This covers order management, inventory tracking, and no SQL store reporting, all from the back office.

Q: How do predefined chips work in the PrestaShop Smart Admin Assistant?

Predefined chips are quick-click buttons inside the chat widget of the PrestaShop admin AI chatbot. Each chip sends a pre-saved question to the AI when tapped. The default set covers orders today, revenue, abandoned carts, low stock, out-of-stock products, active customers, new customers, cancelled orders, free shipping coupons, and products missing a SKU. Custom chips can be added, edited, or removed from the Predefined Chips tab. This is one of the most useful features of the PrestaShop AI Reporting Module for running daily store checks.

Q: What does the SQL visibility feature of the PrestaShop admin AI chatbot do?

When Show SQL Query Toggle is enabled, the assistant displays the SQL it generated beneath each answer. With Allow SQL Edit and Re-run also on, the admin can modify that SQL in the chat, adjusting a date, threshold, or filter, and re-run it immediately. It effectively turns the PrestaShop AI Sales Analytics Addon into a SQL-free reporting tool that any team member can work with directly. This is especially useful for PrestaShop AI backend analysis without requiring a developer.

Q: How does role-based access control work?

Open the Access Control tab and switch on Restrict the chatbot to specific employee profiles. SuperAdmin always has full access and does not appear in the list. From there, tick any additional profiles you want to include, such as Logistician, Salesman, or Translator. Any profile left unticked will not see the assistant in their back office.

Q: What is the schema cache, and when should I refresh it?

The schema cache in the PrestaShop Smart Insight Module holds a structural map of your database so the AI knows which tables and columns to use when building queries. It generates automatically during the first chat session and updates on the interval set in Schema Cache TTL (24 hours by default). After installing a new module, upgrading PrestaShop, or making any change that affects the database structure, use Refresh Schema Now to pull a fresh copy straight away.

Q: How can I get an API key to work with the PrestaShop Admin AI Module?

OpenAI: go to platform.openai.com, open API Keys from your profile menu and create a new key. Anthropic Claude: go to console.anthropic.com, open API Keys from the sidebar and create one. Google Gemini: go to aistudio.google.com, press Get API key and create one from there. After you have the key, copy it into the appropriate field in the AI Provider tab and save.

Q: Is the PrestaShop Smart Admin Assistant compatible with PrestaShop 9?

Yes. The module runs on PrestaShop 1.7.x through 9.x. The product page has the latest compatibility information.

Q: How does the PrestaShop AI Reporting Module help with sales reporting in PrestaShop?

PrestaShop AI sales report module lets the admin get the revenue, orders and conversion data through a simple chat interface instead of running reports manually. For teams looking for the best PrestaShop admin AI tool to replace dashboards, this module has daily reporting, stock checks and customer data all in one place.

13.0 Conclusion

The Knowband PrestaShop Smart AI Admin Assistant brings AI-powered PrestaShop back office analytics to any store without requiring SQL knowledge, developer access, or third-party solutions. Ask in plain English, get answers from live store data, see the SQL behind every result, and configure the PrestaShop Admin Analytics AI Addon in minutes.

Predefined chips turn the daily store check into a one-minute task. Role-based access keeps the right data in front of the right staff. Query History keeps a complete audit trail of everything asked.

For support, custom requirements, or add-on development, contact the Knowband team directly.

Get the Knowband PrestaShop Smart Admin Assistant and start querying your store data from day one.