cotera

Shopify Product-to-Order Analyzer

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

Product performanceRevenue analysisDead inventoryRepeat purchases

The Challenge

You want to know which products to push this month. So you export orders to a CSV, open the products page in another tab, start cross-referencing in a spreadsheet, build pivot tables, and two hours later you have a rough idea of what is selling. Next month you do it all over again because the spreadsheet is already stale.

What This Prompt Does

Catalog + Orders Together

Cross-reference your full product catalog with recent order data

Find Top Performers

Rank products by revenue, units sold, and unique customer count

Spot Dead Inventory

Identify products with zero orders in the time range

Repeat Purchase Patterns

See which products customers come back to buy again

The Prompt

The Prompt

Task

Analyze which products drive the most orders and revenue by cross-referencing the product catalog with order data. Use @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products to get the catalog, @Shopify/List OrdersName it "Shopify/List Orders" and call it with @Shopify/List Orders to pull order history, and @Shopify/Get Customer Orders by EmailName it "Shopify/Get Customer Orders by Email" and call it with @Shopify/Get Customer Orders by Email to look at specific customer purchasing patterns.

Example: "Which of our products had the most orders last month? Which ones haven't sold in 30 days?"

Input

The user will provide:

  1. Time range for the analysis (e.g., "last 30 days", "Q1 2026")
  2. What they want to know (top sellers, underperformers, repeat purchases, etc.)
  3. Optionally, specific products or categories to focus on

Context

Analysis Workflow

Steps to follow:

  1. Pull the product catalog with @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products to get the full picture
  2. Pull orders for the time range with @Shopify/List OrdersName it "Shopify/List Orders" and call it with @Shopify/List Orders
  3. Cross-reference which products appear in which orders
  4. For repeat purchase analysis, use @Shopify/Get Customer Orders by EmailName it "Shopify/Get Customer Orders by Email" and call it with @Shopify/Get Customer Orders by Email on top customers
  5. Calculate metrics: units sold, revenue per product, order frequency
  6. Rank products and identify patterns

Metrics to Calculate

  • Units sold per product in the time range
  • Revenue per product (units x price)
  • Number of unique customers per product
  • Products with zero orders in the time range (dead inventory)
  • Products that appear together in orders (frequently bought together)
  • Repeat purchase rate for top products

Output

Product analysis report:

  • Top 10 products by revenue
  • Top 10 products by units sold
  • Products with zero sales in the time range
  • Repeat purchase patterns (if analyzed)
  • Products frequently bought together
  • Recommendations for marketing focus

Example Usage

Try asking:

  • →"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?"