What are the standalone tools of MCP Tools Plus for sales analysis?
Find below the list of MCP Tools Plus tools to help you analyze your sales:
a) Country codes
| Tool | Technical name | Description | Prompt example |
| Get country codes | get_country_codes |
Returns country codes (e.g.: France = 8). Allows the LLM to filter by country. | "What is the country code for France?" |
b) Order analysis
| Tool | Technical name | Description | Prompt example |
| Sales analytics dashboard | sales_analytics_dashboard |
Totals orders, revenue, as well as minimum, maximum, and average basket values over a given period. | "Give me a sales overview for the last 30-day period with grouping by month." |
| Advanced reports | advanced_business_reports |
Custom order reports with flexible columns (shipping/packaging/discounts, status, invoice numbers, free shipping), filters (dates, status, invoice range, country, customer groups, category/manufacturer/supplier), grouping (country/customer), and global totals (excl. tax/incl. tax/VAT, discounts, shipping, packaging, number of free vs. paid shipping). | "Generate an order report with customer name, total paid, shipping total, and 'free shipping' status grouped by country for 2025." |
| Order charges breakdown | order_charges_breakdown |
Breaks down shipping costs (free or paid), packaging costs, and discounts for each order. Displays totals excl. tax, incl. tax, and VAT for each. Supports grouping by country, customer, carrier, payment, and order status. | "Break down the shipping, packaging, and discount costs for orders placed between 2025-01-01 and 2025-01-31. Group by country." |
| Order fulfillment status | order_fulfillment_tracker |
Counts the number of orders and revenue by order status to identify potential bottlenecks in order processing. | "How many orders are awaiting payment vs shipped in the last 30 days?" |
c) Tax analysis
| Tool | Technical name | Description | Prompt example |
| Tax breakdown | order_charges_breakdown |
Tax overview with totals excl. tax/incl. tax/VAT for shipping, packaging, discounts, as well as the number/ratio of free vs. paid shipping. Supports grouping by country, customer, carrier, payment, or status. |
"For 2025, show me the total excl. tax/incl. tax/VAT for shipping, packaging, discounts, as well as the number/ratio of free vs. paid shipping by country." |
| Tax summary for declaration | tax_declaration_summary |
Aggregates totals excl. tax/incl. tax/VAT for tax filings. | "Calculate the VAT summary for the last 30 days so I can fill out the tax return." |
| Tax analysis by country or rate | multi_market_tax_analyzer |
Groups totals excl. tax/incl. tax/VAT by country or tax rate to facilitate multi-country tax filings. | "Provide a breakdown of VAT by country for the last 30 days, then by tax rate if possible." |
d) Product performance analysis
| Tool | Technical name | Description | Prompt example |
| Product performance tracker | product_performance_tracker |
Ranks products by revenue or quantity, supports filters by country/category/manufacturer as well as top-N limitation. Returns ready-to-use data for pie charts. | "Show me the top 5 best-selling products in France over the last 3 months and display them as a pie chart showing each one's share of revenue with exact amounts on hover." |
e) Customer analysis
| Tool | Technical name | Description | Prompt example |
| Customer analysis | customer_insights_analyzer |
Segments customers (country/group/frequency) and lists the most expensive customers. | "Analyse our customers over the last 30 days segmented by country." |
| Customer behavior summary | customer_behavior_summary |
Provides the total number of customers, the average amount spent, regular customers, top 10 customers, and country distribution. | "Summarize customer behavior over the last 30 days, highlighting regular customers." |
| Customer demographic analysis | customer_demographics_breakdown |
Segments customers who made purchases over a given period, by gender and age range (with optional country filter). | "Analyze the gender and age of customers who made purchases between 01/01/2025 and 31/01/2025" |
f) Profit and margins
| Tool | Technical name | Description | Prompt example |
| Profit analysis | margin_performance_alerts |
Detects products with a profit below a given threshold (or with a negative profit) by comparing revenue and cost of goods sold. | "Highlight the 20 products with a profit below 12% over the last 30 days." |
| Order profitability | get_order_profitability |
Calculates the net profitability of an order. Takes into account product costs, shipping fees, and analyzes margins. | "Analyze the profitability of order #12345." |
| Bulk order profitability | get_bulk_order_profitability |
Calculates the net profitability of multiple orders at once. Provides details on individual profitability as well as global statistics (total margin, average margin in %, profitable vs unprofitable orders). | "Analyze the profitability of orders 1250, 1251, and 1252." |
| Order profitability alerts | order_profitability_alerts |
Analyzes orders over a given period and flags those with a low or negative net profit margin. Helps identify problematic shipments, excessive discounts, or high shipping fees impacting profitability. | "List the orders from last month with a net profit margin lower than 12%, limited to 20 results." |
| Profitability trends | profitability_trends |
Analyzes the net profitability trend over time. Displays global revenue, total costs, and global net margin by day, week, or month. Helps identify seasonal drops or long-term profitability changes. | "Show me the profitability trend by month for the last 6 months." |
| Profitability by category | get_category_profitability |
Analyzes gross profitability by product category. Calculates revenue, cost of goods sold (COGS), and gross margin for each category. Helps identify high-margin categories versus low-margin ones. | "Show me the profitability by category for the last 30 days." |
g) Refunds & Credits
| Tool | Technical name | Description | Example prompt |
| Return and credit analysis | returns_and_credits_tracker |
Lists returns and credits with totals HT/TTC for accounting recovery. | "List all returns and credits issued in the last 30 days with their HT/TTC amount." |
Other FAQs in this category
- What are the default tools available in PrestaShop's MCP Server module?
- What are the MCP Tools Plus tools for using the PrestaModule's Advanced Cookie Banner module?
- What are the MCP Tools Plus tools for using the BusinessTech's Google Merchant Center Pro module?
- What are the MCP Tools Plus tools for using the BusinessTech's GEO Suite module?
- What are the MCP Tools Plus tools for using the PrestaModule's Advanced Pack module?
- What are the standalone tools of MCP Tools Plus for customer service management?
- What are the standalone tools of MCP Tools Plus for managing images?
- What are the standalone tools of MCP Tools Plus for auditing your shop parameters (security, performance, SEO)?
- What are the standalone tools of MCP Tools Plus for managing CMS pages?
- What are the standalone tools of MCP Tools Plus for managing shipping settings?
- What are the standalone tools of MCP Tools Plus for managing specific prices, price rules and vouchers?
- What are the standalone tools of MCP Tools Plus for inventory management?
- What are the standalone tools of MCP Tools Plus to get Google Analytics reports?
- What are the standalone tools of MCP Tools Plus for marketing?
- What are the tools included in the MCP Tools Plus module?
- What is MCP Tools Plus?