Data connector

Send Loja Integrada data to AI, reports, spreadsheets and ETL

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
E-commerce and Marketplaces Financial and Payments

Unlock the full potential of your Brazilian e-commerce operation by accessing detailed Loja Integrada data through Kondado for comprehensive Loja Integrada analytics. Replicate comprehensive information from your online store including customer profiles with contact details and segmentation groups, complete product catalogs with stock levels and variation grades, and detailed order histories with status tracking and invoice data. Access marketing data such as active coupons with application conditions, shipping method costs, and payment method fees to optimize your commercial strategy. This direct connection captures 397 distinct fields across your store’s operational ecosystem.

Connect Loja Integrada now →

Try out all the features for free for 14 days

Kondado provides 17 automated pipelines that replicate 397 fields from Loja Integrada, covering Categories, Customers, Orders, Products, Coupons, and 12 additional data endpoints. This comprehensive data source enables automated updates on a configurable schedule ranging from every 5 minutes to daily, ensuring your analytics reflect current store performance without manual exports.

Marketing teams can analyze coupon redemption rates and customer group segmentation to optimize campaign targeting and promotional strategies. Operations managers benefit from automated inventory tracking through Product Stock and Order Status History pipelines, enabling proactive restocking and fulfillment monitoring. Data analysts can combine Order Invoices with Payment Methods data to calculate net revenue after fees and shipping costs, while customer success teams track communication preferences and purchase patterns to improve retention rates.

The Kondado platform takes care of refreshing Loja Integrada data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Loja Integrada data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

Below you will find the complete list of Loja Integrada pipelines available through Kondado, each designed to capture specific aspects of your e-commerce operation. The Customers pipeline delivers essential contact information and segmentation data for building targeted marketing lists, while the Orders and Order Status History pipelines provide transaction tracking and fulfillment workflow analysis. Product Stock and Product Prices pipelines enable dynamic inventory management and competitive pricing strategies by capturing available quantities, reserved stock, and promotional pricing tiers. The Coupons pipeline captures discount codes and application conditions to measure promotional effectiveness. By combining Orders data with Customer Groups and Shipping Methods, you can analyze geographic shipping costs against customer segments to optimize delivery strategies and margin analysis. Cross-referencing Product Variation Grades with Order Invoices allows you to identify which product variants drive the highest revenue and profit margins across different sales channels. With automated updates on a configurable schedule from every 5 minutes to daily, you can monitor critical KPIs such as conversion rates, average order value, and inventory turnover as frequently as your business requires.

Connector schema

Available Loja Integrada data

17
available pipelines
397
extractable fields

Available integrations

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.
See all available data → Use this connector in chat (AI + MCP) →

Try out all the features for free for 14 days

How to visualize Loja Integrada data in 3 steps

Connect Loja Integrada to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

1
Add Loja Integrada as a data source

Connect your Brazilian e-commerce store by selecting Loja Integrada from the data source catalog and entering your Loja Integrada API credentials to establish the initial connection.

2
Select pipelines and destination

Choose from the 17 available pipelines such as Orders, Customers, and Product Stock, then select where to send your data, whether to Power BI, BigQuery, Google Sheets, or databases like PostgreSQL and MySQL.

3
Analyze in dashboards, sheets, or databases

Build custom reports in Looker Studio or Power BI, manipulate data in Excel or Google Sheets, and run SQL queries on your BigQuery or PostgreSQL tables to uncover insights about sales trends and customer behavior.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Why Kondado?

Focus on extracting value from your data and leave the rest to us

shape-data-to-dashboards icon-data-multiple-destinations

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →
shape-data-to-dashboards icon-data-multiple-destinations

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →
shape-data-to-dashboards icon-data-dollar

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use Loja Integrada data

Loja Integrada > AI (Claude, ChatGPT, MCP)
Looker Studio

Loja Integrada > Looker Studio
Power BI

Loja Integrada > Power BI
Other visualizations
Other visualizations
Amazon S3

Loja Integrada > Amazon S3
BigQuery

Loja Integrada > BigQuery
Excel

Loja Integrada > Excel
Google Sheets

Loja Integrada > Google Sheets
MySQL

Loja Integrada > MySQL
PostgreSQL

Loja Integrada > PostgreSQL
Redshift

Loja Integrada > Redshift
SQL Server

Loja Integrada > SQL Server

Choose a tool to visualize your Loja Integrada data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Airtable
Loja Integrada > Airtable
Alteryx
Loja Integrada > Alteryx
Amazon Quicksight
Loja Integrada > Amazon Quicksight
BIMachine
Loja Integrada > BIMachine
Cortex
Loja Integrada > Cortex
Data Studio
Loja Integrada > Data Studio
Geckoboard
Loja Integrada > Geckoboard
Grafana
Loja Integrada > Grafana
IBM Cognos Analytics
Loja Integrada > IBM Cognos Analytics
Klipfolio
Loja Integrada > Klipfolio
Looker Studio
Loja Integrada > Looker Studio
Looker
Loja Integrada > Looker
Looqbox
Loja Integrada > Looqbox
Metabase
Loja Integrada > Metabase
Microstrategy
Loja Integrada > Microstrategy
Pentaho
Loja Integrada > Pentaho
Power BI
Loja Integrada > Power BI
Qlik Cloud Analytics
Loja Integrada > Qlik Cloud Analytics
Qlik Sense
Loja Integrada > Qlik Sense
Qlik
Loja Integrada > Qlik
QlikView
Loja Integrada > QlikView
Redash
Loja Integrada > Redash
Superset
Loja Integrada > Superset
Tableau
Loja Integrada > Tableau
BI TOTVS
Loja Integrada > BI TOTVS
Zoho Analytics
Loja Integrada > Zoho Analytics

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Loja Integrada to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What specific customer information is available through the Loja Integrada data source? ▼
The Customers pipeline captures comprehensive contact details including email addresses, names, and communication preferences, while the Customer Groups pipeline provides segmentation data with default group indicators. This enables you to build targeted email lists and analyze purchasing patterns across different customer segments for improved retention strategies.
How frequently can I schedule updates for my Loja Integrada data? ▼
Kondado offers flexible scheduling options ranging from every 5 minutes to daily updates, allowing you to choose the frequency that matches your business needs. This configurable schedule ensures your Power BI dashboards or Google Sheets reports reflect recent transactions without overwhelming your system with unnecessary API calls.
Which analytics platforms and databases support Loja Integrada data from Kondado? ▼
You can send replicated data to Power BI, Looker Studio, Google Sheets, BigQuery, and PostgreSQL, as well as MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility allows marketing teams to work in spreadsheets while analysts query structured data in cloud warehouses.
Can I monitor product inventory and variant performance with this Loja Integrada connection? ▼
Yes, the Product Stock pipeline tracks available and reserved quantities for each SKU, while Product Variation Grades captures variant names and values for items like size or color. Combined with the Product Prices pipeline showing sale and promotional pricing, you can analyze which variants sell fastest and require restocking.
What financial and order tracking data does Loja Integrada provide through Kondado? ▼
The Orders pipeline captures transaction IDs, statuses, and creation dates, while Order Invoices provides detailed billing information including total values and creation timestamps. You can also access Payment Methods data to calculate transaction fees and Shipping Methods to analyze fulfillment costs against revenue.
How can I analyze promotional campaign effectiveness using Loja Integrada data? ▼
The Coupons pipeline extracts discount codes, application conditions, and usage parameters, allowing you to measure redemption rates and revenue impact. By connecting coupon usage to Order data in BigQuery or PostgreSQL, you can calculate ROI on specific promotional campaigns and optimize future discount strategies.
Is it possible to track order fulfillment workflows and status changes? ▼
The Order Status History pipeline maintains a chronological record of every status change with timestamps, while the Order Statuses pipeline provides current state descriptions and last updated information. This enables you to identify bottlenecks in your fulfillment process and measure average time between order placement and shipping confirmation.

Related on Kondado

Try out all the features for free for 14 days