CSV Import Error: Line is not included in the list

[hi_kt]

I am facing an error as below on product import via CSV

Although these products already exist but I am trying bulk update of tags. For this from product page, I remove all the tags and then upload this product sheet (after exporting all the products and updating new final tags) in override mode. The error message is not very clear and I checked in the forum, others have got the error but no one posted the solution for the same.

• 107 products were modified
• 43 products couldn’t be changed due to invalid information

To import products that couldn’t be updated, fix any errors in the CSV file and try importing it again.

Failed:

• Line 18-25: is not included in the list
• Line 139-145: is not included in the list
• Line 279-285: is not included in the list
• Line 543-548: is not included in the list
• Line 549-554: is not included in the list
• Line 555-561: is not included in the list
• Line 562-568: is not included in the list
• Line 569-577: is not included in the list
• Line 578-587: is not included in the list
• Line 588-596: is not included in the list
• Line 597-604: is not included in the list
• Line 605-612: is not included in the list
• Line 613-620: is not included in the list
• Line 621-628: is not included in the list
• Line 629-636: is not included in the list

[hi_kt]

The problem got solved!! So basically few rows did have the handle but no variant (this would happen if no. of images is more). In that case, the row should not have any variant information on the row (as there is no variant). I was somehow putting the weight in that row leading to error. But how did I narrow it down to this? Read on.

Took me a while but I followed an approach which anyone in general can try if they are facing error via CSV upload.

I exported my existing products (the file would not have any formatting error) and made changes in that file and then analyzed what were the differences between the two files. if you are doing it for first time, you can add few products manually and then export it to learn the format better. This will always help.