Jump to content

Bulk importing images from csv links

Go to solution Solved by paul2009,

Recommended Posts

Hello, I am in the process of migrating my dad's web store from Magento to SquareSpace. I am trying to see if I can bulk-import his catalog with the images included.

I created this test csv file, and it almost works besides the Hosted image section.

Product Id,Variant Id,Product Type,Product Page,Product Url,Title,Description,SKU,Price,Sale Price,On Sale,Stock,Categories,Tags,Weight,Length,Width,Height,Visible,Hosted Image URLs
,,Physical,shop,star-wars-solo-hobby-box-24-packs,Star Wars Solo Hobby box 24 packs,"Topps Star Wars Solo: a star wars story 24 pack hobby box, with 2 hits including 1 auto or sketch card guaranteed.",887521069972,79,,No,1,Non-Sports/Star Wars,,,,,,Yes,https://www.oldtimehobbies.net/pub/media/catalog/product/2/0/20200124_133103_2_.jpg

This is the link to the image: https://www.oldtimehobbies.net/pub/media/catalog/product/2/0/20200124_133103_2_.jpg

The only error I get is:

Row Error
2
Categories not assigned
Try assigning these categories manually

The image does work if I upload it to imgur. I get the same error as above. This is the link to it: https://i.imgur.com/3MesYWu.jpeg

Untitled.thumb.png.b3ac3fb26967e97e690eb6648f539f9e.pngNow I don't want to upload 988 images to imgur individually. Is there anything I can do to fix this?

Link to comment
  • Replies 5
  • Views 2k
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution
12 hours ago, Davideesk said:

I am trying to see if I can bulk-import [my dad's web store] catalog with the images included. I created this test csv file, and it almost works besides the Hosted image section.

I cannot explain why the image URLs are not being processed. The image URL is valid. The CSV content is valid. Everything appears to be correct, so the importer should either import the image correctly or show the following error - which it doesn't!

image.png.7bd6fb9faa9c4deb38cd1d9129322ea2.png

I recommend that you reach out to Squarespace Customer Care directly about this. You may get some pushback initially ("we don't troubleshoot CSV files") but as the importer is not showing an error, something is amiss. I've tested this too and can see that it isn't attempting to use the image URL. If they provide you with a solution or workaround, please post it here for the benefit of other users. 

Did this help? Please give feedback by clicking an icon below  ⬇️

About me: I've been a SQSP User for 18 yrs. I was invited to join the Circle when it launched in 2016. I have been a Circle Leader since 2017. I don't work for Squarespace. I value honesty, transparency, diversity and good design ♥.
Work: I founded and run SF.DIGITAL, building Squarespace Extensions to supercharge your commerce website. 
Content: Views and opinions are my own. Links in my posts may refer to SF.DIGITAL products or may be affiliate links.
Forum advice is free. You can thank me by clicking one of the feedback emojis below. Coffee is optional.

Link to comment
  • 3 months later...
20 minutes ago, Bitmvr said:

Based on my understanding, in 7.1 the Categories must be created first before uploading.

The image upload issue wasn't related to categories. 

About me: I've been a SQSP User for 18 yrs. I was invited to join the Circle when it launched in 2016. I have been a Circle Leader since 2017. I don't work for Squarespace. I value honesty, transparency, diversity and good design ♥.
Work: I founded and run SF.DIGITAL, building Squarespace Extensions to supercharge your commerce website. 
Content: Views and opinions are my own. Links in my posts may refer to SF.DIGITAL products or may be affiliate links.
Forum advice is free. You can thank me by clicking one of the feedback emojis below. Coffee is optional.

Link to comment
  • 3 months later...

Just as an FYI, I was also unable to get images to work in bulk import via csv. I reached out to support (thanks for the link above!), and they verified that it's a bug and said the only workaround is to manually upload images individually. They are unable to provide any timeline for addressing it. Davideesk, I'd really love to know if you reported it to them back in February when you posted this - if so, I'll know I shouldn't wait for a fix!

Link to comment
15 hours ago, creedon said:

It's telling me I don't have permission to see this content, unfortunately - but thank you for the info! It's helpful (albeit incredibly frustrating) to know they will probably not fix it quickly. I have over two thousand products to import and part of the reason I went with Squarespace was because they claimed I could do it in bulk. At least the data import is working for me so far.

 

 

Link to comment

Create an account or sign in to comment

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


×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.