AI-powered natural language queries: No SQL knowledge required.<\/span><\/span><\/b><\/h2>\nWrite a question in simple language, and the wizard will return the answer based on your store’s real-time data in a matter of seconds. What truly makes it useful, beyond its convenience, is the “Show SQL Query” feature. When activated, the wizard displays the exact SQL query it generated to produce the answer. A second option, “Allow SQL Editing and Re-execution,” allows the administrator to modify the query and run a revised version without having to write SQL from scratch.<\/span><\/span><\/span><\/p>\nPreviously, data requests involving multiple tables or custom filters remained on the developers’ to-do list. Now, any administrator can handle it without technical expertise.<\/span><\/span><\/span><\/p>\nExample: <\/span><\/span><\/b>An administrator wants to find customers who have placed at least three orders but haven’t placed any in the last 90 days for a customer recovery campaign. They write: “Show me the customers who have placed at least 3 orders but haven’t placed any in the last 90 days.”<\/span><\/span><\/span><\/p>\nThe PrestaShop Smart Admin Assistant generates and executes this query:<\/span><\/span><\/b><\/p>\nSELECT<\/span><\/span><\/span><\/p>\nc.id_cliente, c.nombre, c.apellido, c.correo electr\u00f3nico,<\/span><\/span><\/span><\/p>\nCOUNT(o.id_order) AS total_orders,<\/span><\/span><\/span><\/p>\nMAX(o.date_add) AS last_order_date<\/span><\/span><\/span><\/p>\nFROM ps_customer c<\/span><\/span><\/span><\/p>\nJOIN ps_orders o INTO c.id_customer = o.id_customer<\/span><\/span><\/span><\/p>\nGROUP BY c.id_cliente<\/span><\/span><\/span><\/p>\nHAVING<\/span><\/span><\/span><\/p>\nCOUNT(o.id_order) >= 3<\/span><\/span><\/span><\/p>\nAND MAX(o.date_add) < DATE_SUB(NOW(), INTERVAL 90 DAY)<\/span><\/span><\/span><\/p>\nSORT BY last_order_date ASC;<\/span><\/span><\/span><\/p>\nThe result is a table with the customer’s name, email address, total orders placed, and the date of their last order. All inactive repeat customers are displayed in a single view. <\/span><\/span>The administrator then adds a spend filter to focus first on the highest-value customers.<\/span><\/span><\/strong><\/span><\/p>\nHAVING<\/span><\/span><\/span><\/p>\nCOUNT(o.id_order) >= 3<\/span><\/span><\/span><\/p>\nAND MAX(o.date_add) < DATE_SUB(NOW(), INTERVAL 90 DAY)<\/span><\/span><\/span><\/p>\nAND SUM(o.total_paid) > 200\u00a0 <\/span><\/span>– The administrator adds this line<\/span><\/span><\/strong><\/span><\/p>\nSORT BY last_order_date ASC;<\/span><\/span><\/span><\/p>\nRepeat. Now only customers who spent more than \u20ac200 appear. Export from query history. Retrieved customer list ready. No developers, no phpMyAdmin, no waiting.<\/span><\/span><\/span><\/p>\nDatabase views: Manage and restrict AI access to stored data.<\/span><\/span><\/h2>\n![\"The](\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2026\/05\/Database-Views_-Control-Exactly-What-the-AI-Can-Access.png\")
<\/a><\/p>\nThe Database Views tab allows the administrator to choose which data domains the wizard can query. Available views include Orders, Customers, Products, Stock Availability, Shopping Carts, Cart Rules, Employees, Carriers, Product Combinations, and more.<\/span><\/span><\/span><\/p>\nEach view is a predefined MySQL view, rather than a direct query to the table. This ensures security in two ways: AI cannot modify any data, as the views are read-only; and, since joins are already built into each view, the answers are more accurate than if the tables were queried directly.<\/span><\/span><\/span><\/p>\nIf a view is disabled, the AI-powered admin assistant will not be able to access that data, regardless of the query. This is where PrestaShop admin panel analytics becomes truly controllable, as the administrator sets the limits, not the tool.<\/span><\/span><\/span><\/p>\nExample: <\/span><\/span><\/b>A store owner wants the logistics team to use the PrestaShop Smart Admin Assistant for stock and order queries, but not for customer personal data or employee records. Orders, stock availability, and products are retained. Customers, employees, and customer addresses are deactivated. The logistics team can only access the information they need for their role.<\/span><\/span><\/span><\/p>\nRole-based access control: The right data for the right people.<\/span><\/span><\/b><\/h2>\nThe Access Control tab allows the store owner to select which employee profiles can use the PrestaShop Smart Admin Wizard. Selecting a profile grants that profile access. If not all profiles are selected, access is granted to everyone. If only the profiles that should have access are selected, others will not see anything when they log in.<\/span><\/span><\/span><\/p>\nEjemplo:<\/b> Una tienda con seis cuentas de administrador quiere que solo el Superadministrador y el equipo de ventas utilicen el asistente. El propietario de la tienda marca esos dos perfiles y deja los dem\u00e1s sin marcar. El traductor y el personal de log\u00edstica inician sesi\u00f3n y el asistente no est\u00e1 visible para ellos. No se han realizado cambios en el c\u00f3digo ni en el tema.<\/span><\/p>\nChips predefinidos: Monitoreo diario de la tienda con un solo clic.<\/b><\/h2>\n
Los botones predefinidos son botones de preguntas que se pueden pulsar dentro del widget de chat. Una consulta predefinida se ejecuta al instante con un solo clic, eliminando la necesidad de introducir datos manualmente.<\/span><\/p>\nEl conjunto predeterminado cubre las comprobaciones diarias m\u00e1s comunes: Pedidos de hoy, Ingresos de los \u00faltimos 30 d\u00edas, Carritos abandonados, Stock bajo, Sin stock, Clientes activos, Clientes nuevos este mes, Pedidos cancelados, Cupones de env\u00edo gratuito y Productos sin SKU. Cada chip es editable, se puede reordenar y se puede activar o desactivar individualmente.<\/span><\/p>\nPara las tiendas que realizan las mismas comprobaciones cada ma\u00f1ana, esto por s\u00ed solo supone un ahorro de tiempo considerable. La revisi\u00f3n diaria, que antes implicaba abrir seis p\u00e1ginas diferentes, ahora se gestiona completamente a trav\u00e9s de las herramientas de an\u00e1lisis del panel de administraci\u00f3n de PrestaShop en un \u00fanico widget, en menos de un minuto.<\/span><\/p>\nEjemplo:<\/b> Cada ma\u00f1ana, el gerente de la tienda revisa cuatro cosas: los pedidos del d\u00eda, los ingresos del mes, los productos con menos de cinco unidades en stock y los carritos abandonados de las \u00faltimas 24 horas. Las cuatro son fichas. La revisi\u00f3n completa se realiza en minutos.<\/span><\/p>\nSelecci\u00f3n flexible de proveedores de IA: elija OpenAI, Claude o Gemini.<\/b><\/h2>\n
La pesta\u00f1a Proveedor de IA permite al administrador elegir entre OpenAI, Anthropic Claude y Google Gemini. Cada uno requiere la clave API del administrador y la selecci\u00f3n de un modelo de entre los niveles disponibles del proveedor.<\/span><\/p>\nPara Claude, las opciones son Haiku 4.5 para consultas r\u00e1pidas cotidianas, Sonnet 4.6 para un equilibrio entre velocidad y profundidad, y Opus 4.6 para tareas complejas con m\u00faltiples tablas. OpenAI y Gemini siguen la misma estructura escalonada. Pagar solo por el uso real, sin intermediarios, mantiene los costos operativos predecibles independientemente del tama\u00f1o de la tienda. Esto es lo que hace que el m\u00f3dulo de IA de administraci\u00f3n de PrestaShop sea realmente accesible para las tiendas que no pueden comprometerse con una suscripci\u00f3n mensual fija de IA.<\/span><\/p>\nEjemplo:<\/b> Las grandes tiendas pueden usar Haiku 4.5 para consultas rutinarias basadas en chips y as\u00ed mantener bajos los costos operativos. Cuando el gerente de operaciones necesita un desglose mensual detallado de varias tablas unidas, cambia a Sonnet 4.6 para esa sesi\u00f3n y luego vuelve a la versi\u00f3n anterior.<\/span><\/p>\nEntrada de voz, personalizaci\u00f3n de widgets y soporte multiling\u00fce.<\/b><\/h2>\n
Three functions cover the rest of the daily usability of the PrestaShop Smart Store Management plugin.<\/span><\/span><\/span><\/p>\nWidget Layout centralizes all visual settings: position, chatbot name, welcome message, avatar, width, height, and more. Changes are instantly reflected in a live preview on the right. No CSS is used at any point.<\/span><\/span><\/span><\/p>\nVoice input allows administrators to ask questions aloud instead of typing them. The browser’s built-in speech recognition API handles the transcription. For administrators who are on the go, work with mobile devices, or simply prefer speaking to typing, this eliminates any obstacles to getting a quick response.<\/span><\/span><\/span><\/p>\nThe chatbot language allows the administrator to control the language in which the PrestaShop admin AI module responds. If set to “Back-office language,” the response is based on the admin panel language. If set to “Custom language,” the administrator can choose the language independently, which is important for multilingual teams where the back-office language and each employee’s working language differ.<\/span><\/span><\/span><\/p>\nExample: <\/span><\/span><\/b>A French-speaking operations manager works in an administrative office set to English to maintain consistency across the team. The custom language is set to French. The manager asks a question using voice input and receives the answer in French. The administrative office settings have not been changed.<\/span><\/span><\/span><\/p>\nQuery history and session logs: a complete audit trail<\/span><\/span><\/b><\/h2>\nEach question submitted through the wizard is saved in the Query History tab as a permanent record. The record includes the date, employee, question, number of rows returned, response time in milliseconds, the AI \u200b\u200bprovider that executed it, the status, and the complete SQL query that was executed.<\/span><\/span><\/span><\/p>\nLogs are filtered by date and status and can be exported to CSV or Excel. A retention setting automatically deletes entries older than a specified number of days, keeping the log table optimized without manual cleanup. The Sessions tab saves complete conversation threads for each employee, allowing anyone to review past exchanges or audit how the team uses the tool.<\/span><\/span><\/span><\/p>\nExample: <\/span><\/span><\/b>A store owner receives a suspicious response during Monday morning’s check. He opens the query history, finds the exact query that was executed, reads the SQL code, and discovers that a database view was serving cached data. He clicks “Update Schema Now,” rebuilds the schema, and re-runs the query with the correct result.<\/span><\/span><\/span><\/p>\nHow the intelligent administrative assistant Knowband improves store operations<\/span><\/span><\/b><\/h2>\nEach feature covered here fills a gap that previously required a developer or a report that took too long to generate. The <\/span><\/span><\/span>PrestaShop Smart Store Management AI module<\/span><\/span><\/span><\/a> preserves data depth, SQL continues to function, data remains up-to-date, and controls remain accurate, but the module removes the technical barrier between the administrator and the information they need. For store owners who spend more time analyzing data than running the business, the PrestaShop Smart Store Management plugin is the best practical solution.<\/span><\/span><\/span><\/p>\nThe Knowband PrestaShop Smart Admin Assistant is <\/span><\/span>launching next week.<\/span><\/span><\/strong> Stay tuned for more information about the module and what it can do within your admin panel.<\/span><\/span><\/span><\/p>\n\ud83d\udc49 Explora el m\u00f3dulo con nuestra gu\u00eda en v\u00eddeo<\/b><\/h2>\n
Previously, data requests involving multiple tables or custom filters remained on the developers’ to-do list. Now, any administrator can handle it without technical expertise.<\/span><\/span><\/span><\/p>\n Example: <\/span><\/span><\/b>An administrator wants to find customers who have placed at least three orders but haven’t placed any in the last 90 days for a customer recovery campaign. They write: “Show me the customers who have placed at least 3 orders but haven’t placed any in the last 90 days.”<\/span><\/span><\/span><\/p>\n The PrestaShop Smart Admin Assistant generates and executes this query:<\/span><\/span><\/b><\/p>\n SELECT<\/span><\/span><\/span><\/p>\n c.id_cliente, c.nombre, c.apellido, c.correo electr\u00f3nico,<\/span><\/span><\/span><\/p>\n COUNT(o.id_order) AS total_orders,<\/span><\/span><\/span><\/p>\n MAX(o.date_add) AS last_order_date<\/span><\/span><\/span><\/p>\n FROM ps_customer c<\/span><\/span><\/span><\/p>\n JOIN ps_orders o INTO c.id_customer = o.id_customer<\/span><\/span><\/span><\/p>\n GROUP BY c.id_cliente<\/span><\/span><\/span><\/p>\n HAVING<\/span><\/span><\/span><\/p>\n COUNT(o.id_order) >= 3<\/span><\/span><\/span><\/p>\n AND MAX(o.date_add) < DATE_SUB(NOW(), INTERVAL 90 DAY)<\/span><\/span><\/span><\/p>\n SORT BY last_order_date ASC;<\/span><\/span><\/span><\/p>\n The result is a table with the customer’s name, email address, total orders placed, and the date of their last order. All inactive repeat customers are displayed in a single view. <\/span><\/span>The administrator then adds a spend filter to focus first on the highest-value customers.<\/span><\/span><\/strong><\/span><\/p>\n HAVING<\/span><\/span><\/span><\/p>\n COUNT(o.id_order) >= 3<\/span><\/span><\/span><\/p>\n AND MAX(o.date_add) < DATE_SUB(NOW(), INTERVAL 90 DAY)<\/span><\/span><\/span><\/p>\n AND SUM(o.total_paid) > 200\u00a0 <\/span><\/span>– The administrator adds this line<\/span><\/span><\/strong><\/span><\/p>\n SORT BY last_order_date ASC;<\/span><\/span><\/span><\/p>\n Repeat. Now only customers who spent more than \u20ac200 appear. Export from query history. Retrieved customer list ready. No developers, no phpMyAdmin, no waiting.<\/span><\/span><\/span><\/p>\n The Database Views tab allows the administrator to choose which data domains the wizard can query. Available views include Orders, Customers, Products, Stock Availability, Shopping Carts, Cart Rules, Employees, Carriers, Product Combinations, and more.<\/span><\/span><\/span><\/p>\n Each view is a predefined MySQL view, rather than a direct query to the table. This ensures security in two ways: AI cannot modify any data, as the views are read-only; and, since joins are already built into each view, the answers are more accurate than if the tables were queried directly.<\/span><\/span><\/span><\/p>\n If a view is disabled, the AI-powered admin assistant will not be able to access that data, regardless of the query. This is where PrestaShop admin panel analytics becomes truly controllable, as the administrator sets the limits, not the tool.<\/span><\/span><\/span><\/p>\n Example: <\/span><\/span><\/b>A store owner wants the logistics team to use the PrestaShop Smart Admin Assistant for stock and order queries, but not for customer personal data or employee records. Orders, stock availability, and products are retained. Customers, employees, and customer addresses are deactivated. The logistics team can only access the information they need for their role.<\/span><\/span><\/span><\/p>\n The Access Control tab allows the store owner to select which employee profiles can use the PrestaShop Smart Admin Wizard. Selecting a profile grants that profile access. If not all profiles are selected, access is granted to everyone. If only the profiles that should have access are selected, others will not see anything when they log in.<\/span><\/span><\/span><\/p>\n Ejemplo:<\/b> Una tienda con seis cuentas de administrador quiere que solo el Superadministrador y el equipo de ventas utilicen el asistente. El propietario de la tienda marca esos dos perfiles y deja los dem\u00e1s sin marcar. El traductor y el personal de log\u00edstica inician sesi\u00f3n y el asistente no est\u00e1 visible para ellos. No se han realizado cambios en el c\u00f3digo ni en el tema.<\/span><\/p>\n Los botones predefinidos son botones de preguntas que se pueden pulsar dentro del widget de chat. Una consulta predefinida se ejecuta al instante con un solo clic, eliminando la necesidad de introducir datos manualmente.<\/span><\/p>\n El conjunto predeterminado cubre las comprobaciones diarias m\u00e1s comunes: Pedidos de hoy, Ingresos de los \u00faltimos 30 d\u00edas, Carritos abandonados, Stock bajo, Sin stock, Clientes activos, Clientes nuevos este mes, Pedidos cancelados, Cupones de env\u00edo gratuito y Productos sin SKU. Cada chip es editable, se puede reordenar y se puede activar o desactivar individualmente.<\/span><\/p>\n Para las tiendas que realizan las mismas comprobaciones cada ma\u00f1ana, esto por s\u00ed solo supone un ahorro de tiempo considerable. La revisi\u00f3n diaria, que antes implicaba abrir seis p\u00e1ginas diferentes, ahora se gestiona completamente a trav\u00e9s de las herramientas de an\u00e1lisis del panel de administraci\u00f3n de PrestaShop en un \u00fanico widget, en menos de un minuto.<\/span><\/p>\n Ejemplo:<\/b> Cada ma\u00f1ana, el gerente de la tienda revisa cuatro cosas: los pedidos del d\u00eda, los ingresos del mes, los productos con menos de cinco unidades en stock y los carritos abandonados de las \u00faltimas 24 horas. Las cuatro son fichas. La revisi\u00f3n completa se realiza en minutos.<\/span><\/p>\n La pesta\u00f1a Proveedor de IA permite al administrador elegir entre OpenAI, Anthropic Claude y Google Gemini. Cada uno requiere la clave API del administrador y la selecci\u00f3n de un modelo de entre los niveles disponibles del proveedor.<\/span><\/p>\n Para Claude, las opciones son Haiku 4.5 para consultas r\u00e1pidas cotidianas, Sonnet 4.6 para un equilibrio entre velocidad y profundidad, y Opus 4.6 para tareas complejas con m\u00faltiples tablas. OpenAI y Gemini siguen la misma estructura escalonada. Pagar solo por el uso real, sin intermediarios, mantiene los costos operativos predecibles independientemente del tama\u00f1o de la tienda. Esto es lo que hace que el m\u00f3dulo de IA de administraci\u00f3n de PrestaShop sea realmente accesible para las tiendas que no pueden comprometerse con una suscripci\u00f3n mensual fija de IA.<\/span><\/p>\n Ejemplo:<\/b> Las grandes tiendas pueden usar Haiku 4.5 para consultas rutinarias basadas en chips y as\u00ed mantener bajos los costos operativos. Cuando el gerente de operaciones necesita un desglose mensual detallado de varias tablas unidas, cambia a Sonnet 4.6 para esa sesi\u00f3n y luego vuelve a la versi\u00f3n anterior.<\/span><\/p>\n Three functions cover the rest of the daily usability of the PrestaShop Smart Store Management plugin.<\/span><\/span><\/span><\/p>\n Widget Layout centralizes all visual settings: position, chatbot name, welcome message, avatar, width, height, and more. Changes are instantly reflected in a live preview on the right. No CSS is used at any point.<\/span><\/span><\/span><\/p>\n Voice input allows administrators to ask questions aloud instead of typing them. The browser’s built-in speech recognition API handles the transcription. For administrators who are on the go, work with mobile devices, or simply prefer speaking to typing, this eliminates any obstacles to getting a quick response.<\/span><\/span><\/span><\/p>\n The chatbot language allows the administrator to control the language in which the PrestaShop admin AI module responds. If set to “Back-office language,” the response is based on the admin panel language. If set to “Custom language,” the administrator can choose the language independently, which is important for multilingual teams where the back-office language and each employee’s working language differ.<\/span><\/span><\/span><\/p>\n Example: <\/span><\/span><\/b>A French-speaking operations manager works in an administrative office set to English to maintain consistency across the team. The custom language is set to French. The manager asks a question using voice input and receives the answer in French. The administrative office settings have not been changed.<\/span><\/span><\/span><\/p>\n Each question submitted through the wizard is saved in the Query History tab as a permanent record. The record includes the date, employee, question, number of rows returned, response time in milliseconds, the AI \u200b\u200bprovider that executed it, the status, and the complete SQL query that was executed.<\/span><\/span><\/span><\/p>\n Logs are filtered by date and status and can be exported to CSV or Excel. A retention setting automatically deletes entries older than a specified number of days, keeping the log table optimized without manual cleanup. The Sessions tab saves complete conversation threads for each employee, allowing anyone to review past exchanges or audit how the team uses the tool.<\/span><\/span><\/span><\/p>\n Example: <\/span><\/span><\/b>A store owner receives a suspicious response during Monday morning’s check. He opens the query history, finds the exact query that was executed, reads the SQL code, and discovers that a database view was serving cached data. He clicks “Update Schema Now,” rebuilds the schema, and re-runs the query with the correct result.<\/span><\/span><\/span><\/p>\n Each feature covered here fills a gap that previously required a developer or a report that took too long to generate. The <\/span><\/span><\/span>PrestaShop Smart Store Management AI module<\/span><\/span><\/span><\/a> preserves data depth, SQL continues to function, data remains up-to-date, and controls remain accurate, but the module removes the technical barrier between the administrator and the information they need. For store owners who spend more time analyzing data than running the business, the PrestaShop Smart Store Management plugin is the best practical solution.<\/span><\/span><\/span><\/p>\n The Knowband PrestaShop Smart Admin Assistant is <\/span><\/span>launching next week.<\/span><\/span><\/strong> Stay tuned for more information about the module and what it can do within your admin panel.<\/span><\/span><\/span><\/p>\nDatabase views: Manage and restrict AI access to stored data.<\/span><\/span><\/h2>\n
<\/a><\/p>\nRole-based access control: The right data for the right people.<\/span><\/span><\/b><\/h2>\n
Chips predefinidos: Monitoreo diario de la tienda con un solo clic.<\/b><\/h2>\n
Selecci\u00f3n flexible de proveedores de IA: elija OpenAI, Claude o Gemini.<\/b><\/h2>\n
Entrada de voz, personalizaci\u00f3n de widgets y soporte multiling\u00fce.<\/b><\/h2>\n
Query history and session logs: a complete audit trail<\/span><\/span><\/b><\/h2>\n
How the intelligent administrative assistant Knowband improves store operations<\/span><\/span><\/b><\/h2>\n
\ud83d\udc49 Explora el m\u00f3dulo con nuestra gu\u00eda en v\u00eddeo<\/b><\/h2>\n