What exactly isn't working. I'd actually count the purchases in the orders database and subtract it from the available rather than keeping track of a count in the product table.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.