Shopify is the commerce system of record — orders, customers, and products. Connecting it as a data source through the Connectors library syncs those tables into your Alta workspace, where they become training data for Alta and a foundation for your metrics, dashboards, and Luna analysis. Once it's flowing, you can measure sales, AOV, and repeat purchase behavior — and ask Luna questions in plain English. Shopify connects with credentials.

Who this is for: Commerce, finance, and ops teams who want Shopify order and customer data measured across Alta.

Before you start

Have your Shopify store/shop name (the myshopify subdomain) and an access token from a custom/private app with read access to orders, customers, and products.
Connect a source only once per workspace. If Shopify already shows Connected, edit the existing connection.

Connect Shopify

Open Connectors from the sidebar.
Find Shopify via the ERP or Billing tab, or the Search data sources box.
Click the Shopify card to open the Create connector screen.
Fill in the connection fields shown (such as your shop name and access token), then click Create.
Alta runs a connect test. If it fails you'll see The connect test has failed with Shopify's error — fix the field and retry.
The card then shows Connected and Data is syncing until the first sync finishes.

Choose which tables sync

Open the connection. Shopify brings in tables like orders, customers, and products.
Use the Synced toggle in the Shopify tables section to control what's pulled in.
Turn off Show only synced tables to see everything available (line items, transactions, refunds, and more).

Key tables and fields synced

orders — id, total_price, subtotal_price, created_at, financial_status, fulfillment_status, customer_id
customers — id, email, orders_count, total_spent, created_at
products — id, title, vendor, product_type
order line items (when synced) — per-product detail: product_id, quantity, price

What you can ask this data

Once it's syncing, build it into metrics and dashboards or just ask Luna / Ask AI. For example:

"What's total sales and order count last month?" — sums orders.total_price and counts orders by created_at.
"Who are our top customers by spend?" — ranks customers.total_spent.
"What's average order value over time?" — averages orders.total_price by month.
"Which products sell the most?" — groups order line items by product_id.
"What's our repeat-purchase rate?" — uses customers.orders_count.

Example use cases

Sales dashboard. Revenue, orders, and AOV trended over time and by product.
Customer value. Top customers, repeat rate, and lifetime spend from the customers table.
Product performance. Best and worst sellers by units and revenue.
Commerce + CRM/marketing. Join Shopify orders to marketing or CRM data to connect spend to revenue.

Keep it in sync

Sync status shows Last sync (Succeeded/Failed) and the Sync frequency.
Click Sync now to refresh immediately; it's disabled while a sync runs.
Use the overflow menu (⋯) to Disable, Enable, or Delete.

Tips and common pitfalls

Get the shop name right. Use your store's myshopify subdomain, not the public storefront domain.
Check token scopes. The access token needs read scopes for orders, customers, and products.
Sync line items for product analysis. Order totals alone won't break down revenue by product.
Deleting is permanent. Disable instead to pause.