Cannot Upload .csv Files using Store Importer

Solved
archer223
Tourist
15 0 1

I am trying in upload customer data in csv format from squarespace to shopify using store importer app as stated the link below:-

Migrating from Squarespace to Shopify · Shopify Help Center

However I keep getting error message

The following file(s) could not be added:

  • Shopify.csv couldn’t be uploaded because it is not a recognized file. Ensure you’ve chosen the correct file or learn more about which files can be uploaded.

I do not know what is going on 

0 Likes
peterloane
Excursionist
25 2 9

Can you open the .csv file with something like Notepad++ (or even Excel)?

0 Likes
archer223
Tourist
15 0 1

I created the .csv in excel 

0 Likes
peterloane
Excursionist
25 2 9

If you did not export the data from Squarespace as outlined here 

https://help.shopify.com/en/manual/migrating-to-shopify/shopify-import/squarespace-migration#step-1-...

then it looks like you need to use the templates provided at the link, for example for Customer data 

https://help.shopify.com/en/manual/customers/import-export-customers#customer-csv-template to import customer data.

I recreated the error you got by creating a simple .csv file in Excel and trying to import it with Store Importer, so its looking for a particular file content format.

I then used the customer template linked above, added an extra dummy customer and it imported all three customers without issue with Store Importer.

 

0 Likes
channelup
Shopify Partner
242 11 30

This is an accepted solution.

Hi

In Excel try saving the file as CSV UTF-8 not the standard CSV format. Then test again in Shopify.

Another way people fix file format issues is by saving it in Google Sheets and then exporting it to csv format.

Regards

Tom

Channelup is a product data management solution helping Shopify stores automate their processes.
If you require custom development or would like to test out our features contact me at tom@channelup.io
archer223
Tourist
15 0 1

Thank you so much for that. It worked