Square and WooCommerce Combined Sales Report

If you sell in person on Square and online with WooCommerce, 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. If your store takes payments through the WooCommerce Square plugin, those online orders are also in Square; the report finds them and counts each one once. Your files are read in memory and discarded. Nothing is stored unless you choose to share a copy.

Which files to upload

  • Square: in your Square Dashboard, go to Payments & invoices > Transactions, choose a date range, then Export > Transactions CSV. If your store takes payments through Square, this is the file that lets the report count those orders once. For best sellers across both, export the Items Detail CSV instead.
  • WooCommerce: in WordPress, go to WooCommerce > Analytics > Orders, choose the same date range, and press Download. Exports from the free Order Export & Order Import for WooCommerce (WebToffee) and Advanced Order Export For WooCommerce plugins work too (in Advanced Order Export, choose CSV as the format). The WebToffee export includes each order's payment ID, which matches Square most reliably.

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

Transactions, or Items Detail

Analytics > Orders > Download

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

Two dashboards today, free

Connect Square in one click for your in-person sales, updated every night. Connect WooCommerce the same way: no approval wait, read-only access you grant in WooCommerce itself. Each gets its own free dashboard; a single combined dashboard isn't available yet, so this report is the way to see both together for now.

Connect Square in one click

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

Connect WooCommerce

Frequently asked questions

Why would an online order be in my Square file?

If your WooCommerce store takes card payments through the WooCommerce Square plugin, each of those orders is also a payment in Square. Added together, they'd be counted twice. The report finds them and counts each once, as an online sale.

How are orders paid with Square matched?

By payment ID when your WooCommerce export has it (the WebToffee export does). Otherwise, with the Square Transactions file, an order paid with Square matches a Square payment of the same amount to the cent within 15 minutes, but only when no other payment or order fits. Anything less certain is listed as a possible duplicate for you to check, and left in both totals.

Why don't my totals match Square's and WooCommerce's own reports?

This report counts sales before tax, tips and shipping, after discounts and refunds, so both channels are measured the same way, and online orders paid with Square are counted once. Square's and WooCommerce'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 "Coffee Mug, Large" and "Coffee Mug / 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.