Get a sales and top-sellers report in chat

WooCommerceBeginner~5 min

Before you start

A connected store with the WooCommerce integration enabled and its read abilities on.

Pulling your numbers usually means loading the WooCommerce analytics screen, waiting for it to render, then clicking between the sales tab and the products tab to line up what sold against what came in. This is one prompt that reads all of it and hands you the summary in chat, so you can ask the same question every morning without the clicking.

The prompt
Give me a sales readout for the store. Read only, just the numbers. Pull the
sales summary for [last month]: total sales, number of orders, net sales, and
average order value. Then show me the best sellers for [that same period] by
quantity sold, top [10]. Finish with the order count broken down by status so
I can see how much is still sitting in processing or on-hold versus completed.
Keep it tight, I want to skim it in under a minute.

Why this is safe to run

Every ability here is a read. The sales summary, the top-sellers list, and the order-count breakdown are three separate read abilities, none of which can touch an order, a price, or a product. If the WooCommerce integration is off, or you left these particular reads switched off, the abilities are not registered and the prompt simply has nothing to call. Nothing lands in the store either way.

Already connected? You do not have to paste this at all. Ask your agent for the “sales and top-sellers report” recipe, or just ask it for last month’s numbers, and it runs the same reads against your own store.

How it works

  1. Pull the sales summary for the date range you name: total sales, order count, net sales, and average order value.
  2. List the best-selling products for the period, ordered by quantity sold.
  3. Break the order count down by status so you can see what is still open.
  4. Fold it into one short readout you can skim.

Questions

Can this change an order or a total?
No. All three abilities behind it are reads. It reports the numbers WooCommerce already has and writes nothing.
What date ranges can I ask for?
The sales summary takes a date range and defaults to the current calendar month, and the top-sellers list runs by week, month, or year. Ask for whichever window you want.