How do I connect my Shopify store to Metabase using Kondado?

Start by adding Shopify as a data source in your Kondado account and authenticate with your store credentials. Then select Metabase as your destination and choose which pipelines you want to replicate, such as Orders, Customers, or Products.

What Shopify dashboards can I build in Metabase?

You can create custom reports tracking sales performance, customer acquisition costs, inventory turnover, and abandoned cart recovery rates. Combine data from Orders, Orders Line Items, and Orders Visits UTM Parameters to analyze marketing ROI and product profitability.

How often does my Shopify data update in Metabase?

You can configure the update frequency to match your business needs, choosing from intervals as frequent as every 5 minutes or longer periods like hourly or daily. This keeps your dashboards current without manual data exports.

Which Shopify KPIs should I track in Metabase?

Focus on metrics like average order value, customer lifetime value, conversion rates by traffic source, and inventory levels by SKU. The Orders Discount Applications pipeline helps you analyze promotion effectiveness, while Abandoned Checkouts shows potential revenue recovery opportunities.

Can I share my Shopify Metabase dashboards with my team?

Yes, once you build your dashboards in Metabase, you can share them with marketing, operations, or executive teams. Your colleagues will see the same automated data updates based on the schedule you configured, ensuring everyone works with current information.

Do I need to set up a database before connecting Shopify to Metabase?

No, Kondado connects Shopify directly to Metabase using the "Via Kondado" option, eliminating the need for intermediate databases or complex infrastructure. This allows business users to start visualizing data immediately without technical setup.

Can I send Shopify data to other tools besides Metabase?

Yes, Kondado supports multiple destinations including Power BI , Looker Studio , Google Sheets , and BigQuery . You can also send data to PostgreSQL, MySQL, or Amazon S3 for different analytics needs.

What specific order details can I analyze in Metabase?

You can examine individual line items, applied discount codes, shipping methods, refund history, and payment transactions. The Orders Note Attributes pipeline also brings in custom fields and tags you have configured in your Shopify store.

Connect Shopify to Metabase: Dashboards in Minutes

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

Visualize Shopify Data in Metabase

Kondado helps business teams replicate their Shopify store data directly into Metabase without any coding or technical setup. Simply connect your Shopify account as a data source, select Metabase as your destination, and start building visual dashboards within minutes. You can track orders, customer behavior, and inventory levels using automated updates that run on a configurable schedule, keeping your reports current without manual exports or spreadsheet juggling.

Kondado provides a direct integration between Shopify and Metabase with 17 available pipelines including Orders, Customers, Products, and Abandoned Checkouts, allowing you to replicate 505 data fields on a configurable schedule ranging from every 5 minutes to daily updates.

This connection eliminates the need for complex infrastructure or intermediate databases, letting marketing and operations teams focus on analyzing sales trends and customer insights rather than managing technical processes. With data refreshing automatically based on your chosen schedule, your team always has access to current metrics for making informed inventory and marketing decisions.

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

Combining Shopify data with Metabase visualization capabilities gives marketing and operations teams powerful insights into ecommerce performance. By analyzing the Orders and Orders Line Items pipelines, you can identify your best-selling products and peak sales periods to optimize inventory planning. The Abandoned Checkouts pipeline helps you recover lost revenue by tracking cart abandonment patterns and total values left behind. Meanwhile, Orders Visits UTM Parameters enable you to measure campaign effectiveness and attribute revenue to specific marketing channels, making it easier to allocate your advertising budget wisely.

Try out all the features for free for 14 days

Shopify data available in Metabase

available pipelines

505

extractable fields

Available integrations

Integration	Description
Abandoned Checkouts	View data on abandoned checkouts, including total value, items in the cart, and abandonment date.
Customers	Track customer information, including name, email, status, and account creation date.
Events	Log important events, including event type, date, and details associated with each event.
Inventory: items	Monitor item inventory, including SKU, available quantity, and product location.
Order timeline events	Analyze order timeline events, including status, date, and actions taken during processing.
Orders	Examine order details, including order number, total value, status, and creation date.
Orders Details	Get detailed information about orders, including items, prices, quantities, and applied discounts.
Orders Discount Applications	View how discounts were applied to orders, including discount type and value.
Orders Discount Codes	Access information on discount codes used in orders, including code and discount value.
Orders Fulfillments	Monitor the status of order fulfillments, including fulfillment date and shipping method.
Orders Line Items	Includes information on products, quantities, and prices, along with fields such as SKU, product title, and applied discount.
Orders Note Attributes	Contains custom attributes associated with orders, such as customer notes, tags, and additional fields that assist in identification.
Orders Refunds	Records information about refunds, including amounts, reasons, and status, along with fields such as refund date and method used.
Orders Shipping Lines	Provides details on shipping options, including carrier, shipping cost, and estimated delivery time.
Orders Transactions	Includes data on financial transactions, such as amounts, payment methods, and payment status, along with timestamps.
Orders Visits UTM Parameters	Captures information on order visits, including UTM parameters such as source, medium, and campaign for marketing analysis.
Products	Contains details about products, including title, description, price, SKU, and images, along with information on variants.

Abandoned Checkouts

View data on abandoned checkouts, including total value, items in the cart, and abandonment date.

Customers

Track customer information, including name, email, status, and account creation date.

Events

Log important events, including event type, date, and details associated with each event.

Inventory: items

Monitor item inventory, including SKU, available quantity, and product location.

Order timeline events

Analyze order timeline events, including status, date, and actions taken during processing.

Orders

Examine order details, including order number, total value, status, and creation date.

Orders Details

Get detailed information about orders, including items, prices, quantities, and applied discounts.

Orders Discount Applications

View how discounts were applied to orders, including discount type and value.

Orders Discount Codes

Access information on discount codes used in orders, including code and discount value.

Orders Fulfillments

Monitor the status of order fulfillments, including fulfillment date and shipping method.

Orders Line Items

Includes information on products, quantities, and prices, along with fields such as SKU, product title, and applied discount.

Orders Note Attributes

Contains custom attributes associated with orders, such as customer notes, tags, and additional fields that assist in identification.

Orders Refunds

Records information about refunds, including amounts, reasons, and status, along with fields such as refund date and method used.

Orders Shipping Lines

Provides details on shipping options, including carrier, shipping cost, and estimated delivery time.

Orders Transactions

Includes data on financial transactions, such as amounts, payment methods, and payment status, along with timestamps.

Orders Visits UTM Parameters

Captures information on order visits, including UTM parameters such as source, medium, and campaign for marketing analysis.

Products

Contains details about products, including title, description, price, SKU, and images, along with information on variants.

See all available data →

Try out all the features for free for 14 days

How to create Shopify dashboards in Metabase

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Shopify as data source

Access your Kondado account and add Shopify as a new data source, then authenticate with your store credentials to establish the connection.

Select Metabase destination

Choose Metabase as your destination to begin building dashboards immediately. You can also send the same Shopify data to Google Sheets or BigQuery for additional analysis if needed.

Build dashboards and configure refresh

Use the replicated data to create visual reports in Metabase, then set your preferred update frequency to maintain current metrics without manual intervention.