shopify-admin-variant-performance-report

Rank Shopify product variants by revenue, units sold, and refund rate against inventory.

174|18|Updated Apr 11, 2026
One-click install
npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-variant-performance-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: shopify-admin-variant-performance-report
Source: https://github.com/40RTY-ai/shopify-admin-skills/tree/main/skills/merchandising/shopify-admin-variant-performance-report
Command: npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-variant-performance-report

SYSTEM DOCUMENTATION & REQUIREMENTS

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.”

Frequently Asked Questions about shopify-admin-variant-performance-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I rank Shopify product variants by revenue and refund rate?

To rank Shopify product variants by revenue and refund rate, you need a tool that queries your store's historical orders and computes net revenue metrics. This Skill ranks variants by units sold and refunds, outputting a CSV file for SKU optimization.

How do I identify dead weight SKUs in my Shopify inventory?

Identifying dead weight SKUs requires comparing sales performance against current inventory levels. This Skill joins your Shopify variant revenue and refund rates with live inventoryQuantity data to pinpoint which SKUs tie up shelf space versus top performers.

Can I use Shopify GraphQL to analyze variant performance over a specific date range?

Yes, you can use Shopify GraphQL to analyze variant performance over a specific date range. This Skill performs read-only GraphQL queries for orders and product variants, calculating gross revenue, refunded amounts, and net revenue within your selected historical dates.

What is the best way to optimize merchandising decisions using variant analytics?

The best way to optimize merchandising with variant analytics is to cross-reference refund rates and sales rankings with inventory data. This approach surfaces dead weight candidates and top performers, directly informing your reordering priorities and refund-risk investigations.

Does this Skill require any specific dependencies to analyze Shopify inventory?

No specific dependencies are required to analyze Shopify inventory with this Skill. It operates independently using read-only Shopify GraphQL queries to retrieve order and product variant data, joining the results with your current inventory levels for analysis.

Why are my Shopify refund rates important for inventory optimization?

Shopify refund rates are important for inventory optimization because they reflect actual net revenue and return risks. By computing gross revenue, refunded amounts, and refund rates, this Skill helps you avoid reordering problematic SKUs and identifies true top performers.