How often does Hotmart data update in MySQL?

Kondado updates your MySQL database on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. You can set different frequencies for different pipelines, such as updating Sales Commissions hourly while refreshing Hotmart Club progress daily. This flexibility ensures your analytics reflect current business conditions without overwhelming your database resources.

What specific Hotmart data can I replicate to MySQL?

You can replicate 11 distinct pipelines covering subscriptions, sales, commissions, and educational content from Hotmart Club. Available data includes subscriber records, transaction histories, product catalogs, student progress metrics, module completion rates, and detailed commission breakdowns across 202 total fields. This comprehensive coverage supports everything from financial reporting to learning management analysis.

Can I merge Hotmart data with other platforms in MySQL?

Yes, MySQL serves as a central repository where Hotmart data can coexist alongside information from additional sources. You can combine your digital sales data with marketing metrics from Google Sheets , advertising spend from BigQuery , or customer support data to create unified business intelligence. This consolidation enables cross-functional analysis that connects course sales to campaign performance.

How is Hotmart data formatted inside MySQL tables?

Each Hotmart pipeline creates structured tables in MySQL with normalized field names and appropriate data types for SQL querying. Fields like subscriber_code, transaction_value, and completion_percentage arrive ready for joins, aggregations, and time-series analysis without additional transformation. The schema preserves relationships between entities, allowing you to connect student progress to subscription status or sales commissions to specific products.

Can I send Hotmart data to MySQL and visualization tools at the same time?

Absolutely, Kondado supports multiple destinations so you can replicate Hotmart data to MySQL while simultaneously sending it to Power BI , Looker Studio , or PostgreSQL . This parallel routing ensures your analytical tools stay current while maintaining a historical record in MySQL for complex SQL analysis and custom reporting.

What happens to my existing Hotmart historical data when I first connect?

Kondado retrieves historical records from your Hotmart account during the initial setup, populating your MySQL database with past transactions, subscriber histories, and student progress data. The amount of historical data available depends on your Hotmart plan and API limits. Once the initial backfill completes, the pipeline maintains currency through incremental updates based on your chosen schedule.

Do I need technical expertise to set up the Hotmart to MySQL pipeline?

No coding is required to establish the connection: you authenticate your Hotmart account, provide your MySQL connection details, and select which pipelines to replicate using Kondado's interface. The platform manages API authentication, data type mapping, and schema creation automatically. Technical users can then leverage their SQL skills to build custom queries, while analysts can connect MySQL to their preferred BI tools.

Send data from Hotmart 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

Replicate Hotmart Data to MySQL Automatically

Kondado connects Hotmart to MySQL, allowing you to replicate your digital commerce data without writing code. Simply select your Hotmart account as the data source and MySQL as your destination, then choose which pipelines you want to replicate. The platform handles the data extraction and loading automatically on your preferred schedule, whether you need updates every few minutes or daily batches. Once configured, your subscription, sales, and student progress data flows continuously into your MySQL database, ready for analysis and reporting. This automated pipeline eliminates manual exports and keeps your financial and educational metrics current for decision-making.

Kondado replicates Hotmart data to MySQL on a configurable schedule, offering 11 pipelines including Subscribers, Sales Commissions, Subscription Transactions, and Hotmart Club progress data, with updates available every 5 minutes, 15 minutes, hourly, or daily.

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

With the Subscribers and Subscription Transactions pipelines, you can build cohort analysis queries in MySQL to track retention rates and lifetime value across your digital products. The Hotmart Club: Student Progress pipeline enables you to create custom learning analytics that monitor completion rates and engagement patterns, helping you identify at-risk students or high-performing content. Additionally, combining Sales Commissions data with your own cost structures in MySQL allows you to calculate true profitability per transaction and optimize your pricing strategy for courses and digital downloads.

Try out all the features for free for 14 days

Hotmart data available for MySQL

available pipelines

202

extractable fields

Available integrations

Integration	Description
Subscribers	Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions	Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases	Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown	Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History	Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students	Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules	Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress	Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages	Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products	Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions	Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

Subscribers

Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.

Sales Commissions

Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.

Subscriber Purchases

Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.

Sales Price Breakdown

Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.

Sales History

Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.

Hotmart Club: Students

Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.

Hotmart Club: Modules

Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.

Hotmart Club: Student Progress

Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.

Hotmart Club: Pages

Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.

Products

Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.

Subscription Transactions

Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

See all available data →

Try out all the features for free for 14 days

How to send Hotmart data to MySQL

Sync data automatically — no code, no manual exports.

Connect Your Hotmart Account

Authenticate your Hotmart credentials in Kondado to establish the data source, granting read access to your sales, subscription, and student progress information.

Configure MySQL Destination

Enter your MySQL host, database name, and credentials to establish the destination where your Hotmart pipelines will replicate structured data tables.

Select Pipelines and Schedule

Choose from 11 available Hotmart pipelines such as Subscribers, Sales Commissions, or Hotmart Club progress, then set your update frequency to run every 5 minutes, hourly, or daily.

Try out all the features for free for 14 days