# Shopify Product-to-Order Analyzer

> Find out which products actually sell and which are dead weight. No exports, no spreadsheets, just ask.

Source: https://cotera.co/solutions/marketing/shopify-product-order-analyzer

---

- **Team:** Marketing
- **Tools:** Shopify
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 2 hrs/analysis

## How it works
1. **Catalog + Orders Together** — Cross-reference your full product catalog with recent order data
2. **Find Top Performers** — Rank products by revenue, units sold, and unique customer count
3. **Spot Dead Inventory** — Identify products with zero orders in the time range
4. **Repeat Purchase Patterns** — See which products customers come back to buy again

## Example requests
- Which products had the most orders in the last 30 days?
- Find all products with zero sales this quarter
- What are the top 5 products by revenue and which customers buy them repeatedly?

## Prompt

```markdown
## Task

Use @Shopify/List Products to get the full product catalog, then @Shopify/List Orders to pull recent orders. Cross-reference to find top sellers, dead inventory, and repeat purchase patterns. Use @Shopify/Get Customer Orders by Email for deep dives into specific customer behavior.

## Input

The user provides their Shopify store context and what they want to analyze.

**Example:** "Which products had the most orders in the last 30 days?" or "Find all products with zero sales this quarter"

## Context

### What to Analyze

- Product-to-order mapping: which products appear in the most orders
- Revenue ranking: top products by total revenue
- Dead inventory: products with zero orders in the time range
- Variant performance: which sizes/colors/options sell best
- Repeat purchases: products customers buy more than once
- Customer patterns: who buys what and how often

### Strategy

1. Pull full product catalog with variants and pricing
2. Pull recent orders with line items
3. Map orders to products
4. Rank by revenue and order count
5. Identify dead inventory and repeat patterns

## Output

**Product Performance Report:**

**Top Sellers:**
- Top 10 products by revenue and order count

**Dead Inventory:**
- Products with zero orders in the period

**Repeat Purchase Leaders:**
- Products customers come back to buy

**Recommendations:**
- Products to promote, discount, or discontinue
```

## Related reading
- [Shopify Marketing Automation with AI Agents](https://cotera.co/articles/shopify-marketing-automation-ai.md)
- [Shopify Product Analytics with AI](https://cotera.co/articles/shopify-product-analytics-ai.md)