Bulk add, update, and remove Shopify tags

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

1. 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.
2. 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.

3. In the window that opens, select the Core 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.

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 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.
6. To replicate the tags of one product to others, simply 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 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.

Remove tags in bulk

If you need to simply remove a tag, 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 on its button in the toolbar. 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.