Untag Resolved Warranty Orders in Shopify From a Spreadsheet
Once your team tracks warranty claims in a Google Sheet, the warranty-claim tag on the Shopify order stays put long after the claim is settled, so your filtered order list fills up with closed cases. This workflow watches the claims sheet, and when a row's Status changes to Resolved it finds the Shopify order, removes the open claim tag and adds a resolved tag.
How it works
5 steps to mark a claim Resolved in the sheet and Shopify updates itself
When a row in the warranty claims sheet changes
When a row in the warranty claims sheet changes
Continue only when Status is Resolved
Continue only when Status is Resolved
Find the Shopify order from the row's order number
Find the Shopify order from the row's order number
Remove the open warranty-claim tag from the order
Remove the open warranty-claim tag from the order
Tag the Shopify order as warranty-resolved
Tag the Shopify order as warranty-resolved
Ready to mark a claim Resolved in the sheet and Shopify updates itself
Get setup in 5 minutes.
FAQs
Does this need the claim intake workflow?
No, but it pairs with it. Any claims sheet works as long as each row has the Shopify order number and a Status column your team updates.
What if a claim is denied instead of resolved?
Change the Filter to accept Resolved or Denied, or duplicate the workflow and add a warranty-denied tag for denied rows.
Will the customer tag be removed too?
Not by default, because a customer can have more than one open claim. Add Shopify's Customer Remove Tag action if each customer only ever has one.
Personalize this template
Customize this workflow even further:
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."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
mark a claim Resolved in the sheet and Shopify updates itself
5 min setup • Fully supported if you need help