BV Commerce Forum
»
BV Commerce Support
»
Development
»
Cart Cleanup does not update QuantityReserved
Rank: Member
Joined: 1/21/2021(UTC) Posts: 1 ![United States]( "United States") Location: O'Fallon MO
|
The QuantityReserved column on our bvc_ProductInventory table keeps growing. We are using BVC2015. The UnreserveQuantity stored procedure gets called when an order is completed or when a cart or line item in the cart is manually deleted. But it seems that when a customer leaves their cart for over a week and the cart cleanup process runs that deletes the cart, the UnreserveQuantity stored procedure does not run leaving the QuantityReserved column untouched.
Has this issue been resolved in a later release?
Do you recommend adding a call to this stored procedure in the cart cleanup process?
Was there a reason that this stored procedure call was left out of the cart cleanup process?
Thank you.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
We've seen QuantityReserved issues like you describe in older versions, but we're not aware of such a problem in BVC 2020. Two questions: - Which inventory reserve mode are you using, Order Saved or Add to Cart?
- Are you doing anything special with your cart clean (e.g. manually running a SQL stored proc) or are you letting BVC manage the cart cleanup process?
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.