How can I bulk upload images for product import?

[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?

[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

[rmanke]

If your theme template is done properly, the number of images shouldn't make any difference because they are "lazy loaded" which means they are only loaded when they appear.  You don't have to be concerned with that on most templates.

[KonoHome]

I've loaded products (thousands) using CSV file through Matrixify but all without images. I have images in a separate folder. I've uploaded the images through admin settings in files named via the SKU numbers. Now I am wondering, is there a way to bulk upload images to the matching product? Or will I have to continue to do 1 by 1? Or copy and paste the link 1 by 1? Both are lengthy 

[iceesocial]

We  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. In order to use it you’d have to upload the images to Dropbox but then the app could match everything by SKU. Once you did this bulk import you could continue to use Matrixify and our app and you’ll never have to upload images one by one.

Happy to answer any questions. 

[Renars]

Hey @KonoHome 

Renars here from Matrixify.

If your image's names are SKUs and already are uploaded to Shopify Files, then you sure can construct a file in Excel with formulas that would import your Images to Products.

All images in Files would have the same URL apart from the actual image name.
Here we do have a great tutorial explaining how you could set up such an import file - https://matrixify.app/tutorials/bulk-import-images-shopify-from-computer/#HowtogetURLsforuploadedfil...

The tutorial explains a general idea on how to do that which should be simple enough if image names are SKUs.
If you need further assistance with it, please reach out to us directly and we will help you with that! 

[OluendEN]

File upload via CSV is a nice feature, but how can we delete these files? They do not show under Files. 

When changing products images, not deleting these files could result in storing a lot of useless files (100,000-200,000 initial image files after some time could easily become millions).

Doesn't this big number of images slow down the store?

Is there any native way to delete these csv-imported images?

[Renars]

@OluendEN Sorry about the late reply.

Product images indeed do not show up in Shopify Files. They are removed from Shopify CDN as the image is removed from the product or the product is deleted.

So you do not need to make any other actions to specifically delete images from the server.

[George_C]

In order to bulk delete image files from products, you need to use the Shopify CSV upload feature for Product listings and delete the spreadsheet rows with the images you want to remove. 

I noticed in Matrixify that they have a way to specify File deletions in their CSV upload template, but not sure if they have something similar for Product images. 

[George_C]

Yes Matrixify does do image deletion (and more) via CSV for Products. 

[Renars]

@George_C 

Yes! You sure can only delete specific images if you wish.

This is done by using the `Image Command` column.

For each image in the `Image Src` column, you can set what the app should do with it. So you can set images that you wish to delete to value `DELETE` in the `Image Command` column for that row.

You can also set `Image Command` to `REPLACE` in all rows and only list new images. Then the app will delete all existing images for that product and only add ones from the file.

In our documentation, you can see more details about how Matrixify `Image Command` column works.

[Edward-Newgate]

Hi @albshop 

You can upload images through CSV files. This guide will instruct you on how to do it.

[tresorsstrand]

Jason, I just want a simply CVS file to paste images in to upload to shopify. 

Can this be done ? Jennifer

---

@albshop wrote:

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?

---

[StitchShop]

Hi Jennifer,

Yes it can be done,

you just need a place to store your images that Shopify has access to.

If you use Dropbox you need to replace the link domain

from:

https://www.dropbox.com/

to:

https://dl.dropboxusercontent.com/

I hope that helps.

[movsumov]

I see it is an old question but I would like to add a reply for the people who are coming to the topic from Google.

We recently created a Shopify App which is solving this problem.

This app can save you a lot of time by automatically uploading all your product images from Google Drive to your products.

Your product images should be names the same as the SKUs of your products. Then it will take just a few minutes to upload all images at once.

We have a free plan take a look into it. https://apps.shopify.com/smart-image-upload 

[Morten1919]

Hey @movsumov, 
We have been using smart image upload with G drive. Any chance that you will adding Onedrive and Dropbox to options?

[StanJewellery]

Try this app https://apps.shopify.com/pics-io-import-plugin , works for any number of images, integrates quickly with your Google Drive (100 images upload limit during trial, keep that in mind). 

[movsumov]

Automating the image upload process is possible using the Smart Bulk Image Upload app. If your image names contain SKU, you can easily upload all your images from Google Drive to products automatically.

[rmanke]

That's way too expensive of an app.