Jump to content

Bulk importing images from csv links

By Davideesk, in Setting up your store

Go to solution Solved by paul2009,

Recommended Posts

Davideesk Level 1

Davideesk

Posted
Posted

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 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Posted Images

  • Solution
paul2009 Level 17

paul2009

Posted
  • Solution
Posted
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: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

Link to comment
  • 3 months later...
paul2009 Level 17

paul2009

Posted
Posted
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: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

Link to comment

Create an account or sign in to comment

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

Sign Up / Login
Go to topic listing
×
×
  • Create New...

Squarespace Webinars

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

Upcoming Webinars →

Hire a Designer

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

Get Matched →

Support

Community

Developers

Resources