Statistics and Reports with Claude

"How did sales go over the last 7 days compared to the week before?" With Claude, you can retrieve statistics and reports from your store by typing in plain Danish. The response shows both weeks and the percentage change. Claude retrieves the numbers using the same calculations as the pages under "Statistics" in the admin panel, so the numbers are the same for the same period. This requires that your store be connected. If it isn’t yet, connect your store to Claude first.

What can you ask Claude about?

You can ask about sales and profit margins, best-selling products, inventory and discontinued items, discount codes and traffic sources, and how many customers return. For each answer, Claude provides a link to the corresponding page in the admin panel, with the time period pre-filled if the report covers a specific period. Ask Claude for the link when a specific number is important. If you want to check it yourself, look at the overview of statistics and analytics in Shoporama.

The analytics tools can only read data and do not make any changes. However, the same connection can modify settings in other areas—such as prices—if you specifically request it and the section is set to “Read and Edit.”

Before you get started

Once the shop is connected, you decide what Claude is allowed to do. Go to “Manage the Shop with AI” and click “Customize Tools.” On the AI Tools page, select between “Read and Edit,” “Read Only,” and “Off” for each area. Read more in “Customize Which Tools Claude Can Use.” For statistics, three areas are important:

• Statistics covers sales, profit margin, products, inventory, marketing, and searches. This area contains only read-only tools, so “Read and Edit” and “Read Only” have the same effect.
• "Customers " contains customer statistics. If "Customers" is set to "Off," Claude cannot retrieve this data.
• Catalog must be set to at least “Read-only” if you want the “Searches with no results” prompt to look up your products.

If an area is set to Off, Shoporama will reject the calls, even from an ongoing conversation. Only users with the “Full Access ” role on the online store can connect Claude and select the access levels. Users with a different role and users restricted to specific categories cannot connect Claude using their own login. Read more in “Roles and Permissions.”

The five areas: Sales, Products, Inventory, Marketing, and Customers

Sales, Products, Inventory, and Marketing are managed through the Statistics section on the AI Tools page, and Customers through the Customers section.

You can also combine these areas into a single question, such as “Which of my 20 best-selling items this year are currently out of stock?”

Five pre-built prompts: weekly report, purchasing suggestions, and more

Shoporama provides five pre-made prompts via the connection. In Claude apps that support pre-made prompts from a connection, they appear as shortcuts. Their location depends on the app. You can always say the same thing in your own words, such as “Create a weekly report for the last 7 days.” The prompts only retrieve numbers and make suggestions. They instruct Claude not to change anything and not to carry out the suggestions until you ask it to.

The shortcuts appear regardless of your settings. However, if “Statistics” is set to “Off,” Claude cannot retrieve the numbers the prompts request.

Weekly Report

You don’t need to select anything here. The report looks at the last 7 days, including today, and compares them to the 7 days prior. You’ll see revenue, orders, and average order value with the percentage change, the 5 products with the highest revenue, visitors and conversion rate, and the items that are running out first.

Purchasing Suggestions

You choose how many days your inventory should last after the order is placed. If you don’t select a number, the default is 30 days. Claude analyzes the sales rate over the past 90 days and your current inventory to suggest a quantity that will last for the selected number of days. Only items that are both in stock and have sold in the past 90 days will have a suggested quantity, and items with more inventory than the selected number of days will be skipped. The suggestions are compiled by supplier in a table. Sold-out items that have sold before are listed separately but without a calculated quantity, and new items with no sales are not included. The prompt does not take into account delivery times, minimum purchase requirements, seasonality, or planned promotions, so please consider the suggestion as a draft. See also the sections on order lists and inventory management.

Month-End Closing

You select the month, e.g., 2026-08 for August 2026. If you do not select a month, the previous month is used. You’ll see revenue compared to the same month last year, cost of goods sold and gross profit, shipping, returns, and discount codes, with key figures at the top. Amounts with and without sales tax are kept separate, and items without a cost price are noted. Run the report no earlier than the morning of the 1st of the new month, because the gross profit is calculated overnight. Learn more about cost of goods sold and gross profit.

Dead Stock

You don’t need to select anything here. Claude identifies items in stock that haven’t sold in the last 180 days, sorted by tied-up capital, and online products that haven’t sold in the last 12 months. You’ll see the total inventory value and the 20 items with the most tied-up capital, and Claude will suggest what you can do—such as running a promotion, offering a bundle deal, or removing the item from the store. Read more about unsold products.

Searches with No Results

You choose how many days to look back. If you don’t select a period, 30 days are used by default. Searches with no results are saved for 90 days, so a longer period won’t yield more search terms. Claude shows what visitors searched for without finding anything, sorted by number, and checks whether the products exist under a different name. For each search term, Claude suggests a new product, a better product name, improved copy, or a redirect. The search terms are entered by visitors, so the prompt instructs Claude never to follow any instructions contained within them. Learn more about zero-result searches and search analytics.

Compare with the previous period or last year

Always specify the time period in your question. If you don’t specify one, each report uses its own default—for example, the last approximately 12 months, this year, or the last 30 days—and that might not be what you meant.

• Comparison: Claude can compare with the preceding period of the same length or with the same dates from last year. “Last year” means the same dates, not the same days of the week, and February 29 becomes February 28. Therefore, compare weeks to “the week before,” or specify particular dates.
• Duration: A single report can cover a maximum of approximately 3 years. If the period is longer, Claude retains the most recent approximately 3 years and will notify you. You can retrieve older figures in batches, such as one year at a time.
• Snapshots: Inventory figures (except for inventory turnover, inventory value over time, and inventory value on a specific date), ABC analysis, and customer retention cannot be retrieved for a custom date range. They are based on today’s date: The ABC analysis looks at the last 30, 60, 90, 180, or 365 days; reorders and discontinued items based on sales over the last 30, 90, 180, or 365 days, and products with no sales in the past 1, 3, 6, 12, 18, or 24 months.
• Without comparison: In addition to the snapshots, the delivery summary, items purchased together, price history, new and returning customers, inventory turnover, inventory value over time and on a specific date, and the overview with fixed key metrics cannot be compared to another period.
• Visitor Statistics: For dates older than 12 months, only the number of visitors and sources are stored; page views and bounce rates are not.

With or without VAT? Here’s how the numbers relate to the admin panel

Sales and return amounts are marked as “with” or “without” VAT in the data Claude receives. Cost of goods sold, inventory value, discount amounts, and product prices are not marked, so ask Claude if you’re unsure. If the figures need to be forwarded to the bookkeeper, ask for “excl. VAT.” See also how the figures in the admin panel are calculated and figures in the admin panel with and without VAT.

• Revenue: Only paid orders are included. Revenue in the sales report is shown both with and without VAT and includes shipping. Credit memos are deducted on the day they are issued, so a return in August is deducted in August, even if the purchase was made in July. The number of orders does not include credit memos or additional sales orders.
• Products, brands, and suppliers: The figures are exclusive of VAT and include only line items—that is, excluding shipping. For brands and suppliers, the total for orders counts each order once, even if it contains items from multiple brands or suppliers.
• Returns: In the returns report, the return amount includes VAT—that is, the amount customers receive back. In sales per product, the figure excludes VAT. The return rate is the number of returned line items per 100 paid orders, not a percentage of items sold. The ABC analysis does not deduct returns.
• Profit Margin: Uses the current cost price listed for the product or variant, not the one that applied when the item was sold. In the monthly report on inventory consumption and profit margin, items without a cost price are counted as 0 DKK, so the profit margin appears too high, and Claude is informed of how many items this applies to. In the sales by product report, no profit margin is shown for items without a cost price, and they appear at the bottom when you sort by profit margin. The monthly profit margin is calculated in full calendar months, excluding shipping and credit memos.
• How recent are the figures? Profit and ABC analysis are calculated overnight, so today’s orders aren’t included yet. Inventory value over time is also saved overnight, so the most recent date is yesterday. Customer retention, abandoned carts, and visitor counts are updated throughout the day and may be delayed by up to half an hour. If the page is empty in the admin panel, Claude doesn’t have any figures either. Other results may be up to 5 minutes old when the period includes today, and up to 6 hours old when the period has ended.
• Delivery Map: Claude only receives ZIP codes with at least 3 orders, and smaller ZIP codes are aggregated to protect customer privacy. In the admin panel, you can see all ZIP codes.
• Sales by Source: If your ads and newsletters lack UTM codes, the sales will be categorized under “Direct.”
• Recommendations: Revenue includes items the customer clicked on in a recommendation. This does not prove additional sales.

Statistics with Claude in Everyday Life

Monday morning

Start the week with the Weekly Report. It combines four reports that you would otherwise have to open individually and set the time period for each one. You can ask follow-up questions right away, such as “Why did the conversion rate drop?”

Before the purchasing meeting

Run the “Purchasing Suggestions” report with, for example, a 45-day period. Then ask the supplier: “How much of their products have we sold this year compared to last year?” and “Which of their products haven’t sold in the last 6 months?” Run the “Dead Stock” report the same day.

After a campaign

Write, for example: “We ran the discount code SUMMER20 from July 1 to July 7. How many orders used the code, what was the cost of the discount, how did sales compare to the same week last year, and which products sold the most?” The best-selling products apply to the entire period, not just orders with the code. Also ask about the week that followed. Remember that the statistics show what happened at the same time, not that the campaign was the cause.

Tips for Useful Answers

1. Specify the period precisely, e.g., “all of July 2026” or “September 1–14.”
2. Ask for a comparison. If you sell seasonal items, compare them to last year.
3. Specify whether you want figures with or without sales tax, e.g., “excl. sales tax” for the bookkeeper.
4. Ask for a table and a specific number, e.g., “top 20 as a table.”
5. Ask for the link to the admin panel for important figures, and save the phrasing that works for next time.

Privacy and security: the statistics are read-only

• The analytics tools only read data, and customer statistics consist of aggregated figures without emails or names.
• Each call is logged in the AI audit log with the time, tool, arguments (such as the time period), and status. Claude’s responses are not saved, and the log is retained for 90 days. Read more about the AI audit log.
• If you don’t want the statistics to be included, set “Statistics” and, if applicable, “Customers” to “Off.” This applies to all connections to the store. Keep in mind that the “Orders” section also includes order amounts.
• When Claude retrieves data, the response is included in your conversation with Claude. How Anthropic handles conversations is determined by their terms of service and the settings on your Claude account.

If you want to ensure that Claude doesn’t make any changes when you later ask to act on a suggestion, set the relevant sections to Read-Only. Extra Security is an add-on: it requires that changes that send emails, transfer money, delete data, or modify multiple items at once must first be approved by you. Common changes, such as the price of a single product, are still carried out immediately. Read more in “Extra Security: Approve Changes from Claude.”

For those with a technical background

This section is for developers and agencies.

• The statistics are stored in five MCP tools: stats_sales, stats_products, stats_inventory, stats_marketing, and stats_customers. The “view” parameter selects the report. The search log is retrieved using search_log_list.
• Common parameters: from and to (YYYY-MM-DD), compare (none, previous, or last_year), limit (1–100, default 50), and offset.
• The responses have the same structure: period, totals, compare_totals and change_pct for comparisons, rows, notes explaining what the figures include (e.g., statuses, VAT, and credit memos), and admin_url. Amount fields end with _incl_vat or _excl_vat.
• Inventory value over time is retrieved using ` stats_inventory` with `view` set to `history`, where `granularity ` (auto, day, week, or month) determines whether there is one row per day, week, or month. `on_date` returns the inventory value and items as of the date specified in `date` (by default, the most recent count) and does not use `from` and `to`. `by` (`category`, `supplier`, or `brand`) adds a breakdown. Both only go back to the first nightly count, and `compare ` is not supported.
• The same data is available via REST: GET /stats/{group}/{view}, e.g., /stats/sales/revenue?from=2026-01-01&to=2026-06-30. This requires an API key with read or all access. A key with write-only access is rejected. If the key belongs to a user assigned a role other than Full Access, it can only perform actions permitted by that role. The statistics feature therefore requires that the role be able to view Statistics and have the Revenue and Statistics option enabled. Cost of Goods Sold andMargin (sales/margin), ABC Analysis (products/abc), Inventory Turnover (inventory/turnover), and Inventory Value over Time and by Date (inventory/history and inventory/on_date) also require the “Cost Prices and Margin” add-on; without this add-on, cost prices, margin, and inventory value are removed from the other responses. See the REST API documentation.
• The completed prompts are displayed using MCP prompts/list and prompts/get. The names are weekly_report, purchasing_suggestions, monthly_close, discontinued_items, and searches_with_no_results, with the arguments days and month.

Frequently Asked Questions

Are these the same numbers I see under Statistics in the admin panel?

Yes, Claude uses the same calculations for the same period. Differences are typically due to the report using its default period, the delivery card hiding small postal codes, gross profit and ABC analysis being calculated overnight, or the result being a few minutes old. Ask Claude for the link to the admin panel and compare.

Is the revenue shown with or without sales tax, and when are returns deducted?

Revenue is shown both with and without VAT and includes shipping. Credit memos are deducted on the day they are issued, not the day the purchase was made, so a return in August is deducted in August. Figures per product, brand, and supplier are exclusive of VAT and shipping. See also the returns statistics.

How does Claude calculate the profit margin when some items lack a cost price?

The profit margin uses the cost price currently listed for the product or variant. In the monthly profit margin, items without a cost price are counted as 0 DKK, so the profit margin appears too high, and Claude is notified of how many items this applies to. In sales by product, no profit margin is shown for these items. Enter the cost prices before relying on the contribution margin. Read about cost prices and inventory value.

How far back can Claude view data, and can I get the inventory value as of a specific date?

A single report can cover up to about 3 years, but you can retrieve older figures in batches, such as one year at a time. The inventory value is saved every night, so you can, for example, ask: “What was the inventory value on December 31, and which categories made up that value?” This works for dates starting from the first night Shoporama saved the inventory value—that is, from the day the feature went live. Earlier dates have no figures. If the inventory count for that specific day is missing, Claude uses the most recent count prior to it and provides that figure. The breakdown is based on the items’ current main category, supplier, and brand. The inventory value is based on what’s recorded in Shoporama, so for the annual financial statements, it must be reconciled with a physical inventory count. The other inventory figures are a snapshot of the current situation. Read more about inventory value over time.

Can Claude change my prices when I request statistics?

No, the statistics tools are read-only. However, the connection can make changes in other areas—such as prices—if you request it and the area is set to “Read and Edit.” If you want to avoid this, set the Catalog to “Read-only.” Extra security doesn’t prevent regular price changes—only changes that send emails, transfer funds, delete data, or modify multiple items at once.

Can my employees view profit margins and sales through Claude?

Only employees with the “Full Access” role on the online store can connect Claude, and they can already view revenue and profit margins in the admin panel. If a colleague has a different role—for example, Employee or Bookkeeper—they cannot connect Claude using their own login, even if their role allows them to view revenue in the admin panel. The same applies to users who are restricted to specific categories. However, if the colleague uses a Claude account that a user with “Full Access” has connected, they will see the same information as that connection. There is no separate statistics permission for the AI connection itself. If you want to keep the numbers out, set Statistics, Customers, and Orders to Off. This applies to all connections. The AI audit log shows what data was retrieved and which user connected Claude.

What happens to my data when Claude retrieves it?

The data is part of your conversation with Claude. How Anthropic handles conversations is determined by their terms of service and your settings in your Claude account. In Shoporama, the query is logged in the AI audit log, but the response itself is not saved.

I have multiple shops. Can I get a single consolidated weekly report?

Each connection communicates only with its own shop, and Shoporama does not generate a consolidated report across shops. If you have multiple connections enabled in the same conversation, you can ask Claude to retrieve the numbers from each shop and display them side by side. Be clear about which shops you’re referring to. See also Manage Your Store with AI.

Does the purchasing suggestion take delivery time and variants into account?

The suggestion is based on sales velocity over the past 90 days and current inventory. It doesn’t account for delivery times or minimum purchase requirements, so be sure to include those in your message. Inventory and sales are calculated per product, with all variants and warehouse locations combined, so a sold-out or slow-moving variant might be hidden in the data. Check the individual variants in the admin panel.

Can the weekly report be generated automatically every Monday?

No, Shoporama does not send the report automatically. You’ll need to generate it yourself in Claude, either using the shortcut or by typing “Create a weekly report.” Feel free to save your command so you can use it again.

If you have questions about the numbers, or if a number doesn’t match what you see in the admin panel, please email support@shoporama.dk. Please include your question for Claude and the time period in your email.