MageAsk AI Powered Admin Assistant

OpenAI is a global leader in artificial intelligence research and deployment. Their services, including the renowned ChatGPT and GPT-4 models, help businesses and developers unlock the power of AI for automation, data analysis, and conversational interfaces. Millions of users worldwide leverage OpenAI’s cutting-edge APIs to enhance productivity and drive innovation.

MageAsk is an innovative integration for Magento that connects your store’s admin panel with OpenAI’s API to provide real-time natural language processing for querying store data. With MageAsk, Magento store administrators can simply type natural language questions like “List my top 10 selling products this year” and instantly receive answers in a structured table format - no SQL skills required. Whether you’re a store owner, marketer, or developer, MageAsk simplifies data access, enhances decision-making, and reduces the dependency on technical resources for database insights.

Account & Pricing

• Separate OpenAI account required.
• API key must be generated via OpenAI’s platform.
• OpenAI applies usage-based pricing for API calls. Review their pricing details here: https://openai.com/pricing.
• MageAsk does NOT transmit sensitive or business data - only the query prompt is securely processed through the OpenAI API. 
• MageAsk is a one-time purchase (no subscription for the module itself), but OpenAI charges for API usage separately.

Key Features

• Natural Language Query Box - Ask data-related questions in plain English.
• Tabular Output - Instantly generated, formatted tables.
• Pre-Made Query Templates - Built-in commonly used queries, fully customizable.
• CSV Export - Download query results with one click.
• SQL Transparency - View the exact SQL generated by OpenAI for full clarity.
• Read-Only Data Access - Secure design, allows SELECT queries only. INSERT, UPDATE, DELETE queries are fully restricted.
• Pagination Support - Effortlessly browse large datasets.
• End-to-End Security - Client-side and server-side SQL validation.

Configuration

• Admin Panel Path: Stores → Configuration → Ecommet Extensions → MageAsk
• Enable Module: Yes / No
• Add OpenAI API Key
• Choose Language Model (gpt-4.1, gpt-4.1-mini)

How to Use MageAsk

1. Navigate to MageAsk via the Magento Admin Menu.
2. Enter a query (e.g., “List my top 10 selling products this year”).
3. Click ‘Get Answer’ → See tabular results instantly.
4. Use Export to CSV to download.

Troubleshooting & Support

• No Results? Rephrase your question (e.g., use “last 30 days” instead of “last month”).
• Invalid Query? Only SELECT queries are allowed. If a risky query is detected, the module blocks it for your security.

Disclaimer & Usage Guidelines

• Do not enter sensitive or confidential data such as passwords or personal details.
• Only query prompts are sent to OpenAI. Business data is never shared or stored by OpenAI.
• This AI assistant is powerful but may not always be 100% accurate—please verify all results before making business decisions.
• Be specific and clear with your questions for better accuracy.