Post by KaitoKid1990 » Thu Aug 04, 2022 4:02 pm

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

Newbie

Posts

Joined
Mon Oct 26, 2020 5:55 pm

Post by paulfeakins » Thu Aug 04, 2022 5:36 pm

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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by cedcommerceteam » Fri Aug 05, 2022 5:42 pm

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

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


User avatar
Active Member

Posts

Joined
Wed Aug 09, 2017 9:02 pm
Who is online

Users browsing this forum: No registered users and 59 guests