All things Shopify and commerce
Can someone help me format my product csv file so I can import it.
I keep getting the - Unquoted fields do not allow new line <"\r\n"> in line 1.
Check this thread: https://community.shopify.com/c/shopify-discussions/csv-error-unquoted-fields-do-not-allow-new-line-...
It's either you are missing a header low or there are some left-overs from the previous source
Thanks for the discussion reference but i have tried that and its not helping
Hello,
It looks like your handle column is missing a header. The very first column does not have a header. Also, some of your headers are on the second row instead of the first. Are you just trying to upload new products?
Yes i am trying to import new products
I changed the file changed the header and made some adjustments and I am still getting the same error when importing the CVS file
Shopify has its own headers that need to be used to upload the products. The easiest way to get a template for this is to manually create 1 product and then export that product as a CSV. Once you do this it will download the CSV to your browser. All the headers in that CSV are the ones that can be used with Shopify. The Title and the Handle header are required by Shopify so don't feel like you need to use all of them. One thing to keep in mind about the handle is that it is not just the Key/ID for the product, it is also the slug (used in the browser). A great handle name is the keywords associated with the product (typically the title of your product). Google uses this information for SEO purposes.
Sorry for the information overload here but wanted to let you know just incase this is something you cared about and wanted to implement. Another thing I noticed with the column K is your EAN is all the same number. Anytime you see something like 4.75E+12 or 4.75E+11 you want to make sure before you save that you highlight that column right click > format cells > select 'number' > and change the decimal place to 0 (then save).
Attached is the Shopify header names.
2m ago Learn the essential skills to navigate the Shopify admin with confidence. T...
By Shopify Feb 12, 2025Learn how to expand your operations internationally with Shopify Academy’s learning path...
By Shopify Feb 4, 2025Hey Community, happy February! Looking back to January, we kicked off the year with 8....
By JasonH Feb 3, 2025