McSherry
-
Posts
2 -
Joined
-
Last visited
Content Type
Forums
Gallery
Blogs
Events
Store
Downloads
Profiles
Posts posted by McSherry
-
-
The explanations coming from the administrator are not good enough. Thanks to those users above who've given their tips which are better set out than the official ones but none are working for me at present.
Import: "Missing column Add PRODUCT ID column" When the column is there
in Setting up your store
Posted · Edited by McSherry
additional info.
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.