I want to write a piece of middle ware that updates the quantities between our store system and the online, do you have a copy of the datamodel I can look at? (it looks pretty obivous in the DB, but I wnat to make sure I'm not missing anything) Basically I need to be able to query how many have sold since I last looked and how to update the quantity available for a particular product.

thanks,

Rob

I did this already to get inventory counts from our accounting software and keep the web store up to date.

The field that you're looking for is in Smith_Products, and it's called QuantityOnHand

You can update it with a simple SQL UPDATE statement in a stored procedure (preferably). The *best* way is if the SKU in the store matches the SKU in your accounting system.