From Nuvemshop (Tiendanube) to Redshift: managed, scheduled, no code.
Creating a pipeline that sends data from Nuvemshop (Tiendanube) to Redshift data warehouses takes only a few minutes with Kondado. And the whole integration from Nuvemshop (Tiendanube) to Redshift is managed and executed by our platform. With Kondado, you can focus on extracting value from Nuvemshop (Tiendanube) data and combining it with other data in your Redshift data warehouse
Kondado provides a direct connection between Nuvemshop (Tiendanube) and Amazon Redshift, enabling automated data replication without coding requirements. You configure which pipelines to activate from your Nuvemshop (Tiendanube) store, set your preferred update frequency from every five minutes to daily intervals, and Kondado handles the data transfer to your Redshift cluster. The platform supports 25 different data endpoints including sales, products, customers, and abandoned carts, delivering structured data ready for analysis. Once your data arrives in Redshift, you can build custom reports, combine it with data from other sources like BigQuery or PostgreSQL, and perform complex queries to uncover business insights that drive revenue growth and optimize inventory decisions across your e-commerce operation.
Kondado replicates data from Nuvemshop (Tiendanube) to Redshift on a configurable schedule, offering 25 pipelines and 981 fields including sales transactions, customer profiles, product catalogs, and abandoned cart data, enabling automated e-commerce analytics without manual exports.
With the Sales pipeline, you can analyze transaction patterns and revenue trends directly in Redshift to identify your best-performing products and peak selling periods. The Abandoned Carts pipeline enables you to recover lost revenue by identifying customers who left items behind, allowing you to create targeted remarketing campaigns based on specific products and cart values. Additionally, the Customers pipeline provides comprehensive shopper profiles that you can segment in Redshift to personalize marketing strategies, while the Products pipeline helps you manage inventory levels and pricing strategies by tracking stock availability and variant performance across your entire catalog.
Try out all the features for free for 14 days
Replicated to Redshift
Nuvemshop (Tiendanube) data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
25
available pipelines
981
extractable fields
Redshift
Destination
Available integrations
Custom Fields
Includes fields such as id, created_at, and description, allowing customization of information related to specific resources.
Abandoned Carts
Contains data such as id, billing_address, and completed_at, enabling tracking of unfinished checkouts.
Promotion Discount Settings
Includes information on discount, discount_coupon, and discount_gateway, detailing discount settings applied to abandoned carts.
Abandoned Cart Coupons
Presents data on coupons used, allowing analysis of promotions that encourage purchase completion.
Abandoned Cart Products
Provides information on products included in the cart, such as id and has_stock_available, essential for understanding abandonment.
Applied Promotions for Abandoned Carts
Includes details on promotions applied, allowing analysis of the impact of offers on unfinished carts.
Categories
Contains information about product categories, facilitating the organization and search for items in the store.
Distribution Centers
Presents data on distribution locations, allowing efficient management of inventory and logistics.
Distribution Center Inventory
Includes information on available stock, facilitating control and replenishment of products.
Customers
Contains data such as id, contact_email, and created_at, essential for customer relationship management.
Customers: Custom Fields
Includes fields such as id, created_at, and value, enabling customization of customer information based on specific needs.
Coupons
Contains information about coupons, including id, code, and discount value, facilitating the management of promotions and offers.
Shipping Methods
Presents data on shipping methods, such as id, name, and cost, allowing analysis of available delivery options.
Products
Includes details about products, such as id, name, and price, essential for inventory and sales management.
Products: Custom Fields
Provides fields such as id, created_at, and value, allowing customization of product information as needed.
Products: Variations
Includes information about product variations, such as id, type, and price, facilitating management of different product options.
Products: Variations: Custom Fields
Presents fields such as id, created_at, and value, allowing customization of specific information for product variations.
Sales
Contains data on sales, including id, total value, and date, essential for performance analysis and financial reporting.
Sales: Custom Fields
Includes fields such as id, created_at, and value, allowing customization of sales information as needed.
Sales: Promotion Discount Settings
Presents information on discount settings, such as id, discount type, and value, facilitating promotion management.
Sales: Coupons
View information about coupons used in sales, including fields such as id, discount, and created_at.
Sales: Shipments
Track details of sales shipments, with fields such as tracking_number, shipping_address, and created_at.
Sales: Shipping Events
Examine events related to shipping, including fields such as event_type, event_timestamp, and tracking_number.
Sales: Products
Explore information about sold products, with fields such as product_id, quantity, and price.
Sales: Applied Promotions
Analyze promotions applied in sales, including fields such as promotion_id, discount_value, and created_at.
How to send Nuvemshop (Tiendanube) data to Redshift
Sync data automatically — no code, no manual exports.
1
Connect your Nuvemshop store
Enter your Nuvemshop (Tiendanube) store credentials and API keys in Kondado to establish the data source connection and authorize data access.
2
Configure Redshift destination
Provide your Redshift cluster connection details including host, database name, and credentials to establish the destination warehouse where your e-commerce data will land.
3
Select pipelines and schedule
Choose which 25 available pipelines to activate, such as Sales and Abandoned Carts, and set your preferred update frequency from five minutes to daily intervals for automated replication.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Nuvemshop (Tiendanube) data to Redshift automatically
How does Kondado send Nuvemshop data to my Redshift cluster?▼
Kondado connects directly to your Nuvemshop (Tiendanube) store using your API credentials and replicates selected data to your Redshift warehouse on your chosen schedule. The platform handles schema creation and data type mapping automatically, delivering structured tables that reflect your store's sales, products, and customer information without requiring manual CSV uploads or custom scripts.
What specific Nuvemshop data endpoints can I replicate to Redshift?▼
You can activate 25 different pipelines including Sales, Abandoned Carts, Customers, Products, Coupons, and Distribution Centers, accessing 981 total fields across these endpoints. This includes detailed transaction records, customer contact information, inventory levels at distribution centers, and promotional discount settings, giving you comprehensive e-commerce data for analysis.
How frequently can I update my Nuvemshop data in Redshift?▼
Kondado offers configurable update schedules ranging from every five minutes to daily intervals, allowing you to balance data freshness with processing costs based on your business needs. You can set different frequencies for different pipelines, such as updating sales data every 15 minutes while refreshing product catalogs daily.
Can I merge Nuvemshop data with other platforms in Redshift?▼
Yes, you can replicate data from additional sources like Google Sheets, BigQuery, or PostgreSQL into the same Redshift environment to create unified reports. This enables you to correlate e-commerce transactions with marketing campaign data, financial records, or inventory management systems for holistic business intelligence.
How is Nuvemshop data structured when it arrives in Redshift?▼
Data arrives as structured relational tables with preserved data types, where each pipeline corresponds to a specific table containing relevant fields such as order IDs, timestamps, and monetary values. The schema maintains relationships between entities, allowing you to join sales records with customer profiles and product variations using standard SQL queries.
Do I need technical expertise to build reports from Nuvemshop Redshift data?▼
While Redshift requires SQL knowledge for direct querying, you can connect your Redshift data to visualization tools like Looker Studio or Power BI to create custom dashboards without writing complex database queries. Kondado's automated replication ensures your reports always reflect current data, enabling analysts to focus on insights rather than data preparation.
What can I do with Abandoned Cart data once it is in Redshift?▼
You can analyze abandonment patterns by correlating cart values with customer segments and product categories to identify friction points in your checkout process. This data enables you to calculate potential revenue recovery, optimize your retargeting campaigns, and personalize email marketing flows based on specific items left in carts.
'%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)
