Creating a pipeline that sends data from VTEX to MySQL databases takes only a few minutes with Kondado. And the whole integration from VTEX to MySQL is managed and executed by our platform. With Kondado, you can focus on extracting value from VTEX data and combining it with other data in your MySQL database
Kondado enables you to replicate VTEX data to MySQL without writing a single line of code. Simply connect your VTEX store as a data source, configure MySQL as your destination, and select which pipelines you want to replicate from the available 17 options covering orders, inventory, and customer information. The platform handles data extraction and loading automatically on your chosen schedule, whether you need updates every 5 minutes or prefer daily consolidation for batch processing. Once your data arrives in MySQL, you can run complex SQL queries, build custom analytics dashboards, and combine VTEX information with other business data sources for comprehensive reporting and business intelligence.
Kondado automatically replicates VTEX e-commerce data to MySQL on a configurable schedule, providing 17 pipelines including Orders, Products, Stock, and Marketing Data with 432 fields available for analysis.
With the Orders and Order Items pipelines replicated to MySQL, you can analyze purchase patterns, calculate customer lifetime value, and identify your best-selling products using custom SQL queries. The Stock and SKUs pipelines provide granular inventory data that enables you to build automated low-stock alerts and optimize warehouse allocation directly within your database environment. Marketing teams can leverage the Marketing Data of Orders pipeline to attribute revenue to specific campaigns by joining UTM parameters with transaction values, allowing accurate ROI calculations and budget optimization without exporting CSV files.
Try out all the features for free for 14 days
Replicated to MySQL
VTEX data available for MySQL
Tables Kondado writes into your MySQL, on a schedule you control.
17
available pipelines
432
extractable fields
MySQL
Destination
Available integrations
Coupons
Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock
Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data
Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders
Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders
Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders
Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details
Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders
Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items
Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions
Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits
Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals
Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products
Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions
Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs
Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits
Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices
Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.
Answers about sending VTEX data to MySQL automatically
How does Kondado replicate VTEX data to MySQL?▼
Kondado connects directly to your VTEX account using your API credentials and extracts data from selected pipelines automatically. The platform then loads this information into your MySQL database on the schedule you configure, handling schema creation and updates without requiring manual intervention.
What specific VTEX data can I replicate to MySQL?▼
You can replicate 17 different pipelines including Orders, Stock, SKUs, Coupons, Promotions, Master Data, and Marketing Data of Orders with 432 total fields available. This covers everything from transaction details and inventory levels to shipping logistics and promotional campaign performance.
How frequently can I update VTEX data in MySQL?▼
You can configure updates to run every 5 minutes, 15 minutes, hourly, or daily depending on your business requirements and data freshness needs. This flexible scheduling ensures your MySQL database stays current without overwhelming your VTEX API limits or your database resources.
Can I combine VTEX data with other sources in MySQL?▼
Yes, once VTEX data resides in MySQL, you can join it with information from other Kondado data sources like BigQuery, PostgreSQL, or marketing platforms to create unified reports. This enables comprehensive analysis across your entire technology stack using standard SQL joins.
What format does VTEX data take in MySQL?▼
Each VTEX pipeline becomes a separate table in your MySQL database with properly typed columns reflecting the original field structures, including timestamps, numeric values, and text fields. The schema preserves relationships between entities like orders and items, allowing you to write queries that connect related data points naturally.
Are there pre-built dashboards available for VTEX data?▼
Yes, Kondado offers ready-made report templates including the VTEX Power BI Report and VTEX Looker Studio Report that you can use immediately. You can also send your data to Google Sheets or Looker Studio for quick visualization without building dashboards from scratch.
Do I need technical skills to set up VTEX to MySQL replication?▼
No coding is required to configure the connection: you simply authenticate your VTEX account, enter your MySQL connection details, and select which pipelines to replicate. The no-code interface guides you through mapping fields and setting schedules, making it accessible for analysts and marketers without engineering resources.
Can I send VTEX data to multiple destinations besides MySQL?▼
Absolutely, you can replicate VTEX data to Power BI, BigQuery, PostgreSQL, or Google Sheets simultaneously using the same configured pipelines. This allows different teams to access VTEX information in their preferred tools while maintaining a single source of truth in MySQL.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
