Hi everyone,

Just after some advice before I start coding on stock control.

We have a product table that has a stocklevel field... I'm just after some advice on how to stop a product being sold if two people add it to their cart and purchase it at the same time.

At the moment, they add the item to the cart and click checkout. Then a credit card screen pops up where they purchase the order. I'm thinking at that stage I would pass back whether the credit card was accepted, send the order and minus the ordered stock amount from the product stock level... however this would not stop two people clicking checkout at the same time.

Is there a standard way for doing this?

Please let me know if you want to know my tables layout. Its quite simple, a product table, customer, order and order item table...

Thanks for your sugguestions