Stock Levels Not Reducing Correctly

Good day,

I recently encountered a stock problem where two users were able to make a purchase of an item that only had 1 in stock.

The purchases were made 20 minutes between each other, so it isn’t like the database should have been struggling to write the values correctly.

Order 1: 3:08pm – Product (#25392) 1->0
Order 2: 3:29pm – Product (#25392) 1->0

This was a product drop and there were a number of people on the site at the time, but there were 3 cases of this among a few dozen orders.

I wanted to get some thoughts about how I could go about debugging and resolving this, it caused massive issues with us needing to contact customers and tell them that we couldn’t fulfill our order.

We are not using any payment gateways – as all orders have to be paid via EFT manually. The stock levels should always reduce once the customer confirms their order on the checkout screen.

We’re just using a single database, we only get a few hundred visitors a day.

• This topic was modified 4 years, 9 months ago by trichomechaser420. Reason: Forgot to add the payment gateway method