shopify-product-and-variant-saleslisted
Install: claude install-skill coupler-io/skills
# Shopify Product and Variant Sales
**Tells you which products and variants earn their place in the catalogue — ranked by money, with
margin on the right cost basis, and with the stock-out distortion called out instead of buried.**
A best-seller list ranked by units rewards whatever is cheapest, and one ranked by revenue rewards
whatever is dearest; neither tells you what to reorder. Variant-level truth is worse: product titles
are stored as they were at the time of each sale, so a renamed product splits into two rows; the same
SKU can appear on more than one variant; and an item that was unavailable for three weeks reports as a
poor seller. Then margin arrives from two different cost fields that mean different things, and using
the wrong one restates last quarter at today's cost.
**What you get back**
- **Products and variants ranked by net sales**, with units, average selling price and share of the
total — and the tail rolled up rather than truncated.
- **Gross margin in currency and percent** where cost data is present, with the cost basis named.
- **Mix shift against the prior period**, with each product's contribution to the revenue delta in
currency, not just percent.
- **Concentration risk** — top-ten share of revenue, and what a single product going away would cost.
- **Stock-out distortion flagged** — items whose ranking is understated because they were unavailable,
marked unranked rather than ranked low.
- **The zero-sale list** — items published and in st