Managing Multiple Shopify Stores? Get One Profit Report Across Every Store (Free AI Prompt)

Very few brands stay as one store for long. You open a US store so American customers see dollar prices and fast shipping. You add an EU store for VAT and euros. Amazon becomes a real channel, TikTok Shop starts selling, and wholesale gets its own instance so trade orders don't muddy your DTC numbers. Each move makes sense on its own. Together they leave you with four or five separate views of one business, and nobody who can say, quickly and with confidence, what the whole thing made last month.

That's the question our clients kept asking us. One of them put it simply: had we set up the aggregated view for his two stores yet? So we built it. The Multi-store report is a free prompt in the StoreHero AI Skills Library. You paste it into Claude or ChatGPT, name your stores, and get one combined profit report across all of them, plus a store-by-store breakdown that shows what's working and what isn't. Setup takes about five minutes.

Why growing brands end up managing multiple stores

When we looked across the brands connected to StoreHero, about 80 of them run two or more instances. They fall into a few patterns:

• Regional expansion stores. One Shopify store each for the UK, US, EU and Australia, with their own currency, pricing and ad accounts. Some brands run five or six.
• Shopify plus a marketplace. Your own site and Amazon, each set up as a separate store so you can see the marketplace on its own terms.
• Shopify plus TikTok Shop. Social commerce with its own orders, fees and creator costs.
• One Shopify store, split by order type. Online orders, draft orders, retail (POS) and wholesale kept in separate instances, so a big trade order doesn't make your DTC month look better than it was.

Splitting stores is the right call for running the business. It just makes reporting on the business much harder.

Why adding up the dashboards gives you the wrong number

The obvious fix is a spreadsheet: export each store, paste the totals side by side, add them up. It's slow, and it's wrong in four ways that are easy to miss.

1. You can't average ratios

If one store runs at a MER of 2.46 and another at 1.94, the business isn't at 2.20. The bigger store pulls the true figure towards its own, so you have to add up sales and marketing first, then divide. In one of our test runs the average said 2.20 and the real combined MER was 2.12. Margins, CAC and AOV work the same way.

2. Currencies don't add up on their own

Pounds, dollars and euros in one column is meaningless until they're converted, and each period needs its own rate. Convert last year at this year's rate and an 8% currency swing shows up as “growth”. The prompt uses the average rate for each period (for example from the ECB's reference rates) and splits real growth from exchange-rate effect.

3. Two stores can be reading the same orders

This one surprised us. Testing on a real brand, a marketplace instance turned out to be connected to the same Shopify store as the main site, so it reported identical sales. Adding the two together would have turned a monthly loss into a healthy-looking profit. The prompt compares every store's figures before it adds anything and stops to ask if two look like copies.

4. Ad accounts and platforms blur the lines

One Google account running campaigns for two regions makes one store look like it spends nothing and the other look expensive. And Meta and Google each claim credit for the same sale, so their revenue figures rarely match what actually came in. The report flags shared accounts and shows platform-claimed revenue next to your actual net sales.

How to set it up, step by step

Each store needs to be connected to StoreHero already. From there it's four steps, and you only do the first one once.

Step 1: Connect StoreHero to Claude or ChatGPT

Add the StoreHero connector (MCP) to your AI tool. It gives Claude or ChatGPT read access to every store you can see in StoreHero, so one connection covers all of them. Follow the setup guide if you haven't done it before.

Step 2: Get the Multi-store report prompt

Open the Multi-store report in the AI Skills Library, click Get the prompt, enter your email to unlock the library (it's free) and copy it. There's nothing to fill in before you paste it.

Step 3: Paste it into a new chat and answer three questions

Before it touches any data, the AI asks which stores to include, which currency to report in and what period to cover. Type your store names exactly as they appear in StoreHero, for example “Example Store US” and “Example Store EU”. If you skip the period, it uses last full month and automatically compares it with the previous period, the same period last year and any targets you've set in StoreHero.

Step 4: Check the stores it matched

It finds each store, shows you its currency, sales channel and connected ad accounts, then runs its data checks. If a name matches more than one store, or two stores look like they're reading the same orders, it stops and asks. Everything else goes into the report's data notes. A full run takes a few minutes while it pulls each store one at a time.

What the report looks like

Here's a full run for Harbour & Pine, a made-up outdoor clothing brand with three regional Shopify stores and an Amazon store. The figures are illustrative, but the structure is exactly what you get back.

One scorecard for the whole business

It opens with one line on how the business did in profit terms, then the combined numbers against last month, last year and target. Harbour & Pine did £372.1k of net sales, up 14.7% on last year, with £110.9k of contribution margin, up 11.6%. Both came in just short of target, sales at 97% and contribution margin at 92%, because marketing grew 27% while sales grew 15%. MER slipped from 4.12 to 3.72.

Which store makes the money, and which one costs it

This is the view you can't get from any single dashboard. The UK store is half the sales and two-thirds of the profit at a 40% contribution margin. The US is growing 36% and on target. The EU store is the problem: sales down 12% on last year and just £3.8k left after marketing, a 7% margin. On a combined total that looks healthy, that's easy to miss.

Ads by region and channel

Every store and channel gets a row: spend, share of total spend, platform ROAS, CPA and the change on last year. The weak spot jumps out straight away. EU Meta spent £14.8k at a platform ROAS of 1.60, and its spend went up 17% while EU sales fell. Underneath, it compares what the platforms claim with what actually came in.

The full report also charts the month week by week, picks out the three biggest swings and ties each one to the store, the channel and the ad change behind it, using each ad account's change history.

What happened this time last year, and what's coming up

Then it looks forward. It pulls the same 28 days from last year: the spike days and why they happened, the best products, the discount codes that worked or gave away margin, and the named campaigns that worked or bombed. It works out where your customers actually are from your orders and searches for dated events, holidays and weather in those regions over the next four weeks, each with a source and a suggested action.

Five actions, each with a store, a channel and a number

It ends with five actions: three from this month's results and two for the weeks ahead. Each names the store, the channel and the number behind it, so it's clear who does what.

Then run any other prompt across all your stores

Once the report is done, the chat remembers your stores. Paste any other prompt from the library into the same chat, such as Daily inventory actions, the discount code analysis or a Meta audit, and it runs across every store and comes back as one answer. Totals are added, ratios are recalculated, and lists get a store column. Customer analysis stays side by side, because customers can't be matched across stores. Inventory risk is judged store by store, because stock in your UK warehouse doesn't fix a stockout in the US.

Get it running today

If your stores are already connected to StoreHero, the Multi-store report is free in the AI Skills Library: copy it, paste it, name your stores, and you'll have one view of the whole business in a few minutes. If you're not on StoreHero yet, book a call and we'll connect your stores and run it with you, live, in the first session. And if you're still working out what to measure, start with our guide to ecommerce profitability tracking.

Key takeaways

• Most growing brands end up with several stores: regional Shopify expansion stores, Amazon, TikTok Shop, wholesale or retail kept separate.
• Adding up dashboards gives the wrong answer: ratios like MER and margin must be recalculated from combined totals, never averaged.
• The free Multi-store report prompt rolls every StoreHero store into one report, in one currency, vs last period, last year and target.
• It shows ads by region and channel, the biggest weekly swings, last year's next 28 days and what's coming up in your customers' regions.
• It checks the data before adding anything up: duplicate stores, shared ad accounts, missing channels and cost settings.
• After the report, paste any other prompt from the library into the same chat and it runs across all your stores too.

Frequently asked questions