Shopify Connector

Shopify is a cloud-based, multi-channel commerce platform designed for small and medium-sized businesses.

4.8 on G2
Weld · Data Sources
ShopifyLive
orderSynced
productSynced
customerSynced
locationSyncing
fulfillment_eventQueued
Lands insnowflakebigquerydatabricksAgent context over MCP
How it works

Set up in minutes.
No code, no maintenance.

Shopify

Shopify

Data source

Authenticating...
Ready to connect
Overview

Shopify in your warehouse.
Ready for your agents.

Shopify is a cloud-based, multi-channel commerce platform designed for small and medium-sized businesses. Weld's Shopify connector is fully managed: it extracts data from Shopify, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

AgentsQuery over MCPYour warehouse92 tables, with agent contextWeldExtract, load, keep in syncShopifySource
Agent context

Shopify data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Shopify is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables
92
fields
1,450
relationships
54
Open the schema explorer
Open the full schema explorer
Weld MCP server

Ask your agent.
It already knows Shopify.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Shopify context, finds the tables it needs and queries your warehouse.

  • Agent contextShopify tables, fields and joins
  • QuerySQL against your warehouse
  • OperateCheck, rerun and refresh syncs
Claude CodeOpus 5
>

How many order rows do we have per customer? Use our Shopify data.

Reading the Shopify context first, so the query uses the right tables and keys.

●weld·search_available_references
⎿raw.shopify.order
raw.shopify.customer
+ 90 more Shopify tables
●weld·get_reference_schema
⎿order · 137 columns
joins customer on customer_id
●weld·run_query
⎿select c.id, count(*) from {{raw.shopify.order}} o
join {{raw.shopify.customer}} c on o.customer_id = c.id
group by 1
submitted
●weld·get_query_status
⎿DONE
●weld·get_query_result
⎿rows returned
✓Answered from Shopify data in your warehouse
>Ask about your Shopify data
Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Shopify connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

POST/elt_syncs
▌
FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Talk to us

Put your Shopify data to work.

Connect Shopify, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

ShopifySource
WeldWeld
MCPAgents