[ic] Importing Products Rounds Down Prices

ic at 3edge.com ic at 3edge.com
Sat Feb 17 15:45:45 EST 2007


cblevins at macronet.com writes: 

> When importing products.txt to my MySQL IC database prices are being rounded
> down from 11.95 to 11.00.  If I change the price via the Admin interface it
> imports correctly.  I am uploading the initial products file with a bit over
> 2000 products so it really is not a viable option to update all the prices
> via the admin interface.  Should I be changing COLUMN_DEF "price=varchar" in
> products? I have searched the list and found a few posts but no real
> solution.  Any help with this would be greatly appreciated.  

Have you tried changing your decimal . to a , or vice versa? 

CU, 

Gert


More information about the interchange-users mailing list