AI Reporting for CS-Cart

Note: Before installing the add-on, extract the downloaded package.

1. Install the License Manager add-on first.
2. Then install the CS-Cart AI Reporting add-on.
3. Follow the license activation steps to generate your license key.

CS-Cart AI Reporting is an AI-powered reporting solution that enables administrators and vendors to generate reports using simple natural language queries. The add-on converts user questions into optimized SQL queries using Generative AI and Natural Language Processing (NLP), eliminating the need for manual database queries or technical knowledge.

Powered by Google Gemini, OpenAI, and the Vanna AI Framework, the extension delivers fast, accurate, and meaningful reports related to products, orders, customers, vendors, categories, and reviews. Administrators can also configure their preferred Large Language Model (LLM) provider using API credentials for flexible AI integration.

Key Features

• Generate reports using simple natural language questions.
• Automatically converts user queries into optimized SQL statements.
• Supports Product, Order, Customer, Vendor, Category, and Review reports.
• Powered by Google Gemini, OpenAI, and Vanna AI Framework.
• Accurate AI-generated reporting using NLP-based query understanding.
• Supports both Admin and Vendor reporting.
• Admin can configure preferred AI model through API credentials.
• Schema synchronization for improved SQL generation accuracy.
• Faster reporting with structured and organized results.
• Eliminates the need for manual SQL knowledge.

View Full Blog

AI Reporting Configuration

The administrator can configure the AI Reporting module by entering the Base URL, API Token, and Prefix required for NLP-to-SQL communication. The module also provides a Sync Schema option that updates the database structure used by the AI model, ensuring accurate SQL query generation.

Product Reports

Administrators can simply ask questions such as "Show Me All Products" to instantly generate complete product reports without writing SQL queries.

Order Reports

The add-on allows administrators to retrieve order information using plain language queries such as "Show Me Orders", providing quick access to order-related data.

Review Reports

The extension allows users to retrieve product review reports through conversational queries, helping administrators monitor customer feedback more efficiently.

Vendor Reports

Administrators can generate reports related to marketplace vendors using natural language without requiring database knowledge.

AI Category Reports

Users can filter reports by category using conversational queries such as "Show Products with Electronics Category", allowing faster access to category-specific information.

Minimum System Requirements

• Python 3.10
• Minimum 1 GB Storage Space
• Minimum 1 GB RAM
• Google Gemini or OpenAI API Key
• Server Key and Certificate Files (for Flask API)
• Active Server Port (5000)
• SSH Access for AI Module Installation

Benefits for Store Owners

• Generate reports without writing SQL queries.
• Save time through AI-powered automated reporting.
• Improve reporting accuracy using NLP and Generative AI.
• Access business insights using simple conversational queries.
• Enable vendors to generate self-service reports.
• Configure preferred AI provider according to business requirements.
• Reduce dependency on technical resources for reporting.
• Obtain faster and organized reports for better decision-making.

Support Information

If you face any issues while using the add-on, our support team is available to assist you.

• Free 3 months of technical support included.
• Option to purchase extended support.
• Create a ticket at Webkul HelpDesk or email support@webkul.com.
• Free lifetime module updates.
• Read our Support Policy for more information.