Shopify Product-to-Order Analyzer

Task

Use @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products to get the full product catalog, then @Shopify/List OrdersName it "Shopify/List Orders" and call it with @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 EmailName it "Shopify/Get Customer Orders by Email" and call it with @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