I'm trying to implement a little shopping system. I have a single product which has a limited stock.For example, my product can be bought 5 times.My problem is, if a user adds this product to his cart, fill the form and pay.Decrement the stock when he adds the product to his cart (problem: if he quits the site before the payment? The product stock is decremented, but not bought)Decrement the stock when the payment is confirmed (problem, if 2 or more user pay at the same time)Have you got any advice on the best way to solve this?Thanks
shopping system cart problem with stock
modeling