Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Pricing Product Problem


shelby72

Recommended Posts

I cannot price any of my products over $100. The prices convert back to $99.99. If I price something to $130, it still converts back to $99.99. What could be causing this? I've check everything in the admin. Is there something I'm overlooking? Someone please help me out.

Link to comment
Share on other sites

check your installation, probably someone is overwrite the sql query code with default price $99.99.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

check your installation, probably someone is overwrite the sql query code with default price $99.99.

 

 

 

Where in the installation would I check this? Which file? I've checked the database already and I can't find a default price of $99.99 anywhere.

Link to comment
Share on other sites

Is there not anyone who knows what might be causing this? I really need some help.

Something like that can happen when you changed the properties of the decimal column that contains products_price in the table products. Normally it is size 15, decimals 4 which means the highest number it can contain is 99999999999.9999

If you changed that to say (15, 13) the highest number it could contain would become 99.9999999999999 so every number entered in there higher than that would be truncated to 99.9999999999999

Link to comment
Share on other sites

Something like that can happen when you changed the properties of the decimal column that contains products_price in the table products. Normally it is size 15, decimals 4 which means the highest number it can contain is 99999999999.9999

If you changed that to say (15, 13) the highest number it could contain would become 99.9999999999999 so every number entered in there higher than that would be truncated to 99.9999999999999

 

 

Thank you very much! That solved my problem. My products_price was (3,2) so I changed it. Now everything works fine.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...