Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Using CSV to bulk upload images


Recommended Posts

Site URL: https://dressupandparty.squarespace.com

Hi,

I'm fairly new here but here goes, hope you can help!

I am setting up a store which has approx 3000 products in. I have a large spreadsheet of every single product in, and from the supplier, three image files for each product. I am trying to find a way to bulk upload the images for the products in a far quicker way than copying and pasting 3000 links into the spreadsheet.

For example: Image file name is 12345.jpg currently stored locally, but I need to host it to be a link.

I need a link that is for example www.website.com/anything/12345.jpg. In my spreadsheet I can format the cell to have "www.website.com/anything/*TEXT*" which means I could process ALL links in the sheet at once, as long as they all follow that formula with the image filename at the very end.

Is there an easier way to do this? I have found a website that works in a similar way, but when I tried it it wouldn't work properly. Dropbox for example adds a jumble of characters in the web address so this won't do. I'm really struggling to figure it out! I've tried google drive, dropbox, flickr, even squarespace's own static addresses but these still add a jumble of characters!

Please let me know if you can help!

Thanks,

Brendan

 

Link to post
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...