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.
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
Bringing this back to the top. I'm still having this problem. Does anyone have any idea on what could be causing it?
Offline
It sounds like you changed the column type for the regular price field from a VARCHAR to an INTEGER.
Offline
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
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.
Offline
Thanks cyberws, didn't even think of changing it using PHPMyAdmin. Worked like a charm.
Offline