Tag the Shopify Order When a Square Sale Is Refunded

6 min setup
No coding required
Runs automatically

If you copy Square sales into Shopify for one set of reports, a refund at the counter never reaches the Shopify copy, so your Shopify revenue keeps counting money you gave back. This workflow watches Square for new refunds, finds the matching Shopify order by its Square order ID tag, adds a refund note, and tags it so you can filter refunded counter sales out of your reports.

Square logo icon
When a sale is refunded in Square
Shopify logo icon
Find the matching order in Shopify
Shopify logo icon
Note the Square refund on the Shopify order
Shopify logo icon
Tag the Shopify order square-refunded

How it works

6 steps to flag Square refunds on the matching Shopify order automatically

Square logo icon

When a sale is refunded in Square

App connector: Square • Time to complete: 1 minute

Run whenever a refund is created in Square. The refund carries the order_id of the original Square order, its amount_money in the smallest currency unit, and its status.

Skip refunds that were rejected or failed

App connector: Filter • Time to complete: 1 minute

Continue only if the refund status is PENDING or COMPLETED. Skip REJECTED and FAILED refunds, since no money went back to the customer.

Shopify logo icon

Find the matching order in Shopify

App connector: Shopify • Time to complete: 1 minute

Search Shopify orders for the tag square-{{refund order_id}}, the tag the Square-to-Shopify order copy workflow adds to every order it creates. Return the order ID and its current tags.

Continue only if exactly one order matched

App connector: Filter • Time to complete: 1 minute

Continue only if exactly one Shopify order was found. If none was found, the Square order was never copied into Shopify, so there is nothing to flag.

Shopify logo icon

Note the Square refund on the Shopify order

App connector: Shopify • Time to complete: 1 minute

Add a line to the Shopify order's note with the Square refund ID, the refunded amount converted from cents to dollars, and the refund date, keeping any existing note text.

Shopify logo icon

Tag the Shopify order square-refunded

App connector: Shopify • Time to complete: 1 minute

Add the tag square-refunded to the Shopify order, so refunded counter sales can be excluded from saved order views and exported reports.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to flag Square refunds on the matching Shopify order automatically

Get setup in 6 minutes.

Use this template →

FAQs

Why does this tag the Shopify order instead of refunding it?

The Shopify copy of a Square sale has no Shopify payment behind it, because the customer paid in Square. There is no Shopify transaction to refund, so the workflow records the refund on the order and tags it, which is what your reports need to exclude it.

How does the workflow find the right Shopify order?

It searches for the tag square- plus the Square order ID. That only works if the workflow that copies Square orders into Shopify adds that tag, so add an Order Add Tag step to that workflow first.

What about partial refunds?

A partial refund is flagged the same way, and the note records the exact amount refunded, so you can see whether the whole sale or only part of it came back.

Personalize this template

Customize this workflow even further:

Post refunds to Slack
Add a Slack Send Message step after the tag so the person who reconciles the books sees every counter refund the day it happens.
Log refunds to Google Sheets
Add a Google Sheets row with the Square refund ID, the Shopify order name, and the amount, for a running refund ledger across both channels.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

flag Square refunds on the matching Shopify order automatically

6 min setup • Fully supported if you need help