Chat with your Shopify data

AI to analyze Shopify data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Shopify

You

What's the latest activity in Shopify?

Shopify

Latest in Shopify: +12% MoM across the main metrics tracked by Kondado.

Via Kondado MCP

You

What's the ROAS of Meta Ads this week?

Meta Ads

Meta Ads ROAS this week: 3.42x on R$ 12,400 spent.

Via Kondado MCP

You

List the top 5 products in Shopify this month

Shopify

Top SKUs in Shopify: SKU-021, SKU-188, SKU-054, SKU-301, SKU-077.

Via Kondado MCP

You

How is GA4 conversion trending?

Google Analytics 4

GA4 conversion last 30d: 2.84% (+0.42 pp MoM).

Via Kondado MCP

Works in Claude, ChatGPT and any MCP client

AI to analyze Shopify data with Claude and ChatGPT

Connect your Shopify store to Kondado and start asking Claude, ChatGPT, or any other MCP client questions about your ecommerce data in natural language. Query sales performance across specific date ranges to identify your highest-converting hours, compare conversion rates between different marketing campaigns using UTM parameters, or check current inventory levels for bestselling SKUs before planning your next restock. The AI reads your replicated Shopify data and returns actionable insights instantly through simple chat conversations.

Kondado enables AI-powered analysis of Shopify data by exposing 17 data pipelines through an MCP server compatible with Claude, ChatGPT, and other MCP clients. This setup provides access to 505 fields across orders, customers, products, and abandoned checkouts for conversational analytics and business intelligence. The same replicated data also powers ready reports in Power BI and Looker Studio for teams that prefer visual dashboard monitoring alongside chat-based exploration.

E-commerce managers use this to investigate daily revenue trends and identify fulfillment bottlenecks affecting delivery times, while marketing analysts explore UTM attribution data and customer segmentation patterns to optimize ad spend. Finance teams query transaction histories, discount applications, and refund patterns to reconcile accounts efficiently, and operations staff monitor inventory movements across multiple warehouse locations. Every department gets immediate answers directly from chat without requesting technical reports or waiting for spreadsheet exports.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Shopify data by Kondado in minutes.

View Shopify dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Shopify data in natural language.

View MCP setup →

The 17 available pipelines contain detailed ecommerce records that unlock specific business insights when queried through AI chat. Ask about abandoned checkouts to identify recovery opportunities by analyzing cart values and customer contact information, or query orders combined with discount codes to measure which promotions drive actual revenue versus those that merely attract bargain hunters. Investigate inventory items across all locations to prevent stockouts before they impact sales, and examine orders transactions alongside shipping lines to understand true fulfillment costs per carrier and delivery method. The orders details and line items pipelines reveal product-level profitability and bundle performance that aggregate views miss.

Cross-reference customers with orders visits UTM parameters to calculate customer lifetime value by specific acquisition channel, or join orders refunds with timeline events to identify seasonal patterns in return requests. These combinations transform isolated records into comprehensive business narratives that reveal operational strengths and weaknesses.

With automated updates on a configurable schedule, your AI chat always references the latest Shopify data for accurate daily decision-making.

How to connect Shopify to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp

Detailed guide: Claude Detailed guide: ChatGPT

AI vocabulary

Shopify tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

Tables

505

Fields

∞

Ad-hoc questions

Abandoned Checkouts

View data on abandoned checkouts, including total value, items in the cart, and abandonment date.

Customers

Track customer information, including name, email, status, and account creation date.

Events

Log important events, including event type, date, and details associated with each event.

Inventory: items

Monitor item inventory, including SKU, available quantity, and product location.

Order timeline events

Analyze order timeline events, including status, date, and actions taken during processing.

Orders

Examine order details, including order number, total value, status, and creation date.

Orders Details

Get detailed information about orders, including items, prices, quantities, and applied discounts.

Orders Discount Applications

View how discounts were applied to orders, including discount type and value.

Orders Discount Codes

Access information on discount codes used in orders, including code and discount value.

Orders Fulfillments

Monitor the status of order fulfillments, including fulfillment date and shipping method.

Orders Line Items

Includes information on products, quantities, and prices, along with fields such as SKU, product title, and applied discount.

Orders Note Attributes

Contains custom attributes associated with orders, such as customer notes, tags, and additional fields that assist in identification.

Orders Refunds

Records information about refunds, including amounts, reasons, and status, along with fields such as refund date and method used.

Orders Shipping Lines

Provides details on shipping options, including carrier, shipping cost, and estimated delivery time.

Orders Transactions

Includes data on financial transactions, such as amounts, payment methods, and payment status, along with timestamps.

Orders Visits UTM Parameters

Captures information on order visits, including UTM parameters such as source, medium, and campaign for marketing analysis.

Products

Contains details about products, including title, description, price, SKU, and images, along with information on variants.

Full docs on the wiki → Connect Shopify now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

Connect Shopify on Kondado

Log in to app.kondado.com.br to set up your Shopify data source and select a 'Via Kondado destination' so your data lands ready for AI access and the Power BI and Looker Studio report templates.

Add Kondado MCP in Claude or ChatGPT

In Claude Web or Desktop, or in ChatGPT, open the connection settings to add the Kondado MCP server and complete the OAuth authorization at app.kondado.com.br. This GUI setup requires no CLI commands or JSON configuration, working identically in both clients.

Ask about data or open dashboards

Start asking questions in natural language about your Shopify orders, customers, or inventory in the chat interface. For ongoing visual monitoring without typing queries, open one of the ready Power BI or Looker Studio dashboard templates.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What specific Shopify business questions can I ask Claude or ChatGPT through Kondado? ▼

You can ask about sales trends by product category over specific periods, identify which discount codes generated the highest revenue, analyze abandoned checkout recovery rates, compare shipping costs across carriers, or query customer repeat purchase behavior. The AI interprets your natural language questions against the 17 available pipelines including orders, customers, inventory, and UTM parameters.

How do I configure Claude Web or Desktop to access my Shopify data from Kondado? ▼

In Claude Web or Desktop, navigate to the connection settings and add the Kondado MCP server. You will be redirected to app.kondado.com.br to authorize access via OAuth, granting the AI read-only permission to your replicated Shopify data. This GUI-based setup requires no command line tools or code editing.

Does the AI write data back to Shopify or execute actions like creating orders? ▼

No, the AI provides read-only analytical chat. It cannot create orders, update inventory levels, process refunds, or execute any actions within your Shopify store. The MCP connection only allows the AI to query and analyze your replicated data for insights and reporting purposes.

How does authentication work when connecting ChatGPT to my Shopify store via Kondado? ▼

Authentication occurs through OAuth at app.kondado.com.br. When you add the Kondado MCP server in ChatGPT settings, the system prompts you to sign in to your Kondado account and authorize the connection. This one-time setup links your replicated Shopify data to the AI client without requiring API keys or technical configuration.

How often does the Shopify data update in the AI chat? ▼

Updates occur on a configurable schedule that you set in Kondado, ranging from frequent intervals to daily refreshes depending on your business needs. This ensures the AI references current information for sales figures, inventory counts, and order statuses without manual data exports.

What is the difference between asking the AI about Shopify data and using the ready dashboards? ▼

Asking the AI in chat provides exploratory, on-demand analysis where you investigate specific questions conversationally and receive instant text-based insights. The ready Power BI and Looker Studio reports offer visual, recurring monitoring with pre-built charts and graphs for tracking KPIs over time without typing queries.

Which ready dashboard templates are available for Shopify data visualization? ▼

Kondado provides ready report templates in Power BI and Looker Studio that visualize Shopify metrics including sales performance, customer acquisition funnels, inventory turnover, and fulfillment efficiency. These templates connect to the same replicated data used by the AI chat, ensuring consistency between your conversational analysis and visual dashboards.

Can I use other MCP clients besides Claude and ChatGPT to analyze my Shopify data? ▼

Yes, any MCP client can connect to Kondado's MCP server to analyze Shopify data. While Claude and ChatGPT are the most popular interfaces, other compatible clients work equally well for querying your orders, customers, and product information through the same OAuth authentication process.

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

AI to analyze Shopify data with Claude and ChatGPT

Get started for free

AI to analyze Shopify data with Claude and ChatGPT

I prefer ready dashboards

I want to ask the AI

Shopify tables and metrics available via Kondado

How to connect and use AI with your data

Connect Shopify on Kondado

Add Kondado MCP in Claude or ChatGPT

Ask about data or open dashboards

Other connectors with AI via MCP

CRM and Sales

Marketing and Automation

Advertising and Media

E-commerce and Marketplaces

Financial and Payments

Support and Customer Service

Databases

Productivity and Collaboration

Social Media

User Analytics

Storage and Transfer

Related on Kondado

Frequently asked questions about AI