Rank: Member
Joined: 8/28/2007(UTC)
Posts: 36
|
Hi
I am creating a template for BVC5, and I want to display "Hot products" in a category page. Each category ould display its own hot products(the produsts which are sold more).I want to display These products on the each category page, on the right side of the page either in a list view or grid view. Is it possible
Thanx!
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Sarah,
It should be pretty simple. Duplicate and rename the folder for the Top 10 Products. Duplicate and rename the [bvc_Product_ProductsOrderedCount_s] store procedure.
Add a new param to the sp to represent the current category bvin and use that in an extra join with the ProductXCategory and Category tables and filter by the category bvin.
The update the code for the new page (View.vb from your new folder) to use the new sp and pass to it the current category.
The SP would be something like:
Select ....
From bvc_lineItem L
Join bvc_Product p on l.ProductId = p.bvin
join bvc_ProductXCategory pxc on pxc.productbvin = p.bvin
join bvc_Category c on c.bvin = pxc.categorybvin
where l.OrderBvin IN (....)
AND c.bvin = @currentCategoryID.
I hope I make sense and my sql coded in a textbox is close enough to what you need.
Regards,
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.