Shopify — Channel Overview

Researched: May 2026

Why This Channel

Shopify powers ~4.5 million online stores globally. For Leadmetrics clients in retail, fashion, food, home goods, and lifestyle — Shopify is their primary revenue system. Connecting it turns Leadmetrics from a generic marketing tool into an e-commerce content engine.

The most immediate value: agents can write product descriptions, collection page copy, and promotional content using actual product data instead of generic prompts. The current workflow requires clients to manually paste product details into the agent chat; a Shopify connection eliminates that entirely.

The second value stream: sales data tells agents what to write about. If the “Summer Linen Collection” is converting at 12% but needs more traffic, the Content Brief Writer can create a targeted blog post and landing page for that specific collection.

Auth Mechanism

OAuth 2.0 (Shopify Partner App flow).

• Auth URL: https://{shop}.myshopify.com/admin/oauth/authorize
• Token URL: https://{shop}.myshopify.com/admin/oauth/access_token
• Scopes: read_products read_orders read_customers read_analytics
• Token type: permanent (Shopify offline access tokens do not expire; no refresh needed)

The shop subdomain ({shop}.myshopify.com) is required at connection time — stored as subChannelInfo.id = shop and channel.url = https://{shop}.myshopify.com.

The connection flow requires the user to enter their Shopify store URL first (the url field), then initiates the OAuth popup — same pattern as WordPress basic auth but with OAuth.

What It Enables

Workers Needed

RAG Integration

Synced product and collection data is ingested into the RAG pipeline so all agents have context. The RAG dataset for Shopify:

Ingested via the same rag-ingest queue pattern used for blog posts and web pages.

Insight Worker Output (ChannelInsight)

• Revenue and order count (last 30 days vs. prior 30 days)
• Top 5 products by revenue
• Conversion rate trend
• Average order value trend
• Most returned items (content opportunity: write better product descriptions)
• Suggested: blog topics and landing pages based on high-traffic, low-conversion products

Channel Detail Page — ShopifyChannelDetail.tsx

Tabs:

1. Overview — store name, revenue, orders, conversion rate (last 30 days)
2. Top Products — ranked table; click to generate content brief for that product
3. Collections — list with product counts and revenue contribution
4. Insights — AI-generated e-commerce performance summary
5. Suggestions — content actions (write product description, create collection landing page, etc.)

Implementation Plan

Phase 1 — Connect + Product Sync

1. Create packages/providers/shopify/src/index.ts:

   • getAuthUrl(shop, callbackUrl, channelId) — Shopify OAuth URL with shop subdomain
   • exchangeCode(shop, code) — returns permanent accessToken
   • getProducts(shop, accessToken, pageInfo?) — paginated GET /admin/api/2024-01/products.json
   • getCollections(shop, accessToken) — custom + smart collections
   • getOrders(shop, accessToken, since?) — revenue + order data
   • getShopInfo(shop, accessToken) — store name, currency, timezone
   • verify(shop, accessToken) — GET /admin/api/2024-01/shop.json

2. Add connection flow to apps/api/src/routers/channel-connect.ts:

   • GET /shopify/connect → requires shop query param (store URL); return auth URL
   • GET /shopify/callback → exchange code, store permanent token, close popup
   • Note: no page selection step — one token per store

3. Update channel add UI: Shopify requires the user to enter their store URL ({store}.myshopify.com) in the Add Channel form before OAuth can start

4. Create shopify-sync.worker.ts:

   • Fetch products + collections → upsert to RAG + a lightweight ShopifyProduct cache table for the channel detail page
   • Fetch orders (last 90 days) → aggregate metrics for the detail page

5. Add seed entry to packages/db/prisma/seed.ts

6. Create ShopifyChannelDetail.tsx

Phase 2 — Analytics + Insights

7. Pull Shopify Analytics data: sessions, conversion funnel, traffic sources

8. Create shopify-insights.worker.ts

Phase 3 — Content Generation Actions

9. “Generate product description” button on product row → triggers content-brief-writer with product data as context

10. “Create collection landing page” → triggers landing page writer with collection data pre-filled

DB Changes Needed

model ShopifyProduct {
  id           String   @id @default(cuid())
  tenantId     String
  channelId    String
  shopifyId    String   // Shopify product ID
  title        String
  description  String?  @db.Text
  price        Decimal?
  collections  String[]
  tags         String[]
  imageUrl     String?
  syncedAt     DateTime @default(now())
 
  tenant  Tenant           @relation(fields: [tenantId], references: [id])
  channel ConnectedChannel @relation(fields: [channelId], references: [id])
 
  @@unique([channelId, shopifyId])
  @@index([tenantId])
}

Seed Entry

// packages/db/prisma/seed.ts — CHANNEL_CATALOGUE
{
  type: "Shopify",
  name: "Shopify",
  iconKey: "shopify",
  description: "Connect your Shopify store to generate product content and track e-commerce performance.",
  authenticationType: "oauth2",
  requiresUrl: true,  // user must enter store URL first
  isActive: true,
  categories: ["ecommerce"],
},