Guide for Adobe Commerce AI Reporting

Magento 2 AI Reporting(Adobe Commerce) extension is an outstanding tool that enhances data analysis using cutting-edge AI and Natural Language Processing (NLP) technologies.

It lets you easily retrieve information about customers, orders, products, wish lists, and reviews.

Just enter your queries, and the system will generate clear, visual data, allowing you to make well-informed decisions quickly.

Check a brief overview of the extension –

To use the Magento 2 AI Reporting effectively, ensure that you meet the following minimum system requirements and setup configurations:

Minimum System Requirements:

• RAM: 8 GB
• Storage Space: 4 GB
• Python Version: 3.10

API Setup:

• Server Key and Certificate Files: Required for Flask API integration.
• Ports: Ensure that port 5000 is open and available.
• API Key: Obtain and configure an API key from a large language model provider such as OpenAI or Gemini.

By meeting these requirements, you can ensure a smooth and effective implementation of the Magento 2 AI Reporting.

• You can use NLP2SQL technology to convert natural language into SQL queries for seamless data retrieval.
• Analyze data with interactive charts.
• You can ask queries like sales, customer, order, product, wishlist, and review.
• Save the chart and download the query results.
• Search and copy the SQL query from the response.
• Admins have the option to select the LLM Provider through API setup.
• Ask queries in AI Dashboard in NLP and view responses in table, line, pie, bar, and graph.

To install AI module, we need SSH access. You can also check the AI Models Server Installation Guide and ChromaDB Installation Guide for reference.

The installation is quite simple just like the standard Magento 2 extensions.

#Download Module

Firstly, you need to log in to the Webkul Store, go to My Account>My Purchased Products section, verify, and then download and extract the contents of this zip folder on the system.

#Upload Folder

Once the module zip extracts, follow path src>app and then copy the app folder into the Magento 2 root directory on the server as shown below:

# Run Commands

You need to run the following commands:

php bin/magento setup:upgrade

php bin/magento setup:di:compile

php bin/magento setup:static-content:deploy

php bin/magento indexer:reindex

php bin/magento cache:flush

Language Translation

For translating the module language, navigate through src/app/code/Webkul/AIDashboard/i18n/ and edit the en_US.csv file.

Thereafter, rename the CSV as “en_SA.csv” and translate all right side content after the comma in the Arabic language. After editing the CSV, save it.

Now, upload it to the path src/app/code/Webkul/AIDashboard/i18n/ where the installation of Magento 2 is on the server.

The module translates into the Arabic Language. It supports both RTL and LTR languages.

The user can edit the CSV like the image below.

After installing the module you need to setup database.

Run Following Command via terminal to save data database:

php bin/magento s:db-schema:generate-reports --separate=false

php bin/magento s:db-schema:generate-reports --separate=true --dbname='DbName' --username='DbUser' --password='DbPassword'

php bin/magento s:db-schema:generate-reports --unset=true

php bin/magento setup:upgrade

Configuration:

Once you complete the installation of Magento 2 AI Reporting, login to admin dashboard. Go to Store> Configuration> Webkul AI Reports.

Enable AI Reports: Toggle this option to enable or disable the module based on your requirements.

API URL: Enter the URL of your LLM provider to retrieve data.

Choose Entities: Select the entities from which you want to retrieve data.

Select Attributes: Choose the attributes for which you want to gather data.

Let’s ask few questions to the AI reporting dashboard, navigate through AI Dashboard->Search AI Reporting Manager.

This brings up the below section. Here, within the magic search enter your query.

Let’s enter – show me today’s orders and then tap the Magic search button to the right.

You can see the respective results for the asked query.

Also, you can download a report by tapping 3 horizontal lines, setting the label for the chart , choosing the respective values and lastly, save the same.

After save, check the respective data as shown below:

Pie Chart:

Bar Graph:

More data in value specific orientation.

Also, the admin can save the SQL query auto generated for the asked question in NLP to the AI reporting dashboard.

Let’s now ask few more queries and check the results.

Show orders where 50off coupon is applied and from california –

Now, let’s check another query.

Which coupon code was used for orders today and which shipping methods

Here, the admin can see the saved AI reports as shown below in the screenshot.

Navigate through AI Dashboard->Saved AI Reporting Manager.

So, that was much about Guide for Adobe Commerce AI Reporting extension. You may also check our top-quality Magento 2 AI Extensions.

Still have any queries or doubts, drop us an email at [email protected]