How to Connect Shopify to Claude: Official Connector vs. Windsor.ai (3-Step Setup)

To connect Shopify to Claude, authorize your store at onboard.windsor.ai/app/shopify and add the Windsor.ai connector in Claude. No code, two steps. That’s it. Start a new chat and ask about your store’s performance.

Here’s the problem it solves: You don’t need a million orders to feel the pain of manual analysis. Whether you are doing ten sales a day or ten thousand, the challenge is the same: Shopify’s standard reports show you what happened, but they rarely tell you why or what to do next to improve your margins.

What if you could treat Claude as your fractional COO who identifies exactly where you are losing money or where your next growth lever is hidden?

By connecting Shopify to Claude, you move past static charts and spreadsheets. You can ask Claude to calculate your true Customer Lifetime Value (LTV), identify high-churn segments, or optimize your inventory velocity.

There is now more than one way to connect Shopify to Claude. Shopify ships an official Claude connector for managing your store by chat, and Windsor MCP creates a live data bridge for analysis. They do different jobs, and many stores end up using both:

• The official Shopify connector manages the store: add and update products, adjust inventory, create discount codes, and check orders by talking to Claude.
• The Windsor MCP connector analyzes the business: it streams your Shopify data into Claude alongside your ad platforms, GA4, and CRM, so Claude can answer profit, LTV, and marketing questions that need more than store data alone.
• The manual way (CSV exports uploaded to Claude) still works for a one-off check, and still breaks down for anything recurring.

The full method comparison is below. This guide covers the Windsor route: the three-step setup, what to ask once connected, and the data you get.

🚀 Stream your Shopify data into Claude in seconds, start for free: https://onboard.windsor.ai/.

Windsor.ai allows you to establish this connection in under a minute, removing the headache of manual data prep. Analyze your large-scale Shopify data with AI using natural language and generate high-impact visual reports like the one below with a single prompt.

Let’s get started in three simple steps.

3 steps to automatically sync Shopify data to Claude via Windsor MCP

Using the Windsor MCP, you eliminate the “download-and-clean” cycle and proceed with deep AI insights in <60 seconds.

📖 Follow our quick step-by-step guide to connect your Shopify data to Claude.

Prerequisites for Shopify to Claude Integration

Before you begin, ensure you have the following ready:

• A Windsor.ai account: You need an active account to integrate the Shopify data.
• Shopify admin access: You need “Staff” permissions with read access to Orders, Customers, and Products.
• Claude.ai account: You need an active Claude account, which serves as your AI analytical environment.

Step 1: Grant Windsor access to Shopify

1. Log in to onboard.windsor.ai.
2. Select Shopify as your data source.
3. Connect your Shopify store by following this setup guide.

Windsor will now handle the heavy lifting, flattening hundreds of Shopify metrics and dimensions, from customer_total_spent to order_net_sales, so they are instantly readable by Claude.

Step 2: Activate the Windsor.ai connector in Claude

In Claude, open the Windsor.ai connector page and click Connect.

Optionally, you can set permissions to “Always allow” to enable Windsor MCP-powered queries across all your chats.

Step 3: Start querying your Shopify data

Once connected, you no longer need to look at static analytical dashboards. Just speak to Claude in natural language to extract instant AI insights:

Here are prompt samples you can use:

• “What is my average Customer Lifetime Value (LTV) for customers who used a {WELCOME10} discount code vs. those who didn’t?”
• “Which products are my ‘hidden gems’: low sales volume but extremely high repeat purchase rates?”
• “Analyze my refunds (order_refunds_subtotal) by product and tell me which SKUs are losing the most revenue to returns.”

Dig deeper and ask Claude to generate a visual summary based on the text output.

Official Shopify Claude connector vs. Windsor.ai vs. other methods

Since Shopify and Anthropic launched an official connector, “how do I connect Shopify to Claude” has more than one correct answer. The right one depends on whether you want to run the store or understand the business.

• Best for operating your store by chat, such as adding products or creating discount codes: the official Shopify connector. It manages the store from inside Claude: it updates products and inventory across locations, browses orders and customers, and pulls basic store analytics.
• Best for marketing and revenue questions that span more than Shopify, such as true ROAS after refunds or customer LTV by channel: the Windsor.ai MCP. It streams Shopify data into Claude alongside 350+ other sources (Google Ads, Meta Ads, GA4, CRMs). Analysis only for Shopify; it never changes your store.
• Best for store customization without opening the Shopify admin: ShopMCP, a third-party app from the Shopify App Store that makes store edits from a description, such as landing pages or bulk product changes.
• Best for developers building against or automating a store: the Shopify AI Toolkit (CLI). It authorizes an AI tool on your machine to use the Shopify API, including from Claude Code.

These are not mutually exclusive. Claude supports multiple connectors at once, so the official app and Windsor run side by side in the same account. Use the official app to change things in your store. Use Windsor when the question spans more than Shopify, such as “which ad campaigns bring repeat buyers” or “what is my true ROAS after refunds.”

What does the official Shopify connector for Claude do?

The official Shopify connector lets you manage a store from inside Claude: add and update products with pricing and images, adjust inventory across locations, create discount codes and promotions, browse recent orders, view customer information, and pull store analytics on sales and conversion rates. It works in Claude on the web, desktop, mobile, Claude Code, and the API.

Should I use the official Shopify connector or Windsor.ai?

Both, for different jobs. The official connector operates your store; Windsor.ai analyzes your business across its whole data stack. If you only need to manage products and orders by chat, the official app covers it. The moment your questions involve ad spend, GA4 behaviour, or CRM data next to Shopify revenue, that data lives outside Shopify, and Windsor is the connector that brings it all into one Claude conversation.

Things you can do with your Shopify data in Claude

Even if your store isn’t “scaling to the moon” yet, Claude can help you optimize your current baseline with these use cases:

• Sales & profitability analysis: Stop guessing your net margins. Claude can analyze order_gross_sales, order_total_discounts, and order_net_sales to show you exactly what you’re taking home after every cost is accounted for.
• Deep customer insights: Move beyond basic “Total Customers” counts. Use fields like customer_total_spent, customer_orders_count, and order_total_price to let Claude identify your “Whales” (high-value customers) or build ideal customer profiles (ICPs).
• New vs. returning customer analysis: Segment orders by order_new_or_returning_customer and order_created_at to compare revenue, order counts, and repeat purchase patterns. Identify which channels and products drive first-time vs. repeat purchases.
• Churn prevention: Identify customers who haven’t purchased in 60 days but have a high customer_orders_count. Then ask Claude to draft a personalized “Win-back” email.
• Inventory velocity: Ask Claude to analyze line_item__quantity trends to predict which line_item__sku will stock out in the next 14 days.
• B2B/wholesale discovery: Use customer_tags to separate retail from wholesale buyers and compare their average order value from order_total_price and order_count.
• Marketing ROI by channel: Connect your sales back to the source. Using order_customer_last_visit_source and order_customer_last_visit_utm_source, Claude can tell you if your latest influencer campaign or TikTok ad resulted in high-LTV customers or just one-time bargain hunters.

Shopify analytics prompt ideas for Claude

Most Shopify dashboards answer basic questions like “How many orders did we get?”

But the questions that drive growth are harder:

• Which customers generate the most profit?
• Which products tie up money without selling?
• Which marketing channels bring high-value buyers?
• Which SKUs will run out of stock next week?

These questions usually require exporting Shopify data into spreadsheets or BI tools.

Once your Shopify data is connected to Claude through Windsor MCP, you can ask these questions directly and get structured AI-driven answers.

Below are some common e-commerce problems and the prompts you can use to solve them.

1. Are you making money on each order?

Revenue in Shopify does not equal profit.

Discounts, taxes, shipping costs, and refunds can significantly reduce margins. Many stores rely on rough estimates instead of calculating true net revenue.

Claude can analyze order-level data such as:

• order_gross_sales
• order_total_discounts
• order_net_sales

to estimate real profitability.

Example prompt:

Compare order_gross_sales, order_total_discounts, and order_net_sales by month.
Which month had the highest net margin percentage, and how much revenue did discounts cost me?

This helps you understand which periods and campaigns generated profit, not just sales.

2. Which customers are your most valuable?

Not all customers are equal.

Many stores focus on acquisition while ignoring the customers who generate the majority of lifetime value.

Using fields such as:

• customer_total_spent
• customer_orders_count
• order_total_price

Claude can identify high-value customers and purchasing patterns.

Example prompt:

Identify the top 10% of customers based on customer_total_spent.
What is their average customer_orders_count and average order value compared to the rest of the customer base?

This helps you build ideal customer profiles (ICPs) and optimize acquisition strategies.

3. Are you losing repeat customers without noticing?

Customer churn is one of the biggest hidden revenue leaks for e-commerce stores.

Customers who previously ordered multiple times but suddenly stopped buying are often the easiest revenue to recover.

Claude can detect churn risks by analyzing:

• customer_orders_count
• order_created_at

Example prompt:

Find customers with a customer_orders_count greater than 3 whose most recent order_created_at is more than 60 days ago.
Draft a personalized win-back email referencing the last line_item__title they purchased.

This allows you to turn churn analysis directly into retention campaigns.

4. Which products will run out soon, based on how fast they sell?

Stockouts can cost stores significant revenue, especially for best-selling products.

Many Shopify operators manually track top-selling products and declining inventory (“downsells”) to forecast inventory levels.

By analyzing fields such as:

• line_item__quantity
• line_item__sku
• order_created_at

Claude helps you instantly estimate product sales velocity.

Example prompt:

Identify my top 10 selling SKUs over the last 30 days.

For each SKU:
- Calculate daily sales velocity
- Estimate days until stockout (based on recent trends)

Highlight:
- Products at risk of running out within 21 days
- Slow-moving products with declining demand

Provide a prioritized reorder list.

This helps operators prevent lost revenue from unexpected stockouts.

5. Which marketing channels bring high-value customers?

Not all traffic sources produce the same type of customer.

Some channels generate one-time bargain hunters, while others produce long-term repeat buyers.

Using fields like:

• order_customer_last_visit_source
• order_customer_last_visit_utm_source
• customer_total_spent

Claude can analyze which channels drive the highest long-term value.

Example prompt:

Compare order_customer_last_visit_source and order_customer_last_visit_utm_source values.
Which traffic source produces customers with the highest customer_total_spent over time?

This helps marketers optimize acquisition toward channels that drive repeat purchases and LTV.

6. Which products are dragging your margins down?

Many Shopify stores carry products that:

• sell rarely
• tie up inventory
• generate little revenue

These are often called “zombie SKUs.”

Claude can analyze product sales activity and identify inventory that is no longer moving.

Example prompt:

Identify active SKUs with zero sales in the last 60 days.
Calculate the total inventory value of these products and suggest a discount or bundle strategy to clear the stock.

This helps operators free up capital and warehouse space.

7. How many new vs. returning customers do you have?

Understanding which orders come from first-time buyers versus repeat customers is the basis for measuring growth, retention, and the effectiveness of marketing campaigns. Claude can automatically segment your Shopify orders using fields like:

• order_new_or_returning_customer
• order_created_at
• customer_total_spent

Example prompt to compare the amount and revenue:

For the last 90 days, calculate the total number of orders and revenue from new customers vs. returning customers and their average order value.

Example prompt to define the top-performing channels:

Identify which marketing channels bring the highest proportion of new customers vs. returning customers.

Example prompt to discover the best-selling products:

Analyze repeat purchase rates by product category and highlight which items drive loyalty among returning buyers.

This explains whether growth is driven by acquisition or retention and helps you optimize campaigns for repeat buyers and improve customer lifetime value.

Bonus: Which advertising campaigns generate the highest true ROAS?

Most e-commerce teams run paid ads across Facebook Ads, Google Ads, TikTok Ads, etc., but struggle to analyze Shopify revenue and ad performance in separate dashboards.

Native platform analytics report conversions and estimated ROAS, but they don’t always reflect actual store revenue.

To calculate true campaign performance, you need to combine:

Shopify data:

• order_total_price
• order_total_discounts
• order_customer_last_visit_utm_campaign

Advertising data (f.e, Meta Ads):

• campaign_name
• spend
• clicks

Using UTM campaign parameters, Claude can match Shopify orders to Facebook Ads campaigns and calculate real ROAS based on actual store revenue.

Example prompt:

Match Shopify orders with Facebook Ads campaigns using order_customer_last_visit_utm_campaign.
For the last 30 days, calculate for each campaign:
- total ad spend
- total Shopify revenue (order_total_price)
- ROAS
Rank campaigns by ROAS and highlight the best-performing ones.

This allows marketers to quickly identify:

• Which campaigns generate the highest ROAS
• Which campaigns should receive more budget
• Which campaigns are underperforming

Instead of relying on isolated dashboards, Claude can analyze both revenue and ad spend together, giving you a clearer view of real marketing performance.

Shopify data that you can stream into Claude with Windsor.ai

Windsor.ai supports over 330 Shopify data fields, enabling a truly comprehensive and in-depth analysis in Claude.

Here are the primary data categories you can sync:

Sales & transactional data

This category includes everything related to the financial health of your orders. It allows Claude to audit your actual take-home pay after costs.

• Key fields: order_total_price, order_net_sales, order_gross_sales, order_total_discounts, and order_currency.

Customer intelligence

These fields help Claude perform cohort analysis and identify your most valuable buyers.

• Key fields: customer_total_spent, customer_orders_count, and order_new_or_returning_customer.

Product & inventory performance

This data is essential for Claude to act as an inventory planner, identifying what’s moving and what’s stuck.

• Key fields: line_item__sku, line_item__quantity, line_item__title, and product_status.

Marketing and channel performance

This category connects your sales back to the source, helping Claude determine which channels are profitable.

• Key fields: order_customer_last_visit_source, order_customer_last_visit_utm_source, order_customer_last_visit_utm_campaign, and order_sales_channel.

The manual way to send Shopify data to Claude

If you only need a one-time snapshot of your store, you can follow these steps to connect Shopify to Claude:

1. Export orders: Navigate to Shopify Admin -> Orders -> Export. Select “All Orders” and choose “CSV for Excel, Numbers, or other spreadsheet programs.”
2. Export customers: Go to Customers -> Export to get your buyer history.
3. Data cleaning: Open the files in Excel to remove sensitive PII (like full addresses) and ensure date formats are consistent.
4. Upload to Claude: Open Claude.ai, start a new chat, and use the attachment icon to upload your cleaned CSVs.
5. Prompt: Use a prompt like: “I have attached my Shopify order and customer data. Please analyze these files to identify which product categories have the highest repeat purchase rate.”

Why the manual method fails e-commerce teams

Most merchants start by downloading CSVs directly from the Shopify admin. However, the complexities of manual Shopify analysis quickly become a bottleneck, especially for small teams, due to these obstacles:

• Data fragmentation: Orders, Customers, and Products are exported in separate files. Claude cannot easily “join” these (e.g., linking a customer’s specific tag to their purchase frequency) without massive manual cleanup.
• The “static” trap: Your data is outdated the moment you hit “Export.” By the time you finish your analysis, new orders and refunds have already changed your inventory and LTV.
• Context loss: CSVs often strip out the metadata that matters, like specific UTM parameters or discount code associations, making it impossible to see which marketing efforts drive profit.
• Browser crashes: Attempting to upload a CSV with 50,000+ orders often hits Claude’s context limits or causes the browser tab to hang.

✨ To bypass these limitations, Windsor.ai automates the entire pipeline, turning hours of manual data prep into a real-time, one-click Shopify to Claude integration.

Manual vs. automated: Choosing your method to connect Shopify to Claude

Feature	Manual CSV export	Windsor MCP (automated)
Setup time	15-30 minutes per export	< 1 minute (one-time setup)
Data freshness	Static (snapshot in time)	Real-time (live API bridge)
Data joining	Manual VLOOKUPs/Joining	Auto-joined (Orders + Customers + Products)
Scalability	Limited by browser/file size	High (Optimized for large-scale stores)
Technical skills	Spreadsheet proficiency required	No-code
B2B context	Strips metadata/tags	Preserves customer tags & UTMs

Conclusion

In e-commerce, the advantage goes to whoever acts on their data fastest.

Manual CSV exports are a barrier to real-time decision-making. By connecting Shopify to Claude via Windsor.ai, you effectively hire a fractional Data Scientist who works 24/7.

Whether you are auditing your net margins, predicting stockouts, or uncovering hidden high-LTV customer segments, the combination of Windsor’s automated pipeline and Claude’s analytical power gives you a massive unfair advantage.

🚀 Stop wrestling with spreadsheets and start asking the questions that move the needle for your store with Windsor.ai. Start for free now: https://onboard.windsor.ai/app/shopify.