From VTEX to Amazon S3: managed, scheduled, no code.
Kondado provides automated data replication from VTEX to Amazon S3, moving inventory, orders, promotions, and customer data on your configured schedule without requiring engineering resources or manual exports.
How to send VTEX data to Amazon S3? Kondado enables direct data replication from your VTEX e-commerce platform to Amazon S3 on a configurable schedule. You select which pipelines to activate from the available 17 data endpoints covering orders, inventory, and promotions, set the frequency from every 5 minutes to daily, and your data flows automatically into your S3 buckets as structured files ready for immediate analysis.
Once in Amazon S3, you can query this data with Athena or Presto, join it with other business sources, or feed it into your existing analytics stack for comprehensive reporting and business intelligence. This automated setup eliminates manual CSV exports and ensures your data lake stays current with your VTEX store operations, enabling faster decision-making across your organization while maintaining complete data consistency for accurate analysis and strategic planning.
Replicate your Orders and Order Items pipelines to analyze transaction patterns, or activate the Stock pipeline to monitor inventory levels across warehouses automatically. With Marketing Data of Orders, you can attribute revenue to specific campaigns and optimize your advertising spend.
Once stored in Amazon S3, combine this VTEX data with information from other sources to build comprehensive customer profiles or create unified financial reports. The structured files work seamlessly with Athena, Presto, and Dremio, allowing your team to run complex queries without impacting your production VTEX environment.
Try out all the features for free for 14 days
Replicated to Amazon S3
VTEX data available for Amazon S3
Tables Kondado writes into your Amazon S3, on a schedule you control.
17
available pipelines
432
extractable fields
Amazon S3
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.
Sync data automatically — no code, no manual exports.
1
Connect your VTEX store
Authenticate your VTEX account in Kondado by providing your API credentials and store identification. This establishes the data source connection and allows Kondado to access your e-commerce data.
2
Configure Amazon S3 destination
Enter your Amazon S3 bucket details and authentication keys to establish the destination for your replicated data. Kondado will organize the incoming VTEX data into structured folders within your specified S3 environment.
3
Select pipelines and schedule
Choose which of the 17 available pipelines to activate, such as Orders or Stock, and set your preferred update frequency. You can configure different schedules for different pipelines, from every 5 minutes to daily, depending on your analytics requirements.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending VTEX data to Amazon S3 automatically
How does Kondado replicate VTEX data to Amazon S3?▼
Kondado connects to your VTEX account via API and extracts data from your selected pipelines. The platform then transforms this information into structured file formats and loads it into your designated Amazon S3 buckets on the schedule you configure, whether every 5 minutes or daily.
What VTEX data can I replicate to Amazon S3?▼
You can choose from 17 available pipelines including Orders, Order Items, Stock, Coupons, Promotions, and Master Data. Each pipeline contains specific fields such as order details, inventory quantities, and promotional campaign information, giving you granular control over which business data flows into your S3 environment.
How often does VTEX data update in Amazon S3?▼
Kondado updates your data on a configurable schedule that you set during pipeline activation. Options range from every 5 minutes for near-real-time analytics to hourly or daily batches, depending on your business requirements and data freshness needs.
What format is VTEX data stored in within Amazon S3?▼
Data arrives as structured files optimized for analytical querying, compatible with AWS Athena, Presto, and Dremio. This format allows you to run SQL queries directly against your VTEX data without additional transformation or data type mapping.
Can I combine VTEX data with other sources in Amazon S3?▼
Yes, you can replicate data from additional sources into the same S3 bucket or data lake, then join VTEX information with marketing platforms, ERP systems, or customer databases. This unified approach enables comprehensive analytics across your entire business ecosystem.
Are there pre-built dashboards available for VTEX data?▼
Yes, Kondado offers ready-made reports including the VTEX Power BI Report and VTEX Looker Studio Report templates. These report templates provide immediate visualization of your key metrics, or you can send data to BigQuery and PostgreSQL for custom analysis.
Do I need technical skills to set up VTEX to Amazon S3 replication?▼
The setup requires no coding: you authorize the connection to your VTEX store, provide your Amazon S3 credentials, and select which pipelines to activate. Kondado handles the data extraction, formatting, and loading automatically once configured.
'%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)
