How does the Olist Tiny to MySQL replication process work technically?

Kondado connects directly to your Olist Tiny account 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, maintaining data consistency without requiring manual exports or file transfers.

What specific Olist Tiny data can I replicate to MySQL?

You can replicate 15 different pipelines including CRM Issues, Accounts Payable, Accounts Receivable, Orders, Invoices, Products, and Contacts. Each pipeline contains specific fields such as issue tracking details, payment histories, order information, and inventory levels, totaling 792 available fields for analysis.

How frequently does Olist Tiny data update in MySQL?

Kondado updates your MySQL data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This ensures your database reflects recent Olist Tiny activity according to your business needs without overwhelming your systems with constant requests.

Can I combine Olist Tiny data with other business sources in the same MySQL database?

Yes, you can combine Olist Tiny data with information from over 80 other data sources available on Kondado within the same MySQL instance. This allows you to create unified views of your business by joining ERP data with marketing platforms, payment processors, or other operational tools.

What format does Olist Tiny data take once it reaches MySQL?

Olist Tiny data arrives in MySQL as structured relational tables with preserved data types, where each pipeline becomes a separate table. Fields such as data_emissao, valor_total, and cliente_nome maintain their original formats, enabling immediate SQL analysis and reporting.

Are there pre-built dashboards available for Olist Tiny data?

Yes, Kondado offers pre-built report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report. These ready-made dashboards connect directly to your data, providing immediate visualizations of your sales, inventory, and financial metrics without requiring you to build charts from scratch.

Can I send Olist Tiny data to destinations other than MySQL?

Absolutely, you can send Olist Tiny data to multiple destinations simultaneously. In addition to MySQL, you can replicate the same pipelines to BigQuery , PostgreSQL , Google Sheets , or Power BI for different analytical needs across your organization.

Do I need programming skills to set up the Olist Tiny MySQL connection?

No coding is required to establish the connection between Olist Tiny and MySQL. The platform provides a no-code interface where you authenticate your Olist Tiny account, enter your MySQL connection details, and select pipelines through a visual menu.

Send data from Olist Tiny to MySQL

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

Send Olist Tiny Data to MySQL Automatically

Kondado provides a direct integration between Olist Tiny and MySQL, allowing you to replicate your ERP data automatically without writing complex extraction scripts. Simply connect your Olist Tiny account as a data source, configure MySQL as your destination, and select which pipelines you want to replicate from the available 15 options. The platform handles all data extraction and loading on a configurable schedule, ensuring your database stays current with your latest ecommerce transactions, financial records, and operational data while eliminating manual CSV exports and data entry tasks.

Kondado automatically replicates Olist Tiny CRM Issues, Accounts Payable, Accounts Receivable, Orders, Invoices, Products, and 8 additional pipelines directly into your MySQL database on a configurable schedule ranging from every 5 minutes to daily, creating a centralized repository for analytics and reporting.

Once your data arrives in MySQL, you can run complex SQL queries, build custom dashboards, or combine Olist Tiny information with other business systems to generate comprehensive insights about your retail operations, inventory turnover, and financial performance across multiple channels.

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

Available Olist Tiny Pipelines for MySQL

With the CRM Issues and CRM Issues Details pipelines in your MySQL database, support teams can analyze ticket resolution times and customer satisfaction trends using SQL queries to identify bottlenecks in service delivery. Finance teams benefit from the Accounts Payable and Accounts Receivable pipelines, enabling cash flow forecasting by joining payment data with historical trends directly within MySQL. Additionally, the Order Details and Product Stock pipelines allow inventory managers to build automated alerts when stock levels drop below thresholds, ensuring your online store never misses a sales opportunity due to unavailable products.

Try out all the features for free for 14 days

Olist Tiny data available for MySQL

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue in the CRM.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.
Accounts Payable	Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.
Accounts Receivable	Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.
Contacts	Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.
Accounts Payable Details	Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.
Invoice Details	Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.
Order Details	Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.
Product Stock	Contains information about the available quantity of products, including fields such as id, product name, and stock balance.
Invoices	Records details of issued invoices, including fields such as id, issue date, and customer name.
Orders	Includes information about placed orders, with fields such as id, order date, and order status.
Products	Presents data about registered products, including id, name, and selling price.
Products: grid	Provides a grid view of products, with fields such as id, name, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue in the CRM.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.

Accounts Payable

Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.

Accounts Receivable

Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.

Contacts

Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.

Accounts Payable Details

Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.

Invoice Details

Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.

Order Details

Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.

Product Stock

Contains information about the available quantity of products, including fields such as id, product name, and stock balance.

Invoices

Records details of issued invoices, including fields such as id, issue date, and customer name.

Orders

Includes information about placed orders, with fields such as id, order date, and order status.

Products

Presents data about registered products, including id, name, and selling price.

Products: grid

Provides a grid view of products, with fields such as id, name, and category.

See all available data →

Try out all the features for free for 14 days

How to send Olist Tiny data to MySQL

Sync data automatically — no code, no manual exports.

Connect Olist Tiny Account

Authenticate your Olist Tiny ERP system by entering your API credentials in Kondado's data source configuration panel to establish the initial connection.

Configure MySQL Destination

Enter your MySQL database host, port, username, and password in the destination settings to create the target location where your Olist Tiny pipelines will be stored.

Select Pipelines and Schedule

Choose which of the 15 available Olist Tiny pipelines you want to replicate and set your preferred update frequency, ranging from every 5 minutes to daily, to automate the data flow.

Try out all the features for free for 14 days