What to change in DATABASE to put item on sale?

[Jeff_Mash]

I used to know this! I want to programmatically update a product in the database to put it on sale.

I thought that we only had to update the "products_price_sorter" field, but when I do that, it's not reflecting the lower price on the website.

Is there something else I'm missing? Perhaps I need to just add an entry into the "zen_specials" table?

WHY AM I DOING THIS?

We have a vendor who is putting a couple thousand items on sale. The percentages of sale prices vary (some are 30% off, some are 40%, etc). So I can't just create a new "Sale Maker" entry for a category, because there are a bunch of different percentages on the items.

And I don't want to just update the retail price, because I want the customer to see the OLD price, and the SALE price.

So what field(s) do I need to update in the database for each product so that it will show my new "sale" price that I have?