BV Commerce Forum
»
BV Commerce Support
»
How Do I? Questions
»
Looking to have newest products entered load at the top of the category?
Rank: Member
Joined: 9/11/2008(UTC)
Posts: 4
|
I am curious if there is a simple way (using static) to change my default so that the newest products I upload to the site come up first when the category loads. Right now, they are loading at the bottom??
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
I believe you can do that by sorting the products in the SP appropriately. Did you already try doing that? |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/11/2008(UTC)
Posts: 4
|
Sorry Satya, I'm new to all of this, so please can you tell me what SP is? I know I can go into a category edit and use the arrows to move products up or down and sort them this way, I was just wondering if there is a simple way to change the default to automatically load all my newest products to the top of the category load? (so that they show up first when a customer clicks onto that category .... vs. last)
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
By SP, I meant a Stored Procedure in your database. You can edit the stored procedures named "bvc_Product_ByCategory_s" and "bvc_Product_ByCategoryFiltered_s" in your database by modifying the order by clause.
If you edit these 2 SPs, you will notice that towards the end of the Select statement, you will the "Order By RowNum". Just change this to "Order By CreationDate DESC". So basically you are replacing RowNum with" CreationDate DESC".
That should do it. There is a way to do it in code as well. But this is by far the easiest for you. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/11/2008(UTC)
Posts: 4
|
Thank you! I will try this. Much appreciated...
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
No problem. Let me know how it goes. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/11/2008(UTC)
Posts: 4
|
It worked perfectly Satya! Thank you so much. We were struggling with this forever...I wished I asked sooner! Thank you.
|
|
|
|
|
|
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.