How can I bulk upload images for product import?

[StitchShop]

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

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

@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

[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

[tresorsstrand]

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

@Allan

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]

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

Can this be done ? Jennifer

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

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

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

[SilkenLily]

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

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

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