No-code pipeline · Loja Integrada → BigQuery

Send data from Loja Integrada to BigQuery

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

From Loja Integrada to BigQuery: managed, scheduled, no code.
Kondado provides a direct integration between Loja Integrada and BigQuery, automatically replicating 17 data pipelines including Orders, Customers, Products, and Inventory data on a configurable schedule ranging from every 5 minutes to daily, requiring no technical setup or maintenance.
Connect Loja Integrada now →

Send Loja Integrada Data to BigQuery Automatically

Setting up a data pipeline from Loja Integrada to BigQuery requires no coding or complex manual exports when using Kondado. Simply authenticate your Loja Integrada store as a data source, designate BigQuery as your destination, and select which pipelines to replicate from the available 17 endpoints covering orders, inventory, and customer data. Kondado manages the automated extraction and loading on a configurable schedule, ensuring your Google Cloud data warehouse stays current with your Brazilian e-commerce operations without technical overhead or ongoing maintenance.

Once your data arrives in BigQuery, you can build custom analytics combining Loja Integrada sales information with marketing data or external inventory systems. Create comprehensive dashboards in Looker Studio or Power BI that track order trends, customer segmentation, and product performance across your entire operation to drive strategic decisions and optimize your store performance.

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

Replicate your Orders and Order Status History pipelines to BigQuery to analyze conversion funnels and identify bottlenecks in your sales process using standard SQL queries. Combine this with the Product Stock pipeline to correlate inventory levels with sales velocity, ensuring you never miss revenue opportunities due to stockouts during peak Brazilian shopping seasons. The Customers and Customer Groups pipelines enable deep segmentation analysis, allowing you to build cohort-based retention models and personalized marketing campaigns directly within your BigQuery environment alongside data from Google Sheets or PostgreSQL.

Try out all the features for free for 14 days

Replicated to BigQuery

Loja Integrada data available for BigQuery

Tables Kondado writes into your BigQuery, on a schedule you control.

17
available pipelines
397
extractable fields
BigQuery
Destination

Available integrations

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.
See all available data → Send Loja Integrada to BigQuery →

Try out all the features for free for 14 days

How to send Loja Integrada data to BigQuery

Sync data automatically — no code, no manual exports.

1
Connect Loja Integrada Store

Authenticate your Loja Integrada store in Kondado by providing your API credentials through the connection interface. This establishes the data source link allowing Kondado to access your store's orders, inventory, and customer information.

2
Configure BigQuery Destination

Set up BigQuery as your destination by specifying your Google Cloud project ID and dataset location where the replicated data will reside. Kondado automatically creates the necessary dataset structure and manages authentication with your Google Cloud account.

3
Select Pipelines and Schedule

Choose which of the 17 available pipelines to replicate, such as Orders, Products, or Customers, and set your preferred update frequency from every 5 minutes to daily. Once configured, Kondado begins automated replication immediately, keeping your BigQuery data current without further action.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Why Kondado?

Focus on extracting value from your data and leave the rest to us

shape-data-to-dashboards icon-data-multiple-destinations

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →
shape-data-to-dashboards icon-data-multiple-destinations

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →
shape-data-to-dashboards icon-data-dollar

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Loja Integrada to other destinations

Looker Studio

Loja Integrada > Looker Studio
Power BI

Loja Integrada > Power BI
Other visualizations
Other visualizations
Amazon S3

Loja Integrada > Amazon S3
BigQuery

Loja Integrada > BigQuery
Excel

Loja Integrada > Excel
Google Sheets

Loja Integrada > Google Sheets
MySQL

Loja Integrada > MySQL
PostgreSQL

Loja Integrada > PostgreSQL
Redshift

Loja Integrada > Redshift
SQL Server

Loja Integrada > SQL Server

Choose a tool to visualize your Loja Integrada data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Airtable
Loja Integrada > Airtable
Alteryx
Loja Integrada > Alteryx
Amazon Quicksight
Loja Integrada > Amazon Quicksight
BIMachine
Loja Integrada > BIMachine
Cortex
Loja Integrada > Cortex
Data Studio
Loja Integrada > Data Studio
Geckoboard
Loja Integrada > Geckoboard
Grafana
Loja Integrada > Grafana
IBM Cognos Analytics
Loja Integrada > IBM Cognos Analytics
Klipfolio
Loja Integrada > Klipfolio
Looker Studio
Loja Integrada > Looker Studio
Looker
Loja Integrada > Looker
Looqbox
Loja Integrada > Looqbox
Metabase
Loja Integrada > Metabase
Microstrategy
Loja Integrada > Microstrategy
Pentaho
Loja Integrada > Pentaho
Power BI
Loja Integrada > Power BI
Qlik Cloud Analytics
Loja Integrada > Qlik Cloud Analytics
Qlik Sense
Loja Integrada > Qlik Sense
Qlik
Loja Integrada > Qlik
QlikView
Loja Integrada > QlikView
Redash
Loja Integrada > Redash
Superset
Loja Integrada > Superset
Tableau
Loja Integrada > Tableau
BI TOTVS
Loja Integrada > BI TOTVS
Zoho Analytics
Loja Integrada > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Loja Integrada data to BigQuery automatically

How does Kondado replicate Loja Integrada data to BigQuery? ▼
Kondado connects directly to your Loja Integrada store using standard authentication and extracts data from your selected pipelines automatically. The platform loads this information into your specified BigQuery dataset on a configurable schedule you control, handling all schema mapping and data type conversion automatically without requiring manual CSV exports or custom scripts.
What Loja Integrada data can I send to BigQuery? ▼
You can replicate 17 different pipelines including Orders, Customers, Products, Product Stock, Coupons, and Order Status History, totaling 397 available fields. This covers your complete e-commerce operation from inventory management and sales transactions to customer segmentation and promotional campaign tracking.
How often does Loja Integrada data update in BigQuery? ▼
Kondado updates your BigQuery tables on a configurable schedule that you set, with options ranging from every 5 minutes to daily intervals depending on your business needs. This near-real-time synchronization ensures your analytics reflect current store performance without manual intervention or delays.
Can I combine Loja Integrada data with other sources in BigQuery? ▼
Yes, once your Loja Integrada data resides in BigQuery, you can join it with information from marketing platforms, Google Sheets, or PostgreSQL to create unified reports. This enables comprehensive analysis across your entire business ecosystem using BigQuery's powerful SQL capabilities.
What format does Loja Integrada data arrive in BigQuery? ▼
Data arrives as structured tables within your BigQuery dataset, with each pipeline representing a separate table containing typed fields that match Loja Integrada's native data structure. Kondado automatically handles data type mapping and schema creation, ensuring your orders, inventory, and customer information are immediately queryable using standard SQL.
Do I need coding skills to connect Loja Integrada to BigQuery? ▼
No coding is required to establish the connection or maintain ongoing data replication between Loja Integrada and BigQuery. The setup process uses a visual interface where you simply authenticate your store, select your destination, and choose which pipelines to replicate on your preferred schedule.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days