News:

Support the VirtueMart project and become a member

Main Menu

Product price import

Started by Gohan_79, October 31, 2012, 13:52:48 PM

Previous topic - Next topic

Gohan_79

I updated to the newest version of VM 2.0.12f And noticed something while importing product's to sql table. Only the whole price was updated for example if I import product a with the price of 13,82 It only shows 13.00. Could this be somehow related to the comma we use with Euro? I checked that the currency settings for Euro are correct there are 2 decimals and a comma as decimal separator. (Even attempted to create a new currency, but that didn't help)

Somehow when trying to import multiple products and using the comma as decimal separator VM leaves out the cent information. I tested that if I would replace the comma with a period it works but, I have to update several hundred items daily so replacing the comma from every entry with a period is not my ideal choice. Tryed to write a excel macro that would replace the decimal but that didn't work. Would anyone know if this could be fixed and how?

I'm pretty new at VM and even newer with anykind of programming... :(

Thanks for your help in advance.

PRO

Gohan_79,

do you have CSV improved ?

Gohan_79