How to bulk upload images?

[albshop]

I have read you upload them into files directory?

Or you just upload them to your server and then use the path in excel files when you import the products?

[Allan · Accepted solution]

Hey, there!

Jason here from Shopify Support.

You're on the right track. There're two ways you can upload the images files in bulk.

The first method is through the Shopify admin > Settings > Files. Once there, click on Upload files on the top right corner, then you'll be able to upload the image files directly from your device to your admin. You can then use the images while you set up your store/product. For more detailed information, here's a helpful document going through how to upload image files to your store.

The second method is through a CSV file. The key to make sure that the files upload correctly is to follow the CSV format accurately. Here's a great document going over what content is required for each field. I've attached a sample template for you so you can take a look and make sure your Excel file complies with the format. If you wish to use the CSV method, the image files need to be uploaded to a publicly accessible URL first. This can be from the links you received after you use the first method or any cloud services, such as DropBox and Google Drive. Keep in mind the server needs to be at a decent speed. Otherwise, there's a chance you'll get timeout while importing the file resulting in import failure.

If you run into any issues, or if I misunderstood what you're hoping to set up, feel free to reply back here and I'd be happy to help out!

All the best,
Jason

[James_TGP]

I've tried this many times - but dropbox is a horrible place to host images.

In fact, you need a place that allows you to keep a 'fixed' or 'static' link - not one that is scrambled upon upload. (It's a safety thing, so I get it)

When you upload something into dropbox, youll see the 'image URL link' to be something like...

dropbox.com/jhfkjhdsf9734rsfndsfg/image_file_name.jpg

That middle part is what makes it impossible if you're uploading a ton of images.

Ultimately what you want is an image host that allows you to have static URLs like "dropbox.com/folder_name/image_file_name.jpg"

This way it is predictable, and you can change that in bulk in excel. 

[JHS]

Do you have any sample csv files for importing multiple images? That is, my products all have multiple images.

Also, when adding multiple image url's to the csv file, does the upper image become the 'main' image ? 

[James_TGP]

Each product equates to a new row in the CSV.

However if you have additional variants or images for the same product, they too will have a new row.

So if you have a product with multiple images, the first row will be the main product info, and will be the main image.

In order to add additional images, create a new row and copy and paste the handle. Skip to the IMG SRC column and add the image URL. That will result in the second image....

Keep following the same procedure to add additional images.

[JHS]

It's all good ( in a way ) now.

I exported the products I had listed and used the .csv as a cheat sheet.

Abysmal luck with images. Correct format but the import kept failing

when one of the images couldn't be fetched before time out.

I have read that this is a common problem.

They are buried under 4 layers of folders so maybe I can put a copy of

the folder at the root of my current web site to speed things up ( maybe ).

[JHS]

I have placed all my images in a 'shopify' folder at the root of a non-SSL site

but still getting 'time out' when trying to import just 1 product 😞

If I upload all my images to shopify how could I easily access them when adding to a product ?

I have over 500 products.

Current location

http://www.mydomain.com/shopify/__57__4__qw5n-sr.jpg

There is no product identifier in the string so finding it would be ordinarily involve

far too many steps per product.

[Wenzu]

Hello, Just to confirm  understood you well...
So if I got a product with multiple images, i fill in the whole template for the first row and then i just copy and paste the handle and insert the other image links in the image src column under each other, leaving all the rest of columns empty?

Thank you in advance

[Oz_Barron]

The bulk image upload isn't working for me, and I"m not sure why. 

I have a series of items that share an image, so I'm trying to upload an image that's common to all of them, in addition to the image that is different among each one. the primary image is there. So I exported the group of images to a csv. I used google sheets as requested (Though I prefer Open Office, but I got error messages). 

I uploaded the image into shopify files, and put that image URL into the spreadsheet in the image source field

If I have all the fields populated for both images, the import shows no errors, but the secondary image, that I"ve put as Image position 2, does not get added to the item. No error, just no image.

If I put only the header and the image link info, I get errors and it won't import.

I've tried it by importing the images for only one item, and when it imports, there's still no second image and no error.

I must be missing something. I've gone over all the csv info and the bulk import info, but I"m stumped.

I am pretty proficient with CSV files and database imports and exports. I assume this works as it seems others have had success, I'm just seeming to be missing something. And yes, the theme supports multiple images, but they're not showing up in the item card.

I'll take any hints or tips you have.

Thanks, Oz

[BaseCampWA]

Hi @James_TGP 
Surely there is now a better way to upload more than one image per product rather than having to keep adding new rows.
This makes it super difficult when you are importing for a second time and you have to ensure you keep the row below it just to keep all the images with it and if you get it wrong you end up with 100's of products with only one image.
Thanks

[StitchShop]

If you have a Mac, use this.

You can download a demo.

Name your files, match your SKUs and hit upload!

https://www.diagram.one/image-uploader-for-shopify

[madhikar]

Hi,

You need to position your multiple images in sequencing manner in 'Image Position' field. The 'Variant Image' field will have single image URL and 'Image Src' will have multiple image URLs with sequencing.

[danielpretorius]

Hi @madhikar 

You can do this rather easily with Airtable. Airtable natively supports the loading of images from a file on your computer or via URL. You can either manage your images via a separate table (useful for specifying alt tags and the order of your images) or using our Power Images functionality that embeds images right into your product/variant tables. Read more about how to manage your Shopify Images with Airtable and also how to bulk update your Shopify data in general.

[tresorsstrand]

Can you send a sample of this coding?

Jennifer

[StitchShop]

What are you referring to Jennifer?

[StitchShop]

Shopify SKU Image Uploader

If anyone is interested in my Shopify Photo Upload tool, for a short time i am offering it free and looking for beta-testers. It is specifically for matching SKUs/Barcodes with images.

Please read about the product here:

https://www.notion.so/jc2020/SKUpload-Documentation-406e3f3e79e145eb98dbbd2d4d252681

If it is something you are interested in, please contact me via the page.

John

[StitchShop]

Image Uploader Released!

https://www.diagram.one/image-uploader-for-shopify

• Matches Filenames with Variant SKUs
• Uploads to Variant Photo
• Uploads to Generic Product Photo.

 

[rmanke]

Awesome!  Thanks so much John!

[CraigHughes]

Hi John,

This app looks great - do you have any feedback/examples of how stores have used it?  

Also, how would this work in line with the Product upload CSV?

Whats the cost for the app?

Thanks

Craig

[StitchShop]

The App is primarily for matching and uploading images into Shopify without the need to use the CSV or host the images online somewhere.

This is particularly good if you have lots of SKUs

The app assumes you have the product information loaded into Shopify. As most people who have this many skus probably are sending them from an inventory or POS application like Vend. You then can use the app to match and upload.

 

Currently the price is $49.00 USD, If you have lots of SKUs this will save you hours of work. Our team love it.

We have had a number of beta testers  who have 1000s of SKUs and seemed to work fine for them.

Documentation here:

https://www.notion.so/dgrm/Image-Uploader-for-Shopify-406e3f3e79e145eb98dbbd2d4d252681

Download here:

https://www.diagram.one/image-uploader-for-shopify

Feedback welcome

Cheers

John

[FusionDecals]

Have the same issue just one of my category has 400 designs with each product having 7 images each.  I ended up purchasing low end cpanel hosting service and set up ftp access to accommodate my needs.  I already have about 100k images I uploaded by hand to shopify (estimate 7million images if i get all my designs loaded with 7 examples each, we create decals) but alot of those images where dropped during uploading via the browser so its been nothing but a nightmare.  But using a cheap website host with cpanel access to create a ftp directory made it much easier,  once shopify imports the images correctly you can remove them off your server to save space and start on your next upload.  This is unfortunate as these services cost money we already spend 100$ a month just in plugins for shopify so we completely feel your pain.  I also tried the hosts you mentioned and many others and they all generate random urls that are not static and require weird file permissions and or you have to share the files its just useless for what we are doing.   My host WX hosting is hopefully going to make a ftp specific account with more space and less features to keep the price right for us today or tomorrow as technically there service is meant for people hosting Opencart and other functions we do not need as we have shopify which we used to use before we switched to shopify.  Shopify is better in many ways compared to open source shopping carts and is not very good with some of the basics like file hosting and variant limits etc

-Jason 
Fusion Decals

If you still have this issue I can get you in touch with Jeff with WX hosting if your interested.

[James_TGP]

Absolutely - variant limitations have caused many store owner's difficulty.

The image issue is also another one - with the failures, it will tell you why it failed in the export error details. Many times a whole product will error out if one of the images errors out! it's definitely a pain, but takes some elbow grease to keep modifying the spreadsheets and pushing those uploads through. 

Eventually It gets fun when you offer it as a service (or maybe that's just wishful thinking on my end).

But I've done the same and used my own server to host and transfer images. It's a pain to get going, and for many people the amount of 'technical hurdles' involved will also put them in a bit of a tough scenario.

Easier to let someone else do it. But could be costly as well depending on the amount of work.

100K images by hand though? holy *. Haha.

[FusionDecals]

About 500 to 1k at a time over a 2 year period but alot dropped and never
uploaded and ended up getting lost or deleted before I realized on my hard
drive. The file formatting is also a nightmare. I now upload specific
items in a hidden category just for ebay and amazon as those have a few
variables in the shopify format because I sync to those sites. Then for
the items on the site I upload with one option and use a plugin to create
the options, its a complete nightmare but when its working it works great,
even has logic in the drop down options and because the options do not
really exist it doesn't slow down my shopify database which I had happen
with 15k designs all with 80 options combinations each. Now the options
would be more like 500+ per design but instead the plugin just makes notes
on the order since all my items allow for custom options (other then my
specific racing strip kits which just have 15 colors to choose from). But
I am just now testing the ftp and redoing almost all the images in 2k+ res
so its alot of work I can see another 2000 man hrs before I'm satisfied
with my data base on shopify.

[JasonM2020]

Quite incredible, isn't it, that a shopping platform has no simple way of bulk uploading product images? It's an absolute prerequisite to setting up the site, and if you have thousands of images, as I do, you're left with either paying someone to sit and upload one image at a time manually, or try one of the discussed 'workarounds'. It's one thing when you have a free site that has these ridiculous scenario's, but when you're paying top dollar...

[StitchShop]

Agreed.

Currently i am developing a Mac App to look at folder of images and upload them to the correct product/variant.

It would be based on naming the image with the sku eg "barcode1.jpg". It would then find the right product and upload the image.

I can keep you posted.

[JasonM2020]

Thanks, but I need to launch my site ASAP, so I have done what is currently the only option - paid someone to sit and go to each product page and upload the image to the page.... 5,000 times. What a joke.

[Modstop]

Apparantly Excelify allows bulk upload of images from a computer file, but at $200 a month i dont fancy paying that, even though i have over 130,000 product images that need uploading. Luckily i can sit and upload them gradually but currently looking for a faster solution....

[StitchShop]

Hi Jason

5000 !! Good Luck with that.

I have a beta of my app for the Mac that matches SKUs on Shopify with SKU in a file name.

We photograph the products and name the files by using a cheap barcode scanner and output them to a square size.

The same SKU is used for a variant on the Shopify. it is also what we use to track products in our bricks & mortar shop.

The application then matches and then uploads the image to the correct variant and product in Shopify.

At the moment it is only working for our store, as I need to add in preferences to enter different shop credentials.

I also need to check the logistics and legal with Shopify, as it is not a web app in the Shopify ecosystem but an application downloaded and installed locally on your computer.

Ultimately I will sell it as a once off license fee (not monthly), however I would be willing to let some beta testers trial it.

I am continually working on the UI and improvements.

As we have a lot of SKUs, it has been a life saver. We have uploaded over 500 images to our store in the last 2 days and beats mucking about with spreadsheets.

cheers

John

[Nen003]

Hi John,

I was wondering if your app could be used for a butcher shop where each piece of meat will be its own product SKU or variant?

The idea would be to allow you to see the photo of the actual package of the item that you are buying, just like when you look at it in the store refrigerator.

This way you get the actual item you select "t-bone-unique-SKU", and not a generic "t-bone". To do this, each item will be sold only once, and new items created continuously.

Do I understand correctly that I could:

- Weigh the item, and print a unique barcode that contains the info ("t-bone-0.343-kilos")

- Take a picture of the item

- Name the picture by taking a picture of the bar code

- Create the SKU (or variant) in the store using the same code

- Automatically upload the pictures to the correct SKU?

Thanks,

Erik

[StitchShop]

Technically you are almost correct.

You dont take a photo of the barcode or sku, you either type it into the filename or for better accuracy use a $20 usb barcode reader and scan the barcode into the file name. The computer just sees the barcode reader as essentially another keyboard.

We are using CaptureOne to control the photographing process. It allows you to control the shutter on a connected camera and you shoot straight into its library. Adobe Lightroom and even Image Capture (on the Mac) allows this. It just reduces dealing with storage cards and having to match up sku with file names.

Once the photos are cropped and ready. and the filename has the SKU in it, My app will upload and match it to a varient already setup in Shopify.

It is really to support products with 100s of variants and manually doing it in Shopify.

Really depends how many pieces of meat your Butcher does each day. You could easily build an iPhone app that you take a photo (on the iPhone), read the sku from the barcode (iPhones can read barcodes) and match and upload all from the phone.

[Nen003]

Thank you. 

This saved me days of thinking about it.

(Solution: while volume is low, just upload from Shopify mobile, if volume increases, develop app.)

[rmanke]

Are you sharing access to that tool?

[iceesocial]

We just built a public app that does exactly what you guys are looking to do: 

https://apps.shopify.com/photo-finish

We were manually uploading photos to merchants stores and building hacky excel macros and decided to just build something. I use the app myself once a week for migrations and customer updates figured I'd share it incase it helps someone else that's looking at the chain here. Happy to answer any questions also! 

[StitchShop]

rmanke,

I assume you are referring to me? 

I need to make the tool work for any shopify store.

I should have this done in the next week.

You will be able to auto upload any image to a matching SKU straight from your desktop - Mac Only.

[rmanke]

Yes, thanks!

[FusionDecals]

I was able to upload 500-1000 at a time using the file browser in the files section of shopify.  But I learned it would drop tons of files and not actually upload all of them when selecting that many so its a waste of time doing it that way.

[tahiralvi]

Hi @James_TGP 
For upload from dropbox replace the dropbox.com with dl.dropboxusercontent.com.
By doing above you can upload images without any issue.

[DCS111]

any suggestions for hosting images with static URLs?

[rmanke]

If you want to use static image urls, then you need to insert the photos into the description field.  You can't generally host images off site for product images, because that would slow down your shopify store.

[Christilu]

Hi! 

 what is the fastest way to upload a ton of images to an excel file .. is there a better step by step tutorial on this >? please help!! thanks in advance 

[WebsiteExpert]

We can help you in bulk inserting the image.

[Christilu]

how?

[MTaylor]

I notice your reply says Dropbox links can be used for images. I have tried this a few times and always get an error. I have thousands of images and have all of the links for Dropbox.

[WebsiteExpert]

Hi Mark,

What error you are getting can you please share.

[FeltingArt]

HI Jason. I tried your suggestion but kept getting an error message on the images. I contacted chat support and they tried to tell me some of the spreadsheet info was wrong, and it was not. Then they told me that the Google Docs options does not work. I actually had to bulk upload the images to spotify and then copy and paste each assigned URl into the spreadsheet. That finally worked.

[James_TGP]

Sometimes when you copy and paste text from one source into excel, you actually post HTML/styling text that you may not see. It’s code debris from the previous site.

Must’ve been a pain to do all that one by one!

[WebsiteExpert]

Hi, 
Follow the below steps:- 

1) First Upload your images in dropbox.

2) Right Click on your images and copy dropbox link

3) Past the dropbox link and fill the two column one for main image (Image Src)and other for Variant images (Variant Image) 

4) Prepare your excel and upload in Shopify 

[James_TGP]

This works but can be extremely tedious for a large amount of products.

Best to use a image host that DOESNT scramble image urls and offers predictable text structures.

[austin-jeans]

sir

can i call u to understand how to bulk upload my images as i am having more than 500 producta with 6-7 images each. It would be great help if u support me. My mobile number is 9888017670

[carmenhunt]

Now how hard was that to show someone?

WELL THANK YOU .

[StitchShop]

Has anyone solved the Dropbox delima?

I am trying to bulk upload images (via dropbox) based on a CSV with <barcode>.png as the formula to match a large number of images.

But even in the Shopify image editor "add media from URL" doesn't work with Dropbox.

[StitchShop]

it seems you need to use:

https://dl.dropboxusercontent.com/

not https://www.dropbox.com/

[ScandiJohanna]

Hi,

It seems like I am struggling with the same problem as everyone else. How do you get the domain to look like https://dl.dropboxusercontent.com/?

I am just starting with my image project and thought to try this second. Google Drive didn't work.

-H 

[StitchShop]

Normal Dropbox link (the one you create when you ctrl click on a file) does not allow direct downloads so if you put that into your spreadsheet, it will fail.

If you replace  "www.dropbox.com/" with "dl.dropboxusercontent.com" it should work.

HOWEVER

Each file has a different ID slug, so if you plan to use this with 100s of images, it becomes a pain to automate off a file name.

[ScandiJohanna]

Hi,

It works now. Thanks for your help. But we also have 4000+ pics to upload so a faster way would be nice. AirPower might work but we are just thinking if the price becomes too high annually. We are more a pop shop at least for now... 

-H

[StitchShop]

Are you cataloging your images with SKUs in the filename.?

i would be happy for you to beta trial my app.

---

@ScandiJohanna wrote:

Hi,

It works now. Thanks for your help. But we also have 4000+ pics to upload so a faster way would be nice. AirPower might work but we are just thinking if the price becomes too high annually. We are more a pop shop at least for now... 

-H

---

[Brodieman]

Hey John, your app sounds awesome! I've got about 500+ images I need to upload and they're already named with the SKUs digitally. I have three questions for you though:

1. I have several pictures of the same product and have been naming them like this:  productnumber-sku-1, productnumber-sku-2, etc. Can you have the same sku on multiple images distinguish them with a 1, 2, 3. . for each individual image? Would that still work or is this set to specifically work with one image per product?

2. Have you developed this to work with windows?

3. If so, can I be part of the beta pretty please?

Shaun

[StitchShop]

Hi Shaun,

Happy to help.

I will answer your questions as numbered.

1. Shopify has items classed as "products" and "variant".
Products are essentially a grouping of variants, even if the product only has one. (they hide the variant details if only 1 exists).

Some rules that the Shopify structure has:

• The SKU is attached at the variant level.
• Variants can only have 1 photo linked to it
• Products can have mulitple images linked and include the Variant ones.

2. I only have a Mac version at the moment and looking to improve it based on workflows

3. Happy to have beta testers. I need to add authentication into the app so you can add your store details. This is a week or so away.

Cheers

John

[JonWright]

Hi @StitchShop I'd be happy to beta test it for you as looks really useful, I'm on a Mac and do a lot of messing around with images for Shopify.

[StitchShop]

Thanks Jon.

I will get back to you here.

Can i ask, how do you manage the photography process?

Are the products already in Shopify?

Where is the pain points for you?

I want to adjust my application to ensure it meets most photography processes. 

Cheers

John

[Brodieman]

John,

I truly appreciate the help. Or, the attempt I guess. I'm glad there is a great community to reach out to around here.

I was up burning the midnight oil and just went through the images manually. It didn't take as long as I thought but now I see Google Sheets cell boxes everywhere I look. o_0

Thanks,

Shaun

[RobMW]

THIS is the answer about Dropbox that everyone is looking for.

Instead of dropbox.com/sdgfdgdlfhg/gfdghdfh/hfdfgdh (whatever you get there), just replace the dropbox.com part with dl.dropboxusercontent.com

The one with dropbox.com opens a dropbox page from which you can do other things. dl.dropboxusercontent.com opens JUST the image

it seems you need to use:

https://dl.dropboxusercontent.com/

not https://www.dropbox.com/

[hverdagbasics]

thanks for sharing your thoughts. in my case the first option sounds do-able and closer to my requirements. 

---

@Allan wrote:

Hey, there!

Jason here from Shopify Support.

You're on the right track. There're two ways you can upload the images files in bulk.

The first method is through the Shopify admin > Settings > Files. Once there, click on Upload files on the top right corner, then you'll be able to upload the image files directly from your device to your admin. You can then use the images while you set up your store/product. For more detailed information, here's a helpful document going through how to upload image files to your store.

The second method is through a CSV file. The key to make sure that the files upload correctly is to follow the CSV format accurately. Here's a great document going over what content is required for each field. I've attached a sample template for you so you can take a look and make sure your Excel file complies with the format. If you wish to use the CSV method, the image files need to be uploaded to a publicly accessible URL first. This can be from the links you received after you use the first method or any cloud services, such as DropBox and Google Drive. Keep in mind the server needs to be at a decent speed. Otherwise, there's a chance you'll get timeout while importing the file resulting in import failure.

If you run into any issues, or if I misunderstood what you're hoping to set up, feel free to reply back here and I'd be happy to help out!

All the best,
Jason

---

[tresorsstrand]

Hi Jason, Can you make a simplier CVS file  for me to bulk upload pictures to shopify only?

---

@Allan wrote:

Hey, there!

Jason here from Shopify Support.

You're on the right track. There're two ways you can upload the images files in bulk.

The first method is through the Shopify admin > Settings > Files. Once there, click on Upload files on the top right corner, then you'll be able to upload the image files directly from your device to your admin. You can then use the images while you set up your store/product. For more detailed information, here's a helpful document going through how to upload image files to your store.

The second method is through a CSV file. The key to make sure that the files upload correctly is to follow the CSV format accurately. Here's a great document going over what content is required for each field. I've attached a sample template for you so you can take a look and make sure your Excel file complies with the format. If you wish to use the CSV method, the image files need to be uploaded to a publicly accessible URL first. This can be from the links you received after you use the first method or any cloud services, such as DropBox and Google Drive. Keep in mind the server needs to be at a decent speed. Otherwise, there's a chance you'll get timeout while importing the file resulting in import failure.

If you run into any issues, or if I misunderstood what you're hoping to set up, feel free to reply back here and I'd be happy to help out!

All the best,
Jason

---

[SilkenLily]

Does anyone know an easier way to upload images from Google Photo into the media libaray?

[Riana]

HI Jason

I followed these tips as well as the description in the Help Centre. I am trying to upload a product with 90 variants. I left the fields blank as described in the Help.

When importing, it told me that I am about to import 90 products....I thought I would go ahead and see what happens. 

The product uploaded (only one product, not 90), but only with the first variant. What am I doing wrong?

Thank you

Riana

[CraigHughes]

Hi,

I got this to work over the weekend, but made sure that I did the following…


1. Created / Imported the product using the Product bulk upload tool
2. Uploaded 1 image for each product the normal way through the settings/admin
3. I then had to create the file for the image as only the SKU number and _1. If I created anything longer, even if it included the SKU number, it wouldn’t match. So my image files are called 10000020_2, 10000020_3 etc

When I’ve made these changes – it works perfectly.

Thanks

Craig

[kgrammer]

We offer an image management tool that allows you to create buckets for your images, upload your Shopify bulk upload image files, and then auto-populate the image URLs in your template file.

Have a look at https://BucketLynx.com.

[JohnTNBC]

Jason -

I know this is an older thread. I had one follow-up question. I am using the second method that you suggested. The functionality works but the image is placed in the description area rather than in the variant area. How do I get it to be in the variant area and not in the product description area?

Thanks!

John

[rmanke]

You need to have the url of the image in the same row as the variant details for it to be attached to the variant.

I find the best way to make these types of adjustments is to have one product set up.the way you want in your store, and then export the csv of that product so you can use that to recreate the rest of the products.

[DCS111]

Is one method better than the other if you have a lot of images? I don't want to make my site slow to load, but of course I want to have tons of images available