Cannot import products without name field

[goddaj]

Hey guys, I am some-what new to Prestashop and have run into a brick wall, was hoping someone could point me in the right direction.

 

I have just imported 37,000 items, many of these items had names that needed to be modified (had weird characters, too long names, etc). This took heaps of time as you could imagine.

 

Now I am up to needing to update only three fields "Active, Price & Quantity", my CSV sheet only has ID, Reference, Active, Price & Quantity fields. When using import I get "no name (id: ***) cannot be saved." error.

 

I am sure there is others who have had the same issue, seems strange to force name updates. I am just looking for a work around where I will be able to update the fields I want without affecting the names.

 

Maybe there is a way I could merge details from one CSV file to another based on ID?

 

Any help would be appreciated. 

[w3bsolutions]

Merging fields from 2 CSVs that have a shared field can be done easily in Excel with the VLOOKUP function. 

Another option is updating the database directly. You can create the UPDATE commands since your CSV contains the id field. But if you don't have much experience with creating a merged CSV file you can import will be easier.