What specific customer information is available through the Loja Integrada data source?

The Customers pipeline captures comprehensive contact details including email addresses, names, and communication preferences, while the Customer Groups pipeline provides segmentation data with default group indicators. This enables you to build targeted email lists and analyze purchasing patterns across different customer segments for improved retention strategies.

How frequently can I schedule updates for my Loja Integrada data?

Kondado offers flexible scheduling options ranging from every 5 minutes to daily updates, allowing you to choose the frequency that matches your business needs. This configurable schedule ensures your Power BI dashboards or Google Sheets reports reflect recent transactions without overwhelming your system with unnecessary API calls.

Which analytics platforms and databases support Loja Integrada data from Kondado?

You can send replicated data to Power BI , Looker Studio , Google Sheets , BigQuery , and PostgreSQL , as well as MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility allows marketing teams to work in spreadsheets while analysts query structured data in cloud warehouses.

Can I monitor product inventory and variant performance with this Loja Integrada connection?

Yes, the Product Stock pipeline tracks available and reserved quantities for each SKU, while Product Variation Grades captures variant names and values for items like size or color. Combined with the Product Prices pipeline showing sale and promotional pricing, you can analyze which variants sell fastest and require restocking.

What financial and order tracking data does Loja Integrada provide through Kondado?

The Orders pipeline captures transaction IDs, statuses, and creation dates, while Order Invoices provides detailed billing information including total values and creation timestamps. You can also access Payment Methods data to calculate transaction fees and Shipping Methods to analyze fulfillment costs against revenue.

How can I analyze promotional campaign effectiveness using Loja Integrada data?

The Coupons pipeline extracts discount codes, application conditions, and usage parameters, allowing you to measure redemption rates and revenue impact. By connecting coupon usage to Order data in BigQuery or PostgreSQL , you can calculate ROI on specific promotional campaigns and optimize future discount strategies.

Is it possible to track order fulfillment workflows and status changes?

The Order Status History pipeline maintains a chronological record of every status change with timestamps, while the Order Statuses pipeline provides current state descriptions and last updated information. This enables you to identify bottlenecks in your fulfillment process and measure average time between order placement and shipping confirmation.

Send Loja Integrada 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

Connect Loja Integrada to Dashboards and Databases

Unlock the full potential of your Brazilian e-commerce operation by accessing detailed Loja Integrada data through Kondado for comprehensive Loja Integrada analytics. Replicate comprehensive information from your online store including customer profiles with contact details and segmentation groups, complete product catalogs with stock levels and variation grades, and detailed order histories with status tracking and invoice data. Access marketing data such as active coupons with application conditions, shipping method costs, and payment method fees to optimize your commercial strategy. This direct connection captures 397 distinct fields across your store’s operational ecosystem.

Kondado provides 17 automated pipelines that replicate 397 fields from Loja Integrada, covering Categories, Customers, Orders, Products, Coupons, and 12 additional data endpoints. This comprehensive data source enables automated updates on a configurable schedule ranging from every 5 minutes to daily, ensuring your analytics reflect current store performance without manual exports.

Marketing teams can analyze coupon redemption rates and customer group segmentation to optimize campaign targeting and promotional strategies. Operations managers benefit from automated inventory tracking through Product Stock and Order Status History pipelines, enabling proactive restocking and fulfillment monitoring. Data analysts can combine Order Invoices with Payment Methods data to calculate net revenue after fees and shipping costs, while customer success teams track communication preferences and purchase patterns to improve retention rates.

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

Below you will find the complete list of Loja Integrada pipelines available through Kondado, each designed to capture specific aspects of your e-commerce operation. The Customers pipeline delivers essential contact information and segmentation data for building targeted marketing lists, while the Orders and Order Status History pipelines provide transaction tracking and fulfillment workflow analysis. Product Stock and Product Prices pipelines enable dynamic inventory management and competitive pricing strategies by capturing available quantities, reserved stock, and promotional pricing tiers. The Coupons pipeline captures discount codes and application conditions to measure promotional effectiveness. By combining Orders data with Customer Groups and Shipping Methods, you can analyze geographic shipping costs against customer segments to optimize delivery strategies and margin analysis. Cross-referencing Product Variation Grades with Order Invoices allows you to identify which product variants drive the highest revenue and profit margins across different sales channels. With automated updates on a configurable schedule from every 5 minutes to daily, you can monitor critical KPIs such as conversion rates, average order value, and inventory turnover as frequently as your business requires.

Try out all the features for free for 14 days

Available Loja Integrada data

available pipelines

397

extractable fields

Available integrations

Integration	Description
Categories	Includes fields such as id, name, and description, allowing for the organization and hierarchy of products in the store.
Customers	Contains information such as id, name, and email, along with contact details and communication preferences.
Customer Groups	Presents fields such as id, name, and whether it is a default group, facilitating customer segmentation.
Coupons	Includes fields such as id, code, and application conditions, allowing management of discounts and promotions.
Labels	Provides information about labels used to categorize products or customers, facilitating organization.
Shipping Methods	Presents details about available shipping methods, including id, name, and associated costs.
Payment Methods	Includes information about payment methods, such as id, name, and applicable fees for transactions.
Brands	Contains fields such as id, name, and description, allowing for the identification and organization of product brands.
Orders	Includes information such as id, status, and creation date, allowing for tracking and management of orders.
Order Status History	Presents a record of order status changes, including id, status, and date of change.
Order Invoices	Includes fields such as id, creation_date, and total_value, allowing detailed tracking of invoices generated for each order.
Products	Contains information such as id, name, and description, along with data on price and category, essential for managing the product catalog.
Product Stock	Presents fields such as product_id, available_quantity, and reserved_quantity, allowing effective control of the stock for each product.
Product Variation Grades	Includes fields such as product_id, variation_name, and variation_value, facilitating the management of different variations of the same product.
Product Images	Presents fields such as product_id, image_url, and image_description, allowing visual organization and presentation of product images.
Product Prices	Includes fields such as product_id, sale_price, and promotional_price, essential for defining and managing the sale prices of products.
Order Statuses	Presents fields such as id, description, and last_updated, allowing monitoring of the different statuses of orders in processing.

How to visualize Loja Integrada data in 3 steps

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

Add Loja Integrada as a data source

Connect your Brazilian e-commerce store by selecting Loja Integrada from the data source catalog and entering your Loja Integrada API credentials to establish the initial connection.

Select pipelines and destination

Choose from the 17 available pipelines such as Orders, Customers, and Product Stock, then select where to send your data, whether to Power BI, BigQuery, Google Sheets, or databases like PostgreSQL and MySQL.

Analyze in dashboards, sheets, or databases

Build custom reports in Looker Studio or Power BI, manipulate data in Excel or Google Sheets, and run SQL queries on your BigQuery or PostgreSQL tables to uncover insights about sales trends and customer behavior.

Try out all the features for free for 14 days