How to Combine Shopify Reports Into One Profit View

If you run an operating store, you already know the problem. The Sales report says one thing, the Inventory report says another, your Meta dashboard says a third, and your supplier invoice lives in a tab you forgot to open. You stitch them together in your head on the drive home, and the number you land on is a guess.

This guide shows you how to combine Shopify reports into one view that tells the truth — not just blended revenue, but the profit left after every variable cost. We cover the three real methods, a worked per-order example, and the multi-store case.

Why Shopify keeps your reports apart

Shopify stores sales, inventory, and finance data in separate models, so the native reports never share a single row. The Sales report is built on orders. The Inventory report is built on stock movements. The Finances report is built on payouts and fees. They are three different questions, and Shopify answers each one in its own silo.

That is a reasonable engineering choice and a terrible operating one. You don't think in silos — you think in orders. For one order, you want to see the revenue, the garment and print cost, the shipping, the processing fee, and the slice of ad spend that brought the buyer in, all on one line.

The gap gets worse the moment ad spend enters. Shopify has no idea what you paid Meta or Google, because that money never touches the store. So even a perfectly combined Shopify-only report is missing the single largest variable cost most operators carry.

For the wider picture of how these data sets fit together, our guide to ecommerce business intelligence maps the full stack. This article stays focused on the merge itself.

The three ways to combine Shopify reports

There are exactly three places the merge can happen: inside Shopify, inside a spreadsheet, or inside a dedicated layer that reads everything at once. Each trades effort for accuracy.

1. Native custom reports — edit and save the columns

Shopify lets you edit a default report, add or remove columns, apply filters, and save the result. On the Advanced Shopify and Shopify Plus plans you can modify default reports and create custom reports that persist, according to Shopify's custom reports documentation. On lower plans you can filter and edit a report in the moment, but you cannot save the customization.

This is the fastest path and the most limited one. You can combine, say, net sales with discounts and returns in one view. You cannot pull in your Printify or Printful item cost, your real shipping charge, or a dollar of ad spend — none of that lives in Shopify.

Use native custom reports when the question is purely Shopify-internal: which SKUs sold, at what discount, with what return rate. The moment profit enters, you have outgrown the reports tab.

2. Spreadsheet or Google Sheets consolidation

The classic workaround is to export each report to CSV, drop them into tabs, and reconcile on a key like order ID or SKU. A VLOOKUP or XLOOKUP ties the Sales export to a cost table you maintain by hand, and a separate paste of your Meta and Google spend gets allocated across orders.

This works, and for a store doing a few hundred orders a month it is honest enough. The cost is time and decay. Every export is a snapshot, so the sheet is stale the day after you build it, and one renamed column breaks the lookup silently.

The deeper trap is denominator drift — your COGS tab counts the supplier print fee one way, your sheet nets shipping another way, and two months later the margins no longer compare. If you go the spreadsheet route, write down your cost definitions once and freeze them.

3. A reporting app or data layer

Third-party tools read Shopify, your suppliers, and your ad platforms through their APIs and keep the combined view live. Metorik, for example, markets a profit report that tracks product COGS, shipping, and transaction costs and updates with every order, per its analytics page. Report Pundit positions itself around merging fields Shopify keeps apart, such as inventory cost alongside net sales and refunds, per its own write-up.

These remove the manual export step, which is most of the pain. What most of them still leave to you is the interpretation: they combine the reports, hand you a dashboard, and let you decide what the numbers mean and what to do next. For the landscape of what these tools actually measure, see our breakdown of the types of ecommerce analytics.

The report Shopify never builds: true per-order profit

Here is the combined report that actually runs an operating store, worked end to end. Say you run a print-on-demand store doing 600 orders a month at a $34 average order value — $20,400 in monthly revenue, with $3,000 in Meta and $1,200 in Google Ads.

Start with one average order and strip it down:

The arithmetic is plain: $34 − $20 in non-ad variable costs = $14 of contribution, and $14 − $7 of allocated ad spend = $7 of true contribution per order. Across 600 orders that is $4,200 a month, and after, say, $900 in apps and software you clear roughly $3,300.

Now look at what each native report told you in isolation. The Sales report showed $20,400 and felt like a good month. The Finances report showed the fees. The Inventory report showed units moving. Not one of them showed the $7 — and the $7 is the only number that decides whether you scale the campaign or kill it.

That is the whole case for combining Shopify reports. A combined revenue view is a vanity metric; a combined profit view is an operating instrument. If you want to see how this feeds campaign decisions, our piece on ecommerce performance analytics walks the per-channel read.

Combining reports across multiple Shopify stores

If you run more than one store, the merge problem multiplies. Each store has its own Sales, Inventory, and Finances reports, and Shopify gives you no native way to roll them into one line.

The spreadsheet answer is a master tab that unions every store's export with a store-name column, then pivots on it. The tooling answer is a multistore dashboard — several apps show combined revenue, profit, and stock velocity across stores with a drill-down into each one.

Whichever you pick, standardize the cost definitions across stores first. If store A books the print fee in COGS and store B books it in fulfillment, your "combined" margin is comparing two different things. The merge is only as trustworthy as the shared definitions underneath it.

How Victor combines the reports for you

PodVector AI's Victor is an AI employee that connects your Shopify store, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, and computes true per-order profit across all of them. Victor is not a dashboard you have to read — he does the merge and the interpretation, then delivers the finished report to your Google Drive.

Because Victor reads the ad platforms and the POD suppliers directly, the $7-per-order number from the example above is something he calculates for every order, not something you rebuild in a sheet each week. You can ask him for the combined view in plain language instead of maintaining a lookup.

Every write action Victor takes is approval-gated — he drafts, you approve before anything executes, including customer-support email. Put Victor on your store and let the combined profit report build itself.

For the native side of this — squeezing more out of Shopify's own report builder before you outgrow it — see our guide to advanced Shopify reports and the specifics of Shopify delivery reports.

FAQs

Can you combine sales and inventory in one Shopify report?

Not natively. Shopify stores sales on an orders model and inventory on a stock-movement model, so no single native report joins them on one row. You combine them with a saved custom report that pulls the fields you need (on Advanced or Plus), with a spreadsheet keyed on SKU, or with a reporting app that reads both at once.

Do I need Shopify Advanced or Plus to combine reports?

To save a custom combined report inside Shopify, yes — modifying default reports and creating saved custom reports is an Advanced and Plus feature, per Shopify's documentation. On lower plans you can still filter and edit in the moment, and you can combine anything across any plan in a spreadsheet or a third-party tool, since those read the data through the API.

How do I include ad spend in a combined Shopify report?

You can't do it inside Shopify, because ad spend never touches the store. Export your Meta and Google spend and allocate it across orders in a spreadsheet, or use a tool that reads the ad platforms directly and nets the spend against revenue for you. Ad spend is usually the largest variable cost, so a combined report without it overstates profit badly.

What is the best way to combine reports from multiple Shopify stores?

For a handful of stores, a master spreadsheet that unions each store's export with a store-name column works. Past that, a multistore reporting tool that shows combined revenue and profit with per-store drill-down saves the manual merge. Either way, freeze one shared cost definition across all stores so the margins actually compare.

Why does my combined revenue look healthy but my bank account doesn't?

Because revenue is not profit, and most combined reports stop at revenue. In the worked example above, $20,400 in monthly sales left about $7 per order after product, shipping, fees, and ad spend — roughly $3,300 after software. A combined report is only useful if it carries every variable cost down to contribution, not just the top line.