shopify-admin-variant-performance-report

What problem does it solve?

This Skill removes the guesswork in merchandising by ranking every product variant by what it earns, what it sells, and what gets refunded. It then compares that performance to live inventory to pinpoint which SKUs drive revenue versus which ones tie up shelf space.

Core Features & Use Cases

• Variant-level performance ranking: Ranks variants by revenue, units sold, and refund rate within a selected date range.
• Refund-aware metrics: Computes gross revenue, refunded amount, net revenue, and refund rate to reflect returns accurately.
• Inventory cross-reference: Joins sales performance to current inventoryQuantity to surface dead weight candidates and highlight top performers.
• Output for action: Produces a CSV (variant_performance_<date>.csv) and, optionally, human-readable ranked tables for quick decision-making.

Quick Start

Run the skill to rank variants for a specific date range and output a CSV by requesting: “Rank my Shopify variants from 2025-01-01 to 2025-01-31 by revenue and include bottom performers, using store mystore.myshopify.com.”