MCP & AI reporting

How to Connect WooCommerce to Claude with MCP

Connect WooCommerce 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. It's read-only, so it's safe, and here's the 2-minute setup.

Free to start Read-only & secure Works in ~2 min
Claude Data Bloo connected
Pull orders, net sales and average order value for my WooCommerce store, last 30 days.
query_data · WooCommerce ✓
Here's your last 30 days on WooCommerce:
Metric
Value
Orders
1,842
Net sales
€96,410
Avg order value
€52.34
Orders are up 9% vs the prior period at a 2.1% refund rate. Want the top products behind it?
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 Copy
Using Claude Code instead? Grab the one-line CLI command →

The short version

You can ask Claude about your WooCommerce store and get a real answer, pulled from your actual orders, in seconds. Type "how did my store do last month" and Claude reads your numbers and tells you, no CSV export, no admin 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 sales but can never touch a product, a price or an order.

Want Claude to actually operate your store, edit products and manage orders? WooCommerce is building that natively: its own MCP ships in core as a developer preview. Want Claude to read, analyze and report on your sales, blend them with your Facebook Ads and Google Ads spend for real ROAS, 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 WooCommerce to Claude

Stop exporting order CSVs. Start asking.

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

Ask, get instant answers

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

Reports inside the chat

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

Client-ready summaries

"Turn last month's store performance into an executive summary." Paste it into Slack, email or a doc.

Diagnose dips fast

"Why did revenue dip on Tuesday?" Claude looks across products, coupons, order statuses and dates and explains it.

Real ROAS, finally

Line WooCommerce revenue up against Facebook Ads and Google Ads spend in one answer, blended ROAS without a spreadsheet.

Connect once, use everywhere

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

Supported data sources

WooCommerce, 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 WooCommerce to Claude

There are three real options, built for different people. 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 WooCommerce data, plus every other source in Data Bloo, is available to Claude any time. Read-only, blends across channels, and the same connection feeds your Data Studio reports. No plugin, no server, nothing to host.

WooCommerce's native MCP

Woo ships MCP support in core as a developer preview, and the "WooCommerce for Claude" experiment (May 2026) exposes your store at /wp-json/…/mcp. Powerful, but it's per store, needs REST API keys plus a local proxy, and write-capable keys let an AI change your live store.

A manual CSV export

Export orders or an Analytics report from WooCommerce, save the file, upload it to Claude. Free, and it works once. Then you do it again next week, separately for every store.

Data Bloo vs WooCommerce's native MCP vs a manual export

Data Bloo
Woo MCP
Manual CSV
Setup
~2 min, point & click
API keys + local proxy
New export each time
Reads your data
Yes
Yes
A snapshot
Changes your store
No (read-only)
Yes, with write keys
No
Blends other channels
Yes
No, one store only
By hand
Feeds Data Studio
Yes, same connection
No
No
Works with other AI
Yes (ChatGPT, Gemini…)
Any MCP client
Any (paste a file)
Price
Free to start
Free, dev preview
Free
Upkeep
None
You maintain keys & proxy
Redo it each time

The short version: if you want Claude to operate your store, WooCommerce's own MCP is heading there. If you want Claude to read and report on your sales, blend them with your ad spend for real ROAS, and feed the same data to your dashboards, that's Data Bloo.

The honest bit

When to use WooCommerce's native MCP instead

Data Bloo isn't the right tool for everyone. If your goal is to have Claude operate your store, not just report on it, WooCommerce is building exactly that into the platform. MCP support ships in Woo core as a developer preview (enable it under WooCommerce → Settings → Advanced → Features), and Automattic's "WooCommerce for Claude" experiment from May 2026 wraps it into a single endpoint on your own site, with a copy-pasteable config for Claude Desktop and a one-liner for Claude Code. Because it runs inside your WordPress install, it can see and, with read/write API keys, act on everything the REST API can touch.

The trade-offs are real. It's a developer preview, so the APIs can change under you. Setup means generating REST API consumer keys and running a local proxy, per store, and you own that maintenance. Write-capable keys hand an AI edit rights to a live store, the exact risk Data Bloo removes by staying read-only. And it only sees one WooCommerce store, so it can't line your revenue up against Facebook Ads or Google Ads spend, and it doesn't feed Data Studio. Plenty of stores run both: the native MCP to act on the store, Data Bloo to read, blend and report across everything.

Before you start

What you need

Three things, and you probably already have them.

A Data Bloo account with WooCommerce 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 WooCommerce to Claude

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

Claude Desktop / Web Claude Code (CLI)
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 WooCommerce store

Start a new chat and try: "Using Data Bloo, pull orders, net sales and average order value for my WooCommerce 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 WooCommerce stores I have connected." If Claude returns your stores, you're fully connected.

See it in action

Take the MCP for a spin

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

Under the hood

Seven read-only tools, why your store is 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 WooCommerce stores, and the IDs to query.
list_fields
The valid metrics and dimensions for WooCommerce.
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 WooCommerce sales, it can never edit a product, change a price, touch an order or refund a customer. Your store stays exactly as you left it.

Why Data Bloo

Read-only safety and your dashboards, in one connection

The write-capable tools make you choose: hand an AI edit rights to your live store, or keep exporting by hand. Data Bloo doesn't ask you to choose. It reads, it reports, and the exact same connection already powering your Data Studio dashboards now answers questions in Claude.

It can't touch your store

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

One connection, two surfaces

The WooCommerce 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. It's the one thing a single-store, write-first tool structurally can't give you.

The data

What WooCommerce data you can pull

The same metrics you use in your reports, sliced by product, category, order status, coupon, country and date.

Sales & orders

Orders, gross and net sales, revenue, average order value and units sold.

Refunds & coupons

Refunds and refund totals, coupons used and discount amounts, the numbers that turn gross sales into what you actually keep.

Customers & products

Customer counts alongside your top products and categories, so you see what sells and who's buying more over time.

Breakdowns

Product, category, order status, coupon, country and date.

Real answers

What Claude actually gives you back

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

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

Claude: Last 30 days on WooCommerce, 1,842 orders, €96,410 net sales and a €52.34 average order value. Orders are up 9% on the prior period, and the refund rate held at 2.1%.

The read: volume is growing without AOV slipping, demand is up, not just discounting.
"Which products drove the most revenue last month, and which slowed down?"

Claude: Top seller, Linen Throw Blanket at €12,480 across 416 units, about 13% of net sales. Ceramic Mug Set dropped from 210 to 96 units, the steepest decline in the catalog.

The read: restock the blanket before it sells out, and check whether the mug set slipped in search or lost its promo.
"Line my WooCommerce revenue up against Facebook Ads and Google Ads spend this month. What's my blended ROAS?"

Claude: Net sales, €96,410. Ad spend, €12,940 on Facebook Ads and €8,360 on Google Ads, €21,300 total. That's a blended ROAS of about 4.5×, up from 4.1× last month.

The read: revenue is growing faster than spend, there's likely headroom to scale the better-performing channel.

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 WooCommerce 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
€84K
ROAS
4.2×
CVR
2.4%

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 WooCommerce stores I have connected."
"What fields and date ranges can I pull for my WooCommerce store?"
Pulling data
"Pull orders, net sales and average order value for my store, last 30 days."
"Show me revenue and units sold by month for this year."
Breakdowns
"Break down last month's revenue by product category."
"Show orders and revenue by country for the last 30 days."
Reporting & analysis
"Write a client-ready summary of my store's October, with three takeaways."
"Compare this month's average order value to last month's and tell me what changed."
Refunds & coupons
"Which products were refunded the most last month, count and value?"
"How much revenue did each coupon code drive, and what did it cost in discounts?"
Top products
"Rank my products by revenue for the last 30 days, units sold next to each."
"Which products sold well last quarter but are slowing down this month?"
Real ROAS, cross-channel
"Line my WooCommerce revenue up against Facebook Ads and Google Ads spend this month, what's my blended ROAS?"
"Compare store revenue with GA4 sessions and Search Console clicks for the last 30 days."
Store health
"Summarize the health of my store this month versus last."
"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 owner tends to start with.

E-commerce & DTC

Track orders, AOV and top products daily, and line revenue up against ad spend so you always know your real ROAS.

"Show orders, net sales and AOV by week for the last 90 days, and flag the weeks that dipped."

Agencies

Pull and compare across every client store without switching logins, then draft the monthly report in the chat.

"Compare revenue and order volume across all my connected WooCommerce stores this month."

WordPress site owners

Get plain-language answers about your shop without plugins to install, servers to run or API keys to babysit.

"Give me a plain-language monthly summary of my store: sales, top products and refunds."
Troubleshooting

Common issues and fixes

Claude says it can't see your store

You're likely not signed in yet, or WooCommerce 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 WooCommerce source is connected, then try again.

The numbers don't match WooCommerce Analytics exactly

Small gaps are normal. WooCommerce Analytics only counts certain order statuses, your store's timezone decides which day an order lands in, and recent figures keep shifting as orders complete or get refunded. For trends, comparisons and reporting the Data Bloo pull is solid; for an order placed five minutes ago, your admin is freshest.

Revenue looks off after a big refund day

Refunds land on the date they were issued, not the date of the original order. A heavy returns day can drag that day's net sales down even if new orders were strong. Ask Claude for gross and net side by side and the gap explains itself.

Claude won't take an action on your store

That's on purpose. The connection is read-only. If you need to edit products or manage orders from chat, that's WooCommerce's native MCP, not this.

Good to know

Query notes & FAQs

One breakdown dimension per call. For multiple breakdowns, 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.
!Gross vs net. Net sales strip out refunds and discounts. Say which one your report needs, Claude pulls the right field.
Numbers vs WooCommerce Analytics. Small gaps are normal, order statuses, refund timing and your store's timezone.
How do I connect WooCommerce 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 WooCommerce store in plain language.

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, prices, orders or any store setting. For store operations from chat, use WooCommerce's native MCP.

Does WooCommerce have an official MCP?+

Yes, as a developer preview. WooCommerce core ships MCP support, and the "WooCommerce for Claude" experiment exposes your store through an endpoint on your own site. It's self-hosted, needs REST API keys and a local proxy, and with write keys it can change your live store. Data Bloo is the read-only, no-setup alternative that also blends other channels.

Do I need to install anything on my WordPress site?+

Nothing for the Claude side. You connect your store to Data Bloo once, the same connection that powers your Data Studio reports, then paste one URL into Claude. No plugin to maintain, no local proxy, no server to run.

Which AI tools does the MCP work with?+

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

Can I blend WooCommerce with my ad platforms?+

Yes, and it's the best part. As long as they're connected in Data Bloo, ask Claude to line WooCommerce revenue up against Facebook Ads and Google Ads spend for real ROAS, or against GA4 sessions and Search Console clicks, one blended answer.

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.

Do I need a paid Claude plan?+

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

Is it safe to connect WooCommerce 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 sales but can never edit a product, change a price or touch an order, and you never paste API keys into a chat.

Can I use it across multiple stores?+

Yes. Ask Claude to list your connected WooCommerce stores, and it can pull and compare across them, handy for agencies running multiple clients or brands running several shops.

Can I automate recurring WooCommerce reports?+

Yes. Pair the MCP with Claude's scheduled tasks or Claude Code for an automatic Monday-morning sales digest, a refund-rate alert 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 WooCommerce store today

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