How to Connect Claude to Shopify for Orders, Products & Inventory (2027)

Connect Claude to Shopify via Otto MCP to query live orders, products, and inventory alongside GA4 and paid ads without exporting CSVs.

As seen in

  • Fox News
  • ABC News
  • CBS
  • NBC
  • Associated Press
  • USA Today
  • Bloomberg
  • HuffPost
Otto the beaver next to the Google Analytics logo
On this page7

Connect Shopify to Claude by authorizing your store once via OAuth inside Otto and adding Otto's hosted HTTP MCP server (https://otto.islaintel.com/api/mcp) to Claude with a single otto_mcp__ token—or install Shopify's local AI Toolkit (@shopify/dev-mcp) for developer docs and schema checks. In Otto MCP, Shopify reads are open on every plan, while product and inventory changes need Pro and a reviewer or admin; you query it alongside 227 tools across 15 integrations with Google Analytics 4 (GA4), Google Sheets, and Meta or Google Ads while cutting Claude token usage by 80–90% versus pasting a raw 3,000-row Meta Ads Manager CSV. To get started, connect Claude to Otto MCP.

Copy-paste Claude prompts for Shopify orders, products, and cross-channel ops (start here)

Store operators need immediate numbers rather than CSV downloads. These five prompts query live Shopify metrics through Otto MCP and correlate them with search, paid media, and analytics tools in the same conversation.

1. 30-day Shopify order and product catalog summary

Pull my Shopify store for the last 30 days: gross revenue, completed order count, AOV, top 5 products by units and revenue, and inventory on those SKUs. Flag variants under 15 units in stock.

2. Cross-channel funnel reconciliation (Shopify vs. GA4 vs. Google Sheets)

Reconcile last month's Shopify completed orders and net sales with GA4 purchase events and sessions on product landing pages, then compare both to our revenue and order targets in Google Sheets. Report the delta and pacing.

3. Paid-media ROAS and CPA cross-check (Shopify vs. Meta & Google Ads)

For the last 14 days, compare Shopify completed-order revenue against Meta Ads spend and read-only Google Ads campaign spend. Return blended ROAS and CPA by channel.

4. High-impression Google Search Console query check paired with Shopify catalog coverage

List Search Console queries with impressions in the last 28 days and average position 4–15. Match them to Shopify product titles and tags, and list high-intent queries with no matching product or collection page.

5. Mobile Core Web Vitals audit and draft-first fix

Run psi_analyze_url on our three busiest Shopify collection pages (mobile). Report LCP and CLS, then draft a WordPress post or GitHub pull request description for the fixes.

Exporting Shopify CSVs by hand vs. Shopify's local Dev MCP vs. Claude + Otto MCP

Remote MCP servers run over HTTP so the client does not install credentials on every device.

CapabilityManual CSV ExportsShopify Dev MCP (@shopify/dev-mcp)Claude + Otto MCP
Setup methodManual export from Shopify Admin and Ads ManagerLocal stdio process via npx -y @shopify/dev-mcp@latestHosted HTTP endpoint (https://otto.islaintel.com/api/mcp)
Token usageLarge Admin exports fill context; a 3,000-row Meta Ads Manager CSV can consume 40,000 to 80,000 tokens per turnMinimal (developer docs and schemas only)80–90% lower token usage via aggregated metrics
Data accessedStatic, disconnected point-in-time snapshotsShopify API schemas, developer docs, code validationLive Shopify orders, products, and inventory
Cross-channel correlationManual VLOOKUP across tabsNone (Shopify developer tooling only)GA4, Google Sheets, Search Console, Meta Ads, Google Ads
Authentication requiredManual login per platformNone (unauthenticated local developer tool)One-time OAuth inside Otto; single otto_mcp__ token
Live execution & fixesNone (read-only spreadsheet files)Local code generation and schema checksDraft-first WordPress updates and GitHub pull requests

Uploading a raw 3,000-row Meta Ads Manager CSV into Claude can consume 40,000 to 80,000 tokens in a single turn; large Shopify order exports create the same paste-the-whole-file problem without aggregated queries. Connect Claude to Otto MCP

What Shopify's Admin API scopes, Protected Customer Data rules, and rate limits enforce under the hood

Under Shopify API access scopes, permissions dictate object visibility:

  • read_orders grants read access to Order, Fulfillment, AbandonedCheckout, OrderTransaction, and DeliveryCarrierService objects created within the last 60 days. Accessing orders older than 60 days requires declaring read_all_orders and completing Shopify's approval process.
  • read_products grants read access to Product, ProductVariant, Collection, and ResourceFeedback.
  • read_inventory grants read access to InventoryItem and InventoryLevel.
  • read_locations grants read access to merchant inventory Location records.

Under Protected Customer Data rules, Orders and Customers need Level 1 or Level 2 approval for customer-identifying fields, while the product query is not treated as protected customer data.

Shopify API limits cap input arrays at 250 items, pagination and counts at 25,000 objects, and GraphQL Admin API usage by calculated query cost per plan. Otto MCP returns filtered, aggregated records to Claude.

How to connect Claude to Shopify in five steps with Otto MCP

Setting up Claude with your live store takes five steps and keeps credentials secure on the server.

Step 1: Authorize your Shopify store inside Otto

Log into Otto and follow the Connect Shopify to Otto setup guide. Authorize your Shopify store using one-time OAuth alongside your other channels, including GA4, Search Console, Google Sheets, and Meta Ads. Your Shopify Admin credentials and OAuth tokens stay stored on Otto's infrastructure and are never exposed in Claude chat transcripts.

Step 2: Copy your hosted Otto MCP endpoint and bearer token

In your Otto account dashboard, open the MCP configuration tab as described in the How to Connect Claude to Otto MCP documentation. Copy your hosted MCP server endpoint URL (https://otto.islaintel.com/api/mcp) and your organization-scoped bearer token, which uses the otto_mcp__ prefix.

Step 3: Add the custom connector in Claude

Open Claude (Claude Web, Claude Desktop, or Claude Code) or configure Cursor by following How to Connect Cursor to Otto MCP. In Claude's settings, add a custom MCP connector using the Server Sent Events (SSE) or HTTP transport:

  • Server URL: https://otto.islaintel.com/api/mcp
  • Header: Authorization: Bearer otto_mcp__YOUR_TOKEN

Claude loads the registered tools across your active integrations.

Step 4: Run read-only order, inventory, and catalog queries

Prompt Claude to inspect your store. Ask for last week's sales volume, low-inventory variants, or top-performing collections. Otto MCP calls the read-only Shopify endpoints, filters the payload, and cuts Claude token consumption by 80–90% compared to pasting a raw 3,000-row Meta Ads Manager CSV.

Step 5: Correlate with speed checks and draft-first updates

Pair store insights with site health audits. Run Otto's built-in psi_analyze_url tool to inspect Core Web Vitals on slow product pages without entering a personal Google API key. If you find conversion drop-offs, prompt Claude to prepare a WordPress draft post or open a GitHub pull request with a preview deployment to resolve layout issues.

When to use Shopify's official AI Toolkit (@shopify/dev-mcp) alongside Otto MCP

Shopify's Shopify AI Toolkit and local @shopify/dev-mcp server target developer docs, GraphQL/Liquid validation, and extension checks—not live order reporting. Pair that toolkit with Otto's hosted MCP server for store ops, GA4, and paid ads in one Claude session.

Four cross-channel Claude workflows for Shopify orders, GA4 funnels, and Google Sheets KPIs

COO Enrique Vásquez writes operations-focused guides on Shopify and Google Sheets reporting at IslaIntel.

Workflow 1: The Monday store, GA4, and Google Sheets executive briefing

Connecting Google Analytics 4 (GA4) to Otto and Google Sheets to Otto supports multi-channel reporting in Otto Website Analytics and weekly briefings. Prompt Claude:

"Reconcile my Shopify orders from the last 7 days against GA4 traffic sessions and our target row in Google Sheets. Highlight any conversion rate drops on collection pages."

Claude checks Shopify completed orders, queries GA4 conversion events, and compares net sales against target cells in Google Sheets without pasting multi-thousand-row CSV exports.

Workflow 2: Paid ad spend vs. store order attribution

Growth marketers can evaluate acquisition efficiency by comparing paid media against confirmed orders. Learn more about how to connect Claude to Meta Ads in 2027 and evaluating GA4 and paid media landing page insights. Prompt Claude:

"Pull our Meta Ads spend and read-only Google Ads campaign costs for the last 14 days. Compare total ad spend against completed order revenue in Shopify to calculate blended ROAS and paid CPA."

Claude queries ad spend across networks, checks completed Shopify checkouts, and highlights campaigns generating traffic that fails to purchase.

Workflow 3: High-traffic product and landing-page speed audits

Slow product pages reduce e-commerce checkout rates. Review how Core Web Vitals drift causes revenue loss on landing pages. Prompt Claude:

"Run psi_analyze_url on our three highest-traffic product pages. Report mobile LCP and CLS."

Otto MCP runs psi_analyze_url with Otto's platform key—no personal Google API key required. Otto also ships automated image optimization (v1.1.5) and weekly SEO reports (v1.2.0).

Workflow 4: Operating the stack you already run

Otto works directly with your current technology stack rather than requiring a site migration. Explore our supported Otto integrations across Shopify, WordPress, GitHub, GA4, Search Console, and Paid Ads.

Otto AI Website Manager keeps WordPress posts and pages in draft across 29 tools until you publish, and opens GitHub edits as pull requests with previews. You can approve changes from WhatsApp (v1.1.0).

Read-only analytics vs. approval-gated execution: plans, honest limitations, and FAQs

For broader tool comparisons, see 7 best Ryze AI alternatives for paid ads and SEO in 2027.

Specialized tools cover slices of the stack:

  • Madgicx provides creative analytics with rule-based bidding automation for e-commerce ad accounts.
  • Opteo monitors Google Ads accounts and recommends negative keywords and bidding adjustments, but does not cover Meta Ads, SEO, or Claude MCP.
  • Synter offers connectors for Claude across 40+ ad networks, but does not deploy website changes or manage technical SEO.
  • Ryze AI focuses on paid ads and SEO/GEO automation, whereas Otto manages website deployments via GitHub pull requests, WordPress drafts, and Google Business Profile updates.

Pricing and plans

Otto MCP comes with every Otto plan, and Starter is MCP only. You can review all options on our Otto Starter, Pro, and Enterprise pricing page:

  • Starter ($9.99/week or $29.99/month, paid in full, no free trial): MCP only: Otto inside Claude, ChatGPT, or Cursor, reading every connected source, with up to 1,000 data requests a day and one seat. It can publish posts to Instagram, Facebook Pages, LinkedIn, and Google Business Profile, but can't schedule, change ads, generate images, or edit the site.
  • Pro ($199/month, or $99/month billed annually at $1,188/year): Starts with $1 today for 3 days, then the plan price; card required. Covers the Otto app and chat, managed website updates, scheduling, ad changes, image generation, team seats, and WhatsApp, email, and voice. Users can cancel anytime.
  • Enterprise (no published price): A call with the founder, for teams that want Otto across more than one brand.

Operational boundaries and limitations

  • YouTube, Google Sheets, and PageSpeed Insights are read-only in Otto MCP; Shopify, GA4, Search Console, Google Ads, and Google Business Profile review-reply changes need Pro and a reviewer or admin; GBP local posts work on every plan.
  • Checkout, contact, and legal pages always need human approval in Otto core; WordPress stays draft-first and GitHub uses pull requests with previews.
  • Facebook Pages and Instagram publishes go live immediately and need Reviewer or Admin access on any plan.
  • LinkedIn Ads create as DRAFT; $0 budgets are rejected; Meta and LinkedIn ad writes need Pro and a reviewer or admin.
  • Otto CLI is coming soon (MCP is today's path); Wix, Webflow, and TikTok are not live integrations; Otto does not promise rankings or ChatGPT citations.

Frequently asked questions

Can Claude modify my Shopify inventory levels or change product pricing through Otto MCP?

Only with approval. On Pro, a reviewer or admin can update products and set inventory through Otto MCP; new products save as drafts, and making a product active needs an explicit confirm. The order, inventory, and catalog queries in this guide only read, so they change nothing, and Otto MCP doesn't modify store settings.

Why use Otto MCP instead of pasting my Shopify Admin API token directly into Claude?

Pasting Admin API tokens into chat sessions exposes access keys in transcripts and can run into Shopify Protected Customer Data rules on Orders and Customers. With Otto MCP, you connect accounts once inside Otto and the AI client holds only an Otto MCP token while OAuth secrets stay on Otto's server. Claude calls Otto's hosted endpoint with your organization-scoped otto_mcp__ bearer token.

How does Otto MCP keep token usage low when querying store data?

Uploading a raw 3,000-row Meta Ads Manager CSV into Claude can consume 40,000 to 80,000 tokens in a single turn. Otto MCP queries only the specific metrics, filtered date ranges, and aggregated data points requested, cutting token consumption by 80–90%.

Can Otto MCP query Shopify orders older than 60 days?

Shopify's Admin API restricts read_orders to records created within the last 60 days by default. Under Shopify API access scopes, accessing older order records requires declaring the read_all_orders scope and completing Shopify's developer review requirements.

Connect your store to Claude today: Connect Claude to Otto MCP.

Written by

Enrique Vazquez

Chief Operating Officer at IslaIntel

Runs planning, process automation, and project delivery for IslaIntel's AI work in the Caribbean.