Multi-Store Reporting on Shopify Plus: What Works and What Doesn't (2026)

You've built a successful D2C brand on Shopify. Now you're expanding: a dedicated store for your US market, another for Europe, maybe a third for wholesale or B2B. It makes sense architecturally. But suddenly your analytics are scattered across three separate dashboards, your revenue numbers are in three different currencies, and your leadership team is asking: "What's our total revenue?"

Shopify Plus promises to solve this with Organization Analytics. And in 2026, with the Winter update, it's genuinely better than it was. But it still doesn't do what most multi-store operators think it does.

Below: what Organization Analytics actually offers, the real limitations, and practical solutions that work without hiring a data engineer.

Shopify Plus Organization Analytics is a dashboard that sits above your individual stores. Here's what it offers as of 2026:

• High-level KPI cards: total sales and orders across all stores
• Store dimension in custom reports (filter/group by store)
• ShopifyQL cross-store queries (added Winter 2026)
• Heatmap visualizations for store-to-store comparison
• Minute-level monitoring during launches and flash sales

The KPI cards are the headline feature. You see your total revenue, total orders, average order value, and conversion rate across all stores in one view. During a Black Friday campaign, you can watch minute-by-minute updates across your entire organization. That's genuinely useful.

The store dimension in custom reports is the workhorse. You can build a report showing sales by store, or orders by store and date, or any metric sliced by the store dimension. It's the foundation for legitimate cross-store analysis.

But here's where expectations meet reality.

Shopify Plus uses completely independent stores. Each has its own database, customers, inventory, and analytics. Organization Analytics adds a reporting layer on top, but the underlying data is still siloed. A customer who buys from Store A and Store B is two different customers in Shopify's eyes. This matters for customer health reporting: you can't see repeat customers across stores, can't calculate true lifetime value, and can't segment based on cross-store purchase behavior.

The practical problem: your leadership team asks "How many customers purchased from multiple stores?" and the honest answer is "I don't know without custom integration work." Organization Analytics won't help here.

If your US store reports in USD and your EU store in EUR, Organization Analytics shows raw numbers in each store's base currency. There's no automatic conversion. Aggregating into one "total revenue" number requires manual normalization - you either pick one currency and do the math yourself, or you use a third-party tool.

This is worse than it sounds because currency conversion rates change daily. Your spreadsheet from Monday is stale by Tuesday. You need either a tool that refreshes rates daily, or you need to manually update conversion rates constantly.

You want to answer: "Store A is growing 15% YoY while Store B declined 8%. Why?" Organization Analytics doesn't surface this in a single view. You need to query each store separately, export the data, and compare manually. If you want to do this weekly, that's tedious.

If you fulfill from the same warehouse across stores - or if you use unified inventory locations - Organization Analytics doesn't help you see total stock across all stores. "How much total stock do we have of SKU X?" requires jumping between store-level inventory pages or running manual counts.

A standard single-store custom report in Shopify is straightforward: select metrics, add dimensions, set filters. Multi-store reporting requires accounting for the store dimension on every report. Every single custom report needs to either show store as a dimension, or explicitly filter to a specific store. Standard single-store reports don't automatically aggregate. Expect to spend 3-4x longer building cross-store reporting compared to single-store.

So you need multi-store reporting that actually works. Here are three approaches, depending on your budget and technical tolerance.

Use ShopifyQL cross-store queries (the Winter 2026 feature) to pull the data you can get natively - sales, orders, and conversion metrics by store. Export to Google Sheets. Use built-in AVERAGE or LOOKUP functions for currency conversion. Compare trends manually.

Connect all stores to a single analytics platform. These platforms handle aggregation, currency conversion, and cross-store comparison automatically. You get a single dashboard, ask questions once, and get answers across all stores.

The advantage of this tier: you pay a fixed cost, get professional currency handling, and don't maintain anything. A marketer or operator can use it without engineering help. The disadvantage: you're limited by what the platform offers. If you need custom analysis that no platform provides, you're stuck.

Shopify → Fivetran/Airbyte → BigQuery/Snowflake → Looker Studio/Tableau. You own the data. You have complete control over data modeling, unlimited historical data, and unlimited custom analysis. You can build anything.

The cost is not just money - it's engineering time. You need a data engineer or a technical founder to set it up and maintain it. Queries break, schemas change, new stores need to be added to the pipeline. This is an ongoing operational cost.

When you need this: you're over $20M in revenue and need analysis specific to your business that no platform provides. Or you're running complex financial models that need custom data structures.

1. Go to Organization Analytics in the Shopify admin
2. Open the ShopifyQL editor (usually under "Reports" or "Custom Reports")
3. Query sales data across stores using something like: SELECT store_name, SUM(total_sales) FROM orders GROUP BY store_name
4. Export results to Google Sheets weekly
5. Create a summary tab with conversion rates and YoY comparisons
6. Update currency conversion rates at the top of the sheet every Monday

1. Sign up with the platform (most have 7-day free trials)
2. Authenticate your Shopify stores (all of them)
3. Wait for initial data sync (usually 4-24 hours for first sync)
4. Browse the pre-built dashboards - they'll show your stores side-by-side already
5. Spend an afternoon customizing dashboards for your KPIs
6. Set up a weekly reporting schedule if the platform offers it

1. Provision a BigQuery or Snowflake account
2. Set up Fivetran or Airbyte to sync Shopify data nightly
3. Configure each store as a separate source (each store has its own Shopify connection)
4. Plan your data model - how do you want to represent multi-store data?
5. Build transformation queries to normalize currencies and combine stores
6. Connect Looker Studio or Tableau to your warehouse
7. Assign a data engineer to own this setup indefinitely

Regardless of which approach you choose, these tips will save you headaches:

• Name your stores consistently. If one is "US Store" and another is "United States", your aggregations will break. Use a naming convention (store_us, store_eu, store_apac) and stick to it across all systems.
• Fix currency conversion once. Don't convert in multiple places. Pick one tool or dashboard as the source of truth for conversion rates, then use those rates everywhere.
• Separate reporting by geography when possible. Instead of one "global revenue" dashboard, build US, EU, and APAC versions. This makes performance comparison clearer and matches how your teams think about the business.
• Create a data dictionary. As you build multi-store reports, document which metrics include all stores vs. which are filtered. "Total revenue" should mean the same thing in every report.
• Schedule a monthly audit. Pick one week each month to verify that your multi-store numbers are accurate. Run a quick sanity check: does total revenue in your dashboard match total revenue in each store's native dashboard? If not, you have a data issue.

Still have questions? Here are the ones we hear most often.