Bulk Tag Shopify Orders From a Google Sheet

4 min setup
No coding required
Runs automatically

Shopify's bulk actions give every selected order the same tag, and the bulk editor can't edit orders at all, so tagging a list of orders with different tags means opening them one by one. This workflow lets you paste order numbers and the tag each one needs into a Google Sheet. MESA finds each Shopify order, adds its tag, and marks the row done, so a list of hundreds of orders gets tagged without touching the admin.

google sheets logo icon
When an order number and tag are added to the sheet
Shopify logo icon
Find the Shopify order from the row's order number
Shopify logo icon
Add the row's tag to that Shopify order
google sheets logo icon
Mark the row Done in the sheet

How it works

4 steps to paste order numbers and tags into a sheet and Shopify tags every order

google sheets logo icon

When an order number and tag are added to the sheet

App connector: Google Sheets • Time to complete: 1 minute

Runs for each new row in a tagging sheet with columns for Order Number, Tag and Status.

Shopify logo icon

Find the Shopify order from the row's order number

App connector: Shopify • Time to complete: 1 minute

Search orders by the order number in the row, with status set to any, and use the first match.

Shopify logo icon

Add the row's tag to that Shopify order

App connector: Shopify • Time to complete: 1 minute

Add the value of the row's Tag column to the order found in the previous step. Several tags can go in one cell, separated by commas.

google sheets logo icon

Mark the row Done in the sheet

App connector: Google Sheets • Time to complete: 1 minute

Set the row's Status column to Done so the team can see which orders were tagged.

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 paste order numbers and tags into a sheet and Shopify tags every order

Get setup in 4 minutes.

Use this template →

FAQs

Can I remove tags from orders the same way?

Yes. Swap Order Add Tag for Shopify's Order Remove Tag action, or keep both and add a Filter on an Action column so each row can say Add or Remove.

Why not use Shopify's bulk actions?

Bulk actions add the same tag to every selected order, which is the right tool when one tag fits the whole selection. This workflow is for lists where each order needs its own tag, or where the list comes from outside Shopify, like a 3PL or support export.

Does it work for customers or products?

Yes. Use Get List of Customers with Customer Add Tag, or Get List of Products with Product Add Tag, and put an email or product handle in the sheet instead of an order number.

Personalize this template

Customize this workflow even further:

Flag rows that don't match an order
Add a Filter after the order lookup and write Not found to the Status column when no order matches the number.
Tag the customer too
Add Shopify's Customer Add Tag action to tag the customer on each order with the same value.

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

paste order numbers and tags into a sheet and Shopify tags every order

4 min setup • Fully supported if you need help