[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