[ic] Importing Products Rounds Down Prices

cblevins at macronet.com cblevins at macronet.com
Sat Feb 17 15:36:42 EST 2007


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.  

I have verified this on two different servers:

Server 1
MySQL version 5.027
IC version 5.5.0-200612100658

Server 2
MySQL version 4.1.12
IC Version 5.4.0

This is my products.sql on server 1:
Database  products  products.txt __SQLDSN__
Database  products  KEY          sku
Database  products  HIDE_FIELD   inactive
Database  products  COLUMN_DEF   "sku=char(64) NOT NULL PRIMARY KEY"
Database  products  COLUMN_DEF   "description=varchar(128) NOT NULL"
Database  products  COLUMN_DEF   "title=varchar(128) DEFAULT '' NOT NULL"
Database  products  INDEX         title
Database  products  COLUMN_DEF   "template_page=varchar(64)"
Database  products  COLUMN_DEF   "comment=TEXT"
Database  products  COLUMN_DEF   "thumb=varchar(128)"
Database  products  COLUMN_DEF   "image=varchar(64)"
Database  products  COLUMN_DEF   "price=DECIMAL(12,2) NOT NULL"
Database  products  INDEX         price
Database  products  COLUMN_DEF   "category=varchar(64) NOT NULL DEFAULT ''"
Database  products  INDEX         category
Database  products  COLUMN_DEF   "prod_group=varchar(64) NOT NULL DEFAULT
''"
Database  products  INDEX         prod_group
Database  products  COLUMN_DEF   "nontaxable=CHAR(3)"
Database  products  COLUMN_DEF   "weight=varchar(12) DEFAULT '0' NOT NULL"
Database  products  COLUMN_DEF   "size=varchar(96)"
Database  products  COLUMN_DEF   "color=varchar(96)"
Database  products  COLUMN_DEF   "author=varchar(255)"
Database  products  COLUMN_DEF   "related=text"
Database  products  COLUMN_DEF   "featured=varchar(32)"
Database  products  COLUMN_DEF   "inactive=varchar(3) DEFAULT ''"
Database  products  COLUMN_DEF   "gift_cert=varchar(3) DEFAULT ''"
Database  products  COLUMN_DEF   "sub1=varchar(128)"
Database  products  COLUMN_DEF   "sub2=varchar(128)"
Database  products  COLUMN_DEF   "sub3=varchar(128)"
Database  products  COLUMN_DEF   "sub4=varchar(128)"
Database  products  NUMERIC      price
 
Thanx,
Carol Blevins



More information about the interchange-users mailing list