I'm using a fresh installation of 1.3.8a and am using the Google Checkout addon. I would like to make it so that when there is a sale and the product is no longer available and the stock is 0, that it gets moved to another category (trust me, the process sounds nuts, but works for our application). I could do this through a trigger on the database, but would rather do it through the update query as a case statement when the response handler comes back to avoid possible deadlocks. Do you know where I can find and alter this query?