What’s up guys? I got a quick one for you today. We’re going to over the bulk editor tool, and I’m also going to tell you about a workshop I’ve got coming up in September. All that next.

You’ve imported all your products in to Shopify, and now you need to go and make some changes. An example of that is you want to put a bunch of stuff on sale, for example. Now, you could go in one at a time and make those changes, but that can be very tedious, and it’s very time-consuming. You can also go and export the products, so you can click on export, select your export, export it to a CSV file, make your changes in the spreadsheet, and then re-import it back in, but sometimes that might not be something you want to do, say on an iPad.

Anyway, Shopify offers a bulk editing tool, which allows you to edit all your products in one super clean interface. I’m going to show you how to do that. I want to go and I’m going to edit a number of these items, so I’m going to go and I’m going to click on the button over here and it’s going to select all the products. It’s only going to select the products that are shown in my current search result. If I have more than 32 products or more than 100 products on one page, it’s going to show on the next page, so you’re going to get an option here that says “select all products.”

Then, what I can do is I can do two things. One, I can go into bulk actions. I can either hide all the products in my store, delete the selected products and republish them, I can add tags and remove tags, or I can add them or remove them from collections, but what we’re going to do is we’re going to actually click on the edit products button, and what this will do is allow us to edit multiple products in this really cool spreadsheet format.

Now, the most important thing when you’re in the spreadsheet format is understanding that this is pretty much exactly the same as Excel. The only difference is you can’t drag and drop the columns, so you can’t move them around here. The way the columns are lined up is title is fixed. Title always has to be there, but then the order that you add these current fields in at the top is the order that they’re going to show up down here.

Let’s say I’m going to remove inventory tracking and charging taxes, because those aren’t important for me for the sake of what I’m going to be doing. I’m also going to remove compare at price. We’re going to get right down to the basics here, so we have SKU and price. If I want to add another field in, I can click on the add field, and then anything that is not in this light color, anything that’s in the dark color, is a field that I can then add, so I actually do want to add in compare price. The order that I add these things in here is the order that they’re going to show up down below, so it keeps things very, very clean.

Next, I’m going to go in, and I’m actually going to make some changes, so the Commander umbrellas, we had them on sale, and now we’re going to change them so they’re back at regular price, so we’re going to go 105, 99, and we’re going to hit save all changes. What you’ll see happens here is it’s going to iterate through each one of those products and make those changes. The way it shows it is it shows it by the name, and then if it’s indented in the green color, that means it’s a variant. If we have a look down here, we have the lookout hat night sky, it actually has a variant for night sky, and it will show the individual variant underneath it. The master product will then no longer have a way for you to edit it because it has multiple variants underneath it.

That’s everything you need to know about the bulk editor tool. As always, if you have any questions, you can leave me a comment down below. Just a reminder that on September 25th, I have a workshop coming up in Vancouver, British Columbia. This is going to be held at Brain Station. I left you guys a link down below so you can see the event as well as a nice discount code in order to get you 10% off of the price. That’s all for this week. If you would like, please like and subscribe to this video, and we will see you guys next week.


Leave a Reply

You must be logged in to post a comment.