BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Customers who purchased this item also purchased...
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
I don't think this feature is working properly for me... It shows up on some items, but not others. The strange thing is, the most popular items which everyone adds to their orders don't have this display... I know it works sometimes... http://store.attachedtobaby.com/products/Didymos-Instructional-DVD.aspx But here's some of our most popular items, that people order all the time with other things: http://store.attachedtobaby.com/Products/Moby-Wrap-Baby-Carrier.aspxhttp://store.attachedtobaby.com/Products/BabyLegs-Classic.aspx Any ideas on how to get this to work consistently? |
|
|
|
|
|
|
Rank: Member
Joined: 9/27/2004(UTC)
Posts: 1,099
|
Hey Angela. Are these products using the same product template? |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
Yep (using the BVC 2004 product template), the only thing that I can think of why it works for some is that I manually populated the database table once just to see if it "worked"... I'll look into it more.
Does anyone have this working? |
|
|
|
|
|
|
Rank: Member
Joined: 9/27/2004(UTC)
Posts: 1,099
|
Hey Angela.
What is the maximum results under Options > Performance > Suggested Items Maximum Results
Do you have access to the database? If so, try executing the “bvc_Product_SuggestedItems stored procedure and provide your products BVIN. See if it returns anything.
If you are not familiar with SQL Server, open a support ticket and we will look at it for you.
Thanks! |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
I have it set at 4.
The return value I get is always 0 for that stored procedure. |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
Okay I figured out why most of my products aren't returning anything. They are all product variations (size/color), and the very few products I do have that are just one SKU, are indeed showing the Recommended Products.
Is there a way to display the Recommended Products for my products with variations? |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
Wait, I don't think that's the right sql. I'll have to wait for my husband to come home and get it right, he's the database guru. :)
(Mods, you can delete these last two posts, sorry!) |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
I got it to show the items like I wanted. It's late and I might need to do some tweaking yet... but it works! http://store.attachedtob...y-Wrap-Baby-Carrier.aspx SELECT TOP(@MaxResults) ProductID, SUM(Quantity) AS "Total Ordered" FROM bvc_LineItem l JOIN bvc_Order o on l.OrderBvin = o.bvin WHERE o.IsPlaced = 1 AND dbo.bvc_ProductAvailableAndActive(ProductID, 0) = 1 AND OrderBvin IN (SELECT OrderBvin FROM bvc_LineItem WHERE ProductID IN (SELECT bvin FROM bvc_Product WHERE (ParentID = @bvin))) GROUP BY ProductID ORDER BY SUM(Quantity) DESC |
|
|
|
|
|
|
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.