Author: Olivia Smith

Olivia ist eCommerce-Technikberaterin bei Knowband und unterstützt Händler dabei, das Beste aus Plattformen wie PrestaShop, Shopify, Magento, WooCommerce und OpenCart herauszuholen. Ihre Beiträge reichen von der Plugin-Einrichtung über die Shop-Anpassung bis hin zu Performance und Fehlerbehebung – immer mit dem Ziel, Shopbetreibern praktisches, direkt umsetzbares technisches Wissen zu vermitteln. Bei Knowband sind wir Experten der eCommerce-Branche mit Schwerpunkt auf der Entwicklung von Plugins. Mit langjähriger Erfahrung bieten wir die besten Plugins für Plattformen wie Magento, PrestaShop, OpenCart und Shopify. Zudem entwickeln und passen wir Module individuell für Websites und Onlineshops an. Unser Team bleibt stets auf dem neuesten Stand der Branchentrends und liefert innovative Lösungen zur Verbesserung der Funktionalität von eCommerce-Websites. Mit einem kundenorientierten Ansatz ist Knowband ein vertrauenswürdiger Partner für eCommerce-Plugin-Lösungen.

OpenCart Smart AI Admin Assistant Extention User Manual

1.0 Introduction

Every OpenCart store generates data every hour, orders arriving, stock moving, customers registering, carts being left behind, and revenue numbers shifting. All of it sits in the database. Getting to any specific figure means navigating to the right admin section, picking a date range, loading the report, and repeating the whole thing the next day.

The Knowband OpenCart Smart AI Admin Assistant removes that entirely. It places an AI chat interface inside your OpenCart admin panel. Type any store question in plain English and get a direct answer pulled from your live database in seconds. No SQL. No report pages. No developer in the loop.

This guide walks through every tab and setting so you can connect your AI provider, configure the assistant, and start querying your store data from day one. Compatible with OpenCart 3.x.

[Updated July 2, 2026] Analytics Dashboard Integration
Get a real-time view of your store’s performance right from the admin panel, revenue, orders, customers, and stock, all in one screen using the dashboard. Store owners can track trends, forecast revenue, spot slow-moving stock, and catch at-risk customers before they leave, with 34 customizable widgets you can arrange however works best for you.

1.1 Who Should Use This OpenCart AI Admin Chatbot

This admin assistant is built for:

  • Store owners who run the same data checks every morning need a faster way to get there.
  • Operations staff who want live answers on orders, stock levels, and revenue without loading report pages.
  • Multi-admin stores where different team members need different levels of access to store data.
  • Any merchant who wants OpenCart back office analytics powered by AI without relying on a developer.

2.0 Installation Guide

System Requirements

Before installing, confirm your setup meets the following:

  • OpenCart 3.x
  • PHP 7.2 or higher
  • An active API key from OpenAI (ChatGPT), Anthropic (Claude), or Google (Gemini)

Installing the Extension

Step 1: Download the extension ZIP file from your account. Log in to your OpenCart admin panel.

Step 2: Go to Extensions, then Installer. Click the Upload button, select the ZIP file from your system, and click Open. OpenCart processes the upload and extraction on its own.

Step 3: Once the upload confirms, navigate to Extensions, then Extensions. Choose Modules from the category dropdown. Locate the module in the list and click the green Install button next to it.

Step 4: After installation completes, click the Edit button to open the configuration panel for the first time.

Step 5: If the extension does not show up in the list after installation, go to the Dashboard, click the blue cog icon at the top right, and select Refresh to rebuild the cache.

Common Installation Issues

Upload fails: File size exceeds the server limit. Ask your host to raise upload_max_filesize and post_max_size in PHP settings to at least 32 MB, then try uploading again.

Extension not visible after install: Head to the Dashboard and use the cog icon to clear the OpenCart cache. Then return to Extensions, then Modules and search again.

Configuration screen looks broken: Clear your browser cache with a hard reload and reset the OpenCart theme cache from the Dashboard cog menu.

3.0 Admin Panel Overview

The Knowband OpenCart Smart AI Admin Assistant has eight tabs across the top of the configuration screen:

  • Settings: Core preferences, SQL visibility toggles, voice input, language, log retention, schema cache.
  • AI Provider: Connect OpenAI ChatGPT, Anthropic Claude, or Google Gemini using your own API key.
  • Widget Layout: Adjust how the chat widget looks inside the admin with a live preview on the right.
  • Database Views: Choose which store data domains the AI is allowed to query.
  • Access Control: Decide which employee profiles can open and use the assistant.
  • Predefined Chips: One-tap question shortcuts for daily store data checks.
  • Query History: A running log of every question asked with employee name, response time, and status.
  • Sessions: Full conversation threads per employee, viewable any time.

4.0 Settings Tab

4.1 General Settings for the OpenCart Smart AI Admin Assistant

Enable Chatbot: The main on/off control for this back office assistant. Turning it off removes the chat widget from the admin panel completely without deleting any saved configuration or query history.

Enable Predefined Chips: Shows or hides the one-tap question buttons inside the chat widget. The chips appear as an expandable panel that any admin can open or close.

Chips Default State: Sets whether the chips panel is open or closed when the widget first loads. Collapsed keeps it tucked away until the admin opens it. Expanded shows the chips panel straight away.

Max Result Rows: The upper limit on how many data rows the AI returns for a single query. Range is 1 to 1000, default is 100. Push it higher for queries that need full datasets and keep it at 100 or below for quick daily checks.

Show SQL Query Toggle: Set to Yes, and the SQL query used to produce each answer appears in the chat below the result. Any admin can read exactly how the data was fetched without asking a developer.

Allow SQL Edit and Re-run: Set to Yes, and the SQL shown under an answer becomes editable in the chat. Change a date range, swap a product category, or shift a threshold and run it again without typing a new question from scratch.

Voice Input: Turns on the microphone icon in the chat input. Speak a question and the browser converts it to text via the Web Speech API. Functions best in Chrome on desktop.

4.2 Language Settings

Use Back-office Language: The assistant replies in whatever language the OpenCart admin panel is currently running. Switch the back office to French, and responses come back in French automatically.

Use Custom Language: Lock the response language to a specific choice regardless of what the admin panel is set to. Useful where staff work in a different language from the back office default.

4.3 Log and Cache Settings

Log Retention (days): The number of days query history stays in the system before old entries are deleted automatically. Default is 90 days. No manual cleanup is needed; the purge runs on its own.

Schema Cache TTL (minutes): The period the extension holds the cached database schema before refreshing it. Default is 1440 minutes. The schema is a map of the store database structure that the AI relies on to build accurate queries. The Settings page displays the last cached timestamp and the next expiry, so the status is always clear.

Refresh Schema Now: Rebuilds the schema cache on demand without waiting for the TTL cycle. Use this after adding a new extension, upgrading OpenCart, or making any structural change to the database.

Click Save Settings to apply all changes on this tab.

5.0 AI Provider Tab

5.1 Choosing Your Provider

The AI Provider tab connects to an external AI model using your chosen provider. OpenAI (ChatGPT), Anthropic Claude, and Google Gemini are all supported. You bring your own API key, and it connects directly, no third-party relay, no separate subscription needed.

Click any provider button to load its settings below: the API key input, the model selector, and the temperature control. One provider is active at a time. Switching providers does not affect existing query history or configuration.

5.2 How to Get Your API Key

OpenAI

  1. Visit platform.openai.com and log in or register.
  2. Open the API Keys section from the account icon menu.
  3. Hit Create new secret key, give it a label, and save.
  4. Copy the key before leaving the page. OpenAI does not show it again. Paste it into the OpenAI API Key field.

Anthropic Claude

  1. Visit console.anthropic.com and log in or register.
  2. Go to API Keys in the left navigation.
  3. Click Create Key, name it, and copy it.
  4. Paste into the Claude API Key field. A direct link to the Anthropic console is also available in the module.

Google Gemini

  1. Visit aistudio.google.com and log in with a Google account.
  2. Click Get API key from the top left.
  3. Pick a project and generate the key.
  4. Copy and paste it into the Gemini API Key field.

5.3 Model Selection for the OpenCart Back Office Analytics Extension

OpenAI:

  • GPT-4o Mini, quick turnaround, lower API cost, suited to routine daily admin questions.
  • GPT-4o, stronger reasoning for queries that span multiple joined tables.
  • GPT-5.5, the most capable tier for complex or layered analytical questions.

Anthropic Claude:

  • Claude Haiku 4.5, fast and low-cost, works well for morning store checks.
  • Claude Sonnet 4.6 is a useful middle point between speed and analytical depth.
  • Claude Opus 4.7 is the best option when queries involve multiple data sources.

Google Gemini:

  • Gemini 3.5 Flash, fast and capable, the standard starting choice for most stores.
  • Gemini 3.1 Flash-Lite, the cheapest per query, ideal when keeping API spend low matters.

5.4 Temperature Setting

Governs how consistent or varied the AI responses are. At 0, the answers are most precise. At 1, there is more phrasing variation. For store data queries, 0.3 is the practical starting point. Use 0.0 when strict factual precision is the priority.

Click Save Provider Settings to apply.

6.0 Widget Layout Tab

The Widget Layout tab controls the appearance of the chat widget inside the OpenCart admin. Every adjustment shows in the real-time preview panel on the right before anything is saved.

Position: The screen corner where the chat bubble appears. Bottom Right is the default.

Chatbot Name: The name in the widget header. Smart Admin Assistant by default.

Greeting Message: The first message shown when the widget opens. Default: Hello! Ask me anything about your store.

Bubble Icon: Swap out the default bubble image. Square PNG, 64×64 px, 2 MB limit.

Chatbot Avatar: The image shown beside each bot reply. Square PNG, 48×48 px, 2 MB limit.

Widget Width and Height: The size of the open chat panel in pixels. Default is 400 wide by 560 tall.

Colour Settings: Six colour controls, Header, Chat Bubble, User Message, Bot Message, Background, and Text. No CSS knowledge needed. Changes reflect in the preview immediately.

Click Save Layout to apply.

7.0 Database Views Tab

7.1 How Database Views Work in This OpenCart Admin AI Chatbot

A set of pre-built MySQL views was built for the OpenCart AI reporting extension that organises and simplifies the relevant data for each domain. Queries run against these views only; the AI has no path to raw tables, and all views are read-only. Store data cannot be changed, deleted, or written through the chat under any circumstances.

Unticking a view removes that domain from the assistant’s allowed query list. The view stays in the database intact and can be re-enabled at any point.

7.2 Available Database Views

  • Orders Overview: Orders joined with customer details, currency, status, and totals.
  • Order Line Items: Individual product lines per order with quantities and prices.
  • Customers: Full customer records with group, gender, and last visit date.
  • Products: Catalog data with name, stock, price, category, and image info.
  • Specific Prices / Product Discounts: Per-product and per-combination price overrides. Off by default.
  • Categories: Category names and their hierarchy.
  • Shopping Carts: Active and abandoned carts with customer and currency details.
  • Cart Rules / Coupons: Discount rules with usage data and free shipping flag.
  • Stock Availability: Stock levels per product and combination with readable names.
  • Employees: Admin accounts and their profile data.
  • Customer Addresses: Address records with country, state, and customer data resolved.
  • Carriers / Shipping Methods: Active carriers with delivery delay text. Off by default.
  • Manufacturers / Brands: Brand records with descriptions and product counts.
  • Product Combinations / Variants: Variant data with stock, reference, and attribute names.
  • Product Attributes and Values: Attribute groups like Colour and Size with their values.

Click Save and Create Views to apply. The Knowband extension builds the MySQL views for any domain switched on.

8.0 Access Control Tab

The Access Control tab sets which OpenCart admin staff can open the assistant.

Tick: Restrict the chatbot to specific employee profiles to switch role-based access on. When this is off, every logged-in admin can use the assistant without restriction.

When role-based access is active, a profile list appears below. SuperAdmin access is permanent and does not appear in the list. Tick any other profiles, Logistician, Salesman, Translator, or custom roles, that should have access. Profiles left unticked see no assistant when they log in. Leaving all profiles unticked while role-based access is on limits the assistant to SuperAdmin only.

Click Save Access Settings to apply.

9.0 Predefined Chips Tab

Predefined chips are question shortcuts built into the chat widget. Each chip sends a stored question to the AI the moment it is tapped, no typing, no navigation.

9.1 Default Chips in the OpenCart Order Insights Plugin

Ten chips come ready out of the box:

  1. Orders Today: How many orders were placed today?
  2. Revenue (30d): What is the total revenue in the last 30 days?
  3. Cancelled Orders: How many orders were cancelled in the last 30 days?
  4. Abandoned Carts: How many carts were abandoned in the last 30 days?
  5. Active Customers: What is the current active customer count?
  6. Out of Stock: Which products are at zero stock right now?
  7. Low Stock (under 5): Which products have fewer than 5 units left?
  8. No SKU Products: How many products are missing a SKU reference?
  9. Free Shipping Coupons: Which active coupons offer free shipping today?
  10. New Customers (This Month): How many customers registered this month so far?

9.2 Adding a Custom Chip

Click Add Chip to open the chip form.

Label: Short button text. Keep it under three words. For example: Weekly Revenue.

Question: The question the AI gets when this chip is tapped. Write it the same way you would type it into the chat directly. For example: What is the total revenue for the past 7 days?

Position: The chip’s position in the panel list. Lower numbers appear first.

Active: Yes displays the chip in the widget. No keeps it saved but hidden.

Click Save Chip to finish. Edit and Delete buttons appear on each row for future changes.

10.0 Query History Tab

The Query History tab records every question sent through this tool. Each log entry shows:

  • Date: The time the query was sent.
  • Employee: Which admin account ran it.
  • Question: The full text of what was asked.
  • Rows: Number of data rows the query returned.
  • Time (ms): How long the query took to run.
  • Provider: The AI service that handled it, shown as a labelled badge.
  • Status: Green for success, red for errors.
  • SQL: The query that ran, visible inline.

Filter by status and date range at the top. Export visible results to CSV or Excel using the buttons above the table. Click Purge Old Logs to remove entries older than the Log Retention setting immediately.

11.0 Sessions Tab

The Sessions tab holds the full conversation history per employee. Each row shows the employee name, session start time, and message count. Click View to open the complete thread, questions and responses in chronological order in a pop-up window. Useful for reviewing what data was accessed, checking how the assistant is being used, or continuing the thread from a previous session.

12.0 Analytics Dashboard

The Analytics Dashboard gives you a real-time overview of your store’s performance, including sales, orders, customers, and inventory, all from a single screen in your OpenCart admin panel. The dashboard is organised into three widget groups:

Key Metrics: KPI cards summarising revenue, orders, and customer activity
Charts & Trends: visual breakdowns of sales over time and by category
Lists & Tables: detailed rankings such as best sellers and low stock alerts

Every admin user can choose which widgets appear on their own dashboard and reorder them freely. Store-wide behavior, such as which order statuses count as revenue, is controlled centrally by an administrator in Settings → Analytics Dashboard Settings.

12.1 Analytics Dashboard Settings

Store owners can find the dashboard setting in Settings -> Analytics Dashboard Settings
This is the central OpenCart admin dashboard settings screen for Knowband Smart AI Admin Assistant. Every field here applies globally, to all admin users. Individual users can still personalise which widgets they see and how they’re arranged from the dashboard’s Customize panel. Use this section to configure how your OpenCart analytics dashboard calculates revenue, which time period it opens with, how it looks, and whether it replaces your OpenCart admin home page.

12.2  Dashboard Settings in Smart AI Admin Assistant

Revenue Order Statuses

Revenue Order Statuses: This field controls which OpenCart order statuses count as revenue across every sales widget on the dashboard, including Revenue, Orders, Average Order Value, Best Sellers, Top Customers, and Coupon Usage.

Default Period

The default period is the period in which you want your dashboard to show the analytical data. Options are included as Last 7 days, Last 30 days, Last 3 months, Last 6 months, Last 1 year

Colour Theme

The colour theme is the theme of the dashboard which shows the analytics data. This module includes the Options like Indigo (default), Ocean, Emerald, Rose, Dark, and Custom.

List Rows

This feature controls how many rows are displayed in every list and table-style widget on the dashboard, including Best Sellers, Top Customers, Slow Movers, Reorder Suggestions, Churn Risk, Low Stock Alerts, Coupon Usage, and Brand Performance.

Churn Window

This defines the number of days of customer inactivity after which a customer is flagged in the Churn Risk widget, one of the key OpenCart customer retention tools on the dashboard.

Low Stock Threshold

This feature sets the product quantity at or below which a product is treated as “low stock” across the Low Stock, Low Stock Alerts, and Reorder Suggestions widgets, forming the basis of the dashboard’s OpenCart inventory management alerts.

Replace Default Dashboard

Store owners can enable the same to control whether the Analytics Dashboard should replace your opencart default dashbpard.
The admin home page automatically opens the Analytics Dashboard instead of OpenCart’s default dashboard the moment any admin user logs in. When set to Disabled, OpenCart’s standard dashboard remains the default landing page, and the Analytics Dashboard is accessed separately from the admin menu whenever needed.

5. Customising Your Dashboard

Each admin user can personalise their own dashboard layout independently by clicking on customisation on the dashboard.

Click Customise (widget library icon) on the dashboard.
Move or reorder any widget within its group (Key Metrics, Charts & Trends, Lists & Tables).
Close the panel, and now you will see the customised dashboard. You can click on Restore default to restore it to the original dashboard.

12.2 Key Metrics (17 widgets)

Revenue
Total order value for the selected period and order status chosen from the dashboard setting, with a daily trend graph and percentage change versus the previous period. This feature works as an OpenCart revenue report on the dashboard.

Orders
Total number of orders placed in the selected period, with a daily trend graph and percentage change, forming the base of the dashboard’s OpenCart order analytics.

Avg. Order Value
These values show the avgerage value per order, calculated on the basic total revenue divided by the total number of orders. Average order value provides store owners with a real-time check at a single glance. Instead of digging through spreadsheets, Excel, owners can instantly see if their pricing and marketing strategies are actually working.

Items Sold
This KPI metric shows the total units sold across all orders in the period that store admins have selected, which is useful for tracking sales volume independent of revenue.

Items per Order
This item per order metrics shows the items per order, so that store owners can have a idea of how he is selling items like individually or in bulk with OpenCart Analytics & Reporting Extension.

Discounts Given
The discount given option in the OpenCart AI Sales Analytics Plugin give the total value of coupon, voucher, and reward discounts applied during the selected period with per cent change from the previous analytics

Taxes Collected
The OpenCart AI Reporting Extension give the figure of total tax collected from orders in the period, useful for reconciliation and reporting.

Shipping Revenue
This feature gives the total shipping charges collected from customers on the orders during the selected periods, also show the percentage changes compared with the previous data.

Refunded Value
The total amount that is refunded will be marked as refunded in the selected periods, giving visibility into returns and lost revenue.

New Customers
Shows the total number of customers who registered during the selected period, calculated directly from new account sign-ups. This OpenCart Customer Analytics metric helps store owners gauge the real-time impact of acquisition campaigns, rather than waiting on a manual account export.

Repeat Customers
Counts customers who placed two or more orders within the selected period. This figure feeds directly into the dashboard’s OpenCart Customer Retention Dashboard, giving store owners a quick read on loyalty without cross-referencing order history manually.

Returning Buyer Rate
Shows the percentage/rate of buyers in the period who ordered more than once, which is calculated as repeat customers divided by total unique purchasers. This AI Assistant acts as an OpenCart Customer Analytics indicator; it shows store owners whether their retention strategy, from email marketing to loyalty programs, is actually converting first-time buyers into repeat business.

Total Customers
Total customers display every customer registered in the store to date, independent of the period selector. As a Real-Time Store Analytics snapshot, it always reflects the current customers the moment the dashboard loads, giving store owners an accurate data to check growth.

Active Products
Shows the number of products currently enabled and available for purchase in the storefront. This snapshot gives store owners an instant read on active catalogue size, useful when auditing inventory as part of the dashboard’s broader OpenCart Inventory Management toolkit.

Out of Stock
Flags-enabled products are currently sitting at zero quantity. As part of the OpenCart Inventory Management alert system, this widget lets store owners catch stockouts immediately, rather than discovering them after a lost sale.

Low Stock
Counts enabled products at or below the low-stock threshold configured in Analytics Dashboard Settings. This real-time alert gives store owners an early warning system for reordering, well before a product actually runs out.

Units in Stock
Totals the quantity across every enabled product in the store, giving a single figure for overall inventory volume. Store owners can use this widget alongside Low Stock and Out of Stock for a complete OpenCart Inventory Management picture in one glance.

12.4 Charts & Trends (9 widgets)

Revenue Trend
Plots revenue over time as a line chart, daily for periods up to six months and monthly for a full year. As a visual extension of the dashboard’s OpenCart Sales Report data, it helps store owners quickly spot spikes, dips, or seasonal patterns that raw numbers alone can hide.

Revenue Forecast
Analyses the last 90 days of trading and projects likely revenue for the next 30 days, using recent trend data rather than the selected period. This OpenCart Revenue Forecast widget helps store owners plan cash flow, stock orders, and marketing spend ahead of time, based on real sales momentum rather than guesswork.

Orders Trend
Charts order count over time using the same daily or monthly logic as Revenue Trend. It gives store owners a volume-based counterpart to the revenue chart, feeding into the dashboard’s wider OpenCart Order Analytics view of how order activity is moving.

Payment Methods
This chart shows how revenue splits across the payment options customers actually chose at checkout. If one method is quietly outperforming the rest, it’s worth understanding why, and if another barely gets used, that’s often a sign it needs more visibility or trust-building on the checkout page.

Sales by Country
A simple bar chart of revenue by shipping destination, but a genuinely useful one. It’s usually the fastest way to see where a store’s real strength lies geographically, which matters a lot if you’re weighing up new shipping zones or where to put the next ad budget.

Order Status
One bar list, every active status, revenue and order count side by side. It’s the quickest way to answer “where are things sitting right now,” whether that’s orders still processing, ones stuck pending, or ones already through to completion.

Sales by Carrier
Breaks revenue down by shipping method so you can see which carriers your customers end up using most. Worth checking every so often, especially when it’s time to renegotiate rates or decide if a new carrier option is actually needed.

Sales by Day of Week
Takes the whole selected period, not just last week, and groups total revenue by weekday. Patterns tend to show up here that aren’t obvious day to day, like a Thursday that consistently outsells everything else, which is handy to know when planning promotions or staffing.

Sales by Hour
Once you can see exactly when customers are most likely to buy, timing things like flash sales, email sends, or live support becomes a lot less guesswork and a lot more strategy.

12.4 Lists & Tables (8 widgets)

Best Sellers
Ranks products by units sold, with reference, quantity, and revenue shown side by side. As a key part of any OpenCart Sales Report review, this widget tells store owners exactly which products are carrying the business.

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

Top Customers
Ranks customers by total revenue, alongside their order count, giving store owners a clear view of who to prioritize for loyalty perks, personal outreach, or account management as part of a broader OpenCart Customer Analytics strategy.

Churn Risk
Flags high-value customers who haven’t placed an order beyond the configured Churn Window, along with their lifetime value and last order date. This is the core of the dashboard’s OpenCart Customer Retention Dashboard, helping store owners win customers back before they’re gone for good.

Low Stock Alerts
Lists every product currently at or below the configured stock threshold, or already out of stock, with reference and quantity. This is a core OpenCart Inventory Management tool that gives store owners 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, units sold per day, and days of stock cover remaining. Store owners can use this feature to restock exactly the right amount, avoiding both overstocking and stockouts.

Coupon Usage
This shows every coupon redeemed during the selected period, along with number of uses and total discount value, so store owners can measure 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 OpenCart Business Intelligence view of what’s actually driving the store, down to the brand level.
Rights Reserved.

12.0 Frequently Asked Questions

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

This is an OpenCart Admin AI Chatbot that lets store admins ask plain-language questions and get answers from live store data instantly. It connects to the store database through pre-built read-only MySQL views, sends each question to the chosen AI provider, OpenAI, Anthropic Claude, or Google Gemini, which builds and runs a SQL query, then delivers the result in natural language. Compatible with OpenCart 3.x.

Q: Which AI providers work with the OpenCart back office analytics tool?

The Knowband OpenCart Smart AI Admin Assistant 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). Each provider connects via your own API key with no extra subscription. You pay only for what the AI actually processes.

Q: Can the OpenCart Smart AI Admin Assistant change or delete any store data?

No. The OpenCart AI sales analytics tool reads data only through pre-built MySQL views. No query sent through the chat can update, delete, or write anything back to the database. Every response is a read-only retrieval from your live store.

Q: What data can I query using the OpenCart admin AI chatbot?

Orders, customers, revenue, stock, abandoned carts, discount coupons, product combinations, employee accounts, shipping carriers, brands, and categories are all queryable. The Database Views tab governs which domains are active. Switch a domain on to allow it, switch it off to restrict it.

Q: How do predefined chips work in the OpenCart Smart Store Analytics tool?

Chips are one-tap question buttons in the widget. Tap one, and the saved question goes to the AI straight away. The default chip set covers orders, revenue, abandoned carts, low stock, out-of-stock items, active customers, new customers, cancelled orders, free shipping coupons, and products without a SKU. New chips can be added, edited, or removed from the Predefined Chips tab.

Q: What does the SQL visibility feature do in the OpenCart back office analytics tool?

Enable Show SQL Query Toggle, and the SQL behind each answer appears in the chat below the result. Turn on Allow SQL Edit and Re-run as well, and that SQL becomes editable directly in the chat. Change a date, a filter, or a threshold and run it again without asking a new question. This OpenCart AI sales analytics tool makes this accessible to any admin, not just those with SQL knowledge.

Q: How does role-based access control work in the OpenCart AI admin chatbot?

Open the Access Control tab and tick Restrict the chatbot to specific employee profiles. SuperAdmin access cannot be removed. For every other profile, Logistician, Salesman, Translator, or any custom role, tick the ones that should have access. Any profile left unticked will not see the assistant after logging in.

Q: What is the schema cache in the OpenCart back office analytics tool?

The schema cache holds the structural map of the store database so the AI can build queries accurately without reading the full database on every request. The first chat session builds it automatically. It refreshes based on the Schema Cache TTL setting. After installing a new extension, upgrading OpenCart, or making any database change, use Refresh Schema Now to rebuild it on the spot.

Q: How do I connect an AI provider to the OpenCart Smart AI Admin Assistant?

Go to the AI Provider tab. Click the provider you want: OpenAI, Anthropic Claude, or Google Gemini. For OpenAI, sign in at platform.openai.com, go to API Keys, and generate a new secret key. For Anthropic, sign in at console.anthropic.com, open API Keys, and create one. For Gemini, sign in at aistudio.google.com, click Get API key, and generate one for your project. Paste the key into the relevant field and save.

Q: Is the OpenCart Smart AI Admin Assistant compatible with OpenCart 3.x?

Yes. The Knowband OpenCart Smart AI Admin Assistant works on OpenCart 3.x. Visit the product page for current compatibility details and version notes.

13.0 Conclusion

The Knowband OpenCart Smart AI Admin Assistant delivers AI-powered OpenCart back office analytics to any OpenCart store without needing SQL knowledge, developer support, or third-party reporting platforms. Ask in plain English, get answers from live data, view the SQL behind each result, and refine it on the fly.

The Opencart AI Assistant for Admin is now available on OpenCart Marketplace. Try the demo now.

For support, custom requirements, or OpenCart development work, contact the Knowband team directly.

PrestaShop AI Review Generator Module – Complete User Guide

Every product page with zero reviews loses conversions before a single visit turns into a sale. Building review volume through follow-up emails takes months, and the response rate rarely justifies the wait. The Knowband PrestaShop AI Review Generator solves this from the admin panel.

The PrestaShop AI Review Generator connects directly to ChatGPT (OpenAI), Claude (Anthropic), or Gemini (Google) and generates product-specific reviews based on rules you define. Each review includes a star rating, a title, body content written in the tone you select, and a guest reviewer profile with a randomised name and details. Reviews are published through the native Product Comments module and appear on the storefront exactly as a genuine customer review would.

This guide covers every setting across all three admin tabs so you can configure it, connect your AI provider, and start building review volume on day one. Compatible with PrestaShop 1.7. x through 9.x.

1. 1 Who Is This Module For

This module is built for:

  • New stores that need review volume before organic feedback has had time to build.
  • Store owners launching new products who want social proof live on day one.
  • Merchants running multilingual stores who need reviews in multiple languages without separate workflows.
  • Any PrestaShop admin who wants keyword-rich product reviews live on the storefront without depending on customers to submit them.

2.0 Installation Guide for Prestashop AI Review Generator Addon

System Requirements

Check these before starting the install:

  • PrestaShop 1.7.x, 8.x, or 9.x
  • PHP 7.2 or higher 
  • Native PrestaShop Product Comments module is installed and active
  • A valid API key from OpenAI, Anthropic, or Google

Installing the Module

Step 1: Download the ZIP file from your account and open your PrestaShop back office.

Step 2: Head to Modules, then Module Manager. Find the upload option at the top right of the screen.

Step 3: Choose the ZIP file from your downloads. PrestaShop processes the upload and unpacks the files on its own.

Step 4: Hit Install on the prompt that follows. The module configuration screen loads straight after.

Step 5: If the module does not show up, type AI Review Generator into the Module Manager search and open Configure.

Common Installation Issues

Upload fails: The server is rejecting the file size. Ask your host to raise upload_max_filesize and post_max_size to at least 32 MB.

Module not visible after install: Clear the PrestaShop cache under Advanced Parameters, then Performance,e and run the search again.

Reviews not showing on the storefront: The native Product Comments module must be installed and switched on. Reviews generated by this module go through it and will not appear without it.

3.0 Admin Panel Overview of Prestashop AI Review Generator Addon

The PrestaShop AI Review Generator adds three tabs to the back office:

  • General Settings: Switch the module on, connect an AI provider, and get the CRON URL for automated generation.
  • Review Rules: Build and manage the rules that define how reviews are created, where they apply, and when they are published.
  • Reviews: Check, approve, or remove any generated review before or after it reaches the storefront.

4.0 General Settings Tab in Prestashop Product Review Generator Module

This tab holds the global configuration for the PrestaShop AI review generation module. A notice at the top of the page shows whether the current settings cover all stores or just one.

4.1 Enable Module

The main toggle. Set to Enabled, and the module is active across the store. Set to Disabled and generation stop,s but all rules, reviews, and history stay in place.

4.2 AI Provider

Choose from three providers:

  • ChatGPT (OpenAI)
  • Claude (Anthropic)
  • Gemini (Google)

One provider runs at a time. Changing the selection does not touch existing rules or any reviews already generated.

4.3 API Key

Enter the API key for the selected provider. No key means the AI service cannot be reached, generation will not run, and the module stays inactive.

How to get your API key:

For OpenAI: go to platform.openai.com, open the API Keys section under your account, and create a new key. Copy it straight away as it is only shown once.

For Anthropic: go to console.anthropic.com, open API Keys, and create a new one.

For Google Gemini: go to aistudio.google.com, click Get API key, and generate one under your chosen project.

Click the Test key to check the connection before saving.

4.4 Model Selection

Pick the model that suits your needs from the ones available under each provider.

OpenAI models: GPT-5.5, GPT-5.4, GPT-5.4 mini, GPT-5.4 nano, GPT-5 (chat), GPT-4.1, GPT-4.1 mini, GPT-4.1 nano, o3, o3-mini, o4-mini, GPT-4o, GPT-4o mini, GPT-4 Turbo, GPT-4, GPT-3.5 Turbo

Claude models: Claude Opus 4.7, Claude Sonnet 4.6, Claude Opus 4.6, Claude Opus 4.5, Claude Sonnet 4.5, Claude Haiku 4.5, Claude Opus 4.1, Claude Sonnet 4, Claude Opus 4

Gemini models: Gemini 3.5 Flash, Gemini 3 Flash (Preview), Gemini 3.1 Flash-Lite, Gemini 2.5 Flash-Lite, Gemini Flash (Latest), Gemini Flash-Lite (Latest)

4.5 Max Tokens

This number sets the upper limit on how much text the AI can write per review request. Range is 1 to 16384, and the default value is 4000. Pushing it higher gives the AI room to write more detailed content,t but raises the API call cost. Keeping it lower produces shorter reviews, cuts costs, and speeds up each run. Align it with whatever Max Words per Review value you are using in the rules.

4.6 Temperature

Temperature decides how consistent or varied the AI output is. The scale runs from 0.0 to 1.0. At zero, the output is predictable and uniform, which suits stores that need every review to stay within a fixed tone. Closer to 1, the output gets more varied. For reviews that are meant to read naturally, somewhere between 0.5 and 0.7 tends to give a good balance.

4.7 Check Existing Reviews

Set this to Yes, and the module runs a check on each product before generating. If reviews are already present, that product is skipped. This stops the same product from receiving repeated batches and avoids spending API tokens on content that is not needed.

4.8 CRON URL for Scheduled Generation

A token-secured URL for automated review generation on a schedule is available on the General Settings tab. Immediate and scheduled reviews are both published through this URL.

Copy it and add it to your server cron job. The recommended frequency is every 15 minutes. Only requests that carry the correct token trigger generation. The URL does nothing without it.

Click Save to apply all changes on this tab.

5.0 Review Rules Tab

Review Rules control exactly how the PrestaShop auto-generate reviews process runs. Each rule targets a set of products or categories and defines the publish mode, generation limits, tone, language, and rating distribution for that set.

The Review Rules list shows every created rule with its ID, name, publish mode, content type, max per day, active status, generate button, and assigned store. Click Generate now on any row to run that rule immediately. Click Edit to change the rule settings.

5.1 Adding a New Review Rule

Click the Add Rule button to open the rule creation form.

Store: Select which store this rule applies to when running a multi-store setup.

Enable rule: Toggle on to make the rule active. Rules set to off are saved, but do not run on CRON or Generate now.

Publish Mode: Three options control when generated reviews go live.

  • Immediate (publish on generation): Reviews go live the moment they are generated. No waiting, no approval step.
  • Scheduled (publish after a random delay): Reviews are generated and held, then published at a random point between a minimum and maximum number of days you set. A range of 0 to 7 days publishes each review at a random time within that window. This makes the review accumulation pattern look organic rather than instant.
  • Manual (await approval in Reviews): Reviews are generated and held in the Reviews tab. Nothing is published until an admin opens each entry and approves it. Best when editorial control over what goes live matters.

Random Delay (days): Appears when Scheduled mode is selected. Set a Min and Max day range. Generated reviews are published at a random point within that range.

Max per Cron: The maximum number of reviews this rule can generate in a single CRON run.

Max per Day: The total number of reviews this rule can generate across all CRON runs in one calendar day.

Max per Product per Day: The maximum reviews a single product can receive from this rule in one day. This prevents any one product from accumulating an unnatural volume in a short period.

Max Words per Review: The maximum word count for each generated review. Set to 150 for standard-length reviews. Reduce to 50 or below for short-form reviews. Increase for long-form, detailed content.

Languages: Tick the languages reviews should be generated in. If both English and French are ticked, every review is generated in both languages. Only languages installed in your PrestaShop store appear in this list.

Content Type: Choose whether the rule targets Products or Categories. Selecting Products lets you search and add specific products. Selecting Categories lets you target an entire category; every product in that category receives reviews under this rule.

Tone: Select the voice for the generated reviews.

  • Professional
  • Casual
  • Technical
  • Persuasive

Generate Using: Toggle which product data points the AI uses when writing the review. At least one must be enabled.

  • Product name
  • Product description
  • Product price
  • Product category

Disabling a data point means the AI does not factor it into the review. Enabling price means reviews may reference the product’s value. Enabling description gives the AI more context for detailed, product-specific content.

Rating Distribution (%): Set the percentage split across 1 to 5 star ratings. The total must equal exactly 100. For example: 5 stars 50%, 4 stars 30%, 3 stars 10%, 2 stars 5%, 1 star 5%. The module uses this distribution to weight the rating assigned to each generated review, keeping the mix natural rather than uniformly perfect.

Rule Name: A required field. Give the rule a clear name that identifies its purpose, for example, Summer Collection English or Homepage Category Casual.

Custom Prompt (en): An optional field that overrides the default generation instruction for this rule. Write a plain instruction and drop in any of the supported variables to bring product data into the prompt.

Supported variables: {product_name}, {product_description}, {price}, {category}, {shop_name}, {tone}, {max_words}

For example: Write a review for {product_name} priced at {price}. Keep it under {max_words} words and use a {tone} tone.

Click Save to create the rule. It appears in the Review Rules list immediately.

5.2 Editing and Deleting Rules

Click Edit on any rule row to reopen the configuration form and change any setting. Click the dropdown arrow next to Edit and select Delete to remove a rule permanently. Deleting a rule does not delete reviews already generated under it.

5.3 Bulk Actions

The Bulk actions dropdown at the bottom of the rules list lets you apply actions to multiple selected rules at once.

6.0 Reviews Tab

The Reviews tab shows every review generated by this module. This is where you approve, publish, or remove reviews before or after they reach the storefront.

6.1 Reviews List

Each entry in the list shows:

  • ID: Sequential review number.
  • Product: Which product was the review generated for?
  • Language: Which language was this review generated in?
  • Review Preview: A shortened version of the review body.
  • Reviewer: The generated reviewer name and email address.
  • Rating: The star rating assigned based on the rule’s distribution settings.
  • Status: Scheduled, Published, or Pending Approval.
  • Created: When the review was generated.
  • Published: When the review went live on the storefront.
  • Shop: Which store does the review belong to?

 

Filter the list by product, language, reviewer, rating, status, created date range, published date, or shop using the search controls above the list.

6.2 Approving and Publishing Reviews

For rules set to Manual publish mode, reviews land in this tab with Pending Approval status. Click Approve and Publish on any row to send that review live immediately.

Click the dropdown arrow next to Approve and Publish to access the View option. This opens the full review text so you can read it before publishing.

6.3 Deleting Reviews

Click the dropdown arrow next to Approve and Publish and select Delete to remove a generated review permanently. Deleted reviews cannot be recovered.

7.0 Frequently Asked Questions

Q: What is the Knowband PrestaShop AI Review Generator, and how does it work?

It connects to ChatGPT (OpenAI), Claude (Anthropic), or Gemini (Google) and generates product-specific reviews based on rules you define in the admin panel. Each review is written fresh for the specific product, in the language and tone the rule specifies, and published through the native Product Comments module. Compatible with PrestaShop 1.7. x through 9.x.

Q: Which AI providers does the PrestaShop AI Review Generator support?

The PrestaShop AI product reviews module supports three providers: ChatGPT via OpenAI, Claude via Anthropic, and Gemini via Google. You connect using your own API key. Only one provider is active at a time. Switch providers from the General Settings tab without affecting existing rules or generated reviews.

Q: What are the three publishing modes in the PrestaShop auto-generated reviews module?

Immediate publishes a review the moment it is generated. Scheduled holds it and releases it at a random point within a day range you set, which creates a natural-looking accumulation pattern. Reviews set to Manual stay in the Reviews tab with a Pending Approval status. An admin has to open each one and approve it before it reaches the storefront.

Q: How does the rating distribution feature work in the PrestaShop AI product reviews module?

Open any review rule and find the Rating Distribution (%) section. Assign a percentage to each star level from 1 through 5. The numbers must add up to exactly 100. As an example: 5 stars at 50%, 4 stars at 30%, 3 stars at 10%, 2 stars at 5%, 1 star at 5%. When the module generates reviews, it follows this split when assigning each rating, so the overall profile across a product page does not look artificially uniform.

Q: How does the CRON automation work for PrestaShop product review automation?

The General Settings tab provides a token-secured CRON URL. Add this URL to your server cron job set to run every 15 minutes. Each run uses the PrestaShop automated review generation rules to produce content and publishes immediate and scheduled reviews that are due. The URL only triggers generation when the correct token is included; it cannot be accessed without it.

Q: Does the PrestaShop auto-generate reviews module support multiple languages?

Yes. Inside each review rule, tick the languages the reviews should be generated in. If English and French are both selected, every review is generated in both languages. Only languages installed in the PrestaShop store appear in the language list.

Q: What is the custom prompt feature in the PrestaShop AI review generation module?

The Custom Prompt field sits inside each review rule and is optional. Fill it in when the default generation output does not match your store’s tone or when you need reviews to focus on a specific product attribute. Write a plain instruction and drop in any of the supported variables to bring product data into the prompt: {product_name}, {product_description}, {price}, {category}, {shop_name}, {tone}, {max_words}.

Q: What does Max Tokens control in the PrestaShop AI product reviews module?

Max Tokens caps how much text the AI generates per review in one request. The accepted range is 1 to 16384. A higher number gives the AI room to write longer, richer reviews, but raises API cost per generation. A lower number cuts both the length and the cost. Set it in line with the Max Words per Review value in the rule so both limits stay consistent.

Q: Can I prevent duplicate reviews from being generated?

You can turn on Check existing reviews in General Settings in a AI Review Generators available on Prestashop Addons. Once active, the module looks up each product before generating and skips any that already carry reviews. This keeps the database clean and avoids spending API tokens on products that do not need new content.

Q: Is the PrestaShop AI Review Generator compatible with PrestaShop 9?

Yes. The PrestaShop AI Review Generator runs on PrestaShop 1.7. xx through 9.x. Before generating, make sure the native Product Comments module is installed and switched on. No changes to the theme or custom templates are required.

8.0 Conclusion

This module puts AI-powered product review automation inside the PrestaShop admin panel. Define a rule, connect an API key, and the module handles generation, scheduling, and publishing from there. Keyword-rich reviews go live on product pages without waiting for customers to write them.

Rating distribution controls keep the review mix credible. The PrestaShop product review automation runs end-to-end without daily management once the rules are set. Multilingual generation covers every market the store serves. Manual approval mode gives full editorial control when it matters. The CRON automation handles the rest on schedule.

For support, custom development, or PrestaShop add-on requirements, contact the Knowband team directly through support@knowband.com

Opencart Catalogue Import Export Extension User Manual

If you manage a growing OpenCart store, you already know how time-consuming manual product updates can be. The Knowband OpenCart Import Export Scheduler Pro is, therefore, purpose-built to eliminate that friction entirely. It handles bulk product and category transfers in CSV, XLSX, JSON, and XML formats  all from within the OpenCart admin panel  with no coding, no developer involvement, and no wasted hours.

Furthermore, what truly sets this OpenCart bulk product import/export extension apart from generic tools is its reusable profile system. Every import or export task is consequently saved as a named profile with its own file format, column mapping, FTP or SFTP destination, and optional cron schedule. As a result, store owners can move from one-off data dumps to fully automated, scheduled catalogue syncs in a matter of minutes.

Moreover, whether you are running a daily supplier feed via FTP, migrating products between two OpenCart stores, or pushing bulk price updates to a remote SFTP server, Knowband‘s OpenCart Catalogue import export extension covers every scenario out of the box. No custom code is required. The OpenCart catalogue Migration via Import Export Extension is now available on the OpenCart Marketplace

1.1 Key Capabilities of Opencart Import Export Extension

  • Four file formats are supported for OpenCart bulk product import/export: CSV, XLSX, JSON, XML
  • Reusable named profiles with saved mappings, format settings, and FTP/SFTP configuration
  • FTP, FTPS, and SFTP transfer with live connection testing before saving
  • Fully automated, unattended OpenCart cron import/export on any schedule
  • Column auto-matching with required-field validation that blocks incomplete imports
  • Full import export support for OpenCart product combinations and variants
  • Multilingual field handling  export and import translated fields across all active languages
  • Transfer Logs with row-level error detail and re-download links for every run
  • Automatic file cleanup on a configurable retention schedule
  • Compatible with OpenCart 3. x.x | PHP 7.2+ | MySQL 5.6+

1.2 Who Is This Extension For?

This OpenCart CSV import export extension is specifically designed for:

  • Store owners managing catalogs of 100 to 50,000 SKUs who need repeatable bulk updates without manual effort
  • Agencies handling multiple OpenCart stores and requiring smooth catalogue migration between instances
  • International stores managing multilingual product data across several active languages
  • Businesses syncing supplier feeds on a daily or hourly schedule via FTP or SFTP
  • Administrators who want a reliable, log-backed history for every OpenCart bulk import/export run

2. Installation

Before proceeding, verify that your server meets the minimum requirements for Knowband‘s OpenCart scheduled import export extension: OpenCart 3.x.x, PHP 7.2 or higher, and MySQL 5.6 or higher.

Step 1: Upload via FTP

To begin with, extract the ZIP archive downloaded from the Knowband store. Connect to your server via an FTP client and copy all extracted files from the upload folder into the root directory of your OpenCart installation.

Step 2: Install in the Admin Panel

Next, log in to your OpenCart admin panel. Navigate to Extensions > Extensions, locate Knowband Import Export  Plugin in the list, and click Install. The  Plugin will thereafter be registered with your OpenCart instance.

Step 3:  Configure

Finally, click Edit on the same row to open the extension configuration page. You will land on the General Settings tab, where all global preferences  including cron URLs, file size limits, and cleanup schedules  are managed.

3. Admin Panel Overview

Once installation is complete, the Knowband OpenCart Import Export Scheduler Pro adds four clearly organised tabs inside its configuration page. Understanding each tab’s purpose is, consequently, the fastest way to get productive with OpenCart bulk catalog management.

4. General Settings

The General Settings tab is the control centre for all global behaviours of the OpenCart import export extension. It is divided into four sub-sections. Configuring these settings correctly upfront will, in turn, ensure that all subsequent import and export operations run smoothly.

4.1 Preferences

Extension Enable / Disable turns the entire extension on or off. When disabled, all scheduled cron import and export tasks are paused immediately.

Maximum Visible Columns sets how many columns display at once in the OpenCart import mapping table. Range: 1–20. Default: 6. Use the pagination arrows to navigate remaining columns.

Maximum Visible Rows sets how many sample data rows appear in the mapping preview. For visual verification only does not restrict the actual import row count. Range: 1–50. Default: 10.

Import Batch Size controls how many rows are processed per AJAX request during OpenCart bulk product import. Lower values reduce timeout risk on shared hosting. Range: 10–500. Default: 100. On VPS or dedicated servers, increase to 300 or higher for faster large imports.

Click Save Settings to apply.

4.2 Template Files

This section provides ready-to-fill sample files for every supported entity and format combination  an essential starting point for anyone setting up an OpenCart CSV import or XLSX-based bulk upload for the first time. Two entities are available: Products and Categories. Each has four format buttons: CSV, JSON, XML, and XLSX.

Simply click the relevant button to download the template. Each template includes every column the importer recognises, with safe placeholder data. Fill it with real product data and import it back.

Important: Your uploaded file must follow the column layout shown in the templates. Deviating from this layout will cause column auto-matching to fail and require manual remapping.

4.3 Limits and Speed

Max Records Per Download: Maximum number of records exported per file. Increase only if your server memory supports it. Range: 100–50,000. Default: 5,000.

Max Upload Size (MB)  Maximum import file size the plugin accepts. Works alongside PHP’s server-level upload limit; whichever is lower takes effect. Range: 1–200 MB. Default: 50 MB.

Click Save Settings to apply.

4.4 Scheduled Cleanup and Cron URLs

This is where you configure the three cron job URLs that power the automated side of Knowband‘s OpenCart scheduled import/export system. Each URL has a dedicated Copy button; paste it directly into your server crontab or OpenCart’s built-in scheduled tasks.

Keep Files For (Days)  Import and export files older than this number of days are deleted automatically by the cleanup cron. Range: 1–30 days. Default: 7 days.

Cleanup Cron URL  Recommended: daily at 2 AM. Deletes old temporary files automatically.

Export Profiles Cron URL: Recommended: daily at 3 AM. Runs every export profile flagged as cron-enabled and stores the generated file in Transfer Logs.

Import Profiles Cron URL  Recommended: daily at 4 AM. Fetches files via FTP/SFTP and runs every FTP-source import profile flagged as cron-enabled. Upload-source profiles are manual-only and are skipped automatically.

Click Save Settings to apply.

5. Export Profiles: Complete Walkthrough

The Export tab lists all saved export profiles. Knowband‘s profile-based approach means you set up the OpenCart bulk export once and reuse it indefinitely  either manually with one click or automatically on a cron schedule. Each profile displays its ID, name, entity type, format, cron status, and date added.

Click Add Export Profile to create a new one. The wizard runs through three steps: Transfer Settings, Choose Fields, and Generate File.

5.1 Step 1  Transfer Settings

Profile Name: A unique label for this profile in the Export listing. Example: Weekly Product Feed.

Output File Label: Base name for the generated file. The plugin is added automatically. Use letters, digits, hyphens, and underscores only. Example: products-daily.

Data Type: Select Products or Categories.

File Format: Select CSV, XLSX, XML, or JSON.

Language(s)  Select one or more store languages. Translated fields such as name and description are exported for each selected language. Select All Languages to include every active language, a key feature for multilingual OpenCart product import export workflows.

Date Range (optional)  Filter records by creation date. Leave blank to export all records.

Record Order (optional)  Controls row sequence in the output file. Leave on default for standard database order.

Export Product Combinations (Options/Variants). When enabled, each product row is followed by one row per combination. Adds the columns row_type, parent_reference, combination_reference, attributes, and impact_price. Enable this for a full OpenCart catalog export that includes all product variants.

Scheduled Run  Enable Cron  When on, the Export Profiles Cron URL runs this profile automatically and stores the generated file in Transfer Logs after each run.

Export Destination

The file system saves the file locally. Administrators download it directly from Transfer Logs.

FTP / SFTP pushes the file to a configured remote server after each run. A local copy is also retained in Transfer Logs as a fallback.

When FTP / SFTP is selected, the following additional fields appear, Username, Password, Hostname and Remote Folder which is basically a path name of the folder on which you will export.

Output Style (CSV Delimiter): Universal comma, Windows/Excel semicolon, or Tab-separated.

List Glue  Separator for multi-value fields such as Tags and Category Names. Options: Pipe, Slash, or Comma.

Narrow by Category / Manufacturer / Supplier. Optional filters to scope the export to a specific product subset.

Price Window: Include only products within a specified minimum–maximum price range. Leave blank for no filter.

Click Next Step to proceed.

5.2 Step 2  Choose Fields

Every available product or category column appears as a selectable checklist. Required fields, marked with an asterisk, cannot be deselected. Additionally, you can reorder columns by dragging rows to control the exact sequence in the output file.

Three quick-action buttons are available:

  • Select All includes every available column in the export.
  • Deselect All  Clears all optional selections, leaving only required fields active.
  • Reset to Defaults restores the recommended default column set.

Available product fields include: ID, Model (SKU), Name, Status, Product Type, Condition, Manufacturer, Supplier, Tags, Date Added, Short Description, Description, Weight, Dimensions, EAN, UPC, MPN, Meta Title, Meta Description, SEO URL, Cover Image URL, All Image URLs, Category IDs, Category Names, Price, Cost Price, Special Price, Minimum Quantity, Stock Quantity, Stock Status, and Out of Stock Behaviour  making it one of the most comprehensive OpenCart bulk product export tools available.

Click Preview Data to see the first five rows based on your current selection. Click Save Profile to save without generating, or Next Step to proceed.

5.3 Step 3: Generate File in Opencart Catalogue Import Export Plugin

The final step presents a Download Summary confirming Data Type, File Format, File Label, and Fields Selected. Click Build and Download to generate the file immediately. The file downloads to your browser or is pushed to the configured FTP/SFTP destination, and the run is recorded automatically in Transfer Logs.

Note: Export files remain available for re-download in Transfer Logs until the scheduled cleanup cron removes them after the configured retention period.

6. Import Profiles  Complete Walkthrough

The Import tab, similarly to the Export tab, lists all saved import profiles. Each profile shows its ID, name, entity type, format, source type (Upload or FTP), cron status, and date added. Click Add Import Profile to begin the three-step wizard: Source Settings, Map Columns, and Run Import.

6.1 Step 1  Source Settings

Profile Name: A unique label for this profile. Example: Daily Supplier Feed.

Data Type: Products or Categories.

File Format  CSV, XLSX, JSON, or XML  must match the actual file format.

Output Style: CSV delimiter matching the file being imported.

List Glue must match the glue used during the corresponding export. This setting directly affects multi-value fields like Tags, Categories, and Image URLs.

Language: Default language for rows that do not specify their own language within the file.

Import Options

Update existing records when ID or model matches. Standard setting for all regular OpenCart bulk product import runs. Updates an existing product when a matching ID or SKU is found instead of creating a duplicate.

Force IDs from the file. Use only when migrating between stores where preserving the exact original product ID is required. Not recommended for routine imports.

Source Selection

Upload File for one-time manual imports. Maximum file size: 50 MB. Accepted formats: CSV, XLSX, JSON, XML.

FTP / SFTP  For pulling files from a remote server. Required for cron-driven automated OpenCart imports via scheduled FTP product sync.

When FTP or SFTP is selected as the source for an import profile in the Knowband OpenCart Import Export Scheduler Pro, a set of additional configuration fields appears on the screen. Each field plays a specific role in establishing the remote connection and controlling how the automated OpenCart scheduled import behaves.

The Transfer Protocol field is where you choose the connection method between FTP, FTPS, or SFTP. FTPS is generally recommended for production environments because it adds a layer of encryption over the standard FTP connection. The Server field takes the address of your remote FTP server, for example ftp.example.com. Right alongside it, the Port field auto-populates based on whichever protocol you select, which is 21 for FTP and 22 for SFTP, though you can override this if your server uses a non-standard port.

The Username and Password fields hold the login credentials for the remote server. Both are stored encrypted at rest, meaning they are never saved in plain text anywhere in the system. Once you have filled in the credentials, the Remote File Path field requires the absolute path to the source file on the remote server. 

This path must be exact and the file must exist at that location every single time the OpenCart cron import export runs. A typical example would be something like /home/feed/products.xml.

Passive Mode is a toggle that is recommended for FTP and FTPS connections, as it helps avoid connection issues caused by firewalls blocking the data channel. When SFTP is selected as the protocol, this setting is simply ignored. 

The Cron toggle, when enabled, instructs the Import Profiles Cron URL in General Settings to automatically fetch the file from the remote server and run the OpenCart bulk product import on the configured schedule, without any manual intervention. 

Click Save Profile, then Next Step.

6.2 Step 2: Map Columns

The column mapping screen loads actual rows from your uploaded or fetched file. Each column from your file is matched to the correct OpenCart field. Knowband‘s auto-matching engine detects column names and maps them without manual intervention wherever possible.

A confirmation at the top of the screen shows how many columns were successfully matched  for example: 47 of 47 columns auto-matched. Nevertheless, you should still review the mapping below to verify accuracy, particularly for custom or non-standard column names.

Each file column appears as a dropdown selector at the top of its respective data column. The rows below display real data values from the file, making it straightforward to verify that each column is mapped correctly. Use the search box to find a specific column, and navigate through remaining columns with the pagination arrows.

Important: If a required field is left unmapped, the extension blocks the import and displays a warning before allowing you to proceed. This OpenCart import mapping validation step ensures data integrity on every run.

Click Save Profile to save the mapping. Click Next Step to proceed.

6.3 Step 3: Run Import

Once the mapping is confirmed, two options are presented:

Save Profile saves the import profile for future use without running the import immediately.

Start Import runs the import in batches as configured in General Settings. When complete, Transfer Logs records the full result: total records processed, successful records, and any failures with row-level error detail.

For large catalogs, the batch processing approach used by Knowband‘s extension means the OpenCart bulk product import continues reliably even on shared hosting because each batch is a separate AJAX request; server timeouts cannot interrupt the overall process.

7. Transfer Logs

The Transfer Logs tab provides a comprehensive history of every import and export operation run through the extension. This is, consequently, the first place to check whenever an OpenCart bulk import export run produces unexpected results or an export does not appear in the expected destination.

Using Transfer Logs for Troubleshooting

Click the Log button on any row to open row-level error detail for failed records. This detail view shows precisely which rows failed and the specific error reason for each. As a result, you do not need to re-import the entire file; simply fix only the affected rows in your source file and re-import just those rows.

Export files remain available for re-download in the Logs tab until the scheduled cleanup cron removes them after the configured retention period (default: 7 days). This gives you ample time to verify, redistribute, or archive any generated OpenCart bulk export.

 

8. Frequently Asked Questions

Question1: What is the Knowband OpenCart Import Export Scheduler Pro?

Knowband‘s OpenCart Import Export Scheduler Pro is a professional-grade bulk data management extension for OpenCart 3.x.x. It handles product and category imports and exports in CSV, XLSX, JSON, and XML, and furthermore includes reusable profiles, column mapping with validation, FTP/SFTP file transfer, cron scheduling, email notifications, and full transfer logs  all from the OpenCart admin panel without any developer involvement.

Question2: How do I bulk upload products in OpenCart using a CSV file? Go to the Import tab and click Add Import Profile. Set the data type to Products, select CSV as the format, upload your file under Pick Source, and click Next Step. The extension auto-matches columns and displays the first rows of the actual file for verification. Confirm the mapping and click Start Import. Sample CSV templates are available from General Settings > Template Files to ensure your file follows the correct column layout.

Question3: Can I import and export OpenCart product combinations and variants? Yes. Enable Export Product Combinations (Options/Variants) in the export profile settings. Each product row is consequently followed by one row per combination, with attributes presented in a readable format. On re-import, any missing attribute groups and values are created automatically in the destination store.

Question4: How do I automate OpenCart product imports using cron jobs? Create an import profile with FTP or SFTP as the source and enable Cron in the scheduling section. Next, copy the Import Profiles Cron URL from General Settings > Scheduled Cleanup. Add it to your server crontab or OpenCart’s scheduled tasks with the required interval. From that point on, Knowband‘s extension handles the entire fetch-and-import cycle automatically a complete solution for scheduled OpenCart import automation.

Question5: How do I migrate products from one OpenCart store to another? Export the full catalog from the source store using any supported format. Import the resulting file into the destination store using a new import profile. Categories, product combinations, and attribute values that do not exist in the target store are created automatically on import, making cross-store OpenCart catalog migration clean and complete.

Question6: What happens if a bulk import fails or has errors? Every run is logged in Transfer Logs with a full record count. Partial failures show the count as X / Y with failures highlighted. Click the Log button on any row to review row-level error detail. Fix only the affected rows in your source file and re-import just those rows  there is no need to process the entire file again.

Question7: Which OpenCart versions does this extension support? Knowband‘s OpenCart Import Export Scheduler Pro is compatible with OpenCart 3.x.x, running on PHP 7.2 or higher and MySQL 5.6 or higher.

Question8: Can I schedule exports to be pushed automatically to an FTP server? Yes. In the export profile’s Transfer Settings, set the Export Destination to FTP / SFTP, configure the remote server credentials, and enable Cron. Thereafter, the Export Profiles Cron URL  when added to your server crontab  will automatically generate and push the export file to your FTP server on the schedule you define. Knowband‘s Opencart Import Export Extension additionally retains a local copy in Transfer Logs as a fallback for every automated run.

9. Tutorial

Admins can check the overall functionality through the tutorial video for the Opencart Import Export Extension

Build Any PrestaShop Form in Minutes- Form Studio All-in-One Module

Prestashop Form Studio is an all-in-one form builder module that allows store owners to create custom forms without coding. With a drag-and-drop interface and flexible field options, you can quickly build contact forms, surveys, feedback forms, registrations, quote requests, and more directly inside your PrestaShop store.

If you’ve ever tried to collect customer feedback, run a product survey, or simply set up decent custom forms in PrestaShop, you already know the pain. Either you stitch something together with workarounds, or you spend hours digging through settings that weren’t built for what you actually need.

That’s exactly the problem Form Studio is designed to solve. It’s a PrestaShop Form Builder module that lets store owners create virtually any type of form, like Contact forms, Return request forms, Feedback form, Quote Request Form, Product inquiry forms and many more. Whether you need a quick contact form or a multi-step customer survey, it just works.

What Is Form Studio?

Form Studio is an all-in-one PrestaShop Form Builder Addon designed to give store owners complete control over how they collect information from visitors and customers.

This PrestaShop custom form builder combines a visual drag-and-drop interface with a flexible field library, making form creation genuinely easy, even for non-technical users.

Updated September 30, 2026: Need contact, quote, or registration forms without writing code? The PrestaShop Online Form Builder module gives you a drag-and-drop editor to create custom forms and collect customer data easily. It is ideal for capturing enquiries, feedback, and registrations. Explore the full introduction and features of the PrestaShop Online Form Builder module on PrestaShop Marketplace.

Key Features of Prestashop Form Builder Module

1. Flexible PrestaShop Form Builder

The drag-and-drop form builder in PrestaShop sounds simple because it is. You pick a field, drop it where you want it, configure it, and move on. No HTML. No PHP. No headaches.

You can arrange fields in any order, group them into sections, and preview exactly how your form will look before it goes live. That alone saves a ton of back-and-forth.

2. Every Field Type You Need in PrestaShop Form Studio

PrestaShop feedback forms support a wide range of input types:

  • Text fields, text areas, and email fields: For names, emails, and short answers
  • Number and phone number fields: For phone numbers, age, quantities, and more
  • Dropdown menus: Great for categorizing inquiries
  • Checkboxes and radio buttons: Perfect for surveys and polls
  • File uploads: Ideal for warranty claims or support tickets
  • Date pickers: Useful for collecting scheduling or timeline information
  • Cloudflare Turnstile: Added protection against spam bots

As a PrestaShop Survey Form Builder Module, it also handles complex survey logic, including conditional fields that show or hide based on previous answers.

3. Built-in PrestaShop Contact Form Module

Your default PrestaShop contact form is fine. But Form Studio turns it into something genuinely useful.

You can create branded, multi-section contact forms that route submissions to the right department, auto-respond to customers, and keep everything organized in one dashboard.

4. Submission Management & Notifications

Every form submission is stored inside your PrestaShop admin panel. You can check entries, filter submissions, and set up email notifications so you never miss an important message.

If you’re running a PrestaShop Survey & Form Builder campaign, you can also analyze responses directly from the backend.

5. Direct Backend From Communication

When a user submits a form, the module instantly notifies the admin via email and sends an automated confirmation to the customer. Every submission is logged in the backend under its respective form, giving store admins a complete record of responses, along with the ability to follow up with any submitter directly, using a personalized message.

6. Predefined Templates

The PrestaShop Survey Form Builder allows users to create predefined templates for:

  • Admin email notifications
  • Auto-response emails
  • Direct message templates for store admins

Furthermore, inside the email templates, you can dynamically include field values submitted by customers using the PrestaShop Feedback Form Builder Module.

.

🤖 Want AI platforms and LLMs to recommend your products?

 

LLMS.txt Generator for PrestaShop

Generate AI-ready llms.txt files to improve your store’s visibility and discoverability across AI search engines and large language models.

Try the demo for Free Now →

 

Who Should Use It?

Knowband PrestaShop Form Studio is a no-code form builder for PrestaShop websites and is a solid fit for:

  • Small to mid-sized PrestaShop stores that need flexibility without hiring a developer
  • Marketers running customer satisfaction surveys or lead capture campaigns
  • Support teams that need structured, organized inquiry forms
  • B2B stores handling complex onboarding or quote request workflows

If you’ve been searching for a reliable PrestaShop Form Creator that grows with your needs, Form Studio checks every box.

Types of Forms You Can Create

Additional types of forms that you can create using Form Studio include:

  • Contact forms
  • Return request forms
  • Product inquiry forms
  • B2B wholesale forms
  • Job application forms
  • Event registration forms
  • Warranty claim forms
  • Customer satisfaction surveys

How to Build a Form in Minutes

Here’s the basic workflow:

  1. Install Form Studio from your PrestaShop module manager
  2. Open the module and click “Create New Form”
  3. Drag your fields into the builder canvas
  4. Configure email configurations
  5. Place the form on any page using the configuration of where to display or hook

Frequently Asked Questions

1. What is Form Studio for PrestaShop?

Form Studio is an all-in-one PrestaShop Form Builder module by Knowband that lets you create contact forms, surveys, multi-step forms, and more using a visual drag-and-drop editor without any coding.

2. Can I use Form Studio as a PrestaShop Survey Module?

Yes. Knowband Prestashop Survey Module fully supports survey-style forms with multiple question types, conditional logic, rating fields, and submission analytics built directly into the PrestaShop admin panel.

3. Does Form Studio replace the default PrestaShop contact form?

It can. Form Studio works as a powerful PrestaShop contact form module replacement, giving you full design control, custom routing, and auto-response capabilities that the default form simply doesn’t offer.

4. Do I need coding knowledge to use the prestashop form builder?

Not at all. The entire PrestaShop Form Builder by Knowband experience is visual and no-code. You configure everything through a graphical interface inside your admin panel.

5. Is Form Studio compatible with all PrestaShop themes?

Form Studio is built to be theme-agnostic. It adapts to your store’s existing styles and can be placed on any page using hooks or shortcodes.

Conclusion

Building forms in PrestaShop doesn’t have to be technical.

With Prestashop Form Studio Builder Module, you get a true drag-and-drop PrestaShop Form Builder that handles everything from a simple contact form to a full-scale survey campaign inside one clean, easy-to-use module.

If your store currently relies on workarounds or a basic contact form that barely does the job, it’s time for an upgrade.

→ Try Prestashop Form Studio today and build your first form in minutes

 

 

How to Automatically Sync PrestaShop Products to eBay Without Manual Uploads

Quick Answer: Knowband PrestaShop eBay Marketplace Module is an integration plugin that connects your PrestaShop store to eBay, letting you manage your eBay products directly from your PrestaShop back office.

eBay attracts over 132 million active buyers globally, yet most PrestaShop store owners still manage their eBay listings by hand. That means copying product titles, re-entering prices, and manually updating stock every time something changes. Sound familiar? The process eats hours each week and leaves far too much room for costly errors. There is a better way, and it starts with the right PrestaShop eBay Integration Module.

What is the PrestaShop eBay Integration Module?

The PrestaShop eBay Integration Module is an e-commerce plugin that connects your PrestaShop store directly to your eBay seller account. It automates product listing, inventory updates, order imports, and price synchronisation, all from inside your PrestaShop admin panel. Store owners who sell across multiple channels use it to eliminate the double-entry problem that slows down growth. Knowband developed this module specifically for PrestaShop merchants who want to expand to eBay without building a separate workflow for it.

Core Features of the PrestaShop eBay Marketplace Integration Module

Bulk Product Listing from PrestaShop to eBay

The eBay PrestaShop Integrator lets you push entire product categories to eBay in one action. You map your PrestaShop categories to eBay categories once, and the module handles the rest. This removes the need to list products one by one, which is particularly valuable for stores with large catalogues.

Real-Time Inventory and Price Sync

Whenever a product sells on either platform, stock levels update across both stores automatically. Additionally, price changes made in PrestaShop reflect on eBay without manual intervention. This two-way sync keeps your data accurate regardless of where the sale happens.

Order Import and Centralised Management

eBay orders come into your PrestaShop back office directly through the PrestaShop eBay API Integration Module. Furthermore, you process, ship, and track everything from one dashboard. There is no need to log into eBay separately just to manage fulfillment.

Attribute and Variation Mapping

Products with multiple sizes, colors, or configurations map cleanly to eBay’s variation system. The eBay PrestaShop Connector handles attribute matching so your listings display correctly on eBay without reformatting each variant by hand.

Category and Condition Mapping

The Prestashop eBay Marketplace Module lets you define eBay-specific conditions (new, used, refurbished) and assign the right eBay category to each product group. Moreover, this ensures your listings meet eBay’s requirements and appear in the correct search results on the marketplace.

The Standout Feature: Profile-Based Listing Rules

Most integration modules push your PrestaShop data to eBay as-is. The PrestaShop eBay Integration Addon goes further by letting you create listing profiles and predefined rule sets that control how specific product categories appear on eBay. Want to apply a 10% price markup to all electronics listed on eBay, while keeping apparel at the original price? A profile created through the Knowband Prestashop eBay Marketplace Module handles that without touching individual products.

What makes this genuinely different is flexibility at scale. You are not locked into a one-size-fits-all sync. Instead, you define the rules once per product group, and the module applies them automatically on every subsequent upload or update. How many integration tools let you do that without custom development?

Frequently Asked Questions

How do I sync PrestaShop products to eBay automatically?

The PrestaShop eBay Integration Module syncs your products automatically by connecting both platforms through eBay’s official API. After initial setup and category mapping, the module pushes new products and updates existing listings whenever changes occur in your PrestaShop catalog. No manual uploads are required after configuration.

Does the PrestaShop eBay Integration Plugin support product variations?

The PrestaShop eBay Integration Plugin fully supports product variations including size, color, and custom attributes. It maps PrestaShop combinations to eBay’s variation structure automatically, so multi-variant listings appear correctly on eBay without manual reformatting.

Is the PrestaShop eBay Integration Module compatible with all PrestaShop versions?

The PrestaShop eBay Integration Module is built for PrestaShop 1.6 and above, including PrestaShop 8.x. Additionally, it connects through eBay’s official API, which means it works across all major eBay marketplaces including eBay US, UK, Germany, and Australia.

How does the eBay PrestaShop Connector handle orders?

The eBay PrestaShop Connector imports eBay orders directly into your PrestaShop admin panel in real time. You manage shipping, tracking, and fulfillment from PrestaShop alone — there is no need to process orders separately inside eBay Seller Hub.

Will the module keep my inventory accurate if I sell on both PrestaShop and eBay simultaneously?

The PrestaShop eBay API Integration Module runs a two-way inventory sync that updates stock levels on both platforms whenever a sale occurs. Therefore, if a product sells on eBay, PrestaShop reflects the new quantity immediately, and vice versa. This prevents overselling across channels.

How much does the PrestaShop eBay Integration Addon cost?

Pricing for the PrestaShop eBay Integration Addon varies by provider and license type (single store vs. multi-store). Most commercial modules are available as one-time purchases or annual subscriptions. It is best to check the official module page on Knowband’s website for current pricing and what each plan includes.

Can I control how my products appear on eBay pricing, titles, and conditions?

The module includes profile-based listing rules that let you set custom pricing rules, eBay-specific titles, and product conditions per category. Consequently, you can list the same product at a different price on eBay than on your PrestaShop store, without editing each product individually.

Start Selling on eBay Without the Manual Work

The PrestaShop eBay Integration Module removes the biggest barrier to multichannel selling: the operational cost of keeping two platforms in sync. Your catalog, inventory, pricing, and orders all connect through one module, and the setup pays for itself the first week you stop doing it manually. Visit Knowband to explore the module, review current pricing, and start your eBay expansion on a foundation that actually scales.

 

Build an Amazon-Like Marketplace in PrestaShop with a Multi-Vendor Module

Yes! You can create a marketplace in PrestaShop by installing a PrestaShop Multi-Vendor Marketplace Module by Knowband that allows multiple vendors to register, manage their own store, and list products individually. This setup of the PrestaShop Multi Vendor Marketplace gives you centralised admin control, automated commission tracking, and individual vendor dashboards, without hiring a technical team to build from scratch.

Why PrestaShop Works Well for a Multi-Vendor Marketplace

PrestaShop is an open-source eCommerce platform used by over 300,000 merchants worldwide. Its modular structure makes it a practical choice for marketplace development because you extend what already works rather than rebuilding core functionality.

The prestashop platform natively supports multiple languages, currencies, and easy-to-handle store configurations. When you add a PrestaShop Multi Vendor Module  on top of that foundation, you get a marketplace that handles seller management, product listings, and order routing in one place. That combination is what makes it a genuine alternative to building on a proprietary platform.

According to most developers and merchants who have worked with both PrestaShop and competing platforms, PrestaShop offers more customisation control at a lower total cost, particularly for businesses that want marketplace features without the licensing fees of enterprise solutions.

What a Multi-Vendor Module Actually Does

The Prestashop Multivendor Module allows the sellers to register theirself as seller and list products. All the functionalities like approving seller, product, commission are handled by store admin from the backend.

Key Features of Knowband Prestashop Multivendor Listing Module

Vendor Registration and Approval
 Sellers register through a front-end portal. The admin reviews each application and approves or rejects it. Furthermore, approved vendors get access to their own dashboard where they manage listings, orders, and payouts.

Separate Seller Storefronts
 Each vendor operates their own product catalogue within your marketplace. They set prices, manage stock, and define their shipping for their listings. All purchases, however, go through your central checkout, so payment collection and commission stays under your control.

Commission Tracking and Payouts
 The module automatically calculates your platform commission for every sale. For example, if you set a 12% commission on electronics, the system deducts that amount and generates a payout report for the vendor. You process the remaining balance manually or through an integrated payment options.

Step-by-Step: How to Set Up Your PrestaShop Marketplace

Step 1- Install PrestaShop
 Download the latest PrestaShop version from the official site. Run the installation, set your store name, base currency, and primary language. Keep the admin credentials secure from the start.

Step 2 – Pick and Install a Multi-Vendor Module
 Go to the PrestaShop Addons marketplace and search for PrestaShop Multi Vendor Module. Webkul’s Multi-Vendor Marketplace module is a dependable choice with broad feature coverage. Install it through the Module Manager inside your admin panel.

Step 3- Configure Vendor Rules
 Open the module settings and define how vendor registration works. Set whether vendors need manual approval or can activate automatically. Establish your commission rates at this stage — either a flat percentage across all categories or different rates per category.

Step 4- Enable Vendor Storefronts
 Turn on public-facing vendor pages. Each seller gets a dedicated storefront page showing their products, ratings, and basic business information. This gives buyers confidence and gives vendors a reason to promote their store URL.

Step 5- Set Up Order Routing
 Configure how orders split between vendors when a buyer purchases from multiple sellers in one transaction. Most modules handle this automatically, but verify the settings match how you want fulfillment to work.

Step 6- Onboard Your First Sellers
 Open registration and invite sellers to sign up. Prepare a short onboarding guide covering how to list products, set shipping options, and read their dashboard reports. Clear instructions reduce support requests significantly.

Why Customers Prefer Knowband’s Prestashop Multi Seller Listings Module

A functional marketplace needs more than product listings. These features separate a professional setup from a basic one:

  • A vendor dashboard with real-time order and earnings data
  • Product approval controls so admin reviews listings before they go live
  • A customer review and rating system for each vendor
  • Dispute management plugins for handling order problems between buyers and sellers
  • SEO-friendly vendor pages that search engines can index independently
  • Automated commission reports that vendors can download themselves

FAQ

Q1: Do I need a developer to build this marketplace?
 Not necessarily. Prestashop Multi-vendor Marketplace module are designed for installation through the admin panel. However, if you want custom design changes or specific integrations, a developer saves time.

Q2: What is the best multi-vendor module for PrestaShop?
 Knowband’s Prestashop Multi-Vendor Marketplace module covers the widest range of features including commission management, vendor dashboards, and shipping configuration.

Q3: Can vendors set their own shipping rates?
 Yes. This Prestashop Multivendor Marketplace modules allow vendors to define their own carriers, delivery zones, and shipping costs independently from the main store settings.

Q4: How do vendor payouts work?
 The Prestahsop Multi Vendor marketplace module owner collects all payments at checkout. This marketplace creator module generates commission-based payout reports for each vendor. You then transfer the vendor’s share manually or through tools like PayPal, bank transfer, or a payout integration.

Q5: How many vendors can PrestaShop support?
 There is no hard vendor limit. Performance depends on your hosting environment. A well-configured VPS or dedicated server handles hundreds of active vendors and thousands of product listings without issues.

Conclusion

PrestaShop gives you a solid starting point, and the PrestaShop Multi Vendor Marketplace module fills in everything else needed to run a working marketplace. Set up vendor registration, configure your commissions, enable seller storefronts, and you have a platform where independent sellers can operate alongside each other under your brand. The technical barrier is lower than most people expect, and the operational control you retain is higher than most hosted marketplace solutions allow.

 

Why AI Isn’t Recommending Your Products (And How to Fix It)

Direct answer: AI usually ignores your products when your data lacks structure, your URLs confuse crawlers, and your website fails LLM protocols. Use a PrestaShop llms.txt generator and clean URLs to improve AI visibility and increase your chances of being surfaced in answers.

Understanding the Real AI Visibility Problem

Most merchants blame spammy backlinks for the real AI visibility from LLMs. However, that misses the point. AI models like ChatGPT, Gemini, and Claude read your site differently than Google does. They need explicit instructions from your content. Additionally, they require clean URLs and structured text files.

Your product may rank on Google. Yet, that does not guarantee AI visibility. These two systems operate separately. Therefore, you need a dedicated strategy for large language models on your PrestaShop store.

Why Traditional SEO Fails for LLMs

  • Googlebot crawls JavaScript. LLMs do not.
  • Keywords matter to search engines. Structure matters to AI.
  • Backlinks build domain authority. Meanwhile, clean data builds machine trust.

A furniture store ranked #2 for “office chair” on Google. Nevertheless, ChatGPT never recommended their products. Why? Their URLs contained random numbers. Additionally, their site lacked an LLMs.txt file. Consequently, AI could not fetch the information to their systems.

Step-by-Step Fixes to Regain AI Recommendations

Follow these three steps. Each targets a specific LLM requirement for your PrestaShop store.

Step 1: Deploy an LLMs.txt File Immediately Using the Knowband Prestashop LLMS.txt File Generator

Use a PrestaShop llms.txt file generator addon to generate an llms.txt automatically  to create a machine-readable map of your store. This file helps AI systems locate key pages faster

How to create LLMs.txt for PrestaShop:

  • Download the PrestaShop LLMs.txt Generator Module
  • Add the store details in the configurations
  • Select the crawlers of LLMs models like gptbot, Claude Anthropic bot, DeepSeek bot, and many more which you want to be active
  • Select the content that you want to add on the LLMs.txt file, e.g., specific products, categories, or CMS pages
  • Run the cron job. Your LLMs.txt file will update automatically on the server

Practical example: An electronics retailer, Eddie Sales, added an LLMs.txt file pointing to 500 product pages. Within one week, Claude and Perplexity started recommending their electronic items. As a result, AI traffic increased by 180%.

Step 2: Optimise Every URL for AI Parsing

AI models read URL content. They extract meaning from slashes and words. For instance, a URL like /p?id=3847 tells AI nothing. In contrast, a URL like /men-leather-boots-brown-size-10 tells AI everything.

How to optimize PrestaShop URLs:

  • Download the PrestaShop SEO URL Optimizer Module
  • Remove product ID, category ID, and supplier ID from the URLs of the catalog
  • Remove .html from the URLs of the catalog
  • Manage duplicate URL rewrite products

Example before optimization:
https://psm.knowband.com/urlcleaner/16/en/casual-dresses/3-printed-dress.html

Example after optimization:
https://psm.knowband.com/urlcleaner/16/en/casual-dresses/printed-dress.html

After enabling the remove product ID option, the module removes the product ID from the URL. Both product URLs become clean and identical. This PrestaShop SEO URL Optimiser Module offers three redirection options including 301, 302, and 303 to the store owner.

Step 3: Write Product Data for Machine Consumption

LLMs prefer bullet points over paragraphs. Moreover, they value consistency over creativity. Write every product description as structured data first. Then, add human-friendly text second.

Machine-ready product format in product description from the backend:

  • Start with a one-sentence summary
  • List five to seven attributes as bullet points
  • End with a use-case statement

For example, a kitchenware brand rewrote 200 product descriptions. Each followed the same template. Each included material, dimensions, care instructions, and best use. As a result, AI recommendations tripled within two weeks.

Advanced AEO and GEO Strategies

Answer Engine Optimisation (AEO) and Generative Engine Optimization (GEO) require different tactics than traditional SEO. Therefore, apply these three techniques immediately on your PrestaShop store.

Use Direct Answers Above Product Descriptions

Place a 40–60-word direct answer at the top of every product page. Answer one specific question. For example, “What problem does this solve?” or “Who should buy this?” AI models extract these answers for featured snippets and voice search.

Build Internal Linking with Descriptive Anchor Text

LLMs follow links to understand relationships. Hence, use anchor text like “see our waterproof jackets” instead of “click here.” This teaches AI the context between products in your PrestaShop catalogue.

FAQ

Q1: What exactly is an LLMs.txt file?

A plain text file that lists your website’s most important pages. AI models can use it to better discover and understand your PrestaShop content.

Q2: How does PrestaShop SEO URL optimisation affect ChatGPT recommendations?

ChatGPT and similar AI systems use URL structure as a context signal. Clean, descriptive URLs help them understand product categories and attributes more clearly.

Q3: Can I use my existing sitemap.xml instead of LLMs.txt?

No. A sitemap.xml helps search engines, while an LLMs.txt file is a simpler, emerging format aimed at improving AI accessibility and content discovery.

Q4: How often should I update my LLMs.txt file?

Update it whenever you add or remove products. Weekly updates work well for most stores, while large catalogs may benefit from daily updates.

Q5: Will fixing URLs hurt my existing Google rankings?

No, if you use proper 301 redirects. Search engines typically handle this smoothly, and rankings stabilize over time.

Q6: Which AI crawlers should I enable in the LLMs.txt generator?

Enable GPTBot, Claude (Anthropic bot), PerplexityBot, and DeepSeek bot. You can also include Google-Extended for Google’s AI systems.

Conclusion

AI ignores your PrestaShop products for one clear reason. You have not made your site readable for language models. Google rankings no longer guarantee AI visibility. Therefore, deploy an LLMs.txt file using the PrestaShop LLMs.txt Generator Module today. Moreover, optimise every URL with the PrestaShop SEO URL Optimiser Module. Finally, write product data as structured answers. These three actions take one weekend. Yet, they have delivered AI recommendations for years. Instead, start building for LLMs. Your PrestaShop products deserve a place in every AI answer.

Best PrestaShop Product Recommendation Module to Boost Cross-Selling Sales

Quick Answer: The PrestaShop Automatic Related Product module is the most effective PrestaShop product recommendation solution available today. This automatically displays related, alike, and cross-sell products on any product page, home page, cart pages and many more, helping store owners increase average order value, improve product discovery, and reduce bounce rates without manual configuration.

What Is the PrestaShop Automatic Related Product Module?

The PrestaShop Automatic Related Product module is a powerful addon that intelligently links products together based on categories, tags, attributes, or custom rules. Unlike manual product linking, this addon automates the entire process , saving time while delivering a personalised shopping experience at scale.

Store owners who install the PrestaShop-related products addon immediately gain access to smart recommendation widgets that appear on product pages, checkout screens, and even email follow-ups. Therefore, customers see relevant suggestions exactly when purchase intent is highest.

Key Features of the PrestaShop Advance Related Product Module

Most related product modules stop at basic category matching, and that is exactly where they fall short. The PrestaShop advance related product extension, however, goes further by giving store owners real control over how products are connected and where recommendations show up.

Here is what it actually does:

Automatic product linking: Instead of manually pairing every product, the module reads shared attributes, categories, and tags to make those connections for you. As a result, when you add a new product, it gets picked up straight away with no extra steps needed.

Cross-sell widget placement: You are not limited to just the product page. In fact, recommendation blocks can appear on product detail pages, inside the cart, and even on the order confirmation screen. That means there are multiple touchpoints where a customer might spot something worth adding to their order.

Alike product suggestions: Sometimes a customer is simply not sold on what they are looking at and just needs to see something similar. For that reason, this feature surfaces comparable products before the visitor leaves, which cuts down on those dead-end browsing sessions that lead nowhere.

Custom rules engine: Not every store has the same needs, and that is perfectly fine. That is why admins can set their own priorities, cap how many products appear, control the display order, and exclude anything that should not show up in recommendations, all from one place.

Responsive design: Whether a customer is shopping on a phone, tablet, or desktop, the recommendation sliders and grids adjust to fit the screen properly. In other words, nothing looks out of place or broken regardless of the device being used.

Multi-language and multi-shop support: For stores running across different regions or operating more than one shop, this feature handles everything from a single back-office. As a result, each shop can have its own setup without things getting unnecessarily complicated.

Why the PrestaShop Related Products Module Outperforms Manual Linking

Manual related product linking demands constant maintenance, especially as store catalogs grow. However, the Prestashop Automatic Related Product system eliminates that overhead entirely.As your catalog grows or changes, product relationships update on their own so your recommendations stay relevant without you having to revisit them manually. Keeping that consistency across a large product range by hand simply is not realistic. Product recommendations, when set up well, can become one of the stronger revenue drivers in your store.

🤖 WANT TO RECOMMEND YOUR PRODUCT THROUGH AI Assistant?

 

Recommend Products  with a Prestashop AI Chatbot using Popular LLMs

 

Answer customer questions 24/7, suggest products based on the queries, reduce cart abandonment, and free up your support team, all with one smart AI Chatbot for Prestashop.

Try the demo for Free Now →

Frequently Asked Questions

Q: What is the PrestaShop Automatic Related Product module for PrestaShop?

A: It is a PrestaShop addon that finds and shows related, similar, or complementary products on product and cart pages based on rules you define. No manual linking required.

Q: How does it help increase revenue?

A: Suggestions appear on the product page and in the cart, where shoppers are already considering a purchase. Seeing a relevant add-on at that moment makes it easy for them to throw it in which naturally lifts your average order value.

Q: Will it work with my theme?

A: In most cases, yes. The module connects through PrestaShop’s native hook system, so it fits into standard and custom themes without extra styling work.

Q: Can I control how many products show up in each widget?

A: Yes. From the settings panel you can set a minimum and maximum count, choose how products are sorted  by price, popularity, or relevance — and leave out any products or categories you do not want included.

Q: Does it work across multiple stores?

A: Yes. If you run more than one shop, you can set different recommendation rules for each from the same back-office.

Q: How is the alike product feature different from standard related products?

A: Standard-related products need to be assigned by hand. The alike product feature matches items by shared attributes and categories automatically,  so even products you added last week get picked up without any extra effort on your part.

Final Thoughts

If your store has more than a handful of products, manually maintaining related product links is a losing battle. Things get missed, catalogs change, and the whole setup quietly stops working. This Knowband Prestashop Product Recommendation Module takes that off your plate. You set your rules once, and it handles the matching from there, on product pages, in the cart, and at checkout. For most store owners, that kind of set-and-forget reliability is what makes it worth installing.

Boost Your ROI: AI Chatbots & Video Carousels in OpenCart Mobile Apps

In today’s fast-moving digital landscape, having a powerful mobile presence is no longer optional,  it is essential. Shoppers increasingly prefer browsing and buying through their smartphones, making it critical for store owners to invest in a robust OpenCart Mobile App. Knowband’s feature-rich OpenCart Mobile App Builder empowers merchants to deliver engaging, conversion-focused shopping experiences without writing a single line of code.

Why Your Business Needs an OpenCart eCommerce Mobile App

Consumer behaviour has fundamentally shifted. Desktop traffic continues to decline as mobile commerce grows year over year. An OpenCart eCommerce Mobile App puts your store directly in your customer’s pocket, enabling faster browsing, easier checkout, and stronger brand loyalty.

Unlike a mobile-responsive website, a dedicated app built with the OpenCart Mobile App Maker offers push notification support, offline browsing capabilities, and app-store visibility,  all of which translate directly into higher repeat purchase rates and reduced cart abandonment.

Introducing Knowband’s OpenCart Android and iOS Mobile App Builder Plugin

The Knowband OpenCart Android and iOS Mobile App Builder Plugin is a complete solution for merchants who want to launch native-quality apps on both major platforms simultaneously. You do not need separate development teams or expensive agency contracts. The plugin handles everything from design to deployment, making it the most practical choice for growing OpenCart businesses.

Key capabilities of the plugin include:

Real-Time Editor: Customize your app’s layout, color scheme, banners, and navigation menus through a visual drag-and-drop interface. Changes reflect instantly, so you can preview exactly what your customers will see before going live.

Multi-Platform Publishing: The OpenCart Android and iOS Mobile App Builder Plugin generates fully compatible builds for both the Google Play Store and Apple App Store, cutting your launch timeline significantly.

Push Notifications: Send targeted promotions, flash sale alerts, and back-in-stock notifications directly to your shoppers’ lock screens, one of the highest-converting marketing tools available to mobile retailers.

Trending Video Widgets: Turn Browsers into Buyers

Short-form video content has redefined how people discover products. The OpenCart Mobile App Creator by Knowband includes a Trending Video Carousel feature from Opencart Video Manager Plugin that brings a social-media-style experience directly into your store app.

Static product images often fail to communicate texture, scale, or real-world usage. Video fills this gap by giving shoppers a near-tactile sense of what they are purchasing. With the video carousel and Floating Widgets, you can:

  • Feature user-generated content and influencer reviews to build social proof
  • Showcase product demonstrations directly on category or home pages
  • Drive impulse purchases by pairing short clips with “Shop Now” call-to-action buttons

For best results, keep video clips between 15 and 30 seconds. This length maintains fast loading speeds while delivering enough context to reduce buyer hesitation.

  • see exactly where customers are getting confused and refine your product descriptions or AI prompts accordingly.

🤖 Also on OpenCart?

 

Automate Store Conversations with an OpenCart AI Chatbot using Popular AI

 

Answer customer questions 24/7, reduce cart abandonment, and free up your support team, all with one smart AI Chatbot for OpenCart.

Try the demo for Free Now →

Smart AI Chatbot Integration for 24/7 Customer Support

Modern shoppers expect answers immediately. The OpenCart Mobile App from Knowband supports AI chatbot integration, giving your store the ability to respond to customer queries around the clock, even outside business hours.

A well-configured chatbot handles the most common customer service tasks efficiently:

  • Order Tracking: Customers can check real-time shipping status without calling your support team.
  • FAQ Responses: Common questions about return policies, sizing, and payment methods are resolved instantly.
  • Product Suggestions: The bot can guide shoppers toward relevant items based on their browsing behavior and queries.

The result is a measurable reduction in support ticket volume and a smoother checkout journey that keeps customers moving toward purchase rather than abandoning their carts in frustration.

Actionable Tips for Maximising Your OpenCart Mobile App

To get the most out of the OpenCart Mobile App Builder, follow these best practices:

  1. Map your top support queries and configure your chatbot to handle at least the top 10 most common questions your team receives.
  2. Place the video carousel above the fold on your home page for maximum first-impression impact.
  3. Schedule push notifications strategically, time them to coincide with high-traffic periods such as lunch hours or evenings.

Conclusion

A well-built OpenCart eCommerce Mobile App is one of the most impactful investments a merchant can make in today’s mobile-first marketplace. With the Knowband OpenCart Mobile App Builder, you gain access to enterprise-level features,  trending video carousels, smart chatbot support, push notifications, and dual-platform publishing through a single, user-friendly plugin.

Whether you are launching your first app or upgrading an existing one, the OpenCart Mobile App Maker Plugin from Knowband provide everything you need to deliver a modern, high-converting shopping experience that keeps customers coming back.

Ready to grow your mobile revenue? Explore the Knowband OpenCart Android and iOS Mobile App Builder Plugin today.

OpenCart Multi-Channel Integration: Sync Google Shopping, Etsy, and eBay from One Store

Introduction: One Store, Three Powerful Sales Channels

Research from Shopify’s 2024 Commerce Report confirms that merchants selling on three or more channels generate significantly more revenue than single-channel sellers. The logic is simple that more visibility means more buyers. But managing separate platforms manually leads to stock errors, missed orders, and wasted hours.

So here is the real question: What if you could manage Google Shopping, Etsy, and eBay all from your OpenCart backend without logging into each platform separately?

That is exactly what the right set of OpenCart integration modules makes possible. Knowband builds each of these connectors specifically for OpenCart merchants who want reliable, low-maintenance multi-channel selling.

Marketplace selling has become an important part of the multichannel ecommerce strategy. According to a 2024 DHL report, 63% of ecommerce businesses sell on at least three online platforms, showing how common it has become for merchants to reach customers through more than one sales channel. In the case of OpenCart, while the opportunity to explore existing marketplaces may help reach a wider discovery of products, it also presents the problem of maintaining consistency in listings, inventory, and orders. This is where selling on the top marketplaces with an OpenCart store can be considered as part of a multichannel selling approach.

OpenCart Google Shopping Integration Module

The OpenCart Google Shopping Integration module connects your product catalog directly to Google Merchant Center. This module auto-generates a Google-compliant XML feed, maps your categories to Google’s taxonomy, and keeps prices and stock levels updated in real time.

Key Highlights

  • Automated feed generation: No manual XML exports needed
  • Real-time price and inventory sync: Supports real-time updates from your store to Google Shopping
  • GTIN, MPN, and brand field support: improves product eligibility and visibility
  • Feed scheduling: submit updates hourly, daily, or weekly automatically

Why Google Shopping  Matters for your Opencart Store

Google Shopping targets buyers who are already searching for your product. A clean, accurate feed from the OpenCart Google Shopping Module puts your listings in front of high-intent shoppers without requiring a large ad budget. Furthermore, free listings alone can drive consistent, qualified traffic back to your store.

OpenCart Etsy Marketplace Extension

The OpenCart Etsy Marketplace Extension bridges your OpenCart catalogue with Etsy’s marketplace, which attracts over 90 million active buyers looking for unique, handmade, and vintage products. It handles Etsy’s specific listing requirements,  custom variations, renewal cycles, and category tags, all managed from OpenCart.

Key Highlights

  • Product variation sync: Maps OpenCart options like size, color, and material to Etsy listing variants
  • Listing renewal management: Provides many synchronisation features like relisting, listing, and many more
  • Tag and category mapping: Pulls relevant keywords from OpenCart to improve Etsy search visibility
  • Order import: Etsy orders flow directly into your OpenCart dashboard

Why Etsy Marketplace Matters for Your Opencart Stores

Etsy’s audience actively searches for products they cannot find on mainstream platforms. If your store carries handmade, customizable, or niche items, this extension puts them in front of exactly the right buyers. Moreover, centralised order management means you never lose track of an Etsy sale again.

OpenCart eBay Marketplace Connector

The OpenCart eBay Marketplace Connector, also referred to as the OpenCart eBay Marketplace Extension,  links your OpenCart store to eBay’s global marketplace, one of the highest-traffic e-commerce platforms worldwide. Furthermore,  automates product listing, bidirectional inventory sync, and order management between both platforms.

Key Highlights

  • Bulk product listing: List your entire OpenCart catalogue to eBay in one action
  • Bidirectional inventory sync: A sale on eBay instantly updates stock in OpenCart
  • Automated order import: Ebay orders appear in your OpenCart backend without manual entry
  • Pricing rules: Apply platform-specific markups to account for eBay fees automatically

Why eBay Matters for Your Store

eBay draws buyers who compare prices across sellers before purchasing. Getting your products listed there increases competitive visibility significantly. Furthermore, the OpenCart eBay Marketplace Extension ensures your stock numbers stay accurate across both platforms, eliminating the risk of overselling.

Why Running All Three Together Makes Sense

Each platform serves a different buyer intent. Google Shopping captures search-driven traffic. Etsy attracts niche and handmade product seekers. eBay pulls in price-conscious, high-volume shoppers. Together, they cover a wide spectrum of the buying journey.

When all three connect to a single OpenCart store, inventory updates once and syncs everywhere. Orders from all channels land in one dashboard. There is no switching between platforms, no spreadsheet reconciliation, and no overselling risk.

Conclusion

Multi-channel selling is no longer optional for growing OpenCart stores; it is the standard. The OpenCart Google Shopping Integration Extension, the OpenCart Etsy Marketplace Extension, and the OpenCart eBay Marketplace Connector each solve a specific visibility problem. Together, they turn your OpenCart store into a fully connected, automated sales hub.

Start with the channel that fits your product type best. Then expand. The infrastructure is already there