Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 12-20-2011 14:09:19

Dave4Showcases
Member
Registered: 03-24-2011
Posts: 12

Regular Price Being Rounded

I'm having a problem with the Regular Price being rounded to the nearest whole dollar, for example .99 is being changed to 1.00.  This isn't just happening in the display, the actual database entry is being changed.

Initially the site was set for all of the items to have volume based pricing, so I'm not sure how or when this problem first surfaced. 

Also it is worth mentioning that I did not do the initial setup for the site, I only inherited the day to day maintenance of it.

I've searched the forum and can't seem to find anything to help me with this.  Can anyone piont me in the right direction?

Offline

 

#2 03-19-2012 09:35:25

Dave4Showcases
Member
Registered: 03-24-2011
Posts: 12

Re: Regular Price Being Rounded

Bringing this back to the top.  I'm still having this problem.  Does anyone have any idea on what could be causing it?

Offline

 

#3 03-20-2012 07:53:29

salesdesk
Member
Registered: 07-03-2008
Posts: 147

Re: Regular Price Being Rounded

It sounds like you changed the column type for the regular price field from a VARCHAR to an INTEGER.

Offline

 

#4 03-20-2012 10:29:55

Casimiro
Member
Registered: 01-25-2010
Posts: 175
Website

Re: Regular Price Being Rounded

Same thing happened to me after I installed a mod.  I don't recall exactly how it was resolved but it was along the lines of what Jeff mentioned.

Offline

 

#5 03-23-2012 14:23:07

Dave4Showcases
Member
Registered: 03-24-2011
Posts: 12

Re: Regular Price Being Rounded

Thanks for the feedback.  It looks like this is what happened.  Now the next question I have is how can I change it back to VARCHAR?

Offline

 

#6 03-23-2012 14:30:44

cyberws
Member
From: Atlanta, GA
Registered: 02-05-2004
Posts: 756

Re: Regular Price Being Rounded

If you have access PHPMyAdmin you can visit that table and then when viewing the structure of the table click on edit for that column and from the drop down list select Varchar although you'll need to enter a number.  I don't run v7 so unfortunately I can't say what it was before.  However varchar 10 should be fine as that would allow up to seven places out with a dot and two numbers after.  ie 9999999.99 max.

The other option is run the sql query using the raw database admin function in CCP.  While I could generate the query I am not sure of the column and table name.  Again I never have run v7.


Jeremy O

Production CCP .:. Version 6 w/QuickBuy and many in house hacks
Skills: PHP & Perl programming, Solaris & Linux server administration, Oracle OCP training and MySQL experience

Offline

 

#7 03-23-2012 15:01:16

Dave4Showcases
Member
Registered: 03-24-2011
Posts: 12

Re: Regular Price Being Rounded

Thanks cyberws, didn't even think of changing it using PHPMyAdmin.  Worked like a charm.

Offline

 

Board footer