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.
| Capability | Manual CSV Exports | Shopify Dev MCP (@shopify/dev-mcp) | Claude + Otto MCP |
|---|---|---|---|
| Setup method | Manual export from Shopify Admin and Ads Manager | Local stdio process via npx -y @shopify/dev-mcp@latest | Hosted HTTP endpoint (https://otto.islaintel.com/api/mcp) |
| Token usage | Large Admin exports fill context; a 3,000-row Meta Ads Manager CSV can consume 40,000 to 80,000 tokens per turn | Minimal (developer docs and schemas only) | 80–90% lower token usage via aggregated metrics |
| Data accessed | Static, disconnected point-in-time snapshots | Shopify API schemas, developer docs, code validation | Live Shopify orders, products, and inventory |
| Cross-channel correlation | Manual VLOOKUP across tabs | None (Shopify developer tooling only) | GA4, Google Sheets, Search Console, Meta Ads, Google Ads |
| Authentication required | Manual login per platform | None (unauthenticated local developer tool) | One-time OAuth inside Otto; single otto_mcp__ token |
| Live execution & fixes | None (read-only spreadsheet files) | Local code generation and schema checks | Draft-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
Otto MCP
Ask your AI assistant what changed in your ads
Connect Claude or ChatGPT to Otto, then ask about Meta Ads, Google Ads, GA4, and Search Console in the same chat. The logins stay in Otto.
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_ordersgrants read access toOrder,Fulfillment,AbandonedCheckout,OrderTransaction, andDeliveryCarrierServiceobjects created within the last 60 days. Accessing orders older than 60 days requires declaringread_all_ordersand completing Shopify's approval process.read_productsgrants read access toProduct,ProductVariant,Collection, andResourceFeedback.read_inventorygrants read access toInventoryItemandInventoryLevel.read_locationsgrants read access to merchant inventoryLocationrecords.
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.
Otto Website Analytics
Monday should say what actually changed.
Otto checks that the numbers are still counting, then sends the week in plain language. Visitors, the pages that moved, and the fix worth doing next.
See how Otto does it