I am trying to import a list of only 4 products (so far that was all meant to be as a test). I am using three of my already existing pructs as I am downloading a .csv export open it within excel, add another line with very simple information of the 4th product. Afterwards I am trying to upload the .csv flatfile but it always shows me the following error message:
The header exists (I left it out and filled it back in only to try), the formating of the data is correct, as well as the .csv is saved as UTF-8. I feel like being within a loop trying over and over again and would appreciate your help.
To all the Gurus out there: Yes the header has the correct form which is why I am not sure if that error message is the correct one.
Happy to help get this looked into! Would you mind uploading your CSV file to Settings/Files, then posting the URL that is created in a reply below? This way, I can test the CSV on my side and properly troubleshoot the errors you’re seeing.
Reviewing the CSV file, nothing pops out at me that would explain why you’re getting that error. In most cases, when a CSV file looks near perfect, and you still get an error then it’s almost always a formatting issue. I copied and pasted the contents into a new CSV file which seemed to fix the problem as I was able to successfully import the file to my test store without any errors. You’ll find the CSV I tested with here.
thanks a lot for your help! I tried to keep it as simple as possible to check the functionality. It makes total sense to me and I am very happy about your super quick solution. Are you using a spreadsheet-software to handel your .csv’s, like excel?
We wouldn’t recommend using Excel tends to change characters when saving to CSV format, which can cause issues with importing the file to Shopify. I use Numbers (available for Apple devices); however, you can also use Google Sheets if you don’t use an Apple device.
As I am trying to upload my file it shows the following:
Illegal quoting in line 11. (When I delete line 11, and upload again it shows illegal quoting in line 7)
Selected column types Ungültiger CSV-Header: Fehlende Header: Title
I tried what you mentioned but it is not helping. I think my settings are alright. I received that file from my wholesaler, so the file should also be alright.
Can I ask Shoppify administrator for help inthis case? Im new to shopify and usinfg this Community for the first time.
If the file is provided to you by a wholesaler, then there is a good chance that it won’t fully align with what our system requires in a CSV file. I’d recommend downloading our CSV template here and reviewing our detailed list of required columns here. If you’re still having issues with your file after reviewing the template and required columns, then feel free to post a few screenshots of your CSV file (including the titles of the columns), so I can take a look!
If the handle is different for every product, then our systems treat the product as a standalone product. Meaning that if you then have values in Option 1 Name & Option 1 Value, it will cause an error. The errors the CSV file generates are:
Line 2: Validation failed: You need to add option values for color
Line 86-87: Validation failed: The variant ‘Default Title’ already exists.
These directly connect to how you have your option 1 name and value options setup. You will need to remove the values in these fields or set up the options correctly to resolve the errors you’re seeing. I’d recommend reviewing our CSV help doc here for further insight on the columns and what they require.
Other error messages to note:
Line 109: ignored because handle vol-1meetmattehugheslastin already exists.
Line 112: ignored because handle petaltothemetal-shiftinto already exists.
Line 138: ignored because handle ro-09-ro-60 already exists.
You can see these in the email that is sent to you after the CSV has imported.
If you’re still getting errors once you’ve fixed the Option 1 Name and Option 1 Value columns, then let me know by replying with the errors provided to you via email so I can take a look!
The CSV you have linked is empty, so I am unable to review the issue further. With that said, the error you are seeing could be a formatting issue. I’d recommend downloading the CSV template here, then copying and pasting everything into the new sheet and trying again. You will want to ensure that the headers remain the same, as shown in the template.
same issue here, and tried asking via chat and email, and one Shopify Guru named Taylor did not help at all. She’s addressing the problem that I was asking her in the first place… I got so confused >_<
anyhow I tried exporting my products, editing the csv file using Numbers, export with unicode UTF-8 format and import back to Shopify
but still getting the same error message:
"There was an error importing your CSV file. After you fix the error, try importing the CSV file again.
It looks like it is a formatting error. I copied and pasted the contents of your CSV into a new CSV, which worked. You can download the CSV I used here. Though, I will save you the trouble of importing that file and provide the errors of your CSV below.
Line 2-7: Validation failed: You need to add option values for Size
Line 8-15: Validation failed: You need to add option values for Size
The variants you have set up are incorrect. When adding “Option 1 Name,” you then need to add the first variant option in “Option 1 Value” and not on the next line as you have it below. You also have “Title” and “Default Title,” followed by variant options, which will cause your products to import incorrectly as you have not classified the correct name and value.
While the system only shows two errors, once you fix those lines, you will be greeted with further errors for the same reason throughout your CSV sheet. You will want to fix each product to save yourself time.
Can you confirm that you have reviewed the previous posts, and ensured those steps are resolved? If you’re still facing issues with the CSV file after going through those steps, then please provide access to the CSV file you’re using so I can review it further. If you do not feel comfortable providing the file in a public forum, let me know as I can reach out to you via email to obtain the file.
