Square and Shopify Combined Sales Report

If you sell in person on Square and online on Shopify, each one only shows you half the picture. Upload an export from each and see your combined sales on one page: how much comes from each channel, by day and week, and your best sellers across both. Your files are read in memory and discarded. Nothing is stored unless you choose to share a copy.

Selling online with WooCommerce instead? Use the Square and WooCommerce combined report.

Which files to upload

  • Square: in your Square Dashboard, go to Payments & invoices > Transactions, choose a date range, then Export > Items Detail CSV (for products). The Transactions CSV works too, for totals only.
  • Shopify: in your Shopify admin, go to Orders, then Export, choose the same date range, and pick CSV for Excel, Numbers, or other spreadsheet programs.

Use the same date range for both. The report covers only the days both files have.

Items Detail, or Transactions

Orders, then Export

CSV files only, up to 10 MB each. Customer names, emails, phone numbers and addresses are never read.

Want your Square sales updated every night?

Connect Square in one click for a free dashboard of your in-person sales.

Connect Square in one click

Free plan, no signup form. By connecting you agree to our Terms and Privacy Policy.

Flumen for Shopify is coming to the Shopify App Store. Join the waitlist to hear when it's live.

Frequently asked questions

Why don't my Square and Shopify totals match their own reports?

This report counts sales before tax, tips and shipping, after discounts and refunds, so both channels are measured the same way. Square's and Shopify's own reports each include different things.

How are products matched?

By SKU first, then by an identical name once case and punctuation are ignored, so "Latte (Large)" and "Latte - Large" match. Anything that doesn't match exactly is listed separately, never merged on a guess.

Is my data stored?

Nothing is stored unless you choose to share a copy. Your files are read in memory and discarded when the results page is built, and nothing from them is logged. A shared copy has customer, contact, address, employee and card details removed and is deleted after 90 days.