Import: "Missing column Add PRODUCT ID column" When the column is there

Right. This is ridiculous but it has just worked for me:

1. Don't use the Squarespace CSV template. It's not correct as far as I can see. Some of the instructions disagree with other instructions; such as entering categories .
2. Use Google Sheets - NOT Numbers and NOT Open Office (I can't say anything about Excel as I don't have it.)
3. Make a single product in Squarespace that matches what you want to bulk upload and which works.
4. DOWNLOAD that product from Inventory in Squarespace.
5. Bring it into Google Sheets.
6. Import your bulk product into Google sheets, placing it below the existing correct data.
7. Match everything up in the columns made by the working product. 
8. Remove example product from Google Sheets
9. Download the Google Sheets spreadsheet as a CSV
10. Import into Squarespace.
 

• You can leave the Product ID and Variant ID columns (the first two) blank as per SQSP instructions.
• The file that you downloaded (Step 4.) can be named anything. I uploaded all my products with a file called: "SquareSpace All Products - products_Feb-11_06-02-11PM.csv"
• When I uploaded this file back into SqSp, I confirmed in the dialogue box that I wanted to replace the existing file and it worked perfectly. By the way, by this time every product had automatically been given a Product ID and Variant ID. I added a new product that didn't have either IDs and it still worked.
• This all means that you can keep the products file up on Google and just add to it as you create products. You can bulk add tags or whatever info you need, just make sure you keep the format exactly the same.

Almost March 2022 and this glitch still exists 😕

I work with Excel. After going through all the solutions suggested in this thread, I confirm that using the Google Sheets workaround is the only way that worked for me.

Disappointing as I upgraded my plan to get that bulk .csv upload feature mostly...

Thank you!

This completely fixed my upload errors. I wish this was included in the instructions or the instruction video.

I used Excel and it worked just fine. Just had to make sure it is saved as a Comma Separated Values (.csv) format instead of the CSF UTF-8 Comma Delimited (.csv) format. Correct one highlighted below. 

I tried  all these suggestions, nothing is working yet.

It is been the same issue for years. Squares space unfortunately didn't fix this bug yet.

I was just having this issue and this thread helped me solve it. Anyone currently searching for help with this and is using NUMBERS on a mac, don't save your document and try to upload it. go to File > Export to > CSV...

simply saving it changes it to a .numbers file which is why you'll get the error. Hope this helps!

I know this is an old post, but I had a solution that ended up working for me.

The headers that are being used for the exports/samples are wrong. I had Product-URL as a header in my export and when I imported back into SquareSpace unedited, it couldn't find the missing column Product URL. I ended up removing the dash and it was able to import successfully. So verify that the missing header is matching. Hopefully this helps others!

For those who are still having the issue of “add PRODUCT ID column, here’s how I fixed it. 

I’m switching my art shop from 7.1 to the fluid engine. 

1. export the file from squarespace "inventory" (the original site)

2. "import" the file into Excel.

3. make all changes without removing anything except all the listing under PRODUCT ID & VARIANT ID - make sure everything under those 2 column are blank.

4. Save as (comma separated values) .csv not the .CSV UTF-8 (comma delimited) because it won’t work. 


5. Before you import the file to the site, add a listing (this something you’ll delete later) - make a fake listing with the basic information.

6. Then "import" the file to the squarespace inventory. 

PS: I did not change the name of the file saved.

Hope this helps others.

14 minutes ago, Ai-KonicGraphics said:

I’m switching my art shop from 7.1 to the fluid engine

Do you mean you're switching from a v7.0 site to a v7.1 site?

Yes. Sorry about that.

On 3/29/2023 at 8:25 AM, Ai-KonicGraphics said:

For those who are still having the issue of “add PRODUCT ID column, here’s how I fixed it. 

I’m switching my art shop from 7.1 to the fluid engine. 

1. export the file from squarespace "inventory" (the original site)

2. "import" the file into Excel.

3. make all changes without removing anything except all the listing under PRODUCT ID & VARIANT ID - make sure everything under those 2 column are blank.

4. Save as (comma separated values) .csv not the .CSV UTF-8 (comma delimited) because it won’t work. 


5. Before you import the file to the site, add a listing (this something you’ll delete later) - make a fake listing with the basic information.

6. Then "import" the file to the squarespace inventory. 

PS: I did not change the name of the file saved.

Hope this helps others.

This does work, but I'm in a situation where I ABSOLUTELY HAVE TO use the UTF8, because the descriptions that I put in the file are in a language that requires UTF8 and I am absolutely sure this used to work just fine, because I have a ton of products imported like that. 

So technically, this is a new issue right now, May 2023 and your solution (though it works) is not an actual solution, but rather a workaround of sorts. Hope someone fixes it soon. 

Thank you, implementing this was the only way I could move past the product id issue only to receive the '