Using CSV import to Update Tags in BULK

Christine_Lemke
Tourist
4 1 0

I want to use CSV import to update product TAGS in bulk for many of my products, but don't need to change or update any of the variants.

If I remove all rows for variants, just leaving the main product row containing the TAGS, will this in any way affect the product variants?

Also, what columns do I need at a minimum to do this? Do I need ALL the columns or just a required few (and which ones)?

I don't want to mess things up by not knowing how Shopify handles import of CSV files.

My thinking is the less the better for speed of import, etc., just keeping the minimum required structure for it to work correctly.

Many Thanks!

0 Likes
channelup
Shopify Partner
383 16 53

Hi

The key thing to remember is if you leave a column in your csv import (even if it is blank) then that data will be overwritten. So in your scenario you would need to make sure you remove the option columns as if you leave them in but remove the variant rows then the variants will be deleted leaving only a simple product with your new tags.

Try a test with one product and drop all your columns except handle and tags then remove variant rows.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
If you require custom development or would like to test out our features contact me at tom@channelup.io
0 Likes
JoesIdeas
Shopify Expert
1310 118 342

If you can update them based on rules (example, update all tags for products in collection X), then you can use a free app called Bulk Edit Tags. Then you don't have to deal with the risks of CSV uploads.

 

Founder of Speed Boostr (Shopify optimization experts, theme customization, custom app development).
Creator of Shopify Analyzer (first performance analysis tool for Shopify sites, free for the Shopify community).
Creator of Order Automator (auto tag orders and customers + auto fulfillment + more automations).
More apps: Theme Scientist (A/B testing), Tip Jar (add a tip button), File Optimizer (optimize CSS, JS, Liquid).
0 Likes
natashadisante
Shopify Partner
64 0 3

Hi @Christine_Lemke 

You can easily bulk edit your Shopify product tags using Mixtable's Excel-like spreadsheet interface for Shopify. You can sync your product data to a worksheet, map the product's tags to a column, edit the tags, and then sync the changes back to Shopify by saving your workbook.

0 Likes