What’s up guys? Today we’re going to go over something very interesting. A lot of times when you’re transferring from another system, you’re given Excel spreadsheets. Now these spreadsheets typically are in different formats. They’re usually called CSV files. One of the problems that people run into, especially when importing into Shopify, is they’ve imported the spreadsheet, everything works fine, but the only images that seem to import are the images on the first line. Now the reason this happens is because you need to have a handle associated [00:00:30] with every image on every row of the CSV. What I’m going to do is I’m going to show you in Excel how to set up a very easy script, or a little formula, in order to auto fill the columns, so that you have your variant handle as well as the image location next to it so that when you do the import, it actually imports all of the images. This is one that I struggled over for a number of weeks, so it’s … I thought it would be a very helpful thing to show you. [00:01:00] Let’s hop over to it now, and we can go over it.
One of the things you find is, when you’re importing from another import statement, and you’re importing them into Shopify, and it’s only importing the first image, and it’s not importing the rest of it. The reason is, is because you need to have the handle associated with the image in order for it to know where to import it. What I’m going to do is I’m going to show you a quick Excel trick that you can do in order to auto fill this column. [00:01:30] If you don’t do that, what you have to do is you have to go through it and basically drag these down on each one. If you’re dealing with thousands of products, this can be very time consuming. I’m going to show you how to do it in one fill method. First thing you want to do is you want to insert a new column. This is the column that we’re going to use to take over the handle when we’re finished doing the copy and pasting.
First thing we want to do is we want to start using the if statement, because we’re going to do [00:02:00] an if statement to find out whether something is blank or not. We type if, then we open up our if statement. Now the logical test that we’re going to do is we’re going to check to see if the column that we need is blank. If is blank, is blank. Then it needs to have a value put in there. In our case, what we’re going to do is we’re going to check to see if M2 is blank, because what we want it to do is if it’s not blank, [00:02:30] we want it to fill with the item that’s in here. If it is blank, then we want to input our own field. If M2 is blank, then the next portion of it is we need to know if … Tell it what to do if it’s true.
If it’s true, what we’re going to do is we’re going to fill this column with the item that’s above it. The one above it would be M1. The one above it, and then if it’s false, [00:03:00] what we want to do is we actually want to fill it with its current value. If it’s not blank, we want to continue to keep that value. That would become M2. Then we’re going to close that. Once we’ve done that, as long as I have all the commas in the right spot, we should see it pull in the item that’s in the handle here. Now if I drag this down, we should see it auto fill. Actually, hold on. This should be N2, [00:03:30] not M2, my mistake, because we want it to grab the one above. Fills it down and then when we get to the next item, it’ll fill it in with the column down below. We can drag that along. When we get down to the next one, it’ll drag it in. Now what we can do, is we can go and auto fill the entire column with values, and then rename this to handle, and delete handle.
Now when we do the import, what it’s going to do is it’s actually going to take [00:04:00] each individual image, and attach it to a product handle. Then that way, we have all of our images imported. That’s everything you need to know about using the if blank statement in Shopify. Once we finish filling in our columns, and we’ve got all of our handles in the new column that we’ve created, what we’re going to need to do, is we’re going to need to delete out this original column. What we’re going to do, is we’ll call this handle here … Oh, actually, no. What we’re going to do is, we’re going to insert one more blank column. Let me [00:04:30] do that, insert. Then what you want to do is you want to copy all of the stuff that you’ve just generated. We’re going to copy that. Then we’re going to go to this new column that we created, and we’re going to paste values only.
Now if you’re on a PC, you can right click and go paste special, and it will give you the option to paste values only. The reason we want to do this, is because when we eventually delete this column here, so I’m going to do that now. You’ll notice that the one that we created, it’s going [00:05:00] to screw up all the formulas. We want to have a finalized version in just value format, that we can then delete out and clean up everything that’s not needed. I’m now going to delete the reference one that we had before, and we’re going to call this handle. You should be able to now import your newly generated CSV file with all your handles matching up with your images, so now all of the images for your import will show [00:05:30] up underneath your specific products.