FROM CACHE - en_header

importing CSV client list keeps on showing error "Missing header: Email"

Solved
LaGirafeCouture
Tourist
5 0 1

Hello,

I am trying to import a CSV file of a customer list and I keep on getting the following message "Missing header: Email."

I checked and the header "Email" is in my CSV file which I built exactly as per the template provided by Shopify. 

Any idea how to fix this?

Thank you!

Accepted Solutions (2)

Accepted Solutions
channelup
Shopify Partner
655 34 142

This is an accepted solution.

Hi

Could you email the file to me and I can double check it? tom@channelup.io

It might be something to do with how the file is being saved but probably quicker to just have a look myself.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.

View solution in original post

channelup
Shopify Partner
655 34 142

This is an accepted solution.

Hi

Just to note it here if anyone else has similar issue. 

Semi colons were the culprit as they replaced the commas in the file that are meant to separate columns therefore the required headers were not being detected.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.

View solution in original post

Replies 13 (13)
channelup
Shopify Partner
655 34 142

Hi

I know you said it has the correct header information but have you tried using the example file to check if it successfully imports: https://help.shopify.com/en/manual/customers/customer-csv-issues#missing-header-or-missing-headers

If that one works then double check the file again and perhaps save it as CSV UTF-8 format and try reimporting. Let me know how you go.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.
LaGirafeCouture
Tourist
5 0 1
Hello,

Thank you for your reply.

I downloaded the template file provided by Shopify and I tried to import it. I get the same message « Missing header: Email »

Any suggestion please?

channelup
Shopify Partner
655 34 142

This is an accepted solution.

Hi

Could you email the file to me and I can double check it? tom@channelup.io

It might be something to do with how the file is being saved but probably quicker to just have a look myself.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.
channelup
Shopify Partner
655 34 142

This is an accepted solution.

Hi

Just to note it here if anyone else has similar issue. 

Semi colons were the culprit as they replaced the commas in the file that are meant to separate columns therefore the required headers were not being detected.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.
LaGirafeCouture
Tourist
5 0 1

Thank you so much Tom for going out of your way to fix my problem.

Issue fixed!

 

Andrea_Slater-S
Tourist
3 0 1

So, I definitely had the semi-colon issue (fixed in google sheets) but I'm still getting the missing header error. This is so frustrating. I didn't have this issue when I bulk edited products before.

channelup
Shopify Partner
655 34 142

Hey

If you need another set of eyes to have a look over it just send a sample over and I can double check it.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.
Andrea_Slater-S
Tourist
3 0 1

That would be most appreciated. Not sure how best to share a sample but happy to share the direct link, too?

I've dropped you a mail. Hope that's okay?

Tenera123
Excursionist
31 0 10

Hello Tom, 

 

I am having the same issue and could not manage to solve the issue...

channelup
Shopify Partner
655 34 142

Hi

Always double check the final file in notepad and see if the rows are set up correctly.

Another good idea is to download the Shopify template file and use the first row from that and add your data underneath it. If it still fails usually problem with how you are saving it.

If still no luck you can email it over. Just need the first couple of lines after header row so no need for full file.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
Get in touch with our team here.
edlep23
New Member
1 0 0

Hello i have the same probleme for the csv... the error is Missing header : email too, and i have already try to change in csv utf8 but it is the same, error again... excuse me for my english, im french ^^

 

nadiabiad
New Member
1 0 0

I first Opened the file as Text with notepad, i replaced the semi comas with comas and saved the file with utf-8 encoding, and it worked

Beardedpup
New Member
1 0 0

I’m having this exact same problem.  How do you edit any of it?? You’d think Shopify would fix this issue as it appears everyone has the same problem. I’m not a tech guy and I’ve spent 4 hours today trying to import my csv file and I’m still unsuccessful