First, backup your database ...
Second, make sure that you backed up your database ...
Third, you should be able to run this from either phpMyAdmin or from the Tools ... Install SQL Patches ...
Code:
DELETE FROM products_discount_quantity WHERE discount_qty = 0;
That should remove all of those useless Discount Quantities that are throwing off your prices ...
I am not quite sure how they got in there in the first place ... but, there has been added to an upcoming release a bit more of a cleanup when working with Discount Quantities to try to tidy things up a bit more when Adding and Canceling, as the Update already knows to do this clean up ...
Bookmarks