Cannot import CSV file

Mad_Modeler
Explorer
87 1 10

I'm trying to import products via CSV file.

After inserting a couple of products manually, i exported that file as a template to add the rest of my products to.

On importing I get the following error[s]

 

The variant 'Default Title' already exists.

Line 2: You need to add option values for Title

Al of my products are singles with no variants for size, colour etc, so I'm perpplexed as to how it is raising these errors

Any idea's would be helpful

0 Likes
Mad_Modeler
Explorer
87 1 10

Managed to reseolve this following a chat with Cassidy in Chat

0 Likes
leathersatchel
New Member
1 0 0

Hi Mad,

 

Could you detail for us what was the solution, what did Cassidy recommend you do? 

0 Likes
Mad_Modeler
Explorer
87 1 10

If my memory serves me right.

This was because I was assigning handles to the products.

In the "Handle" column of the CSV you have to have a unique code, it can be anything (A123, A124, etc)

 

You may also want to know that in order to assign products to collections, you have to creat a colum called "Collection" in the CSV file, I do this next to the "Type" column.

TIP

Keep a master copy of your CSV file.

Brerak it down into smaller files, this will speed up the import process

When you export a product file it will not include the "Collections" column you created.

When uploading always make sure you check the "Overwrite" box or you will duplicate all your products, and if you have hundreds you will have to delete them one at a time, or delete them all and start again from your master CSV file

Any validation errors will stop a product being imported

 

Hope this helps

0 Likes