How to Connect WooCommerce to Claude (2 Steps, No Code)

To connect WooCommerce to Claude, authorize your store at onboard.windsor.ai/app/woocommerce, then add the Windsor.ai connector in Claude. That’s it. Open a new chat and ask about your store’s performance.

Here’s the problem it solves: WooCommerce’s built-in reports tell you what sold and when, but not why an order was profitable or which customers are worth chasing again.

Your orders, products, customers, and coupons all live inside WordPress, split across separate WooCommerce REST API tables. Blending that with your ad spend, email performance, or site analytics means exporting CSVs from several tools and stitching them together by hand, every time someone asks a new question.

By the time the spreadsheet is built, new orders and refunds have already changed the numbers. Windsor.ai closes that gap: it connects your live WooCommerce store to Claude, so you can ask about orders, coupons, products, and customers in plain language and get an answer built from current data, not a snapshot from last week.

2 steps to connect WooCommerce to Claude

No code, no CSV exports. The whole setup runs through the native Windsor.ai connector for Claude.

📖 Full documentation: How to integrate data into Claude with Windsor MCP.

Prerequisites

• A Windsor.ai account: free forever plan or paid plan
• A WooCommerce store with REST API access enabled (store admin access to generate a Consumer Key and Consumer Secret under WooCommerce → Settings → Advanced → REST API)
• A Claude account

Step 1. Connect WooCommerce to Windsor

Go to onboard.windsor.ai/app/woocommerce and select WooCommerce as your data source. Enter your store URL, then paste in the Consumer Key and Consumer Secret from your WooCommerce REST API settings (Read permission is enough). Windsor confirms the connection and starts pulling your order, product, customer, and coupon data.

Step 2. Add the Windsor.ai connector in Claude

In Claude, go to Settings → Connectors, search for Windsor.ai, and add it from the Claude directory, one click, no URL to paste. Set permission to “Always allow” so your WooCommerce data is available in every conversation automatically.

Confirm the connection with a quick test prompt:

List my connected WooCommerce stores and show total revenue and order count for the last 30 days.

If Claude returns real numbers instead of asking you to upload a file, the connection is live.

The metrics that matter for WooCommerce

Metric	What it tells you
orders__total	Total order value, including tax and shipping, the headline revenue number for any date range
orders__net_sales	Order revenue after tax, shipping, and discounts are stripped out, closer to what the store actually earned
orders__discount_total	How much of an order’s value was knocked off by coupons or manual discounts
orders__status	Where an order sits in the fulfillment lifecycle (processing, completed, refunded, cancelled)
orders__order_attribution_utm_source / orders__order_attribution_utm_campaign	Which channel and campaign actually drove a given order
orders__line_items__product_id / orders__line_items__quantity	Which specific products were in an order and how many units sold
products__stock_quantity	Units currently left in stock for a product
products__total_sales	Lifetime units sold for a product, WooCommerce’s own best-seller signal
customers__is_paying_customer	Whether a registered customer has completed at least one paid order
coupons__code / coupons__discount_type / coupons__amount	Which discount code was used and how much it took off the order

What to ask Claude about your WooCommerce data: prompt ideas

Which products are actually profitable, not just popular

Units sold and revenue don’t tell you what a product earned after discounts and refunds cut into it.

Using WooCommerce order and product data for the last 90 days, calculate net sales per product after discounts and refunds.
Rank products by net sales, not units sold.
Which best-sellers by volume are actually weak performers once discounts are factored in?

Are your coupons paying for themselves?

A coupon that drives orders but erodes margin faster than it grows revenue is easy to miss without pulling the numbers together.

List every active coupon with its code, discount type, and amount.
Match each one to the orders it was used on, and show total orders, total discount given, and total revenue generated per coupon.
Which coupons are costing more in discounts than they bring in?

Which customers are worth targeting again

Repeat buyers are usually the cheapest revenue to win back, but they’re easy to overlook without looking across order history.

Find customers with more than 2 completed orders in the last 12 months.
Show their total spend, average order value, and days since their last order.
Which of these repeat customers haven't ordered in the last 60 days?

What’s about to sell out

Stockouts on fast-moving products cost revenue that’s hard to recover once a customer buys elsewhere.

For products with fewer than 20 units in stock, calculate average daily units sold over the last 30 days using line item quantity data.
Estimate days until stockout for each, and flag anything likely to run out within 2 weeks.

Bonus: analyze WooCommerce alongside your full marketing stack

Windsor.ai connects WooCommerce alongside 350+ other data sources, so Claude can answer questions no single dashboard can.

• GA4: tie site sessions to actual WooCommerce orders, and see which landing pages convert into real revenue, not just pageviews.
• Google Ads: calculate real ROAS by matching ad spend against actual WooCommerce revenue instead of platform-reported conversions.
• Mailchimp: see which email campaigns actually drove WooCommerce purchases, not just opens and clicks.

Conclusion

WooCommerce keeps your store’s data close, inside WordPress, but its native reports were never built to answer questions that cross orders, products, customers, and marketing spend at once.

Windsor MCP turns that data into something Claude can query directly. Instead of exporting CSVs every time a new question comes up, you get answers about profitability, coupon performance, repeat customers, and inventory, built from current store data, in plain language.

🚀 Connect WooCommerce to Claude with Windsor MCP. Free forever plan, no credit card → onboard.windsor.ai/app/woocommerce.