# Review your store's sales

> A weekly or monthly store review with your AI - sales against the last period, best sellers, low stock, stuck orders and top customers.

This guide reviews how your online store is doing: sales against the previous period, what sold, what's running out, which orders need attention, and who your best customers are. With Google Ads or GA4 connected too, you can put ad spend and traffic next to revenue.

Plugsight only reads your store. It can't change orders, products, prices or stock.

## What you need

- A [WooCommerce](https://docs.plugsight.app/connectors/woocommerce.md) or [Magento / Adobe Commerce](https://docs.plugsight.app/connectors/magento.md) connection in your MCP server. Stores work on **any plan**.
- Optional, on **Pro** or **Agency**: [Google Ads](https://docs.plugsight.app/connectors/google-ads.md), [Google Analytics 4](https://docs.plugsight.app/connectors/google-analytics-4.md) or [Google Merchant Center](https://docs.plugsight.app/connectors/google-merchant-center.md), for Step 6.

If you have more than one store, name the store in every question.

## Step 1: sales against the last period

- "How did the shop do last month compared with the month before? Show a table with sales, orders, average order, refunds and discounts, and the % change."

The sales report gives gross and net sales (WooCommerce) or revenue (Magento), orders, items sold, average order, tax, shipping, refunds and discounts, with a day-by-day breakdown.

> [!NOTE]
> Magento sales reports use UTC dates, leave out cancelled orders, and add up at most 3,000 orders. If a period has more, your AI is told how many were included: ask for a shorter period, such as one week at a time.

## Step 2: best sellers

- "What were the 20 best-selling products last month, with quantity sold?"

Sales reports list up to 50 best sellers (10 unless you ask for more).

## Step 3: stock

- WooCommerce: "Which products are out of stock or on backorder?"
- Magento: "List products with 5 or fewer in stock."

Then put the two together:

- "Which of last month's 20 best sellers are low on stock?"

## Step 4: orders that need attention

- "Which orders are on hold or still processing from more than 3 days ago?"
- "Find order 1042 and tell me what was bought, how it was paid and where it's shipping."

Order lists come up to 100 at a time, newest first.

## Step 5: customers

- "Who are my ten biggest customers by total spent?" (WooCommerce)
- "Show every order from ann@example.com this year."

WooCommerce's customer search covers registered customers; guest checkouts appear in orders only.

## Step 6: marketing next to sales (Pro and Agency)

With marketing connectors in the same MCP server:

- "Compare Google Ads spend last month with WooCommerce revenue for the same days, by week."
- "In GA4, which channels brought the most revenue last month?"
- "Which Merchant Center products are disapproved, and are any of them best sellers?"

Store and ad platform figures are counted differently (for example, refunds, tax and conversion windows), so expect them to differ a little.

## Step 7: the summary

- "Write a one-page store review: a table of the headline numbers against the last period, best sellers, stock risks, orders needing attention, and three actions for next month."

## Make it a routine

Run the same questions at the same point each week or month (for example every Monday for the previous Monday to Sunday) with exact dates, so periods line up. See [Write better questions](https://docs.plugsight.app/guides/better-questions.md).

## Related articles

- [WooCommerce](https://docs.plugsight.app/connectors/woocommerce.md)
- [Magento / Adobe Commerce](https://docs.plugsight.app/connectors/magento.md)
- [Get accurate numbers from marketing data](https://docs.plugsight.app/guides/accurate-marketing-numbers.md)

---

Web version: https://docs.plugsight.app/guides/store-sales-review
