Import Csv using reference as key does not work

[Dunald]

Hi!

I need to update 5000 products using a Csv import but as my references looks like this Or-baoba-123456DD etc

the import doesn´t work. I can only have a reference without - and without numbers.

But I need the reference to look the way it does.

 

How can I update my prices?

I use a EAN as ID so all the ID´s are unique , I want to be able to import only ID,quantity,price

 

I also do not want to import the name of the products since I have changed them all and it took forever.