Product price changes after Import CSV, why?

Hi,
I import all my Products by CSV. Titel, Discripcion, price etc etc, all was fine, then i export my products to add further information, like Brands and Categories. But when i import my new file back all my prices are changing from 79,95 € to 7.995,00 €, 112,95 € to 11.295,00 € Waht is happend, why all my prices are chaning and where is the error. And at least, what can i do the fix the problem. Unfortunately, I haven't got the original csv anymore and i don t know how to fix it in exel. Can anybody please help .) I hope i do not need to do everything oncemore.

Sincerely
Alexandra

Ok Thank You .)

Hi Nicolas,
I think there is anything wrong, with my prices.. When i edit my prices it change also my prices, i must be able to work on my prices without problems. Then the next problem is, i uplaod my file with the corrected prices and exactly this roducts i lost now. they just aren't there anymore. There is anything wrong. it's not just the file, also the editing does not work. Please have a look, whats happend there. I always (many years) work with files for changing things on my Products, i never had theese problems before. Working with files in exel and editing this has to work. I can send you the file, please let me know, where i can send it.
Sincerely
Alexandra
Please let me know where i can send you the files, because with every export the file changes without i making any changes.

Hi Nicolas,
Thank you for your fast answer and i send you the error file by mail.
Meanwhile i have made and uploaded a new file (products)
I don t know where the error is. Maybe you're right, and it's exel.
Sincerely
Alexandra

Hi Alexa,

to get the price right uploading excel sheet.

You have to check on Hikashop--Configuration on the "main tab" scrolling down to "Files" (archivos) and put as field separator "point and coma" and as "CSV decimal separator" just "coma"
Now you can download the product sheet in excel BUT YOU HAVE TO IMPORT AS A TEXT FILE IN EXCEL. (don't forget to put coma as a separator when you import the csv file. When you are finished save as "csv file separated by commas" AND choose from TOOLS "web options" and got to the codification tab and choose from "save this document as" the "Unicode (UTF8)" and check the box below.
If you have any question you're welcome

Regards Nico