Chat with your Loja Integrada data

AI to analyze Loja Integrada data with Claude and ChatGPT

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

Loja Integrada
You
What were my total sales on Loja Integrada yesterday?
Loja Integrada Sales
Yesterday your Loja Integrada store processed R$ 12.450 across 89 orders with an average ticket of R$ 139,88.
Via Kondado MCP
You
Which product category had the highest growth this month?
Category Performance
Electronics grew +23% MoM compared to last month, driven by 156 orders for smartphone accessories and headphones.
Via Kondado MCP
You
How many orders are currently pending shipment?
Order Status
You have 34 orders awaiting fulfillment, with 12 in processing status and 22 ready for carrier pickup since yesterday.
Via Kondado MCP
You
What is my best-selling brand by revenue this quarter?
Brand Analytics
Brand "TechLife" generated R$ 45.780 in Q3 sales, representing 28% of total revenue across 312 transactions.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Loja Integrada data with Claude and ChatGPT

Ask Claude, ChatGPT or any MCP client about your Loja Integrada store performance using natural language. Query order volumes across specific date ranges, compare coupon effectiveness between customer segments, or investigate stock levels for product variations without writing SQL or manually exporting spreadsheets. The AI reads your replicated data and returns calculated insights instantly through conversational chat.

Kondado replicates Loja Integrada data through 17 pipelines to Claude, ChatGPT and any MCP client, enabling conversational analysis of e-commerce metrics. The same data also powers ready reports in Power BI and Looker Studio for visual monitoring.

E-commerce managers track daily sales trends and identify top-performing brands by asking simple questions in chat. Marketing analysts measure coupon redemption rates and segment high-value customers using natural language queries about purchase histories. Operations teams monitor order status transitions and shipping method performance to optimize fulfillment workflows, all without technical setup or data engineering resources.

I prefer ready dashboards

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

View Loja Integrada dashboards →

I want to ask the AI

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

View MCP setup →

The following pipelines expose detailed Loja Integrada metrics for AI-driven exploration. Query the Orders pipeline to analyze revenue trends and status distributions, or examine the Product Stock pipeline to identify items with low available quantities requiring immediate replenishment. The Customers and Customer Groups pipelines enable precise segmentation analysis, while Coupons data reveals which discount codes drive the highest conversion rates across your store. Combining Order Invoices with Payment Methods unlocks cash flow analysis by transaction type, and linking Product Prices with Product Variation Grades helps optimize pricing strategies across different SKUs. These automated updates run on a configurable schedule, ensuring your chat queries reflect the latest store activity with near-real-time accuracy.

How to connect Loja Integrada 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

Loja Integrada 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.

17
Tables
397
Fields
∞
Ad-hoc questions
Categories
Includes fields such as id, name, and description, allowing for the organization and hierarchy of products in the store.
Customers
Contains information such as id, name, and email, along with contact details and communication preferences.
Customer Groups
Presents fields such as id, name, and whether it is a default group, facilitating customer segmentation.
Coupons
Includes fields such as id, code, and application conditions, allowing management of discounts and promotions.
Labels
Provides information about labels used to categorize products or customers, facilitating organization.
Shipping Methods
Presents details about available shipping methods, including id, name, and associated costs.
Payment Methods
Includes information about payment methods, such as id, name, and applicable fees for transactions.
Brands
Contains fields such as id, name, and description, allowing for the identification and organization of product brands.
Orders
Includes information such as id, status, and creation date, allowing for tracking and management of orders.
Order Status History
Presents a record of order status changes, including id, status, and date of change.
Order Invoices
Includes fields such as id, creation_date, and total_value, allowing detailed tracking of invoices generated for each order.
Products
Contains information such as id, name, and description, along with data on price and category, essential for managing the product catalog.
Product Stock
Presents fields such as product_id, available_quantity, and reserved_quantity, allowing effective control of the stock for each product.
Product Variation Grades
Includes fields such as product_id, variation_name, and variation_value, facilitating the management of different variations of the same product.
Product Images
Presents fields such as product_id, image_url, and image_description, allowing visual organization and presentation of product images.
Product Prices
Includes fields such as product_id, sale_price, and promotional_price, essential for defining and managing the sale prices of products.
Order Statuses
Presents fields such as id, description, and last_updated, allowing monitoring of the different statuses of orders in processing.
Full docs on the wiki → Connect Loja Integrada now →

How to connect and use AI with your data

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

1
Connect Loja Integrada at app.kondado.com.br

Select Loja Integrada as your data source and choose a Via Kondado destination to replicate your store data, making it available for AI analysis and the dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

Open the connection settings in Claude Web or Desktop, or in ChatGPT, to add the Kondado MCP server and complete the OAuth authorization at app.kondado.com.br once, with no CLI commands or code required.

3
Ask about Loja Integrada in chat

Start querying your store data using natural language in the chat interface, and for ongoing visual monitoring, open the ready Power BI or Looker Studio report templates.

Other connectors with AI via MCP

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

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

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 business questions can Claude answer about my Loja Integrada store data? ▼
Claude can analyze your sales velocity by product category, identify which customer groups generate the highest average order value, and track order status transitions to spot fulfillment bottlenecks. You can ask about coupon redemption rates by campaign, compare shipping method costs across regions, or query current stock levels for specific product variations using everyday language.
How do I configure Claude or ChatGPT to access my Loja Integrada data through Kondado? ▼
In Claude Web or Desktop, or directly in the ChatGPT interface, 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 permissions to your replicated Loja Integrada pipelines. Other MCP clients also work with the same simple configuration process.
Can the AI execute actions in my Loja Integrada store or modify data? ▼
No, the integration provides read-only analytical access for chat-based questioning. The AI can analyze historical orders, calculate performance metrics, and compare trends across time periods, but it cannot create new orders, update stock quantities, change product prices, or modify customer records in your Loja Integrada account.
How frequently does the Loja Integrada data update for AI queries? ▼
Kondado replicates Loja Integrada data on a configurable schedule, which can be set to near-real-time intervals depending on your operational needs. This ensures that when you ask Claude or ChatGPT about yesterday's sales, current inventory levels, or recent order statuses, the responses reflect your most recent store activity.
What is the difference between asking the AI in chat and using the ready dashboard templates? ▼
Chat analysis with Claude or ChatGPT is ideal for exploratory questions, ad-hoc calculations, and specific investigations like determining which brands had the highest return rates last month or comparing quarterly growth across product categories. The ready Power BI and Looker Studio report templates provide visual monitoring with pre-built charts and graphs for recurring KPI tracking and executive presentations.
Which dashboard templates are available for visualizing Loja Integrada data? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize your Loja Integrada metrics through automated pipelines. These templates cover sales performance overviews, inventory monitoring dashboards, and customer analytics reports, complementing the deep-dive conversational analysis available through MCP chat.

Try out all the features for free for 14 days