Product stock negative + problem many orders the same time

Hello,

using OC 2.3.0.2.
Journal Theme
Problem is in Default Checkout and Journal Checkout

on some months in year we have days with many big orders. this means 200 Orders in 1 hour with ca. 50-150 products per order. many customers at the same time.

some stock values are negative after some time. and we sold more than we had on stock. both is a problem. I think the problem is updating stock value in mysql when some customers are ordering at the same second.

any idea how to solve this problem? is there an extension? Or some Code to change?

Thanks

Kaito

KaitoKid1990 wrote: ↑

Thu Aug 04, 2022 4:02 pm

any idea how to solve this problem? is there an extension? Or some Code to change?

It's actually a very difficult problem to solve - think about buying tickets for seats at the theatre - once you put them in your cart you see a timer where those seats are unavailable for other people to buy. You'd need something similar to that to be sure you couldn't oversell.

Search this forum - the question has been asked a lot before. It might be there's an extension.

If you can't find an extension, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

Hello

For this you need a custom-based module and put a Threshold value for stocks like suppose 10 products in spare, So that if the stock goes negative then you can manage the stocks from threshold value. Otherwise you have better option you can suggest us. We will create custom based module and set automated technique for product update to Database.

You can email us: williamsmith@cedcommerce.com

Thanks