Why not mark the whole order as valid, invalid instead of each individual item? 
Because I don't keep a record of transactions (since PayPal do that it just duplicates something that's already in place), I just want to remove items from the shop when they've been sold without having to do it manually.
If you used the checkout wizard, the OrderID, is one of the fields in the OrderDetails table that you can use to identify all of the items in that order. It is stored as a session variable in the Store Cart Summary in Database server behavior. 
If this contains all the ID's I need then that would be great, but I don't understand how to get at them. Essentially all I need is a way to have the item ID's returned to me either individually or in an array, so I can run an update on the database.


