Ingest Your Ecommerce Data

What you'll do

Create ingestor assets for your Shopify store and the tools around it. Each asset pulls data from a SaaS tool into your warehouse on schedule.

Why this step matters

A Shopify store has data spread across many tools: orders and products in Shopify, payments in Stripe or Shopify Payments, email engagement in your marketing platform, ad performance in your ad platform, and website traffic in your analytics tool. Getting all of this into one warehouse is the foundation for every report you'll build later.

Bruin's ingestor assets use ingestr under the hood - an open-source tool with 100+ built-in connectors. You define what to pull in a simple YAML file, and Bruin handles scheduling, incremental loading, and dependency management.

Let Claude Code create the asset files

You can create each ingestor asset file manually (shown below), or ask Claude Code to do it for you:

Look at the Bruin ingestr docs and create ingestor assets for Shopify orders, customers, products, and inventory_levels. Use merge strategy with updated_at for the first three, and replace for inventory. Use my warehouse connection as destination. Put them in ecommerce/assets/.

Below we show the files so you can see what they look like, but feel free to have Claude Code generate them.