Hotmart Import
Import your Hotmart sales data into GoConverso to automatically create client records, track revenue, and build customer journey timelines. Available on all plans.
FreeOverview
The Hotmart Import app lets you bring your existing Hotmart sales history into GoConverso’s CRM. Upload a spreadsheet exported from Hotmart, and the system automatically creates client records, tracks purchase revenue, and maps each customer’s journey — giving you a complete picture of your business without manual data entry.
Key capabilities:
| Feature | Description |
|---|---|
| File Import | Upload CSV or Excel files (.xlsx, .xls) exported from Hotmart |
| Smart Matching | Automatically matches buyers to existing clients by email |
| Revenue Tracking | Tracks active revenue and lost revenue (cancellations, refunds) |
| Customer Journey | Creates timeline milestones for each purchase |
| Batch Processing | Handles large files with real-time progress tracking |
| Multi-language | Detects Portuguese and English column names automatically |
Who it’s for:
- Hotmart producers migrating their client base to GoConverso
- Digital product sellers who want unified CRM across platforms
- Professionals tracking revenue from Hotmart alongside GoConverso bookings and orders
Getting Started
Accessing the Hotmart Import App
Navigate to the App
Go to Dashboard → Apps → Hotmart Import.
Export your data from Hotmart
In your Hotmart dashboard, export your sales data as a CSV or Excel file. The export should include buyer information (name, email) and transaction details (product, amount, status, date).
Start the import wizard
Click New Import to launch the 5-step import wizard.
Hotmart Import is available on all plans. Free users can run up to 3 imports per month with unlimited rows. Plus and above have unlimited imports.
Import Wizard
The import process follows a guided 5-step wizard.
Step 1: Upload File
Upload your Hotmart export file:
| Supported Format | Extension |
|---|---|
| Excel (modern) | .xlsx |
| Excel (legacy) | .xls |
| CSV | .csv |
- Drag and drop the file onto the upload area, or click to browse
- Maximum file size: 10 MB
- Files are stored temporarily and automatically deleted after 7 days
Step 2: Preview Data
After upload, the system parses the file and shows a preview:
- Column auto-detection — The system recognizes 27+ column name variations in both Portuguese and English
- Row preview — See the first rows of parsed data in a table
- Column mapping — Verify that columns are correctly matched to fields (name, email, product, amount, status, date)
The column detector is case-insensitive and handles common variations like “Nome do Comprador”, “Buyer Name”, “nome_comprador”, and more. You don’t need to rename columns before importing.
Step 3: Confirm Import
Review the import summary before processing:
- Total rows to process
- Detected columns and their mappings
- Import options (how to handle duplicates)
Click Confirm to start processing.
Step 4: Processing
For large files (300+ rows), the system automatically splits your data into chunks of 300 rows. Each chunk is processed sequentially in batches of 50 rows internally:
- Real-time progress bar updates after each chunk completes
- Live counters for clients created, updated, and skipped
- Chunk indicator shows which chunk is being processed (e.g., “Chunk 2 of 4”)
- Processing continues in the background — you can navigate away and come back
| File Size | Chunks | Estimated Time |
|---|---|---|
| Up to 300 rows | 1 (no splitting) | Instant |
| ~900 rows | 3-4 chunks | ~1 minute |
| ~2,000 rows | 7 chunks | ~1.5 minutes |
| ~5,000 rows | 17 chunks | ~4 minutes |
For each row, the system:
- Looks for an existing client with the same email address
- If found, updates the client record with the purchase data
- If not found, creates a new client in your CRM
- Creates a customer journey milestone with the transaction details
- Tracks revenue (active for completed sales, lost for cancellations)
Files with fewer than 300 rows are processed in a single request with no splitting — the chunking is fully transparent and backward-compatible.
Step 5: Results
After processing completes, you see a detailed summary. If the import fails mid-way, you’ll see a friendly error message instead of a blank screen — with options to retry or start a new import.
| Metric | Description |
|---|---|
| Clients Created | New client records added to your CRM |
| Clients Updated | Existing clients with new purchase data |
| Rows Skipped | Rows that couldn’t be processed (missing email, etc.) |
| Errors | Any rows that failed with error details |
| Total Revenue | Sum of active purchase amounts |
| Lost Revenue | Sum of cancelled/refunded amounts |
Click View Clients to go directly to your CRM and see the imported data.
How It Works
Client Matching
The import system uses email as the primary identifier for matching:
Import Row (email: maria@example.com)
│
├─ Client exists? → YES → Update client record + add purchase milestone
│
└─ Client exists? → NO → Create new client + add purchase milestoneThis means:
- No duplicates — The same buyer won’t be created twice
- Enriched data — Existing clients get their Hotmart purchases added to their timeline
- Unified CRM — Hotmart buyers appear alongside your booking and order clients
Revenue Tracking
The system categorizes each purchase by status:
| Hotmart Status | GoConverso Category | Impact |
|---|---|---|
| Completed / Approved | Active Revenue | Added to total_revenue |
| Cancelled | Lost Revenue | Tracked as lost_revenue |
| Refunded | Lost Revenue | Tracked as lost_revenue |
| Expired | Lost Revenue | Tracked as lost_revenue |
| Overdue | Lost Revenue | Tracked as lost_revenue |
This gives you visibility into both your earned revenue and recovery opportunities from churned customers.
Customer Journey Integration
Each imported purchase creates a milestone in the customer’s journey timeline:
- Purchase date and amount
- Product name
- Transaction status
- Source marked as “Hotmart Import”
These milestones appear alongside other GoConverso events (bookings, orders, portal visits) in the client’s CRM profile, giving you a complete history.
Large File Handling
Files with more than 300 rows are automatically split into chunks on the client side. Each chunk is sent to the server individually, keeping each request well within the 60-second timeout limit:
File: 921 rows
│
├─ Chunk 1: rows 0–299 → sent to server → processed in batches of 50
├─ Chunk 2: rows 300–599 → sent to server → processed in batches of 50
├─ Chunk 3: rows 600–899 → sent to server → processed in batches of 50
└─ Chunk 4: rows 900–920 → sent to server → processed + finalizedThe final chunk triggers the import finalization, which calculates the overall summary statistics (total clients created, revenue imported, etc.).
If you experience a timeout error with very large files, try splitting the spreadsheet into files of 3,000 rows or fewer before importing.
Column Detection
The parser supports 27+ column name variations in both Portuguese and English:
| Field | Portuguese Examples | English Examples |
|---|---|---|
| Buyer Name | Nome do Comprador, nome_comprador | Buyer Name, buyer_name |
| Buyer Email | Email do Comprador, email_comprador | Buyer Email, buyer_email |
| Product | Produto, nome_produto | Product, product_name |
| Amount | Valor da Venda, valor | Sale Amount, amount |
| Status | Status da Transação, status | Transaction Status, status |
| Date | Data da Compra, data | Purchase Date, date |
The detection is case-insensitive and handles underscores, spaces, and common abbreviations.
Import History
All past imports are tracked in the Import History tab:
| Column | Description |
|---|---|
| Date | When the import was run |
| File Name | Original file name |
| Total Rows | Number of rows in the file |
| Clients Created | New clients from this import |
| Clients Updated | Existing clients updated |
| Status | Completed, Processing, or Failed |
You can view details of any past import to see the full results breakdown.
Plan Availability
| Feature | Free | Plus | Pro | Max | Ultra |
|---|---|---|---|---|---|
| Imports per month | 3 | Unlimited | Unlimited | Unlimited | Unlimited |
| Rows per import | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
| Revenue tracking | Yes | Yes | Yes | Yes | Yes |
| Customer journey | Yes | Yes | Yes | Yes | Yes |
| Import history | Yes | Yes | Yes | Yes | Yes |
| Column auto-detection | Yes | Yes | Yes | Yes | Yes |
Related
- Client Management — View and manage imported clients in your CRM
- Digital Products — Sell digital content natively on GoConverso
- E-Commerce — Full e-commerce store with inventory and orders