---
name: top-products
description: >-
  Ranks products by revenue and units for a period, flags the fastest growing and fastest declining, and checks stock for the winners. Use when the user asks what is selling, what is not selling, or which products to push.
---

# Top and Declining Products

Rank my products for [TIMEFRAME] and compare with the period before it.

## Steps
1. Pull sales by product for both periods: revenue, units, orders.
2. Build four lists from the returned rows only: top 10 by revenue, top 10 by units, 5 fastest growing by revenue (minimum 5 orders in the current period), 5 fastest declining.
3. For the top 10 by revenue, check current inventory. Flag any product with fewer than 14 days of stock at the current sales rate, and any product that is out of stock.
4. Point out products that appear in the top-units list but not the top-revenue list; these are low-price volume items that may suit a bundle.

## Output
Four short tables with product, revenue, units, % change and a stock note. End with one paragraph of observations, not recommendations.

Never compute a percentage change from zero. If a product was added during the period, mark it "new" instead of a % change.