BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Show as Out of Stock(Allow Orders) changed to "Remove from store" after SP2?
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
I noticed a strange thing. All my products used to have the inventory option of "Show as Out of Stock(Allow Orders)".
After applying the SP2 I now notice that when I go to see the inventory for a product it has "Remove from store" as the default.
If I change it the new value gets applied however the one I see on the screen at the momment ("Remove from store") is NOT applied as the product is still visible in the store.
This looks very strange. Might it be related to my question on another thread:
"What is the difference betwen OutOfStockMode on both bvc_Product and bvc_ProductInventory tables?"
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
You can run this SQL to make sure that all of your products are updated with the OutOfStockMode from the bvc_ProductInventory table.
UPDATE bvc_Product SET bvc_Product.OutOfStockMode = bvc_ProductInventory.OutOfStockMode FROM bvc_ProductInventory JOIN bvc_Product ON bvc_ProductInventory.ProductBvin = bvc_Product.bvin WHERE bvc_ProductInventory.OutOfStockMode <> -1
Keep in mind that this will update all of your products inventory modes to whatever was in the ProductInventory table and will not reflect changes made to the bvc_Product table. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Justin,
Is the bvc_ProductInventory.OutOfStockMode used anywhere? The reason I ask is that I see now that the products behave on the site as per their option in this table so I'm just courius why.
Thanks,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
It shouldn't be referenced anywhere. What does your bvc_ProductAvailableAndActive scalar-value function look like in the db? |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
The function looks ok in the DB. I using the product.OutOfStockMode, but that still does not explain why I can see all the products.
The ones that are marked as "Remove from Store" appear as "Out of stock" if you hit the product page directly.
However they dissapear from the category lists or CrossSell/UpSell which is correct.
Anyway, I run your query and it looks ok now.
Thanks,
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.