product Discount Type

If you're using the discount feature, and wish the field would hold a decimal for a percentage, instead of an integer, here's the fix:

change the product->product_discount_id field from INT(11) to DECIMAL(10,4)

for a new install, open the phpshop.sql file and change the line:

product_discount_id` int(11) default NULL

to

product_discount_id` decimal(10,4) default NULL

for existing installs, just modify the database table properties for that field (i used phpmyadmin).  mine worked fine.

now, if you're wondering why you might want to do this:  taking a straight percentage off is nice, but if you're trying to get down to an actual number, you might need the extra decimal places to get it exactly (try 645 -> 599  -  it requires a value of 7.1318 to get there)