Two powerful tools, together

Integrate Shopify and Pentaho to turn your data into actionable insights.

About Shopify

Shopify is an ecommerce platform.

Stitch offers detailed documentation on how to sync your Shopify data.

Stitch Shopify Documentation

About Pentaho

Pentaho is a BI software suite with a focus on big data analytics. Pentaho features tools around reporting, dashboard creation, data mining, and data modeling.

Learn more about Pentaho

Shopify to your data warehouse in minutes

Stitch delivers all your data to the leading data lakes, warehouses, and storage platforms.Then, simply connect Pentaho to the warehouse of your choice.

Expected Shopify data

Here’s a sample of the raw Shopify data that Stitch will replicate to your analytics warehouse:

Checkouts

This table contains information about abandoned checkouts. Abandoned checkouts are defined as checkouts where the customer has entered their billing and shipping information, but not completed the ordering process.

Integrations Table Icon Table name: checkouts

Customers

This table contains information about customer accounts.

Integrations Table Icon Table name: customers

Order

This table contains information about completed customer orders.

Integrations Table Icon Table name: order

Product

This table contains information about products.

Integrations Table Icon Table name: product

Refunds

This table contains information about refunds.

Integrations Table Icon Table name: refunds

Transactions

This table contains information about transactions. In Shopify, a transaction is created for every order that results in an exchange of money - an authorization, a sale, a capture, a void, and a refund.

Integrations Table Icon Table name: transactions

View all tables

With Stitch we spend more time surfacing valuable insights and less time managing the data pipeline.

Caitlin Moorman

Insights and Analytics Lead, indiegogo

Why our customers choose Stitch

Stitch is a simple, powerful ETL service built for developers. Stitch connects to your first-party data sources – from databases like MongoDB and MySQL, to SaaS tools like Salesforce and Zendesk – and replicates that data to your warehouse. With Stitch, developers can provision data for their internal users in minutes, not weeks.

Explore all of Stitch's features
Simple Integrations Icon Simple setup
Start replicating data in minutes, and never worry about ETL maintenance.
Integration Infrastructure Icon Own your own data infrastructure
Stitch replicates to your warehouse, meaning you’re always in control.
Replication Features Icon Mature replication engine
Accurate data from any structure, all the time.
Explore all of Stitch's features

Connect to your ecosystem of data sources

Stitch integrates with leading databases and SaaS products. No API maintenance, ever, while you maintain full control over replication behavior.