How to Add and Remove Shopify Tags in Bulk

Tags help organize Shopify products, orders, and customers. With Mixtable Spreadsheet Editor, you can see those tags beside the rest of your Shopify data, update many rows at once, and review every pending change before syncing it to Shopify.

Mixtable gives you three ways to bulk edit tags:

What you need to do	Best method
Set the complete tag list for each row	Edit the Tags column directly
Add or remove the same tags from every visible row	Use Bulk Tools
Apply different product-tag actions to different rows	Use Action Columns

Changes made with any of these methods remain pending in the spreadsheet until you intentionally click Sync to Shopify.

Before you start

Install Mixtable Spreadsheet Editor, then open a Shopify data worksheet for the records whose tags you want to change:

• For product tags, use a Products (no variants) worksheet or the Basic Product Info template
• For order tags, use an Orders worksheet from the Orders and Order Items template
• For customer tags, use a Customers worksheet or the Customers template

Product tags belong to the parent Shopify product, not to individual variants. A Products (no variants) worksheet is usually the clearest place to manage them.

Add the Tags column

Some templates already include a Tags column. If yours does not, add it before using the direct-edit or Bulk Tools methods.

1. Select an empty column, meaning a column without a green header
2. Click the button in the column header
3. Select Shopify data fields
4. Choose the Tags field. On a Products (with variants) worksheet the picker labels each field as coming from either Variant or Product, so pick the Tags field that comes from Product
5. Click Save Column

Mixtable fills the column with the existing comma-separated Shopify tags for every row.

Edit the complete tag list in the Tags column

Use this method when you want to control the final tag list for each product, order, or customer.

1. Find the row you want to update
2. Edit its Tags cell and separate multiple tags with commas, for example summer, sale, clearance
3. Copy and paste tag lists into more rows, fill values down, or use formulas when the pattern is repeatable
4. Click Preview changes and review the old and new tag values
5. Click Sync to Shopify when the complete tag lists are correct

Editing the Tags cell replaces the complete tag list for that row. If a product currently has summer, blue and you change the cell to sale, Shopify will receive sale as the new complete list. Use the next two methods when you want to add or remove tags while keeping every other existing tag.

Add or remove the same tags from visible rows

The Bulk Tools method is the fastest choice when the same tag change should apply to every row currently visible in the worksheet.

If the change should affect only part of your catalog, filter the Shopify data first. Hidden rows are not included in the bulk tag update.

1. Confirm that the active worksheet has a mapped Tags column
2. Open Bulk Tools in the top toolbar
3. Select Add tags or Remove tags
4. In the Bulk Edit Tags dialog, confirm the Add tag or Remove tag operation
5. Enter one or more tags, using Enter or a comma to separate them
6. Leave Preview first 10 rows turned on and review the Before and After values
7. Click Update Spreadsheet
8. Click Preview changes beside the Shopify sync controls and review the complete pending update
9. Click Sync to Shopify to send the tag changes to Shopify

Update Spreadsheet changes the visible worksheet cells. It does not send anything to Shopify by itself, so you can still review or correct the results before syncing.

Add or remove different product tags with Action columns

Use Action columns when different Shopify products need different tag changes. Each row tells Mixtable which tags to add or remove from the product on that row.

Action columns are available on Products (no variants) and Products (with variants) worksheets. On a variant worksheet, the action changes the tags on the parent product because Shopify tags belong to products, not individual variants.

1. Select an empty column, meaning a column without a green header
2. Click the button in the column header
3. Select Action Columns
4. Choose Add Tags or Remove Tags, then click Save Column
5. Enter the tag or tags for each product row. Separate multiple tags with commas
6. Copy, paste, fill down, or use formulas to prepare the rows you want to update
7. Click Preview changes and confirm the expected product-tag actions
8. Click Sync to Shopify to apply them

Leave an Action column cell blank when that row should not perform the action. For example, an Add Tags cell containing summer, sale adds those two tags without replacing the product's other tags.

If an automated Shopify collection uses tags in its conditions, changing a product tag can also change whether that product belongs to the collection.

Learn more about Action columns.

Use Action columns for product tags only. The direct Tags column and Bulk Tools methods also support Shopify order and customer tags.

Which rows will Bulk Tools change?

The tag tool updates the data rows currently visible in the active worksheet. This makes worksheet filters a useful safety check:

1. Filter the worksheet to the products, orders, or customers you want to change
2. Confirm that unrelated rows are hidden
3. Open Bulk Tools and run the tag operation
4. Review the first 10 visible rows in the dialog
5. Review the full pending change list before syncing to Shopify

If the worksheet is not filtered, the operation applies to all visible data rows.

Tag-management tips

• Use consistent spelling and capitalization so similar tags do not split into separate groups
• Prefer a small, documented set of operational tags over many near-duplicates
• Filter and review the affected rows before running a large tag update
• Use Action columns when the required tags differ by product
• Use the direct Tags column when you need to replace or reorganize the entire list

Shopify automated collections can use product tags as conditions. Adding or removing a product tag may therefore also change whether that product appears in an automated collection.

Once your product tags are consistent, Mixtable Analytics Spreadsheet can compare sales by tag with the Sales by Product Tag report. A product can have several tags, so the same order activity can count in more than one tag row.

Troubleshooting

Bulk Edit Tags says the worksheet has no Tags column

Map the Shopify Tags field to a column, then reopen Bulk Tools. On a Products (with variants) worksheet, choose the Tags field that comes from Product, because Shopify tags belong to the product rather than the variant.

The action-column option is missing

Action columns for tags require a Products (no variants) or Products (with variants) worksheet. Use the mapped Tags column or Bulk Tools for order and customer tags.

Update Spreadsheet ran, but Shopify did not change

That is expected. Update Spreadsheet prepares pending cell changes only. Click Preview changes, then Sync to Shopify when you are ready to apply them.

More rows changed than expected

Do not sync yet. Correct the worksheet cells or undo the spreadsheet edit, then filter the worksheet before running the bulk operation again.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.