Trying to Upload CSV file and i can't find a problem

Trying to Upload CSV file and i can't find a problem

SummitSprout
New Member
4 0 0

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.

Replies 6 (6)

K_Br4
Pathfinder
83 5 14

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

SummitSprout
New Member
4 0 0

Thanks for the discussion reference but i have tried that and its not helping

beauxbreaux
Shopify Partner
294 25 59

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?

Beaux Barker
Developer
Buy me a Coffee
SummitSprout
New Member
4 0 0

Yes i am trying to import new products 

SummitSprout
New Member
4 0 0

I changed the file changed the header and made some adjustments and I am still getting the same error when importing the CVS file 

beauxbreaux
Shopify Partner
294 25 59

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.

Beaux Barker
Developer
Buy me a Coffee