How to combine Amazon and Shopify revenue

Multi-channel revenue reporting — data differences, reconciliation, and SQL

Definition

What it is

Multi-channel revenue reporting is the practice of combining sales data from Amazon Seller Central and Shopify (and other channels) into a single unified view. For sellers active on both platforms, this is the only way to see true total business revenue, channel mix, and cross-channel trends. The challenge is that Amazon and Shopify structure their order data differently — different date fields, fee handling, currency representation, and order statuses require normalisation before they can be compared.

Formula

Combined Revenue Formula

Formula

Total Revenue = Amazon Revenue (net of returns) + Shopify Revenue (net of refunds)

Use a UNION ALL in SQL to combine both sources with a consistent channel label. Ensure date fields are normalised to the same timezone and format. Exclude cancelled Amazon orders and voided Shopify orders. FBA fees are not deducted from Amazon revenue in a combined view — keep it at gross revenue for comparability.

Business impact

Why it matters

Sellers managing both Amazon and Shopify without a unified revenue view are making decisions from incomplete data. Channel mix shifts — Amazon revenue growing while Shopify stagnates, or vice versa — are invisible when each platform is analysed in isolation. Combined reporting also reveals which channel is more efficient on a contribution margin basis once fulfilment costs are factored in.

The challenge

How most teams track this today

There is no native tool in either Seller Central or Shopify that provides a combined view. Most multi-channel sellers maintain two separate spreadsheets and manually consolidate them into a summary monthly. This process typically takes 30–60 minutes per reporting cycle and is prone to copy-paste errors.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Amazon Seller Central account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Amazon and Shopify combined revenue →Connect Amazon Seller Central →Try Free — $29.99/mo

FAQ

Common questions

What are the main differences between Amazon and Shopify order data?

Amazon orders have marketplace-specific fields (ASIN, fulfilment channel, FBA fees) and are reported in settlement periods. Shopify orders use financial status fields (paid, refunded, partially_refunded) and are recorded in real time. Amazon cancellations are separate events; Shopify uses order status. Both need normalisation before joining.

Should I compare Amazon gross revenue or net revenue to Shopify?

For a fair channel comparison, use gross revenue (before fees) from both platforms. If you want true profitability comparison, subtract FBA fees from Amazon and Shopify payment processing fees from Shopify. Mixing gross Amazon revenue with net Shopify revenue (or vice versa) produces misleading channel mix percentages.

Does Taptic automatically normalise Amazon and Shopify data for combined queries?

Yes. Taptic imports both Amazon and Shopify tables with consistent date formats, currency handling, and status normalisation. The combined revenue SQL query uses a UNION ALL across both order tables and adds a channel column so you can group, filter, and compare by platform.

Can I add QuickBooks data to the combined revenue view?

Yes. Taptic imports QuickBooks Online invoice data alongside Amazon and Shopify. You can write queries that join all three sources — useful for reconciling eCommerce revenue against QBO recognised revenue, particularly for businesses that invoice clients separately from marketplace sales.

Analytics hub

All Amazon queries, use cases, and SQL examples in one place.

Amazon Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Amazon Seller Central to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo