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 the Tags column is not 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.

Shopify Tags: Examples

Here are some common examples of how store owners use tags in Shopify:

Product Tags

Product tags are essential for organizing your inventory and improving the customer’s shopping experience.

Pro tip: Use the Product spreadsheet template to manage product tags in bulk with Mixtable.

• Categorization and Filtering:

  • By attribute: red, cotton, large, waterproof
  • By style or theme: bohemian, minimalist, holiday-collection, summer-essentials
  • By status: new-arrival, best-seller, on-sale, out-of-stock

• Internal Operations:

  • fragile (to alert fulfillment staff to handle with care)
  • discontinued (to easily find products that need to be hidden from the store)
  • supplier:company123 (to filter products by a specific vendor)

Use tags to create Automated Collections:

You can set up automated collections to automatically group products that share a specific tag for a better user experience and navigation.

For example: A collection called “Summer Dresses” could automatically include all products tagged with dress and summer.

You can do that from Shopify admin > Products > Collections page

Customer Tags

Customer tags are used to segment your customer base for marketing and support purposes.

Pro tip: Use the Customer spreadsheet template to manage customer tags in bulk with Mixtable.

• Customer Segmentation:

  • Loyalty and value: VIP, high-value-customer, first-time-buyer
  • Behavior and engagement: newsletter-subscriber, abandoned-cart, brand-advocate
  • Status or type: wholesale, distributor, local-pickup

Tag customers for Marketing purposes:

By tagging customers, you can create targeted email campaigns or special offers.

For example: You could send a personalized email with a special discount to all customers tagged VIP.

Tag customers for internal operations and support:

Tags like issue-reported, refund-requested, or review-needed can help your support team quickly identify and prioritize customer inquiries.

Order Tags

Order tags help in managing and prioritizing the order fulfillment process.

Pro tip: Use the Orders spreadsheet template to manage customer tags in bulk with Mixtable.

• Fulfillment and Shipping:

  • express-shipping, local-pickup, international
  • back-ordered, delayed, partial-fulfillment
  • gift-wrap, special-instructions

• Internal Status:

  • high-risk (to flag orders for manual review before fulfillment)
  • manual-payment-capture (for orders that require manual payment processing)
  • fulfilled-by-warehouse-a (to manage orders across different fulfillment locations)

How to tag orders:

You can use the Shopify Flow tool to add tags to orders based on specific conditions automatically.

For example: An order from a customer tagged VIP could automatically get the priority tag.

Other Tag Examples

• Blog Post Tags: Organize blog content by topic, like gardening-tips, new-recipes, or product-reviews.
• Draft Order Tags: Tags like pending-approval or custom-pricing can help manage and track draft orders before they are finalized.
• Transfer Tags: Used to manage inventory transfers between different locations, such as restock or damaged.

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.