What specific VTEX data can I replicate using Kondado?

You can access 17 distinct pipelines covering Orders, Order Items, Stock levels by warehouse, SKU pricing, Coupons, Promotions, Master Data entities, and detailed payment transactions. Each pipeline contains specific fields such as shipping estimated dates, UTM campaign parameters, invoice data, and stock quantities to support comprehensive VTEX analytics.

How do I connect VTEX to Power BI for e-commerce reporting?

Set up the VTEX data source in Kondado, select your desired pipelines, and choose Power BI as your destination. Kondado offers a pre-built VTEX Power BI Report template that you can customize with your specific KPIs and branding requirements.

Are there ready-made VTEX dashboard templates available?

Yes, Kondado provides pre-built report templates including the VTEX Power BI Report and VTEX Looker Studio Report. These templates come with pre-configured visualizations for order tracking, inventory management, and sales performance that you can deploy immediately after connecting your VTEX data source.

How frequently can I update my VTEX data in BigQuery?

Kondado updates VTEX data on a configurable schedule that you control, ranging from every 5 minutes to daily intervals. This flexibility allows you to maintain near-real-time inventory visibility in BigQuery or opt for daily batch updates to optimize API usage and costs.

Can I send VTEX order data to Google Sheets for team collaboration?

Absolutely, you can replicate VTEX Orders, Order Items, and Shipping Data directly to Google Sheets for easy sharing with marketing and operations teams. This enables non-technical stakeholders to access live sales data, track order statuses, and monitor shipping estimates without accessing the VTEX admin panel.

Which pipelines contain VTEX logistics and shipping information?

The Shipping Data of Orders pipeline provides estimated delivery dates and shipping windows, while Logistics Information of Orders contains invoice input and output data essential for fiscal management. These pipelines enable you to track fulfillment performance and manage cross-border commerce documentation.

How do I analyze VTEX promotion and coupon effectiveness?

Use the Coupons and Promotions pipelines to track coupon IDs, expiration intervals, maximum items per client, and redemption rates. Combine this data with the Marketing Data of Orders pipeline containing affiliate IDs and UTM parameters to measure which campaigns drive actual conversions versus just traffic.

Send VTEX data to reports, spreadsheets and ETL

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

VTEX Data Pipelines for Analytics & BI

Kondado enables you to extract comprehensive VTEX data including orders, inventory levels, promotional campaigns, and customer transactions through automated pipelines. Replicate detailed information from 17 distinct pipelines covering everything from SKU pricing and stock positions by warehouse to order logistics, shipping estimates, and marketing attribution data. Access granular fields such as coupon redemption details, payment transaction histories, Master Data entities, and logistics documents to power your VTEX analytics and business intelligence initiatives without manual exports.

Kondado provides a direct integration with VTEX featuring 17 ready-to-use pipelines and 432 distinct fields. Replicate data from core commerce entities including Orders, SKUs, Stock, Coupons, Promotions, and Master Data without writing code or managing complex API connections.

Marketing teams can analyze campaign performance using the Marketing Data of Orders and Promotions pipelines to track UTM attribution, affiliate IDs, and coupon effectiveness across all channels. Operations managers monitor inventory health and warehouse allocation through Stock and SKUs pipelines while finance teams reconcile transactions using Payments: Order Transactions and Orders: Totals data. Data analysts build comprehensive VTEX analytics combining logistics information, customer service details from Order Details, and sales metrics to identify growth opportunities, optimize pricing strategies, and improve the entire customer journey from browsing to final delivery.

The Kondado platform takes care of refreshing VTEX data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing VTEX data in your report, spreadsheet, data warehouse, data lake, or database

Ready-to-use and customizable reports for VTEX

Power BI

VTEX Power BI Report

Looker Studio

VTEX Looker Studio (now Data Studio) Report

Available VTEX Pipelines

Below you will find the complete list of VTEX pipelines available through Kondado, each containing specific fields for your e-commerce analytics requirements. The Orders pipeline captures order IDs, status values, and totals for comprehensive sales tracking, while Order Items reveals exactly which products were purchased with quantities and payment methods used. Marketing Data of Orders enables detailed analysis of affiliate performance and UTM campaign effectiveness, and Shipping Data of Orders provides critical logistics insights through estimated delivery dates and warehouse routing information. Finance teams benefit from the Payments: Order Transactions pipeline which details payment names and transaction values for accurate revenue reconciliation and financial reporting.

By combining Stock data with SKUs: Prices, you can analyze current inventory valuation and identify slow-moving products that need promotional discounting. Cross-referencing Orders: Fees and Benefits with Promotions data helps measure the true profit impact of coupons rather than just redemption volumes, while joining Orders with Shipping Data enables delivery performance analysis. With automated updates on a configurable schedule ranging from every 5 minutes to daily intervals, your VTEX dashboards and reports always reflect current stock levels, order statuses, and sales performance without requiring manual refreshing or CSV uploads.

Try out all the features for free for 14 days

Available VTEX data

available pipelines

432

extractable fields

Available integrations

Integration	Description
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.

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.

See all available data →

Try out all the features for free for 14 days

How to visualize VTEX data in 3 steps

Connect VTEX to dashboards, spreadsheets, or databases — no code required.

Add VTEX as a data source

Connect your VTEX account to Kondado by adding it as a data source using your VTEX API credentials. This establishes the secure connection needed to begin extracting your e-commerce data.

Select pipelines and destination

Choose from 17 available VTEX pipelines including Orders, Stock, and SKUs, then select where to send your data such as Power BI, Google Sheets, BigQuery, or PostgreSQL.

Visualize and analyze your data

Access your replicated VTEX data in BI dashboards like Looker Studio, analyze trends in spreadsheets including Excel and Google Sheets, or query structured tables in databases such as MySQL, Redshift, SQL Server, and Amazon S3 to generate actionable insights.

Try out all the features for free for 14 days