No-code pipeline · Loja Integrada → MySQL

Send data from Loja Integrada to MySQL

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

From Loja Integrada to MySQL: managed, scheduled, no code.
Kondado replicates Loja Integrada data to MySQL on a configurable schedule, offering 17 pipelines including Orders, Customers, Products, and Coupons with 397 total fields available for analysis.
Connect Loja Integrada now →

Send Loja Integrada Data to MySQL Automatically

Sending data from Loja Integrada to MySQL requires a direct connection that automates the extraction and loading process for your Brazilian e-commerce operations. Kondado provides a no-code solution that connects your online store to your open-source database without manual CSV exports, complex scripting, or technical maintenance requirements. You simply authenticate your account, select the pipelines you need from the available data source, configure your MySQL destination parameters, and establish your preferred update frequency.

Once your data arrives in MySQL, you can query it using standard SQL to build custom reports, combine it with other business data, or power dashboards in tools like Power BI or Looker Studio. This automated workflow ensures your e-commerce metrics stay current while eliminating manual data entry tasks and reducing the risk of human error in your reporting processes.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

The Orders pipeline delivers comprehensive transaction details including status history and invoice information directly into your MySQL database, enabling you to calculate revenue trends and monitor fulfillment performance using custom SQL queries. When combined with the Customers pipeline, which captures contact details and segmentation data alongside the Customer Groups pipeline, you can analyze purchasing behavior and lifetime value across different audience segments. Additionally, the Product Stock and Product Prices pipelines ensure your inventory levels and pricing strategies remain synchronized, allowing you to build automated alerts when items run low or analyze margin shifts across your catalog.

Try out all the features for free for 14 days

Replicated to MySQL

Loja Integrada data available for MySQL

Tables Kondado writes into your MySQL, on a schedule you control.

17
available pipelines
397
extractable fields
MySQL
Destination

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 → Send Loja Integrada to MySQL →

Try out all the features for free for 14 days

How to send Loja Integrada data to MySQL

Sync data automatically — no code, no manual exports.

1
Connect Your Loja Integrada Store

Authenticate your Loja Integrada account in Kondado by entering your API credentials to establish the data source connection. This grants the platform access to extract your store's transaction, customer, and product information.

2
Configure MySQL Destination

Enter your MySQL database connection details including host, port, database name, and authentication credentials to establish the destination endpoint. Kondado will verify the connection and prepare your database to receive the incoming e-commerce data structures.

3
Select Pipelines and Schedule

Choose from the 17 available pipelines such as Orders, Customers, and Products, then set your preferred update frequency ranging from 5 minutes to daily. Once activated, Kondado will automatically begin replicating your selected Loja Integrada data to MySQL according to your configuration.

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 →

Send data from Loja Integrada to other destinations

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)

Answers about sending Loja Integrada data to MySQL automatically

How does Kondado connect Loja Integrada to MySQL? ▼
Kondado establishes a direct connection to your Loja Integrada store using your API credentials to extract data from selected pipelines. The platform then automatically loads this information into your MySQL database on your chosen schedule, handling schema creation and updates without requiring manual intervention.
Which specific Loja Integrada data points can I replicate to MySQL? ▼
You can access 17 distinct pipelines encompassing Orders with status histories, Customer profiles with segmentation details, Product catalogs with stock levels, and Coupon management data. This includes 397 total fields covering everything from shipping methods and payment configurations to product variations and brand information.
What schedule options exist for updating my Loja Integrada data in MySQL? ▼
Kondado supports automated updates on a configurable schedule ranging from every 5 minutes to daily intervals, allowing you to balance data freshness with system resources. You select your preferred frequency during the initial setup and can adjust it later as your reporting requirements evolve.
Can I merge Loja Integrada data with other business data in MySQL? ▼
Yes, MySQL serves as a central repository where you can combine your e-commerce data with information from additional sources like Google Sheets or BigQuery exports. This consolidation enables comprehensive analysis such as correlating inventory levels with supplier data or matching customer behavior across multiple touchpoints.
How is Loja Integrada data structured once it reaches MySQL? ▼
Each pipeline creates a dedicated relational table with properly typed columns reflecting the original data structure, such as VARCHAR for customer emails or DECIMAL for order totals. The schema preserves relationships between entities, allowing you to join Orders with Customers or Products with Categories using standard SQL foreign key relationships.
Is it possible to send Loja Integrada data to MySQL and visualization tools at the same time? ▼
Yes, Kondado supports multi-destination replication, meaning you can simultaneously send your store data to MySQL for SQL analysis and to Power BI or Looker Studio for dashboard creation. This ensures both your technical teams and business stakeholders access the same current data through their preferred interfaces.
What can I build with Loja Integrada data once it is in MySQL? ▼
With your e-commerce data stored in MySQL, you can construct custom business intelligence reports, automate inventory alerts when Product Stock levels drop below thresholds, or calculate customer lifetime value by joining transaction histories with demographic information. The SQL environment allows complex aggregations and filtering impossible within the standard Loja Integrada interface.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days