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 you’re 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.
Mixtable’s spreadsheet interface makes it trivial to bulk edit tags in your Shopify store. Here’s how:
- Set up a workbook and set up 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, and so we’ll be editing Product tags.
- Right-click on the column header of a column that is not yet mapped to sync to a field. Such columns have a grey background, whereas columns that are set up for data syncing have a light green background. When you right-click you’ll see a context menu show up. Select the Shopify Sync Settings option.
- In the window that opens, select the Standard Field radio button option. You will see a dropdown show up, prompting you to select the field you’d like to sync. Find and select the Tags field. Now, click on the Save button.
- You’ll now see the column populate with any existing tags for your products.
- Now, find the product whose tags you want to modify. You can set tags directly or use an Excel-style formula. If your product has multiple tags, you need to separate those with a comma (e.g., “tag1, tag2”) as that is how Shopify stores tag information.
- To replicate the tags of one product to others, simply copy and paste the relevant cell.
Bulk editing tags is fast and convenient by directly modifying cells that display a product, order, or customer’s tags. But if you need to simply 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 on its button in the toolbar. 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.
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.
