Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Unable to import CSV file with new products

Solved

Unable to import CSV file with new products

Lyt35
Tourist
7 0 1

Hi,

 

I try to import products in our new Shopify webshop, but we keep getting the error "Invalid CSV header: missing headers: Title" (Free translated from Dutch) The file is a CSV (UTF8) and all the headers are still in the original file I downloaded from Shopify. I tried a lot of different ways but I can't fix it. Is there anybody who can help me with this problem? 

Accepted Solution (1)

Alok_Kasgar
Shopify Partner
112 26 28

This is an accepted solution.

Hi @Lyt35 

Go to google sheet and create new sheet

paste your all data here and download as a csv file then try with shopify

Alok Kasgar
If helpful, please Like and Accept this Solution to help others too | Email: alokasgar@gmail.com

View solution in original post

Replies 8 (8)

saim007
Shopify Partner
609 74 103

@Lyt35 Can you please attach CSV file here so I can check.

Saim | Shopify Partner Expert

Was I helpful?

Buy me a Coffee

🙂
Hire me   to unlock the full potential of your e-commerce store 🙂
Lyt35
Tourist
7 0 1

Hereby the file. Thank you in advance for checking it! 

saim007
Shopify Partner
609 74 103

@Lyt35 Please use attached csv file format for product importing.

 

Please let me know if works and like mark as solve!

Saim | Shopify Partner Expert

Was I helpful?

Buy me a Coffee

🙂
Hire me   to unlock the full potential of your e-commerce store 🙂
Lyt35
Tourist
7 0 1

Thanks Sandy, import of this sheet works, but it's not an file I can edit by myself. If I open it in Excel as a CSV UTF8 and import it again I get the same error message. So this is not the solution for me.. 

simon-skrod
Shopify Partner
150 12 31

Hi@Lyt35 ,
From file you attached previously, it seems like tool you are using to edit csv files is configured to save files with semicolon delimiter, while it should use comma.

When you save files make sure you save then using comma delimiter, if you use microsoft office, you will have an option so save file as "CSV (Comma delimited) (*.csv)".

Simonas Skrodenis
Developer of Feeds Bridge - Catalog Management System
Email: simonas@feedsbridge.com
Lyt35
Tourist
7 0 1

Hi Simon,

 

I tried, but the strange this is when I open the file in Notepad ++ again it shows the semicolon again instead of the comma. I tried it in Google Sheet now and it's working. Thanks anyway!

Alok_Kasgar
Shopify Partner
112 26 28

This is an accepted solution.

Hi @Lyt35 

Go to google sheet and create new sheet

paste your all data here and download as a csv file then try with shopify

Alok Kasgar
If helpful, please Like and Accept this Solution to help others too | Email: alokasgar@gmail.com

Alok_Kasgar
Shopify Partner
112 26 28

Hi

This is alternate solution. PFA sample csv file 

You can put your product data in this sheet and upload to new store

Alok Kasgar
If helpful, please Like and Accept this Solution to help others too | Email: alokasgar@gmail.com