MCP & AI reporting

How to Connect Shopify to Claude with MCP

Connect Shopify to Claude with the Data Bloo MCP and pull orders, revenue, average order value and top products straight from the chat, no exports, no dashboards. Then line store revenue up against your ad spend for true ROAS. It's read-only, so it's safe, and here's the 2-minute setup.

Free to startRead-only & secureWorks in ~2 min
ClaudeData Bloo connected
Pull orders, net sales and average order value for my Shopify store, last 30 days.
query_data · Shopify ✓
Here's your last 30 days on Shopify:
Metric
Value
Orders
1,842
Net sales
€96,418
Avg order value
€52.34
Orders are up 9% vs the prior period with AOV steady at €52.34. Want revenue by product, or lined up against your ad spend?
Reply to Claude…
The one thing you need

Your Data Bloo MCP URL

Paste this into Claude when you add a custom connector. Then expand Advanced settings and enter 43 in the OAuth Client ID field, leave the Client Secret blank. That's the whole secret; everything below is just where to click.

https://mcp.databloo.com/mcp
Using Claude Code instead? Grab the one-line CLI command →

What connecting Shopify to Claude actually means

You can ask Claude about your Shopify store and get a real answer, pulled from your actual sales data, in seconds. Type "how did my store do last month" and Claude reads your orders, revenue and top products and tells you, no CSV export, no dashboard to open. The connection runs through the Data Bloo MCP, takes about two minutes to set up, and it's read-only, so Claude can analyze your store but can never change a product, an order or a setting.

One thing worth knowing up front: Shopify's own MCP servers do a different job. The Storefront MCP lets AI shopping agents browse your catalog and build carts for customers, and the Dev MCP helps developers build on Shopify. Neither answers "what were my sales last week". Want Claude to read, analyze and report on your store, blend revenue with Facebook Ads, Google Ads and TikTok Ads spend, and feed the same data to your Data Studio dashboards? That's Data Bloo, and that's what the rest of this guide covers.

Why connect Shopify to Claude

Stop exporting order reports. Start asking.

The same Shopify store you already trust for your Data Studio reports, now answering questions in a chat. No exports, no dashboards to open.

Ask, get instant answers

"Which products drove the most revenue last week?" Claude pulls the numbers and explains them.

True ROAS, finally

Line Shopify revenue up against Facebook Ads, Google Ads and TikTok Ads spend in one answer. Real store revenue over real ad spend, not the number each ad platform claims for itself.

Reports inside the chat

Ask for a 30-day store view and get tables plus a summary ready to share, no Data Studio setup.

Diagnose dips fast

"Why did revenue drop on Tuesday?" Claude looks across products, channels and dates and explains it.

Client-ready summaries

"Turn the last 30 days of store performance into an executive summary." Paste it into Slack, email or a doc.

Connect once, use everywhere

The same Shopify store you linked for Data Studio is instantly available to Claude, zero duplicate setup.

Supported data sources

Shopify, plus every other connector

Already connected in Data Bloo? It's instantly available to Claude, connect once, use everywhere.

Pick your route

Three ways to connect Shopify to Claude

There are three real options, built for different jobs. Here's the honest version, including the case where the answer isn't us, so you pick the right one the first time.

Recommended for reporting

A connector like Data Bloo

Connect once and your Shopify sales data, plus every other source in Data Bloo, is available to Claude any time. Read-only, blends store revenue with ad channels for true ROAS, and the same connection feeds your Data Studio reports.

Shopify's official MCPs

Shopify ships several MCP servers, but for other jobs: the Storefront MCP lets AI shopping agents browse your catalog and build carts for customers, and the Dev MCP gives developers Shopify's docs and GraphQL schemas inside Claude Code. Great at what they do; none of them is a sales-reporting tool for you, the merchant.

A manual CSV export

Export orders from your Shopify admin, save the file, upload it to Claude. Free, and it works once. Then you do it again next week, and it still can't see your ad spend.

Data Bloo vs Shopify's official MCPs vs a manual export

Data Bloo
Shopify MCPs
Manual CSV
Setup
~2 min, point & click
Per surface: admin toggle or npm install
New export each time
Reads your sales data
Yes
No, catalog & dev docs
A snapshot
Changes your store
No (read-only)
Can create carts & checkouts
No
Blends other channels
Yes, ads + store
No, Shopify only
By hand
Feeds Data Studio
Yes, same connection
No
No
Works with other AI
Yes (ChatGPT, Gemini…)
Yes (any MCP client)
Any (paste a file)
Price
Free to start
Free
Free
Upkeep
None
Low, surfaces still evolving
Redo it each time

The bottom line: if you want AI agents to shop your store or you're building on Shopify, Shopify's own MCPs do that. If you want Claude to read and report on your sales, blend them with your ad channels for true ROAS, and feed the same data to your dashboards, that's Data Bloo.

The honest bit

When to use Shopify's official MCPs instead

Data Bloo isn't the right tool for every Shopify-and-AI job. Shopify has gone deep on MCP, just aimed at different users. The Storefront MCP makes your store shoppable by AI agents: customers ask an assistant for a product, the agent searches your catalog, checks policies and builds a cart, right through to checkout with the companion Checkout and Customer Account MCPs. If agentic commerce matters to you, and in 2026 it should, turn it on. The Dev MCP is for developers: it puts Shopify's docs and GraphQL schemas inside Claude Code and Cursor, part of the AI Toolkit Shopify open-sourced in April 2026. If you're building a theme or an app, use it, it's excellent.

What none of them do is answer "how were my sales last month". They serve your customers and your developers, not your reporting. Shopify has said an analytics-focused MCP is on the roadmap, but even then it would be Shopify-only, it can't put your Facebook Ads spend next to your store revenue. That cross-channel view, plus Data Studio dashboards from the same connection, is exactly the job Data Bloo does. Plenty of stores run both: Shopify's MCPs to sell, Data Bloo to read, blend and report.

Before you start

What you need

Three things, and you probably already have them.

A Data Bloo account with Shopify connected. If you already use Data Bloo for your Data Studio reports, your store is ready, connect once, use everywhere.
A Claude account. Desktop, Web or Claude Code all work, and a free Claude account is enough to start.
Pop-ups allowed for sign-in. Data Bloo's sign-in opens a browser window during setup, so make sure your browser isn't blocking it.
Setup · ~2 minutes

How to connect Shopify to Claude

Pick your Claude client. Desktop & Web are easiest for most marketers; Claude Code is a one-liner for developers.

1
Open Claude and click the + in the chat

Launch Claude Desktop or claude.ai. In the chat input, click the + icon on the left to open the tools menu.

2
Go to Connectors → Manage connectors

Hover over Connectors, then click Manage connectors to open your connector settings.

3
Click + → Add custom connector

Click the small + at the top of the connector list, then choose Add custom connector.

4
Name your connector "Data Bloo"

Type Data Bloo in the Name field. That's how you'll find it inside any conversation later.

5
Paste the Data Bloo MCP URL

In the Remote MCP server URL field, paste https://mcp.databloo.com/mcp. Then expand Advanced settings and enter 43 in the OAuth Client ID field, leave the Client Secret blank.

6
Click Add and sign in

Claude opens your browser on Data Bloo's sign-in page, sign in and approve so Claude can read your data. You sign in once.

7
Ask about your Shopify store

Start a new chat and try: "Using Data Bloo, pull orders, net sales and average order value for my Shopify store for the last 30 days." Claude returns a table plus a short analysis.

Step 1, Register the Data Bloo MCP

Open your terminal and run:

terminal
# Register Data Bloo as an HTTP MCP server in Claude Code
claude mcp add --transport http databloo https://mcp.databloo.com/mcp
Step 2, Authenticate with Data Bloo

Next time you start a Claude Code session, Claude opens your browser to sign in to Data Bloo. Sign in once, the connection persists across sessions.

Step 3, Verify

Run /mcp, you should see databloo with status connected.

Confirm it works: in a fresh chat, ask "Using Data Bloo, list all the Shopify stores I have connected." If Claude returns your store, you're fully connected.

See it in action

Take the MCP for a spin

Walk through connecting Shopify to Claude and pulling a report, no signup, right here in the page.

Under the hood

Seven read-only tools, why your store stays safe

You just ask in plain language, Claude picks the right tool. The typical flow: list_data_sources → get_connector_accounts → list_fields → query_data.

Tool
What it does
get_user
Your plan, MCP access, usage limits and remaining calls.
list_data_sources
Every available connector, with its name and description.
get_connector_accounts
Your linked Shopify stores, and the IDs to query.
list_fields
The valid metrics and dimensions for Shopify.
query_data
The actual pull: metrics and dimensions over a date range.
list_accounts
Every connected account across every connector, in one call.
get_dates
Turns "last month" into the exact start and end dates to query.

Read-only, always. Claude can pull and analyze your Shopify data, it can never edit a product, change an order, issue a refund or touch a store setting. Your storefront stays exactly as you left it.

Why Data Bloo

Read-only safety and your dashboards, in one connection

Shopify's own MCPs serve your customers and your developers. The reporting job, sales in plain language, blended with your ad channels, feeding your dashboards, is a different job, and it's the one Data Bloo does with a single connection.

It can't touch your store

All seven tools are read-only. Claude pulls and analyzes your Shopify data, but it can't edit a product, cancel an order, change a price or issue a refund, so there's no wrong instruction that could put your store at risk. No safety checklist to memorize, because there's nothing to switch off.

One connection, two surfaces

The Shopify source you built for Data Studio is the same one Claude reads. No second setup, no second bill, and the numbers Claude quotes always match the dashboards you send clients or check every Monday. It's the one thing a customer-facing, Shopify-only MCP structurally can't give you.

The data

What Shopify data you can pull

The same metrics you use in your reports, sliced by product, order date, customer type, country and sales channel.

Sales & revenue

Orders, gross sales, net sales, total revenue and average order value, daily, weekly or monthly.

Customers, refunds & discounts

Customers split new vs returning, plus refunds and discounts, so net numbers tell the honest story.

Products

Top products by revenue and units sold, spot your bestsellers and the SKUs quietly slipping.

Breakdowns

Product, order date, customer type, country and sales channel, ask for any of them in plain language.

Real answers

What Claude actually gives you back

Three real prompts and the kind of answer Claude returns once Shopify is connected through Data Bloo, numbers, then a plain-language read.

"Pull orders, net sales and average order value for my Shopify store, last 30 days."

Claude: Last 30 days on Shopify, 1,842 orders, €96,418 in net sales and a €52.34 average order value. Orders are up 9% on the prior period, AOV is flat.

The read: growth is coming from order volume, not order size, a bundle or free-shipping threshold could lift AOV too.
"Which products drove the most revenue last month, and how many units did each sell?"

Claude: Top three, Everyday Sneaker · White at €14,820 (312 units), Canvas Weekender at €9,640 (154 units), Merino Crew Sock 3-pack at €7,215 (485 units). Together they're 33% of last month's revenue.

The read: a third of revenue sits in three products, keep them in stock, and consider featuring them in your ads.
"Line my Shopify revenue up against Facebook Ads and Google Ads spend for last month. What's my blended ROAS?"

Claude: Shopify net sales, €96,418. Facebook Ads spend, €16,467. Google Ads spend, €9,210. That's €25,677 total spend against store revenue, a blended ROAS of 3.75×, up from 3.4× the month before.

The read: this is real store revenue over real ad spend, not what each ad platform claims for itself, and it's trending the right way.

Example outputs shown for illustration; your figures come live from your own connected store.

Data Bloo MCP

Not just charts. Finished, branded deliverables

Plug your live Shopify data into Claude, ChatGPT or Gemini through our MCP, and generate branded presentations, audits and executive reports straight from a chat prompt.

Client presentations

Slide-ready decks with your logo, colors and commentary, built from live data, ready to send.

92
!

Audits

Automated store audits that flag issues, wins and opportunities, with clear next steps.

REV
€96K
ROAS
3.8×
AOV
€52

Executive reports

Concise, narrative summaries for leadership, the numbers that matter, explained in plain language.

Try it

Prompts to paste into Claude

Once connected, drop any of these into a fresh chat. Name Data Bloo in your first message, then drill in.

Discovery
"Using Data Bloo, list all the Shopify stores I have connected."
"What fields and date ranges can I pull for my Shopify store?"
Pulling data
"Pull orders, net sales and average order value for my Shopify store, last 30 days."
"Show revenue and units sold by month for this year so far."
Breakdowns
"Break down last month's revenue by country and sales channel."
"Show orders by customer type, new vs returning, for the last 90 days."
Reporting & analysis
"Write a client-ready summary of my Shopify store for October, with three takeaways."
"Compare this month's net sales to last month's and tell me what changed."
Top products
"Rank my top 10 products by revenue for the last 30 days, with units sold next to each."
"Which products are trending up fastest month over month?"
Customers & retention
"What share of last month's orders came from returning customers?"
"Compare average order value for new vs returning customers, last 90 days."
Cross-channel ROAS
"Line my Shopify revenue up against Facebook Ads, Google Ads and TikTok Ads spend this month. What's my blended ROAS?"
"Compare GA4 sessions with my Shopify orders for the last 30 days, where's the drop-off?"
Store health
"Summarize the health of my store this month versus last, orders, refunds and AOV."
"What changed most week over week, orders, average order value or refund rate?"
Who it's for

Built for how you actually work

Same connection, different job to be done. Here's the prompt each type of store operator tends to start with.

E-commerce & DTC

Track revenue, AOV and top products daily, and line store revenue up against every ad channel for the ROAS number that actually matters.

"Show my blended ROAS: Shopify revenue vs Facebook Ads and Google Ads spend, last 30 days."

Agencies

Pull and compare across every client store without switching logins, then draft the monthly report, ad spend and store revenue in one view.

"Compare revenue, orders and AOV across all my connected Shopify stores this month."

Founders & operators

Skip the dashboard entirely. Get the Monday readout, orders, net sales, refunds, in one question, and dig deeper only when something looks off.

"Give me a 5-minute readout: orders, net sales, AOV and refunds vs last week."
Troubleshooting

Common issues and fixes

Claude says it can't see your store

You're likely not signed in yet, or Shopify isn't connected in Data Bloo. Ask "Using Data Bloo, list the accounts I have connected." If it comes back empty, open Data Bloo, confirm your Shopify source is connected, then try again.

The numbers don't match your Shopify admin exactly

Small gaps are normal. Shopify's analytics run on your store's timezone, refunds and edited orders land on different dates than the original sale, and recent figures keep updating as payments settle. For trends, comparisons and reporting the Data Bloo pull is solid; for the last few hours of a flash sale, your Shopify admin is freshest.

Gross sales and net sales don't agree

They're not supposed to. Gross sales are before discounts and refunds; net sales come after. If a number looks too high or too low, tell Claude which one you mean, "use net sales", and the comparison snaps into place.

Claude won't take an action on your store

That's on purpose. The connection is read-only, Claude can't edit products, fulfill orders or issue refunds through it. If you want AI agents selling your storefront, that's Shopify's Storefront MCP, not this.

Good to know

Query notes & FAQs

One breakdown dimension per call. For query and page together, ask Claude to run separate queries and combine them after.
Confirm fields first. Field IDs vary per connector. Claude usually lists fields before querying to avoid rejected requests.
!Say gross or net. Gross sales are before discounts and refunds, net sales after. Name the one you want and comparisons stay clean.
Numbers vs Shopify admin. Small gaps are normal, store timezone, refund timing and orders that keep updating as payments settle.
How do I connect Shopify to Claude?+

Add a custom connector in Claude, name it Data Bloo, and paste the MCP URL https://mcp.databloo.com/mcp. Sign in once, then ask Claude about your Shopify store in plain language. The whole setup takes about two minutes.

What is the Shopify MCP?+

"Shopify MCP" usually refers to Shopify's official MCP servers: the Storefront MCP, which lets AI shopping agents browse your catalog and build carts for customers, and the Dev MCP, which gives developers Shopify's docs and schemas inside tools like Claude Code. Neither is a reporting tool. To ask Claude about your own sales, orders and products, you connect through an analytics MCP like Data Bloo's.

Is the Data Bloo MCP free?+

It's free to start, no credit card. The free tier includes MCP access with usage limits; paid plans raise the limits and add more connected accounts.

Does Claude change anything in my store?+

No. All seven MCP tools are strictly read-only. Claude can pull and analyze your data but can never edit products, orders, prices or any store settings. Your storefront and checkout are untouched.

Is it safe to connect Shopify to Claude?+

Yes. You sign in once through Data Bloo's secure OAuth flow, and the connection is strictly read-only. Claude can pull and analyze your Shopify data but can never change a product, cancel an order or touch your storefront.

Which AI tools does the MCP work with?+

Any MCP-compatible client, Claude Desktop, Web and Code, plus ChatGPT, and Gemini. The same URL works across all of them.

Do I need a paid Claude plan?+

No. A free Claude account is enough to add the Data Bloo connector and start pulling Shopify reports. Your Claude plan is separate from Data Bloo, and the connector works on Claude Desktop, Web and Code.

Can I blend Shopify with my ad channels?+

Yes, and it's the best reason to connect. As long as they're connected in Data Bloo, ask Claude to line Shopify revenue up against Facebook Ads, Google Ads and TikTok Ads spend, or against GA4 sessions, and it pulls one blended answer, true ROAS from real store revenue.

Do I need to install an app on my Shopify store?+

No app from the Shopify App Store is required. You connect your store to Data Bloo once, the same connection used for Data Studio reports, and Claude reads through that. Nothing is added to your storefront or theme.

How current is the data Claude sees?+

Claude queries your data live through Data Bloo's connectors the moment you ask, subject to each platform's API freshness and your plan's refresh limits.

Can I use it across multiple stores?+

Yes. Ask Claude to list your connected Shopify stores, and it can pull and compare across them, handy for agencies and multi-brand operators.

Can I automate recurring Shopify reports?+

Yes. Pair the MCP with Claude's scheduled tasks or Claude Code for an automatic Monday-morning sales digest, anomaly alerts when orders dip, or a recurring client update, unattended.

Simple, transparent pricing

Scale your reporting without limits

Every plan includes all data sources. Start free, upgrade only when your dashboards demand it.

MonthlyAnnually−17%
FREE
$0/ forever

Best for individuals or early-stage teams starting with marketing data.

Create free account
Destinations included
& more
1 account per connector300 daily refreshes (API calls)All data sources includedData Bloo MCP
STARTER
$8.33/mo
billed annually · save $20/yr

For individuals who need unlimited refreshes with a single account.

Choose Starter
Destinations included
& more
1 account per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
Most popularPRO
$16.66/mo
billed annually · save $40/yr

For freelancers & growing teams that need more accounts and volume.

Choose Pro
Destinations included
& more
Up to 5 accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
AGENCY
$33.33/mo
billed annually · save $80/yr

For agencies managing multi-client reporting at scale.

Choose Agency
Destinations included
& more
Unlimited accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPPriority email & chat support

No credit card required to start · Cancel anytime · See plan FAQs →

Chat with your Shopify store today

Connect Shopify to Claude in under 2 minutes and pull sales reports straight from the chat. Free to start, no credit card.