If you need to update Tags for any of your Shopify items (like Products, Customers, Orders or Blog Posts), then you can do it quickly with the Excelify. Let’s take a look at how to do it.
We will use Products as an example, but the same will apply for other items that have Tags in Shopify store.
Steps in short
- Export Products you need to update.
- Delete unnecessary columns.
- Update the “Tags” and “Tags Command” columns.
- Save, import and enjoy!
1. Export Products you need to update
First, you will need to export the Products that you wish to update. In the Excelify apps Export section select the checkbox “Products“, no other checkboxes are needed.
Then you can click on the filter icon to apply filters so you only export Products that you wish to update not all Products.
Press the “Export” button to start the Export.
2. Delete unnecessary columns
When the export is finished you can download the exported file by clicking on the button “Download Exported File“.
Since you only wish to update only Tags then we do not need to include all columns. You can delete all columns from the file and keep only those:
- Tags Command
3. Update the “Tags” and “Tags Command” columns
Now, you will need to chose what you wish to do with your tags. In the exported file you can see that the column “Tags Command” has the value REPLACE for all Products.
Possible values for Tags Command are:
MERGE Tags Command will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it.
The DELETE Tags Command will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it. All Tags that are not in the file will not be touched for Products with the Tags Command DELETE.
The REPLACE Tags Command will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time.
When you have selected Tags Command that fits your needs you can update the “Tags” column accordingly as I have in the screenshots above.
4. Save, import and enjoy!
Now you can save the file. Go back to the Excelify app and import the file in the Import section. The app will analyze the file and count how many Products you are importing.
Press the Import button to start the import.
If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why particular Products has failed. Then you can fix that issue and re-import just those failed and fixed rows again.