Find your slowest-moving products

WooCommerceIntermediate~10 min

Before you start

WooCommerce enabled, with the top-sellers report, product list, and order-count abilities turned on. No writes are involved.

A top-sellers report tells you what is flying off the shelf. The more useful question some weeks is the opposite one: what is just sitting there? The products that never show up in the ranking, or cling to the very bottom of it, are the ones eating catalog space and attention without earning it. This prompt works out that list for you by comparing your whole catalog against the sales ranking for a period you name. It reads and reports, and it changes nothing.

The prompt
Help me find my slowest-moving products for [last quarter]. Read only, change
nothing.
Pull the top-sellers ranking for that period by units sold. Then list my full
product catalog. Cross-reference the two and show me the products that are
absent from the ranking or sitting near the bottom of it, since those are the
slow movers.
Also give me the total order count for the same period, so I can read the
slow-mover list against how much the store sold overall. For each slow mover,
add a one-line note on whether it looks like a candidate to discount, bundle
with something popular, or retire.

Why this is safe to run

Every ability here is a read. The top-sellers report, the product list, and the order count are three separate reads, and none of them can touch a price, a product, or an order. So the prompt can tell you a product is barely moving, but acting on that, dropping the price, building a bundle, pulling it from the catalog, stays entirely in your hands as a separate step.

One honest caveat on the method. There is no single built-in slow movers figure in WooCommerce to read. The store ranks best sellers by units sold, and this recipe infers the slow end by comparing that ranking to your full product list: a product with no sales in the window simply does not appear in the ranking. It is a cross-reference the agent assembles, not a number you could look up on one screen. Every call runs against the capability of the user you bound the agent to and lands in the Activity Log.

Already connected? Skip the paste. Ask your agent for the “find your slowest-moving products” recipe, or just ask which products barely sold last quarter, and it runs the same reads against your own store.

How it works

  1. Pull the top-sellers ranking for the period you name, ordered by units sold.
  2. List the full product catalog so every product is accounted for, not just the ones that sold.
  3. Cross-reference the two: the products absent from or at the bottom of the ranking are the slow movers.
  4. Pull the order count for the same period so you can read the slow-mover list in context of overall volume.
  5. Report the slow movers with a short note on what to consider for each: discount, bundle, or retire.

Questions

Does this change prices or delete any products?
No. All three abilities behind it are reads. It reports the ranking, the product list, and the order counts, then tells you which products are barely selling. Any discount, bundle, or retirement is a decision you make and act on separately.
Is there a single built-in slow-movers number this reads?
No, and it is worth being clear about. WooCommerce ranks your best sellers by units sold; slow does not have its own report. This prompt derives the slow movers by comparing your full product list against that ranking, so a product with no sales in the period simply never appears in the ranking. It is a cross-reference, not a stock figure you can point at.