Add and remove Shopify tags in bulk

Bulk tag management in Shopify is essential for efficiently organizing large product catalogs and updating multiple items simultaneously, especially when running seasonal sales or managing inventory across different categories. Whether adding promotional tags like “Summer Sale” to hundreds of products or removing outdated tags from last season’s inventory, doing it in bulk saves significant time compared to updating tags individually.

Edit tags from Shopify admin

You can edit Shopify product tags from the Shopify admin. The edits won’t be in bulk for all products, but at least you will have all products in one view and won’t have to load products one by one.

Here’s how to do it:

1. Go to your Products view and select the products whose tags you want to edit.
2. Click Bulk editor
3. If you don’t have the Tags column loaded, select Columns and choose Tags.

4. You can add, remove, or edit the tags by clicking the Tags field for each product.

Edit Shopify tags in bulk from a spreadsheet

Mixtable’s spreadsheet interface makes bulk editing tags in your Shopify store trivial. Here’s how:

1. Set up a workbook and a worksheet to sync the data whose tags you’ll be editing. In the examples below, we are using a worksheet that syncs our store’s Products, so we’ll be editing Product tags.
2. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.
3. In the window that opens, select the Standard Data Field radio button option. A drop-down menu will appear, prompting you to select the field you’d like to sync. Find and select the Tags field. Now, click on the Save button.

4. You’ll now see the column populate with any existing tags for your products.

5. Now, find the product whose tags you want to modify. You can set tags directly or use Excel-style formulas. If your product has multiple tags, you must separate those with a comma (e.g., “tag1, tag2”), as that is how Shopify stores tag information.
6. To replicate the tags of one product to others, copy and paste the relevant cell.

Add tags in bulk

Bulk editing tags is fast and convenient by directly modifying cells that display a product, order, or customer’s tags. But if you simply need to add a tag, the fastest way is with the Bulk Add Tags feature. This feature is only available for worksheets that sync product, order, and customer information (as only this data in Shopify has tags). You’ll also need to have the Tags field mapped to a column.

You activate the Bulk Add Tags feature by clicking its toolbar button. In the dialog that opens, you’ll see a few inputs:

• Tags operation - this will be set to “Add Tag” by default, but you can change it to “Remove Tag” if you’ve changed your mind
• Tag values - here, you enter one or more tags that you want to add. After entering each tag’s value, press Enter
• Preview first 10 rows - if enabled, this will preview the tag addition on the first 10 visible rows in the active worksheet. This way you can preview what the output will be before you make it real.

How to delete tags in bulk

If you need to delete tags in Shopify, the fastest way is with the Bulk Remove Tags feature. This feature is only available for worksheets that sync product, order, and customer information (as only this data in Shopify has tags). You’ll also need to have the Tags field mapped to a column.

You activate the Bulk Remove Tags feature by clicking its toolbar button. In the dialog that opens, you’ll see a few inputs:

• Tags operation - this will be set to “Remove Tag” by default, but you can change it to “Add Tag” if you’ve changed your mind
• Tag values - here, you enter one or more tags that you want to remove. After entering each tag’s value press Enter
• Preview first 10 rows - if enabled this will preview the tag removal on the first 10 visible rows in the active worksheet. This way you can preview what the output will be before you make it real.

Add or remove tags with Action columns

Add the Action Columns spreadsheet functionality to an existing product worksheet to edit Shopify tags in bulk.

Note: The worksheet needs to show product information. You can create one using our Basic Product Info template, or add a Products (no variants) worksheet to an existing workbook.

To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

From the Shopify Sync Settings window, choose Action Columns.

You can quickly add or remove tags once you link the Add Tags and/or Remove Tags columns to your products' spreadsheet. Here's how:

• Add a new tag in the Add Tags column
• Add a tag you want to remove in the Remove Tags column
• Click Sync worksheet changes to Shopify
• Allow some time for the changes to take place.

Note: If you have rules for automated collections based on tags, the new tags will add products to automated collections, and correspondingly, the removed tags will remove them from the automated collections.

Find more about Action Columns functionality here.

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.