Hi,
We have AbleCommerce Version: 9.0.5.6938. There was a sale last night and the cart received over 200 orders in 2 hours, mostly for the same product. About 50 of those orders were within 2 minutes. Payments were made with PayPal or Authorize.Net CIM.
I have placed test orders and the inventory control does seem to work, it appears to be an issue that when there is a large volume of orders it does not work. Is there a limit to the amount of orders that can be handled while working with inventory control?

Below is the relevant error I find in the log:


2023-10-03 19:00:56,445 ERROR lushingEventListener Could not synchronize database state with session
NHibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [CommerceBuilder.Products.Product#27]
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session)
at NHibernate.Action.EntityUpdateAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
at NHibernate.Engine.ActionQueue.ExecuteActions()
at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)

Hi,

I'm sorry, but the bug report missed our cut-off for the last release. We have not had a chance to look into this issue. This scenario with inventory control along with a massive influx of new orders could be problematic but let me ask a few questions first.

Paypal - are you using PayPal Instant Payment Notification?

Authorize.net CIM - are payments captured at time of sale?

Is your inventory setting set to destock on paid orders?

Unfortunately, our software doesn't have advanced features where there is a lock on a product that is added to someone's shopping cart. For example, we've seen, in cases of specials sales where you can put that item in the cart and have some x time to checkout.

For AbleCommerce, it is more like a race to the checkout. I am not sure if we do one final check on inventory right before accepting payment. I need to get the devs input on this.

Hi,

This is the information given to me from our team:



I just wanted to add that PayPal IPN can take longer than the traditional gateway. My thought is that perhaps the PayPal IPN orders have a slight delay over the payment gateway.

I don't know that there anything we can do to prevent this from happening, unless there was a new feature where inventory can be reserved on add to basket. Removing Paypal IPN might be a work-around, if that is something you can test for.