Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order 2.5 yards instead of 2 or 3?


kelly236

Recommended Posts

Hi everyone,

 

I'm selling fabrics online and notice that people can order 2.5 yards of fabrics , but when I try to edit the customer info and view the invoice or packing slip it shows a 3 instead of 2.5 is there any way I can fix this? Please anyone know even where I can read about this or install a contribution that will fix this, I'm LIVE and need a fast solution

 

Thank you ALL for your time and consideration I'm Desperate!!

 

Kelly

Link to comment
Share on other sites

Unfortunately that did not work, I'm still seeing 3 instead of 2.5 when I try to edit the order in the admin or look at either the invoice or packing slip, where else can I change it in the data base that you think will fix this?

 

Thank you for your time, I really appreciate it

 

Kelly

Link to comment
Share on other sites

in addition to the db changes, there might also be some code changes required in some of the files.

Link to comment
Share on other sites

OK. it's working now, my mistake, I forgot to change the Length/Values in my database table, but now my problem is I have too many zero's lol!

I only need 2.5 and maybe one zero like 2.50 but I have 2.500 so I guess I have to keep playing with it and figure out the combination I followed the instruction in the contribution above that toyicebear sent me but I'm just afraid of playing with the length/ Values, since I'm not sure if that will cause any harm, does anyone know which one I should change ?

 

Thank you

 

Kelly

Link to comment
Share on other sites

To fix the 2.500 change your database column attributes to Decimal(X,2) that would give you 2.50

 

 

The instructions have several columns that say they changed. decimal(15,3) (11,3) (5,3) the second number after the comma indicates how many 0's to display so substitute as needed.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...