{"id":460311,"date":"2024-10-03T12:47:02","date_gmt":"2024-10-03T12:47:02","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=460311"},"modified":"2025-08-06T08:12:26","modified_gmt":"2025-08-06T08:12:26","slug":"magento2-ai-reporting-documentation","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/","title":{"rendered":"Guide for Adobe Commerce AI Reporting"},"content":{"rendered":"\n<p><a href=\"https:\/\/store.webkul.com\/magento2-ai-reporting.html\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 AI Reporting<\/a>(Adobe Commerce) extension is an outstanding tool that enhances data analysis using cutting-edge AI and Natural Language Processing (NLP) technologies.<\/p>\n\n\n\n<p>It lets you easily retrieve information about customers, orders, products, wish lists, and reviews. <\/p>\n\n\n\n<p>Just enter your queries, and the system will generate clear, visual data, allowing you to make well-informed decisions quickly.<\/p>\n\n\n\n<p>Check a brief overview of the extension &#8211;  <\/p>\n\n\n\n<div class=\"wp-block-wk-block-youtube-video wp-block-wk-block--yt-video components-placeholder\"><div class=\"wk-block--yt-video-frame\"><div class=\"wk-block--yt-video-frame-request\" data-plyr-provider=\"youtube\" data-plyr-embed-id=\"GvMcNj1duBw\"><div class=\"components-placeholder__instructions\">GvMcNj1duBw<\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Prerequisites for Using Magento 2 AI Reporting<\/h2>\n<\/div><\/div>\n\n\n\n<p>To use the Magento 2 AI Reporting effectively, ensure that you meet the following minimum system requirements and setup configurations:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Minimum System Requirements:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>RAM<\/strong>: 8 GB<\/li>\n\n\n\n<li><strong>Storage Space<\/strong>: 4 GB<\/li>\n\n\n\n<li><strong>Python Version<\/strong>: 3.10<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">API Setup:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Server Key and Certificate Files<\/strong>: Required for Flask API integration.<\/li>\n\n\n\n<li><strong>Ports<\/strong>: Ensure that port 5000 is open and available.<\/li>\n\n\n\n<li><strong>API Key<\/strong>: Obtain and configure an API key from a large language model provider such as OpenAI or Gemini.<\/li>\n<\/ul>\n\n\n\n<p>By meeting these requirements, you can ensure a smooth and effective implementation of the Magento 2 AI Reporting.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Features &#8211; Magento 2 AI Reporting<\/h3>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can use NLP2SQL technology to convert natural language into SQL queries for seamless data retrieval.<\/li>\n\n\n\n<li>Analyze data with interactive charts.<\/li>\n\n\n\n<li>You can ask queries like sales, customer, order, product, wishlist, and review.<\/li>\n\n\n\n<li>Save the chart and download the query results.<\/li>\n\n\n\n<li>Search and copy the SQL query from the response.<\/li>\n\n\n\n<li>Admins have the option to select the LLM Provider through API setup.<\/li>\n\n\n\n<li>Ask queries in AI Dashboard in NLP and view responses in table, line, pie, bar, and graph.<\/li>\n<\/ul>\n\n\n\n<p>To install AI module, we need SSH access. You can also check the\u00a0<a href=\"https:\/\/webkul.com\/blog\/ai-models-server-installation-guide\/\" target=\"_blank\" rel=\"noreferrer noopener\">AI Models Server Installation<\/a>\u00a0Guide and\u00a0<a href=\"https:\/\/webkul.com\/blog\/guide-chroma-db-installation\/\" target=\"_blank\" rel=\"noreferrer noopener\">ChromaDB Installation<\/a>\u00a0Guide for reference.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Installation<\/h3>\n<\/div><\/div>\n\n\n\n<p>The installation is quite simple just like the standard&nbsp;<a href=\"https:\/\/store.webkul.com\/Magento-2.html\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 extensions<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">#Download Module<\/h3>\n\n\n\n<p>Firstly, you need to log in to the Webkul Store, go to&nbsp;My Account&gt;My Purchased Products section, verify, and then download and extract the contents of this zip folder on the system.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">#Upload Folder<\/h3>\n\n\n\n<p>Once the module zip extracts, follow path src&gt;app and then copy the app folder into the Magento 2 root directory on the server as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1200\" height=\"346\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\" alt=\"root directory\" class=\"wp-image-441450\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1-300x87.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1-250x72.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1-768x221.webp 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"># Run Commands<\/h3>\n\n\n\n<p>You need to run the following commands:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento setup:upgrade<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento setup:di:compile<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento setup:static-content:deploy<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento indexer:reindex<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento cache:flush<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"language-translation\">Language Translation<\/h3>\n\n\n\n<p>For translating the module language, navigate through&nbsp;<strong>src\/app\/code\/Webkul\/AIDashboard\/i18n\/<\/strong>&nbsp;and edit the en_US.csv file.<\/p>\n\n\n\n<p>Thereafter, rename the CSV as \u201cen_SA.csv\u201d and translate all right side content after the comma in the Arabic language. After editing the CSV, save it.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1200\" height=\"293\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/04\/i18folder-transfer-i18-language-file.webp\" alt=\"i18-translation-file-copy\" class=\"wp-image-432347\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/04\/i18folder-transfer-i18-language-file.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/04\/i18folder-transfer-i18-language-file-300x73.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/04\/i18folder-transfer-i18-language-file-250x61.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/04\/i18folder-transfer-i18-language-file-768x188.webp 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now, upload it to the path&nbsp;<strong>src\/app\/code\/Webkul\/AIDashboard\/i18n\/<\/strong>&nbsp;where the installation of Magento 2 is on the server.<\/p>\n\n\n\n<p>The module translates into the Arabic Language. It supports both RTL and LTR languages.<\/p>\n\n\n\n<p>The user can edit the CSV like the image below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"710\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv-1200x710.webp\" alt=\"trnslation\" class=\"wp-image-460340\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv-1200x710.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv-300x178.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv-250x148.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv-768x455.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/09\/ai-dashboard-csv.webp 1468w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After installing the module you need to setup database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/magento-ai-db.webp\" alt=\"database\" class=\"wp-image-466689\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/magento-ai-db.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/magento-ai-db-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/magento-ai-db-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/magento-ai-db-768x432.webp 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Run Following Command via terminal to save data database:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento s:db-schema:generate-reports --separate=false<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento s:db-schema:generate-reports --separate=true --dbname=&#039;DbName&#039; --username=&#039;DbUser&#039; --password=&#039;DbPassword&#039;<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento s:db-schema:generate-reports --unset=true<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\">php bin\/magento setup:upgrade<\/pre>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Workflow of Magento 2 AI Dashboard Reporting<\/h3>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Configuration:<\/h3>\n\n\n\n<p>Once you complete the installation of Magento 2 AI Reporting, login to admin dashboard. Go to <strong>Store&gt; Configuration&gt; Webkul AI Reports<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/ai-reporting-config.webp\" alt=\"ai reporting \" class=\"wp-image-466462\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/ai-reporting-config.webp 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/ai-reporting-config-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/ai-reporting-config-250x196.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/ai-reporting-config-768x603.webp 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>Enable AI Reports:<\/strong> Toggle this option to enable or disable the module based on your requirements.<\/p>\n\n\n\n<p><strong>API URL:<\/strong> Enter the URL of your LLM provider to retrieve data.<\/p>\n\n\n\n<p><strong>Choose Entities:<\/strong> Select the entities from which you want to retrieve data.<\/p>\n\n\n\n<p><strong>Select Attributes:<\/strong> Choose the attributes for which you want to gather data.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Query Search and Visualization<\/h3>\n<\/div><\/div>\n\n\n\n<p>Let&#8217;s ask few questions to the AI reporting dashboard, navigate  through AI Dashboard-&gt;Search AI Reporting Manager. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"591\" height=\"559\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/menu-options-ai-reporting.webp\" alt=\"ai reporting dashboard search option menu \" class=\"wp-image-466466\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/menu-options-ai-reporting.webp 591w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/menu-options-ai-reporting-300x284.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/menu-options-ai-reporting-250x236.webp 250w\" sizes=\"(max-width: 591px) 100vw, 591px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>This brings up the below section. Here, within the magic search enter your query.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/today-orders.webp\" alt=\"searh using a generic query\" class=\"wp-image-466469\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/today-orders.webp 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/today-orders-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/today-orders-250x196.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/today-orders-768x603.webp 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Let&#8217;s enter &#8211;  show me today&#8217;s orders and then tap the Magic search button to the right. <\/p>\n\n\n\n<p>You can see the respective results for the asked query.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data-1200x675.webp\" alt=\"search data\" class=\"wp-image-466497\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/search-data.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>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. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/save-data.webp\" alt=\"save report\" class=\"wp-image-466522\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/save-data.webp 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/save-data-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/save-data-250x196.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/save-data-768x603.webp 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After save, check the respective data as shown below: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1200x675.webp\" alt=\"graph\" class=\"wp-image-466535\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Pie Chart:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1200x675.webp\" alt=\"graph\" class=\"wp-image-466538\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Bar Graph:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1-1200x675.webp\" alt=\"bar \" class=\"wp-image-466540\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-1.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>More data in value specific orientation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1-1200x675.webp\" alt=\"graph\" class=\"wp-image-466542\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/beta-1.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Also, the admin can save the SQL query auto generated for the asked question in NLP to the AI reporting dashboard. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2-1200x675.webp\" alt=\"nlp to sql\" class=\"wp-image-466545\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/alpha-2.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Let&#8217;s now ask few more queries and check the results. <\/h3>\n\n\n\n<p>Show orders where 50off coupon is applied and from california &#8211; <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack-1200x675.webp\" alt=\"nlp to sql\" class=\"wp-image-466569\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack-1200x675.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack-300x169.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack-250x141.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack-768x432.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/jack.webp 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now, let&#8217;s check another query. <\/p>\n\n\n\n<p>Which coupon code was used for orders today and which shipping methods<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/coupon-code.webp\" alt=\"coupon codes \" class=\"wp-image-466579\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/coupon-code.webp 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/coupon-code-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/coupon-code-250x196.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/coupon-code-768x603.webp 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Saved AI Report Manager<\/h3>\n<\/div><\/div>\n\n\n\n<p>Here, the admin can see the saved AI reports as shown below in the screenshot.<\/p>\n\n\n\n<p>Navigate through AI Dashboard-&gt;Saved AI Reporting Manager. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/other-data.webp\" alt=\"ai report\" class=\"wp-image-466599\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/other-data.webp 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/other-data-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/other-data-250x196.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/10\/other-data-768x603.webp 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Support<\/h3>\n<\/div><\/div>\n\n\n\n<p>So, that was much about Guide for <strong>Adobe Commerce AI Reporting <\/strong>extension. You may also check our top-quality <a href=\"https:\/\/store.webkul.com\/Magento-2\/magento2-ai-extensions.html\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 AI Extensions<\/a>.<\/p>\n\n\n\n<p>Still have any queries or doubts, drop us an email at<strong> support@webkul.com<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 <a href=\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":273,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9121],"tags":[],"class_list":["post-460311","post","type-post","status-publish","format-standard","hentry","category-magento-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Guide for Magento 2 AI Reporting<\/title>\n<meta name=\"description\" content=\"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guide for Magento 2 AI Reporting\" \/>\n<meta property=\"og:description\" content=\"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-03T12:47:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T08:12:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\" \/>\n<meta name=\"author\" content=\"Kavita Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kavita Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\"},\"author\":{\"name\":\"Kavita Singh\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1\"},\"headline\":\"Guide for Adobe Commerce AI Reporting\",\"datePublished\":\"2024-10-03T12:47:02+00:00\",\"dateModified\":\"2025-08-06T08:12:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\"},\"wordCount\":789,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\",\"articleSection\":[\"Magento 2\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\",\"url\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\",\"name\":\"Guide for Magento 2 AI Reporting\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\",\"datePublished\":\"2024-10-03T12:47:02+00:00\",\"dateModified\":\"2025-08-06T08:12:26+00:00\",\"description\":\"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp\",\"width\":1200,\"height\":346},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guide for Adobe Commerce AI Reporting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1\",\"name\":\"Kavita Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Kavita Singh\"},\"description\":\"Kavita, a seasoned Business Manager, drives growth in e-commerce solutions by implementing strategic management and innovative solutions, ensuring superior performance, and elevating digital commerce for exceptional results.\",\"url\":\"https:\/\/webkul.com\/blog\/author\/kavitasingh-bd984\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guide for Magento 2 AI Reporting","description":"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/","og_locale":"en_US","og_type":"article","og_title":"Guide for Magento 2 AI Reporting","og_description":"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.","og_url":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2024-10-03T12:47:02+00:00","article_modified_time":"2025-08-06T08:12:26+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp","type":"","width":"","height":""}],"author":"Kavita Singh","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Kavita Singh","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/"},"author":{"name":"Kavita Singh","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1"},"headline":"Guide for Adobe Commerce AI Reporting","datePublished":"2024-10-03T12:47:02+00:00","dateModified":"2025-08-06T08:12:26+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/"},"wordCount":789,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp","articleSection":["Magento 2"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/","url":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/","name":"Guide for Magento 2 AI Reporting","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp","datePublished":"2024-10-03T12:47:02+00:00","dateModified":"2025-08-06T08:12:26+00:00","description":"Magento 2 AI Reporting Guide shows how the admin can easily filter sales and reporting data in the provided AI reporting section in backend.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2024\/05\/server-1.webp","width":1200,"height":346},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/magento2-ai-reporting-documentation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Guide for Adobe Commerce AI Reporting"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1","name":"Kavita Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Kavita Singh"},"description":"Kavita, a seasoned Business Manager, drives growth in e-commerce solutions by implementing strategic management and innovative solutions, ensuring superior performance, and elevating digital commerce for exceptional results.","url":"https:\/\/webkul.com\/blog\/author\/kavitasingh-bd984\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/460311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/273"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=460311"}],"version-history":[{"count":35,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/460311\/revisions"}],"predecessor-version":[{"id":502483,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/460311\/revisions\/502483"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=460311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=460311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=460311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}