How do I connect VTEX to Metabase using Kondado?

Start by adding VTEX as a data source in your Kondado account and enter your store credentials. Then select Metabase as your destination and choose which pipelines you want to replicate, such as Orders, Stock, or Coupons. The connection uses our direct Via Kondado method, so you do not need to configure any intermediate databases or technical infrastructure.

What VTEX dashboards can I build in Metabase?

You can create operational dashboards tracking order fulfillment, inventory levels by warehouse, and promotional campaign performance. Marketing teams often build reports combining Orders data with Marketing Data of Orders to analyze customer acquisition costs and conversion rates. Operations managers use Stock and Logistics Information pipelines to monitor shipping times and prevent delivery delays.

How often does VTEX data update in Metabase?

You choose the update frequency based on your business needs, ranging from every 5 minutes to daily schedules. This configurable schedule ensures your dashboards reflect recent transactions without overwhelming your system with constant updates. You can adjust the timing anytime as your business requirements change during seasonal peaks or sales events.

Which VTEX KPIs should I track in Metabase?

Monitor order completion rates using the Orders pipeline, inventory turnover via Stock data, and coupon redemption effectiveness through the Coupons pipeline. Track shipping performance with Logistics Information and compare campaign ROI by analyzing Marketing Data of Orders alongside revenue totals. These metrics help identify bottlenecks in your ecommerce operation and opportunities to increase average order value.

Are there pre-built VTEX report templates available?

Yes, we offer ready-made dashboards including the VTEX Power BI Report and VTEX Looker Studio Report for users who prefer those visualization tools. While Metabase dashboards require custom building, you can reference these templates for inspiration on layout and KPI selection. The same data structure applies across all destinations, so insights from our Power BI or Looker Studio templates transfer easily to your Metabase environment.

Can I share VTEX Metabase dashboards with my team?

Yes, Metabase allows you to share interactive dashboards via links or email subscriptions with stakeholders across your organization. Team members can view reports without needing Kondado access, though you control permission levels for editing versus viewing. This keeps everyone from customer service to executive leadership aligned on current sales performance and inventory status.

Can I send VTEX data to other tools besides Metabase?

Absolutely, you can replicate your VTEX data to multiple destinations simultaneously including Google Sheets , BigQuery , PostgreSQL , MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility lets you use Metabase for executive dashboards while sending raw data to BigQuery for advanced analysis or Google Sheets for operational spreadsheets. Each destination maintains the same update schedule you configured for your primary connection.

Connect VTEX to Metabase: Dashboards in Minutes

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

Visualize VTEX Data in Metabase

Connect your VTEX store to Metabase without writing code or managing complex infrastructure. Kondado offers a direct connection that lets you replicate your ecommerce data on a configurable schedule, updating every few minutes or daily based on your business needs. Business teams can then explore orders, inventory, and customer information through Metabase’s intuitive interface to make faster, data-driven decisions about promotions, stock levels, and customer behavior patterns across all your sales channels.

Kondado connects VTEX to Metabase using a direct Via Kondado connection with no intermediate databases required, allowing you to visualize 17 different data pipelines including Orders, Stock, and Marketing Data in near-real-time dashboards. With automated updates and 432 available fields covering everything from coupon performance to logistics information, marketing and operations teams gain immediate access to the metrics that drive revenue growth without waiting for technical assistance or complex manual exports.

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

Once connected, you can combine data from multiple pipelines to answer complex business questions without technical help. The Orders pipeline reveals purchase patterns and revenue trends across all channels, while Marketing Data of Orders shows which campaigns actually convert customers, helping you optimize ad spend effectively. Stock and SKUs pipelines keep inventory levels visible in your dashboards, preventing overselling and stockouts during peak sales seasons. Metabase makes it easy to build shareable reports that keep everyone from warehouse managers to marketing directors aligned on the metrics that matter most for driving profitability.

Try out all the features for free for 14 days

VTEX data available in Metabase

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 create VTEX dashboards in Metabase

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connecting VTEX as a data source on Kondado

Add VTEX to your Kondado account by entering your App Key and App Token credentials from your VTEX admin panel. Select specific pipelines like Orders, Stock, or Master Data to start replicating your ecommerce information on your chosen schedule.

Selecting Metabase as destination

Choose Metabase as your destination to create a direct connection, or explore alternatives like Power BI and Looker Studio if your team prefers those visualization platforms.

Building dashboards and configuring data refresh

Use Metabase's question builder to create charts from your replicated data, then configure automatic refreshes ranging from 5 minutes to daily updates. Share completed dashboards with your team to keep everyone aligned on sales trends and inventory levels without manual reporting.