How to batch add tags to products from a csv ?

[LothaireBordeau]

Hello ! 

I have used a third party app to generate a reports showing all my items that never sold once. Now that I have the report and exported it as a CSV, how can I tag the items in Shopify so I can easily find them in the future ? 

Is there a way to tag them in the csv and then feed it back to Shopify ? 

[nakano_thesense]

Hello!

Yes, you can use Shopify’s standard product export and import feature to bulk add tags to your items. Here’s how you can do it:

1. First, export your product data from Shopify by going to Products > Export and selecting the option to export your products as a CSV file.

2.Open the exported CSV file in a spreadsheet program like Excel or Google Sheets.

3. In the Tags column, add the tags you want to associate with each product. You can add multiple tags by separating them with commas.

4.Once you’ve added the tags, save the CSV file.

5. Go back to Shopify and navigate to Products > Import. Upload the modified CSV file, and Shopify will update your products with the new tags.

This method allows you to efficiently bulk tag items without having to manually edit each product.

Additionally, if you want to automate this process and apply tags on a regular basis, you might want to consider using an app like Matrixify, which allows for scheduling and automating imports and updates.

https://matrixify.app/tutorials/schedule-import-to-shopify-from-google-sheets/

Let me know if you need further assistance!

[Ablestar_Daniel]

Hi @LothaireBordeau,

It is possible to do this through either the Shopify admin CSV import/export or a third-party app. Could you tell me a little more about what your CSV file looks like? How are the product identified in the CSV file? (ID, SKU, handle or something else?) That'll help figure out what the easiest way to update them is

Best,

Daniel

[LothaireBordeau]

Hello ! This is how the products are identified in the file. 

[nakano_thesense]

Hello!

Importing products to Shopify via Csv is required to include the colums below as a minimum.

- Handle

- Title

So I think it is able to import with creating Csv like below.

Handle	Title	Tags
handle	Product TItle	Tag1, Tag2

Attention

- If products has tag already, It would be overwritten so you have to export it and add the tag that you want to add to Tags column.

- It is required to check overwrite with same handle when import it

[Ablestar_Daniel]

Thanks for the screenshot @LothaireBordeau. If you decide to use the CSV import/export in the Shopify admin the main difficulty will be in updating the spreadsheet you get from Shopify with the titles from your report. I've written steps below on how to do this in both the Shopify admin (w/ an example Google Sheets document) and with our third-party app.

Using the Shopify Admin

I've created a sample spreadsheet here that you can follow along with, the tabs in the spreadsheet refer the different steps I mention below.

1. Export your products from the Shopify admin by clicking on Export at the top of the products page

2. Open up the spreadsheet and remove all columns except for Handle, Title and Tags. Also delete any rows where the Title cell is empty. The spreadsheet should look like the 'Step 1' sheet in the sample spreadsheet

3. Add your report as a separate sheet to your spreadsheet. ('Step 2a' in the sample)

4. Now the tricky part, you need to write a formula that does the following:

1. For each row in the Shopify sheet, look for the product title in the report sheet
2. If the title is in the report sheet, add a tag to the 'Tags' column of the Shopify sheet

'Sheet 2b' of the sample spreadsheet has this formula and uses it to create the values in the 'New Tag' column. Here's we're adding the tag "mynewtag" if the title exists in the report using the following formula:
=IF(COUNTIF('Step 2a. Report CSV'!B:B,B2)>0,concat(C2,", mynewtag"),C2)

5. Move the contents of the 'New Tab' column to the 'Tab' column so your sheet looks like 'Step 3' in the sample file and reupload it to Shopify by clicking on Import from the product page. When you upload it make sure to check the 'Overwrite products with matching handles.' option.

Besides the formula, a few things to keep in mind are:

• Make a backup of all your product data before trying this as it's easy to overwrite data if you're not careful
• Do a test on 1-2 products first to make sure that the changes work as expected
• After the import completes you can't see which products were updated but you should be able to search for the products by tag in the Shopify admin to verify that they updated

Ablestar Bulk Product Editor

If you're open to using a third-party app I would recommend taking a look at our Ablestar Bulk Product Editor. You can use the app to quickly upload a spreadsheet with two columns: the product's title and the tag to add. The file would look like this:

Then you would upload it to the 'Spreadsheet edit' section of our app and set the second column to 'Tags: Add':

When that looks good click Run edit at the top and the app will make the changes for you. There's a few advantages to doing it this way:

• As long as the first column of the spreadsheet identifies a product, you don't need to reformat the spreadsheet to match a strict format
• You don't need to worry with formulas to add the tags
• The app will show you which products it's editing as it makes the changes
• If you make a mistake you can cancel and undo the edit with just a click

I hope one of these options works for you. If you have any questions about either let me know and I'd be happy to help.

Best,

Daniel