BV Commerce Forum
»
BV Commerce Support
»
General Support
»
364: OPEN - bvc_ProductAvailableAndActive does not handle Inventory Status: OutOfStockAllowPurch
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
The SQL Func bvc_ProductAvailableAndActive does not handle the case of a product have an Inventory status of "2" (OutOfStockAllowPurchase) thus Cross sell products do not appear correctly.
Modify in the middle of the proc (line 52) from:
ELSE IF @inventoryStatus = 1
to:
ELSE IF @inventoryStatus = 1 OR @inventoryStatus = 2
On top of this there is another problem with some products having this inventory status of "2" (OutOfStockAllowPurchase) even if they have stock and reserved is lower than stock.
I don't know how to reproduce this (yet) but lots of my products have this status while QuantityAvailable > QuantityReserved(0) and I know the QuantityAvailable is the correct quantity I have in stock and I have no pending orders.
Corneliu. |
|
|
|
|
|
|
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.