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
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
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.KaitoKid1990 wrote: ↑Thu Aug 04, 2022 4:02 pmany idea how to solve this problem? is there an extension? Or some Code to change?
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.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
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
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
Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com
Webinar : Power up Your holiday season marketing with the Automation tool
Who is online
Users browsing this forum: No registered users and 59 guests