Shopify integration

Shopify in Polar: the one-click foundation of your P&L.

Orders, products, customers, refunds, discounts and inventory from Shopify, pulled into Polar with one authorization and turned into a governed P&L. It is the base every other source blends onto: connect Shopify first, then ad spend, email and marketplaces stack on top for blended ROAS, MER and true CAC.

/ ⏎
Connect Shopify See the setup
Google Sheets → Polar

Your whole store, turned into governed metrics.

Orders, products, customers, refunds, discounts and inventory from Shopify, mapped to hundreds of pre-built ecommerce metrics by Polar's semantic layer. No warehouse, no SQL, one row per order, refreshed every 15 minutes.
Orders & Revenue
“What did the store actually sell?”
Gross Sales, Net Sales, Total Sales, Total Orders and AOV, broken down by product, variant, collection and country on every sync.
net sales by product / collection
Products & Inventory
“What is moving, and what is about to run out?”
Per-product and per-variant sales next to Current Inventory Quantity and Cost of Products, so demand and stock sit in the same view.
units sold vs inventory on hand
Customers
“How much revenue is new versus repeat?”
New Sales vs Repeat Sales, Purchase Frequency, Customer Lifespan and Days Since First Order, the raw material for cohorts and LTV.
new vs repeat revenue
Refunds & Discounts
“What is coming back or being given away?”
Returned Orders, Returned Product Quantity, Total Refunds and Discounts per product, so returns and promo leakage land in your margin.
refund & discount rate by SKU
Margin & Costs
“What do I actually keep after costs?”
Cost of Products, Shipping Costs and Tax roll up into Gross Profit, Net Profit and Gross Margin, a real P&L instead of top-line revenue.
net profit & gross margin
Blended Foundation
“What does everything else blend onto?”
Shopify is the base layer. Add Meta, Google, Klaviyo or Amazon and they stitch to these orders for blended ROAS, MER and true CAC.
the base for every connector
Setup Guide

Connect Shopify in one click.

A Polar account and admin access to the Shopify store you want to link. One authorization, and Polar backfills your full order history automatically. No pipeline, no warehouse, no data team.
01 · What you need

A Polar account

Start free. Shopify is usually the first connector you add, and everything else blends onto it.

Connect your data →

Admin on your Shopify store

You need admin (or staff with app permissions) on the store you want to connect. No admin access? Ask an existing store admin to complete the authorization.

Shopify Admin →

One authorization

A single approval to install Polar on your store. No CSV exports, no data pipeline, no warehouse to stand up first.

02 · Connect it, the easy way
1

Add Shopify from Connectors ~1 min

Sales Channels section, or search for it.
In Polar, open Connectors and in the Sales Channels section find Shopify (or use the search bar). Click Connect to Polar Analytics and enter your .myshopify.com store URL.
Open Polar connectors
2

Authorize the install on Shopify ~1 min

Approve Polar, and the backfill starts.
1
You are redirected to Shopify. Review the requested permissions and approve the Polar install for that store.
2
Back in Polar, Shopify shows as connected and the historical backfill kicks off. Running multiple stores? Add each one and Polar unifies them.
Heads up: Polar pulls your full order history on first connect. The initial sync typically finishes within 24 hours (large stores can take 2 to 3 days), then it refreshes every 15 minutes.
3

See it in your reports the payoff

A governed P&L, ready to build on.
Shopify powers your Net Sales, Gross Margin, Net Profit and customer metrics across dashboards and every Ask Polar answer. Connect ads, email or a marketplace next and they blend straight onto this foundation.
Get started

Connect Shopify once, build everything on it.

One authorization turns your store into a governed P&L. Every dashboard, report and AI answer reads it, and every other connector blends on top.

Book a demoConnect your data ↗
The Gap

Your store in. A governed P&L out.

Shopify pours orders, products, customers, refunds, discounts and inventory into Polar. Polar's semantic layer maps it to hundreds of pre-built metrics, so you get Net Sales, Gross Margin and customer cohorts without a warehouse, and every other source stitches onto these orders.

Shopify

orders, products, customers, refunds
Polar

Polar

Featured Use Case

The store P&L that every other source blends onto.

Every morning, a rule or an agent turns yesterday's Shopify orders into a real P&L, gross sales down through discounts, refunds and COGS to net profit and margin, before anyone opens Shopify Admin. Add ad spend later and it drops straight into the same view.
Daily store P&L● 7:00am, every day
Line
Yesterday
Gross Sales
$42,180
Discounts + Refunds
-$6,240
COGS + Shipping
-$18,900
Net Profit
$17,040 · 40%
Built by an AI agent every morning, straight from your Shopify orders.

Scheduled automation

No AI needed

Use Polar Automations to run a rule every morning: roll yesterday's Shopify orders from Gross Sales down to Net Profit and Gross Margin, and send the P&L to Slack or email.

AI agent

Dynamic

Give an agent the Polar MCP. Ask it to build yesterday's store P&L, call out the biggest driver of any margin change, and flag the products or discounts behind it.

Dig deeper into this use case
Other Use Cases

More Polar + Shopify use cases

What teams run once Shopify is the governed foundation of Polar.
Use case 01

Daily store P&L

Yesterday's Gross Sales through discounts, refunds and COGS to Net Profit and margin, in your inbox before standup.

See the use case ›Use case 02

New vs repeat revenue

How much of the business is new customers versus repeat, and how that mix is trending.

See the use case ›Use case 03

True margin by product

Net margin per product and variant after COGS, shipping, discounts and refunds, not just gross revenue.

See the use case ›Use case 04

Inventory days of cover

Current Inventory Quantity against recent sell-through, so you reorder before the winners stock out.

See the use case ›Use case 05

Discount and refund leakage

Where promos and returns quietly eat margin, ranked by the products and codes driving it.

See the use case ›Use case 06

The blended foundation

Layer Meta, Google, Klaviyo and Amazon onto Shopify orders for blended ROAS, MER and true CAC.

See the use case ›
Your Prompt Library

15 prompts a connected Shopify store unlocks.

Net profit, gross margin, new vs repeat, inventory cover, discount leakage. Once Shopify is the foundation in Polar, ask in plain language.
Type
Audience
15 of 15
Get started · connect once · stays in sync

Connect Shopify once. Build your entire P&L on it.

Shopify holds your orders, products, customers, refunds and inventory, but on its own it stops at store-level reports. Connect it to Polar and one authorization turns it into a governed P&L, with Net Sales, Gross Margin and customer cohorts ready to go, and every ad, email and marketplace source blends straight on top.

Get started by booking a demoConnect your data in Polar
Phase 1 ~2 minConnect Shopify in PolarOne authorization on your store. Polar backfills your full order history and maps it to governed metrics.
Phase 2 ~5 minAdd the rest of your stackConnect Meta, Google, Klaviyo or a marketplace. Each one blends onto your Shopify orders automatically.
Phase 3 the payoffUse it everywhereShopify powers blended ROAS, MER, true CAC and your P&L across dashboards, reports and AI answers, always in sync.