Kondado makes it simple to visualize your VTEX store data directly in BI TOTVS without technical complexity or manual work. Simply connect your VTEX account as a data source, choose from seventeen available pipelines including Orders, Stock, and Marketing Data, and replicate the information to your BI TOTVS environment. You control the update frequency, selecting from every five minutes to daily refreshes, ensuring your reports always reflect current business conditions.
Kondado provides a direct integration between VTEX and BI TOTVS that replicates your ecommerce data on a configurable schedule, enabling automated dashboards and reports without manual exports or complex setup.
With your sales, inventory, and customer metrics flowing automatically into BI TOTVS, your marketing and operations teams gain immediate visibility into store performance. Track order trends, monitor stock levels, and analyze campaign effectiveness through visual reports that update themselves, allowing you to focus on growing your business rather than compiling spreadsheets.
Combining VTEX with BI TOTVS unlocks powerful retail analytics for your business operations. By replicating the Orders pipeline alongside Marketing Data of Orders and Stock information, you can analyze how promotional campaigns impact sales velocity and inventory turnover in a single view. Marketing teams identify which affiliates drive the most revenue while operations managers track shipping performance and product availability without switching between platforms. This unified visibility helps you optimize pricing strategies, manage fulfillment efficiently, and make data-driven decisions that improve customer satisfaction and profitability.
Try out all the features for free for 14 days
How to create VTEX dashboards in BI TOTVS
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Connect your VTEX store
Log into Kondado and add VTEX as a new data source by entering your store credentials. Select the pipelines you want to replicate, such as Orders, Stock, or Marketing Data.
2
Choose BI TOTVS destination
Select BI TOTVS from the available destinations to receive your VTEX data. Configure the connection to use the Via Kondado method for direct replication without intermediate databases.
3
Schedule updates and build reports
Set your preferred refresh frequency from five minutes to daily, then start creating visualizations in BI TOTVS. Your dashboards will stay current automatically as Kondado replicates new data on your configured schedule.
Try out all the features for free for 14 days
Access VTEX data in BI TOTVS and combine it with dozens of other data sources
If the source you want is not listed, drop us a chat message. We love to add new sources!
Answers about visualizing VTEX data in BI TOTVS automatically
How do I connect my VTEX store to BI TOTVS using Kondado?▼
Start by adding VTEX as a data source in your Kondado account using your store credentials. Then select BI TOTVS as your destination and choose which pipelines to replicate, such as Orders and Stock data. The connection uses the Via Kondado method, eliminating the need for intermediate databases or complex technical configuration.
What VTEX data can I visualize in BI TOTVS?▼
Kondado offers seventeen pipelines including Orders, Order Items, Stock, SKUs, Coupons, and Marketing Data of Orders. You can analyze transaction details, inventory levels by warehouse, promotional campaign performance, and shipping logistics all within your BI TOTVS environment.
How often does VTEX data update in BI TOTVS?▼
You configure the replication schedule based on your business needs, choosing intervals from every five minutes to daily updates. This ensures your dashboards display current information without manual refreshes, keeping your sales and inventory reports accurate throughout the day.
Are there pre-built dashboard templates for VTEX data?▼
Yes, Kondado provides ready-made report templates including the VTEX Power BI Report and VTEX Looker Studio Report. These templates offer immediate visualizations for common ecommerce metrics, though you can also build custom dashboards directly in BI TOTVS using the replicated data. If your team uses multiple tools, you can also send data to Power BI or Google Sheets.
What ecommerce KPIs should I track in BI TOTVS with VTEX data?▼
Focus on order conversion rates, average order value, inventory turnover by SKU, and campaign ROI using the Orders and Marketing Data pipelines. Tracking shipping estimated dates alongside actual delivery performance also helps optimize your logistics operations.
Can I share VTEX dashboards with my team in BI TOTVS?▼
Once your data flows into BI TOTVS, you can distribute reports to marketing teams, operations managers, and executives through the platform's native sharing features. Everyone accesses the same updated metrics, ensuring consistent decision-making across your organization.
Do I need technical skills to set up the VTEX to BI TOTVS connection?▼
No coding or technical expertise is required. The setup process involves simple selections in the Kondado interface: connect your VTEX account, pick your desired pipelines, and set your update schedule. Business users can complete the configuration in minutes without IT assistance.
'%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)