Jump to content

Import in Bulk products give's a specific error: add Product type column

Recommended Posts

3 minutes ago, Bymygo said:

No matter what I try I get this error message: add product type column. 

Your CSV file requires a Product Type column and for each product you will need to specify whether it is a Physical or Service product. 

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

Did you try using the template they provide? Add a single product to it and test the process so you are familiar with it. If this works, you’ll know the template is ok and you can add further products. 

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
  • 9 months later...
On 11/29/2022 at 12:43 PM, Bymygo said:
Solved. 
Thanks Paul. 

How did you manage to fix it? I downloaded their template and tried to upload it into my shop,... even their .csv shows an error.

- I tried it with Google Sheets (no luck)
- I tried excel, but again nothing 
- Tried Numbers - also no luck

I copied and pasted from each program to another, and deleted PRODUCT ID and VARIANT ID away, (recommended from another article) again with no luck.

Have no clue what else to do,... I have to upload at least 150 products online, and doing it one by one is taking too much time. Please HELP!!!

Link to comment
1 hour ago, Maddox_ said:

and deleted PRODUCT ID and VARIANT ID away,

I've never deleted those columns. Just leave the cells blank and SS fills in the info for you.

I have an example file that I use for testing. This one has variants.

https://docs.google.com/spreadsheets/d/1qD3udQ1AYqxqFDn3QFoAm_1zfvdkwrek7punK0tGjeU/edit?usp=sharing

I suggest you get an import working with it. Then get a couple of items importing from your data. Then once you have a couple of yours importing, move onto the rest.

Let us know how it goes.

Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.

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.