[ic] Importing Products Rounds Down Prices

Cameron B. Prince cplists at princeservices.com
Sat Feb 17 23:37:22 EST 2007


Hi Carol,

Glad it fixed it for you... As best I can recall from looking at the source
code, the NUMERIC option is only used for sorting in the admin. The client
has been running without it for almost a year now and hasn't complained of
any problems caused by its removal.

Cameron

> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-users-
> bounces at icdevgroup.org] On Behalf Of cblevins at macronet.com
> Sent: Saturday, February 17, 2007 3:53 PM
> To: interchange-users at icdevgroup.org
> Subject: RE: [ic] Importing Products Rounds Down Prices
> 
> Cameron,
> 
> Thanx!  That did the job.  Were there any ramifications to doing this?
> 
> Regards,
> Carol
> 
> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of Cameron B.
> Prince
> Sent: Saturday, February 17, 2007 4:04 PM
> To: interchange-users at icdevgroup.org
> Subject: RE: [ic] Importing Products Rounds Down Prices
> 
> Hi Carol,
> 
> I identified this problem last year along with a temporary fix described
> in
> my original post here:
> 
> 
> 
> 
> Hey guys,
> 
> I recently moved a customer over and shortly after was informed of a
> problem
> where all the product prices had the cents stripped off. A price in the
> products.txt of 17.99 was showing up in MySQL as 17.00.
> 
> This is IC v4.8.5, MySQL v4.1.16, perl v5.6.2 and the latest DBI and
> DBD::mysql.
> 
> I reimported the table several times and verified this was happening each
> time. I did a describe on the table and found that the price column had
> not
> been modified from the default foundation catalog:
> 
> | price         | decimal(12,2) |      | MUL | 0.00    |       |
> 
> To further test, I setup a standard catalog using IC v5.4.0 and copied the
> products.txt file over and imported it. I had the same problem.
> 
> So I begin troubleshooting by dropping the product rows from 29,000+ to
> 1,000. I still had the same problem. I edited the
> dbconf/mysql/products.mysql file and removed:
> 
> Database  products  NUMERIC      price
> 
> Once I imported again, the prices were correct. Just as a sanity check, I
> put the line back in the dbconf file and imported again. The problem
> reoccurred. There appears to be a bug in the import function.
> 
> I recall seeing code in the admin pages or source in the past that used
> the
> NUMERIC directive to control sorting I believe. Are there any other
> ramifications I should be aware of by removing it from the dbconf file?
> 
> Thanks,
> Cameron
> 
> 
> 
> 
> 
> > -----Original Message-----
> > From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> users-
> > bounces at icdevgroup.org] On Behalf Of cblevins at macronet.com
> > Sent: Saturday, February 17, 2007 2:37 PM
> > To: interchange-users at icdevgroup.org
> > Subject: [ic] Importing Products Rounds Down Prices
> >
> > 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
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users at icdevgroup.org
> > http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users



More information about the interchange-users mailing list