Jump to content

Shopify Product CSV Import Not Working

Go to solution Solved by JudyD,

Recommended Posts

Hi! I am mocking up a Squarespace site for a client who currently uses Shopify. I don't want to spend time moving over products manually/individually when this is just a demo site to show her what Squarespace can do. I am trying to use the product import by downloading a group of sample products from Shopify but every single time I go to import into Squarespace it gives me an error message to check formatting. I am going through the Shopify specific csv upload, so not sure what is up! Plus, if she does end up moving over to Squarespace, it would really sell her on it if I could just take the whole store and import it over. Thanks!

Screen Shot 2022-02-14 at 1.23.31 PM.png

Link to comment
  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

On 2/14/2022 at 9:23 PM, destinyestringer said:

I am trying to use the product import by downloading a group of sample products from Shopify but every single time I go to import into Squarespace it gives me an error message to check formatting.

It's virtually impossible for us to offer any additional advice without access to the CSV file.

The Shopify specific import is usually straightforward so if it isn't working, I recommend looking through the CSV file to see if there are any obvious issues. This guide covers the steps: Importing products from Etsy, Shopify, and Big Cartel - but you're probably aware of this.

Edited by paul2009

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

I cannot see any issues with the format. I tried another Shopify CSV and saw the same error. Looks like an issue that will require help from Customer Care.

Edited by paul2009

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...
  • 7 months later...
  • Solution

After much trial and error I figured it out. It will import it you create and title the columns the same as the squarespace product export. 

So, I had to add about missing columns.

Product ID [Non Editable]    

Product Type [Non Editable]    

Product Type [Non Editable]    

Product Page    

Stock    

CATEGORIES    

Visible

On Sale

Product URL (copy product title and slugify it with dashes)

Weight

Width

Length

Height

Then change these:

Variant sku - change to SKU

Variant price - change to Price

Image URL - change to Hosted Image URLs

IF you are uploading as generic CSV it will give you all of these changes as error codes. 

Then for good measure I uploaded as a shopify csv file.

 

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.